IBM Support

Unable to create the object with ProgID 'EAdminSQL7_10.SQL7' (request was for 'EAdminSQL7_%v.SQL7')

Troubleshooting


Problem

Error "Unable to create the object with ProgID 'EAdminSQL7_10.SQL7' (request was for 'EAdminSQL7_%v.SQL7')" is presented when trying to start Planning Server service.

Symptom

ERROR
Unable to create the object with ProgID 'EAdminSQL7_10.SQL7' (request was for 'EAdminSQL7_%v.SQL7')

Automation error
ClassFactory cannot supply requested class

Cause

This error is caused due to an incorrect lib registration on Windows.

Resolving The Problem

- Navigate into <cognos instalation>\bin directory.
- Create a file named register_dll.bat
- Copy and paste following code into the created file:

FOR %%1 IN (*.DLL) DO REGSVR32 /S %%1

- Save the file.
- Create another file named register_ocx.bat
- Cop and paste following code into the created file:

FOR %%1 IN (*.OCX) DO REGSVR32 /S %%1

- Save the file.
- Run both files (register_dll.bat and register_ocx.bat) - it will re-register all libs in the bin directory.

[{"Product":{"code":"SSPN2D","label":"Cognos Planning"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.1.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
15 June 2018

UID

swg21662485