Batch file to build cube build fails!!! Cognos 7.4

[Sidney786]

Hi,

I have recently configured two new cognos 7.4 build servers. I am running SQL server 2000.

I have created a DTS job which calls batch file to automate cube builds i.e. "C:\Program Files\Cognos\cer5\bin\trnsfrmr.exe" -n2 -s "D:\******\Reporting\Models\Cube 023 (Sales and Margin Cube).pyi"

The error message i am getting when executing the .bat via my DTS job is:
Tue 21 Dec 2010 08:34:50 0 00000000 (TR3106) Transformer may require signon information from Access Manager. If you do not log into Access Manager you will be prompted for this information as required. Do you want to log into Access Manager? [->No]
Tue 21 Dec 2010 08:34:50 2 00000000 (TR3108) Transformer could not load User Class information. Authentication error. The signon is invalid. [->OK]

Can anyone help or make any suggestions?

Thanks

Sid

 

[drlex]

The issue is that the pyi model includes security and the authentication is not included in the batch call.
Alternative methods:
Use mdl model
Build with macro rather than batch file
Add OS authentication to the log-on used to call the batch file

soi là, soi carré