Friday, February 24, 2012

Error trying to build and deploy for first time

I'm getting a timeout error when trying to deploy my SSAS project for the first time - any suggestions on where to go from here?

Error 1 OLE DB error: OLE DB or ODBC error: Query timeout expired; HYT00. 0 0
Error 2 Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Property Address', Name of 'Property Address' was being processed. 0 0
Error 3 Errors in the OLAP storage engine: An error occurred while the 'Unit Number' attribute of the 'Property Address' dimension from the 'foo' database was being processed. 0 0
Error 4 Errors in the high-level relational engine. The database operation was cancelled because of an earlier failure. 0 0
Error 5 Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Property', Name of 'Property' was being processed. 0 0
Error 6 Errors in the OLAP storage engine: An error occurred while the 'Status Type ID' attribute of the 'Property' dimension from the 'foo' database was being processed. 0 0

How long time does the task take until you see the timeout error? Also, could you check network connectivity to the relational datasource? What authentication do you use?

No comments:

Post a Comment