SYMPTOM
In the warehouse catalog, when right-clicking on a table to check the table structure, users notice that the Data Type for some or all of the columns are displayed as "Unknown" as shown below:
CAUSE
On possible cause is that the data types are user-defined or customized data type alias created in the database instead of SQL Server system data types. One way to verify this is to run the warehouse catalog column read SQL for this table in DB query tool, the data type for the "Unknown" column(s) will return values over 200 as shown below.
ACTION
Strategy only supports the use of SQL Server system data types for table columns, and not user-defined or customized data types alias. Replace the customized data types alias with a SQL Server system data type at the database to resolve the issue.
The internal reference number for this is SPOCUS ID 242883 and KB440747
