Need advice on urgent issues: MSTR 7.2.0 Desktop not ecognizing new columns in SQL Server table.
After I added new physical columns (alter table) and populated them (update table), MSTR warehouse schema will not recognize the new columns in tables.
I have checked the column datatypes and permissions are same as others. The database instance uses same login as the transact-sql.
Any hints or suggestions? How does MSTR update the columns. Doesn't it check the table structure when saving warehouse catalog? Was this addressed in subsequent release? Are there technical notes that discuss?
Thanks.
Robert
After I added new physical columns (alter table) and populated them (update table), MSTR warehouse schema will not recognize the new columns in tables.
I have checked the column datatypes and permissions are same as others. The database instance uses same login as the transact-sql.
Any hints or suggestions? How does MSTR update the columns. Doesn't it check the table structure when saving warehouse catalog? Was this addressed in subsequent release? Are there technical notes that discuss?
Thanks.
Robert