Troubleshooting
Problem
Macro code used to open an Impromptu Catalog with the OpenCatalog method fails to connect to the database.
Symptom
Reports run in the macro are exported without data because the database was not connected when run.
The Creator User Profile does not have a password on the Catalog. The database user and password is embedded in the Catalog. Impromptu is configured to automatically connect to the database when a Catalog is opened. Manually opening the Catalog connects to the database. The same macro code used against a sample Catalog connects successfully
[{"Product":{"code":"SSTQPQ","label":"IBM Cognos Series 7 PowerPlay"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Macro Editor","Platform":[{"code":"PF033","label":"Windows"}],"Version":"7.5","Edition":"Workstation","Line of Business":{"code":"LOB76","label":"Data Platform"}}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Was this topic helpful?
Document Information
Modified date:
09 May 2025
UID
swg21673339