3
votes

I do not have any issue for processing SSAS cubes through Management Studio; however I got the following error message when processing cube through SSIS packages

XML for Analysis parser: The XML for Analysis request timed out before it was completed

Any ideas?

1
What is SSIU? And how long does it take before the timeout error occurs?GregGalloway
@GregGalloway sorry for mispelling, it is ssis packageuser39813
and how long does it take to receive the error?GregGalloway
@GregGalloway Another team uses ssis package to process cube . I will get email from them to tell me something wrong with processing cube in the package and then I will process cube through Management Studio. After I processing cube successfully, cube got processed successfully via ssis package. any ideauser39813

1 Answers

1
votes

full error text is

Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataSource.Error] AnalysisServices: XML for Analysis parser: The XML for Analysis request timed out before it was completed.

Solution in parameter ServerTimeout in server properties also ExternalCommandTimeout must be increase

more about server settings

additional in BI Query you can specify CommandTimeout param

= AnalysisServices.Database("localhost\developer", "Analysis Services Tutorial", [CommandTimeout=#duration(0,3,0,0)])