Troubleshooting
Problem
Error TR1901 There is a duplicate key value category index in (MDC name) when rerunning existing cube.
Resolving The Problem
Check the database table which is being queried. Null values will sometimes cause this error to occur. If the error persists proceed with the following:
1. Delete the PowerCube Definition and recreate. Then rerun the cube.
2. Save the model out as MDL and reopen. Rerun the cube.
3. Run Clean House and retry.
4. Confirm sufficient resources are available for this cube to be created. Free up harddrive space, TEMP space, conventional memory and swap file space. Delete all *.tamp files and run a scandisk and .
[{"Product":{"code":"SSTQPQ","label":"IBM Cognos Series 7 PowerPlay"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Transformer","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"Cognos 8 BI Transformer 7.3;DecisionStream 7.1;PowerPlay Transformer 5.0;PowerPlay Transformer 6.5;PowerPlay Transformer 6.6;PowerPlay Transformer 7.3;PowerPlay Transformer 7.4","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU053","label":"Cloud \u0026 Data Platform"},"Component":"Transformer","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"","label":""}},{"Product":{"code":"SSTQPQ","label":"IBM Cognos Series 7 PowerPlay"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"DecisionStream","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Product":{"code":"SSTQPQ","label":"IBM Cognos Series 7 PowerPlay"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Transformer","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Historical Number
88913
Was this topic helpful?
Document Information
Modified date:
28 November 2022
UID
swg21336102