KB251027: All data type displays as 'unknown' on the MicroStrategy Warehouse Catalog for Netezza in MicroStrategy 10.0

SUMMARY
This issue has been classified as a defect by Strategy. The impact is limited to Netezza database. A code fix for this issue is available in Strategy 10.0 Hotfix 1. Additional steps are needed to upgrade the database instance to apply the fix.
SYMPTOM
In Strategy 10.0, all data types display as unknown on the Strategy Warehouse Catalog when using Netezza as warehouse.
On the warehouse catalog, when right clicking on the table to check the table structure, users notice that the Data Type = Unknown as shown below:

 
CAUSE
This is a known issue with Strategy 10.0.
ACTION
This issue has been fixed In Strategy 10.0 Hotfix 1. Upgrade to this version to take advantage of the fix.
NOTE: Database connection type need to be upgraded manually to apply the fix.
Follow steps below to upgrade the database instance:

• On Strategy Developer, connect to the project source as an Administrator user and navigate to: “Administration”-> “Configuration Managers”->”Database Instances”
• Double click any one of the database instances, and click “Upgrade”
  

• In “DBtypes script file”, user can see the PDS file ”\Common Files\ Strategy\Database.PDS”.
• Click “Load” to load all database types
• Choose “IBM Netezza 6.0.x”, “IBM Netezza 7.0.x”, “IBM Netezza 7.1.x” and then click “>” to add it to existing database types.
• Click “Yes” to replace the existing one.
• Click “OK” to save the changes.