Product:
Cognos BI 10.1.1Windows 2008 R2 serverMSAS SSAS 2008
Symptom:You have created a data source to a SSAS 2008 cube, and test it in Cognos connection.It works for CQM but you get a error for DQM.
Error message:http://sr01634:9300/p2pd Microsoft Analysis Services 2008 / Compatible Succeeded
http://sr01634:9300/p2pd Microsoft Analysis Services 2008 / Dynamic XOD-CON-0001 Failed to connect to OLE DB for the provider (Microsoft Analysis Services 2008) and server (sr01868): ERROR [category=ASSERTION,statusCode=0,causeCode=0,source=CODBOConnection::UpdateConnectionProperties(CNativeEnv&) at Java_com_cognos_xqe_data_providers_olap_odbo_ODBOConnection_cUpdateConnectionProperties]: CCLAssertError: CCL_ASSERT(NULL != m_pIDBInitialize);
Cause:The DQM report service is 64 bit JAVA program and need the 64 bit version of the driver to be installed on the Cognos BI server.
In control panels add/remove programs the driver is listed as111 MB version 10.50.1600.1 (the working version)or77,5 MB version 10.52.4000.0 (not working version)
Possible Solution:Download the x64 version of Microsoft® Analysis Services OLE DB Provider for Microsoft® SQL Server® 2008 R2 from site http://www.microsoft.com/en-us/download/details.aspx?id=16978
File size is 55526 KB for SQLSERVER2008_ASOLEDB10.msi file 64 bit version.
Install the driver on the Cognos BI server and test the connection again.
Connection string:;LOCAL;M8;SERVER=sr01868;Trusted_Connection=yes;LCID=en
www.cogknowhow.com