SYMPTOM:
When a user reads the warehouse catalog in Strategy Developer 10.x, the following error appears:
Object variable or with block variable not set
After enabling the WHCatalog trace in Diagnostics and reproducing the issue, the following messages are logged when the error appears:
Unexpected Error (Line no. 0, Number: 91, Description: Object variable or With block variable not set, Source: WHCatalog)
Function Leave
Function Leave
CAUSE:
The PBTName column is not found in some or all the partition mapping tables. To confirm it check the structure of those tables in the database side. The PBTName column must be present in order for a partition mapping table to be valid. For more information on partition mapping tables, refer to the following Strategy Knowledge Base technical note:
KB5529 (KB4100-7X0-0098): How to set up a project using partition mapping tables in Strategy Architect 8.x
ACTION:
Modify the structure of the partition mapping table(s) in order to include the PBTName column. After that change the warehouse catalog should open up with no errors.
