SUMMARY:
This document shows one issue that varchar data type shows as Unknown in Warehouse Catalog against Microsoft SQL Server 2014. One possible cause is the custom SQL statement of retrieving column information is not correct. The resolution is to use default SQL statement.
SYMPTOM:
Varchar data type shows as Unknown when attempting to view table structure in Warehouse Catalog against Microsoft SQL Server 2014 in Strategy Developer 10.x
CAUSE:
One possible cause is custom SQL statement used to retrieve column information cannot retrieve data type correctly.
ACTION:
Click on "Use Default" in Warehouse Catalog>Options>Catalog>Read Settings>Settings as shown below:
SELECT S.name NAME_SPACE, T.name TAB_NAME, C.name COL_NAME, C.user_type_id DATA_TYPE, C.max_length DATA_LEN, C.precision DATA_PREC, C.scale DATA_SCALE FROM sys.all_objects T JOIN sys.columns C ON T.object_id = C.object_id JOIN sys.schemas S ON T.schema_id = S.schema_id WHERE T.name in (#TABLE_LIST#) ORDER BY 1, 2
