Automate Cognos 10 cube building through a batch file.

[ilyas57]

Hi,
I need to auomate Cognos 10 cubes building process throgh a BATCH file.

cogtr -n -m "d:\userdata\abc_cube.mdl" is showing error TR2610. Please help.

 

[drlex]

I don't have experience of Cognos10, but in versions 5 through 7, TR2610 indicates that Transformer can't open the model. Can't see why IBM would change that relationship/.

Few thoughts:
*Does the log show any more detail?

*Ensure Transformer is not running and search for any .qy? files (temp model & build files); if you find any files, delete them, then run the batch file again.

*Is there a password on the .mdl model? -z command line option is required in such circumstances
e.g.

cogtr.exe -z username=myUserName -z password=myPassword -c -mModel.mdl

*Have you tried a batch script with a .pyi version (compiled binary which include sign-on details)?

*Does the build complete OK via a CognosScript Macro?

soi là, soi carré

 

[blom0344]

For Cognos 8 we ran into trouble using existing batch files when the first customers went from Win2003 to Win2008 64bit servers.

In most cases we had to add a set path line to the .bat file to be able to execute the cogtr executable

example:

SET PATH=c:\progra~1\Cognos\C841_transformer\bin;

COGTR -nologo -n1 -dLogFileDirectory="C:\Temp\Transformer\Logs" -p"C:\SomeApps\Models\Sometrmodel.pyj"

Ties Blom