SQL Server Agent calling cogtr.exe ends with exit code 1

[qvixote]

Hello!

I have a batch file with this only one command:

Code Select Expand

c:\ibm\cognos\c10\bin\cogtr.exe -n2 -c -ju -g -lcso=myuser/mypassword -p"C:\Users\Administrador\Documents\Transformer\Model\DEIS_BI_ATENCION_URGENCIA\DBAU.pyj"


When I execute the batch file manually it works fine (create, update and deploy the cube as indicated in the command), but when I call it from a Operating System (CmdExec) step on a SQL Server Agent job, it fail with the following error message:

Executed as user: NT Service\SQLSERVERAGENT. IBM Cognos Transformer version 10.2.1003.25.  Process Exit Code 1.  The step failed.

The "IBM Cognos Transformer version 10.2.1003.25" part of the message is the output text that the command shows when executed manually. Can anyone give me an idea of what is failing, since the error message is not much useful.

Thanks.

[qvixote]

After searching the web with no results, and trying a lot of things, finally got this resolved. I had to give permissions to SQL Server Agent's Windows user (SQLSERVERAGENT) to access the cognos installation directory.