SYMPTOM:
When the user opens the Warehouse Catalog in Strategy Developer 9.x and 10.x, the following error occurs:
Sample Code/Error
Unexpected error. Invalid procedure call or argument
The user can also observe duplicate table names are listed in the right panel of the Warehouse Catalog:
CAUSE:
The exact cause of this issue is unknown at this point. In order to track down the cause of the inconsistency, customers encountering this issue should make note of Schema-related changes, Object Migrations, or error messages prior to experiencing the problem. Change Journaling, if it has been enabled, can help in preserving this information.
WORKAROUND:
This issue can be addressed by running ScanMD "Warehouse Tables Verification" in fix mode, or please contact Strategy Technical Support for further assistance.
