IBM Support

(TR3110) An unknown error has occurred when building a cube in transformer

Troubleshooting


Problem

Transformer 6.61.436 Description: When building a cube in Transformer receive the following error message: (TR3110) An unknown error has occurred during the operation. Please contact Cognos Customer support. ...and the build fails. Solution: You can try each of the following separately or perform all the steps before trying to rebuild the cubes, but make a backup of the model and cube files in a separate folder first. Delete and re-add the powercubes back to the model: 1. open the model file, select the powercube from the "PowerCubes" window 2. Right click and select delete 3. save the model 4. Physically delete the original MDC file from Windows 5. Reopen the model and right click in the Powercubes window and select insert powercube 6. Specify a new name for the cube in a different folder location 7. Try to rebuild the cube Delete and re-add the data sources back to the model 1. Open the model file 2. Right click on the data source and select "Delete Data source" (repeat for all data sources) 3. Right click in the data sources window and re-add all data sources back to the model 4. Try to rebuild the cube Delete and re-add all dimensions one by one back into the model (note: all defined categories (ie relative time categories) will have to be redefined following these steps) 1. open the model 2. Select the last dimension, right click and select "delete dimension" 3. Recreate the dimension from scratch 4. try to rebuild the cube 5. (repeat for all dimensions) Ensure that the log file is set to a valid location in File - Preferences. Description: If you have orphan categories, ensure the parent categories are set to either 'Suppress Blanks or 'Always Include'. OR If the model has ever been opened and saved from a transformer installation on Windows ME, then this error can occur when porting the model to Windows 2000. Windows ME is not a supported operating system of Transformer 6.61. The solution is to recreate the model.

Symptom

(TR3110) An unknown error has occurred during the operation. Please contact Cognos Customer support.

...and the build fails.

[{"Product":{"code":"SSTQPQ","label":"IBM Cognos Series 7 PowerPlay"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Transformer","Platform":[{"code":"PF033","label":"Windows"}],"Version":"Cognos 8 BI Transformer 7.3;PowerPlay Transformer 6.61;PowerPlay Transformer 7.0;PowerPlay Transformer 7.1;PowerPlay Transformer 7.3;PowerPlay Transformer 7.4","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Transformer","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SSTQPQ","label":"IBM Cognos Series 7 PowerPlay"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Transformer","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SS6G84","label":"IBM Cognos Analytics on Cloud"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

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

108485

Document Information

Modified date:
09 May 2025

UID

swg21336980