Sunday, February 26, 2012

Error Code of 3238395904 and 3240034316

I get the following error for a cube that used to process just fine.

Executed as user: PREMIER_AD\SQLExec. ...ts xmlns="http://schemas.microsoft.com/analysisservices/2003/xmla-multipleresults"><root xmlns="urn:schemas-microsoft-com:xml-analysis:empty"><Exception xmlns="urn:schemas-microsoft-com:xml-analysis:exception" /><Messages xmlns="urn:schemas-microsoft-com:xml-analysis:exception"><Error ErrorCode="3238395904" Description="OLE DB error: OLE DB or ODBC error: Unspecified error." Source="Microsoft SQL Server 2005 Analysis Services" HelpFile="" /><Error ErrorCode="3240034316" Description="Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Vw PASBSCD1291 Fact', Name of 'Drillthrough Data' was being processed." Source="Microsoft SQL Server 2005 Analysis Services" HelpFile="" /><Error ErrorCode="3240034317" Description="Errors in the OLAP storage engine: An error occurred while the 'Reason' attribute of the 'Drillthrough Data' dimension from the 'Pas' database was being processed." Source="Microsoft SQL Server 200... The step succeeded.

I have no idea what Error Codes 3238395904 and 3240034316 are.

Looks like error belongs to the OLEDB provider you are using.

The error message reported by OLEDB provider is just "Unspecified error"

Looks like something went wrong with your relational database connection. Test your conneciton. See if you can process any other objects based on the same data source.

Hope that helps.

Edward Melomed.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Thanks, Edward.

The problem seems to have resolved itself. I believe the connectivity issues might be related to capacity problems were were having with our relational database late last week.

Dan

No comments:

Post a Comment