IBM Support

Getting error(TR1102) and (TR0701) while updating a cube using a mdl script

Troubleshooting


Problem

While updating a cube through command line[cogtr.exe command] using a mdl script, the below mentioned error was received.

Symptom

(TR1102) Transformer detected a model error at line 3 in file D:\BSC\updatecube.mdl. (TR0701) A PowerCube was expected but not found. Either you have referred to a PowerCube by an object name or object identifier that Transformer is unable to locate, or you have not referenced the PowerCube. [->OK]

Cause

In the mdl script for CUBEUPDATE statement customer had given the path of the mdc file instead of Cube name. We can also get the above error if the correct cube name is not provided.

Environment

Windows, Unix

Resolving The Problem

Put proper cube name in the CUBEUPDATE statement of mdl script.

Steps:Following was the scenario:

MDL script[updatecube.mdl] which was used :-

SignonAdd "signonname" UserId "user name" password "password" AutoLogon {True} SignonNamespace "namespace name" SignonType "Cognos
OPENPY "D:\Transformer\XYZ.pyj"
EVENTSTART "Build Monthly Powercube"
CUBEUPDATE "D:\Transformer\XYZ.mdc"
SAVEPY "D:\Transformer\XYZ.pyj"
EVENTEND
SignonDelete "signonname"

Command used was :-

cogtr.exe -mupdatecube.mdl

The correct script should be as below :-

SignonAdd "signonname" UserId "user name" password "password" AutoLogon {True} SignonNamespace "namespace name" SignonType "Cognos
OPENPY "D:\Transformer\XYZ.pyj"
EVENTSTART "Build Monthly Powercube"
CUBEUPDATE "CubeXYZ"
SAVEPY "D:\Transformer\XYZ.pyj"
EVENTEND
SignonDelete "signonname"

[{"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU053","label":"Cloud \u0026 Data Platform"},"Component":"Transformer","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"8.3","Edition":"","Line of Business":{"code":"","label":""}},{"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU053","label":"Cloud \u0026 Data Platform"},"Component":"Transformer","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"","label":"HP Itanium"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"8.3","Edition":"","Line of Business":{"code":"","label":""}},{"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Transformer","Platform":[{"code":"","label":null}],"Version":"","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Historical Number

1040725

Document Information

Modified date:
28 November 2022

UID

swg21343187

Page Feedback