Troubleshooting
Problem
PPT 7.0 (MR1) IMP 7.0 (MR1) Description: Error: (TR0101) An internal inconsistency in code 146 had been detected. attempting to view data from the Transformer model. Solution: The error was generated when querying a view in MSSQL Server. Looked back to the database and found one of the table attributes was designated as type TEXT4 (similar to BLOB). Removed TEXT attribute from the IQD, data is displayed in Transformer OK. Another possible method to avoid the error is to substring the content of TEXT to varchar.
[{"Line of Business":{"code":"LOB76","label":"Data Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSTQPQ","label":"IBM Cognos Series 7 PowerPlay"},"ARM Category":[{"code":"","label":""}],"Platform":[{"code":"PF025","label":"Windows"},{"code":"PF033"}],"Version":"Impromptu 7.3;PowerPlay Transformer 7.0;PowerPlay Transformer 7.1;PowerPlay Transformer 7.3"},{"Line of Business":{"code":"LOB76","label":"Data Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSTQPQ","label":"IBM Cognos Series 7 PowerPlay"},"ARM Category":[{"code":"","label":""}],"Platform":[{"code":"","label":"Platform Independent"}],"Version":"All Versions"},{"Line of Business":{"code":"LOB76","label":"Data Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSTQPQ","label":"IBM Cognos Series 7 PowerPlay"},"ARM Category":[{"code":"","label":""}],"Platform":[{"code":"","label":"Platform Independent"}],"Version":"All Versions"}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Historical Number
124053
Was this topic helpful?
Document Information
Modified date:
13 July 2025
UID
swg21337965