SUMMARY:
The issue described in this document has been classified as a defect by Strategy. The issue occurs in Strategy Developer 10.0 - 10.9 when trying to open Warehouse Catalog. A code fix is available in current releases of Strategy. A workaround is also available in the current document.
SYMPTOM:
In Strategy Developer 10.0 - 10.9, users may get the following error when trying to open Warehouse Catalog:
Invalid procedure call or argument
This issue is specific to a particular project(s), and Warehouse Catalog can be opened successfully in other projects within the same metadata.
CAUSE:
This is an identified defect in Strategy 10.x.
ACTION:
This issue has been addressed in Strategy version 10.4 Hotfix 5 and 10.10. Upgrade to one of these versions or a later version to take advantage of the fix.
WORKAROUND:
Tables can be imported using Architect instead of Warehouse Catalog.
TO LEARN MORE:
Related KB articles:
KB203500: "Unexpected error. Invalid procedure call or argument" error message appears when attempting to add new tables in Warehouse Catalog in Strategy Developer 9.4.1
KB17343: "Invalid procedure call or argument" error occurs when launching the Warehouse Catalog in Strategy Desktop 9.4.1 - Developer 10.x
KB38024: "Unexpected error. Invalid procedure call or argument" error message appears when launching Warehouse Catalog in Strategy Developer 9.x and 10.x
KB45946: "Unexpected Error. Invalid procedure call or argument" error message appears when using multisourcing and selecting a different database instance in the Warehouse Catalog in Strategy 9.x
KB439152
