Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Transformer => Topic started by: qvixote on 10 Jul 2014 10:57:07 AM

Title: SQL Server Agent calling cogtr.exe ends with exit code 1
Post by: qvixote on 10 Jul 2014 10:57:07 AM
Hello!

I have a batch file with this only one command:

Code Select
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.
Title: Re: SQL Server Agent calling cogtr.exe ends with exit code 1
Post by: qvixote on 14 Jul 2014 01:29:27 PM
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.
Text only | Text with Images