SYMPTOM:
After switching the primary database instance in the warehouse catalog for a particular table, the table still executes off of the original instance.
CAUSE:
Moving tables between environments can cause the warehouse table objects to not update properly with correct linking to the new warehouse catalog object.
ACTION:
Contact Strategy Technical Support for assistance with this issue.
WORKAROUND:
Use the Graphical Architect Tool to change the primary database instance.
1. Open the Graphical Architect Tool and switch to Project Tables View
2. On the right hand side in the properties window switch to the Tables Tab
3. From the drop down list to the table that you would like to change the Primary Database Instance
4. Click on the name of the instance that it is currently associated with to see the ellipsis.
5. Click on the ellipsis then change the primary database instance for the table in the available instance pane.
6. Save and close the Graphical Architect Tool followed by updating the Schema.
