Symptom
In Warehouse Catalog of Strategy Developer 2021, when updating table structure, the columns do not get updated.
Troubleshooting & Solutions
For troubleshooting, follow these steps:
- Check if the table name to be updated exists in other namespaces.
- If the table also exists in other namespaces, the root cause may be the SQL updating the wrong table.
- To specify the table to be updated, in Warehouse Catalog, right-click the table and select "Table Prefix".
- By specifying the table prefix (or namespace), the SQL generated to update table schema is performed on the selected namespace.
- To make sure the table prefix is working as expected, do not check the checkbox "Ignore current table name space when reading from the database catalog and update using new table name space" in Warehouse Catalog -> DBI's Option -> Catalog -> Read Settings.
Related
