Problem execute job publish from Datamanager

Cognos 10 Business Intelligence Cognos Connection
1

called a job running a batch file that executes transformer. job waits for ever

10.1.1 64-bit Cognos
DataManager 64-bit
windows 2008 64 bit

on the same machine
Transformer contains sign on a namespace
batch file contains
cogtr-r4-c-n2-g-pE: \ dm \ dm.pyj

please help

2

does your batch file work when you start it from a dos-box?

i find the line
cogtr-r4-c-n2-g-pE: \ dm \ dm.pyj
looking weird :-\

i expect something more like this:
cogtr.exe -r4-c-n2-g-pE:\dm\dm.pyj

3

[quote=“marco, post:1, topic:555”]called a job running a batch file that executes transformer. job waits for ever

10.1.1 64-bit Cognos
DataManager 64-bit
windows 2008 64 bit

on the same machine
Transformer contains sign on a namespace
batch file contains
cogtr-r4-c-n2-g-pE: \ dm \ dm.pyj

please help[/quote]

I have no clue what you are talking about but calling transformer from a batch requires some steps which I think you may have left out.
You have to change to the bin directory before you call transformer.
Sample batch:

c: cd c:\progra~1\ibm\cognos\bin cogtr.exe -n2 -g -pC:\cubes\models\mymodel.pyj

Some things to note here:
-r4 : Not needed as this is always the default
-c : only use this if you need to generate categories otherwise it can be omitted
Transformer command line options:
http://publib.boulder.ibm.com/infocenter/cbi/v10r1m0/index.jsp?topic=%2Fcom.ibm.swg.im.cognos.ug_cogtr.10.1.0.doc%2Fug_cogtr_id11943CommandLineOptions.html

I would also suggest that using an MDL over pyj is recommended. pyj files are compiled and will cause issues later on (this is my experience). Usually resolved with saving the pyj to mdl then reopening the mdl and saving it back to pyj. Never had a problem with mdl.

Same batch commands as above using mdl…

c: cd c:\progra~1\ibm\cognos\bin cogtr.exe -n2 -g -mC:\cubes\models\mymodel.mdl

NOTE TO ADMIN: Might want to add a Transformer sub forum.

4

excellent suggestion Grim. Consider it done!