IBM Support

Error 'The specified module could not be found' or 'ActiveX component cannot create object' when trying to save a Data Mart definition

Troubleshooting


Problem

User launches menu 'Define Data Mart', and creates a new definition. 'Additional Target' is ticked, and 'MS SSAS' is selected. User clicks on 'save' and receives an error message. No cube definition is created on the Microsoft Analysis Server itself.

Symptom

Controller 2.x:

  • Screen message:
    Automation error
    The specified module could not be found.
  • Inside Event Viewer:
    VBRuntime
    The VB Application identified by the event source logged this Application
    FrangoOLAPDirect: Thread ID: 16976, Logged: Error occurred at 09/-8/2007 09:41:37 in FrangoOLAPDirect, Error No=-2147024770, Source=FrangoOLAPDirect.GenerateOneCube, Description=Automation error
    The specified module could not be found ,HelpFile= HelpContext=0

Controller 8.x:
ActiveX component cannot create object

Cause

The Controller application server needs to have some Microsoft Analysis Services DLL files installed on the server. This is so that the Application server (specifically the COM+ application 'COGNOSCONTROLLER' or 'IBMCOGNOSCONTROLLER' depending on version) has the ability to publish MSAS Data Marts (OLAP cubes).

Resolving The Problem

Install the *same* version of Microsoft Analysis Services on the Controller application server as you are trying to publish to (e.g. install MSAS 2000 if you are trying to publish to a MSAS 2000 target server). Afterwards, upgrade to the latest Microsoft MSAS Service Pack. Finally, disable the Analysis Services service (on the application server) to conserve system resources.

Steps:
Microsoft Analysis Server 2000 (for example, if using Controller 2.x, 8.1.x and 8.2.x):

  1. Obtain a short period of downtime
  2. Logon to Controller application server as an administrator
  3. Insert the SQL 2000 cd-rom
  4. Choose 'SQL Server 2000 Components' from the 'autorun' menu
  5. Choose 'Install Analysis Services'
  6. Follow the wizard to perform a default installation
  7. Download MSAS 2000 SP4 ("SQL2000.AS-KB884525-SP4-x86-ENU.EXE") from the Microsoft website. IMPORTANT: This (MSAS 2000 SP4) is DIFFERENT from the 'normal' MS SQL 2000 SP4.
  8. Double-click on SQL2000.AS-KB884525-SP4-x86-ENU.EXE to extract it to the default folder
  9. Launch the file C:\SQL2KSP4\msolap\install\setup.exe and perform a default install
  10. After the installation has finished, right-click on 'My Computer' and choose 'Manage'
  11. Open 'Services and Applications' and then 'Services'
  12. Stop and disable the Windows service 'MSSQLServerOLAPService'
  13. Reboot Controller application server
  14. Test

Microsoft Analysis Server 2005 (for example, if using Controller 8.3.x or higher):
  1. Obtain a short period of downtime
  2. Logon to Controller application server as an administrator
  3. Insert the SQL 2005 cd-rom
  4. Choose 'Install - Server components, tools, Books Online, and samples' from the 'autorun' menu
  5. Choose 'Analysis Services'
  6. Follow the wizard to perform a default installation
  7. Afterwards, download the latest MSAS 2005 service pack (e.g. SP3), for example 'SQLServer2005SP3-KB955706-x86-ENU.exe', from the Microsoft website.
  8. Double-click on SQLServer2005SP3-KB955706-x86-ENU.exe and follow the wizard to upgrade the MSAS version
  9. After the installation has finished, right-click on 'My Computer' and choose 'Manage'
  10. Open 'Services and Applications' and then 'Services'
  11. Stop and disable the Windows service 'SQL Server Analysis Services (MSSQLSERVER)'
  12. Reboot Controller application server
  13. Test

[{"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Controller","Platform":[{"code":"PF033","label":"Windows"}],"Version":"Controller (Frango) 2.3 MR1 SP15;Controller (Frango) 8.3","Edition":"Edition Independent","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Historical Number

1034870

Document Information

Modified date:
15 June 2018

UID

swg21347319

Page Feedback