SYMPTOM:
When a user is attempting to run table scripts in Strategy Command Manager 9.x, for example:
LIST ALL TABLES FOR PROJECT 'projectname';
the following error is received.
• Syntax is correct.• Object variable or With block variable not set.• Task(s) execution completed with errors.• Execution Time: 00:00:01.
CAUSE:The error occurs because one or more logical table objects are inconsistent in the metadata.
ACTION:To resolve the issue, user will need to either
- Use Strategy Object Manager to migrate consistent versions of the tables (from a metadata backup or any QA/Dev environment) and replace the inconsistent tables.
OR
- Delete the inconsistent table objects if no other objects are depending on it.
Please contact Strategy Technical Support for further assistance on the issue.