If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Batch error TR3001 and TR0116

Started by Gaby, 10 Feb 2015 12:15:13 PM

Previous topic - Next topic

Gaby


We have a Transformer Cube that was converted from iQD datasource to a Package datasource.

When we built the cube manually, it build without errors. However we are getting errors when we run it in batch:

Transformer(10.2.5001.14)  Tue Feb 10 11:52:27 2015

LogFileDirectory=C:\Users\cognos\Documents\Transformer\Logs\
ModelSaveDirectory=c:\cognos\production\CubeModels\
DataSourceDirectory=..\data\
CubeSaveDirectory=c:\cognos\production\cubesbeingbuilt\
DataWorkDirectory=c:\cognos\temp\
ModelWorkDirectory=c:\cognos\temp\
MaxTransactionNum=500000
Product locale: English (en)
Run locale: English (United States) (en-us)
Codepage: windows-1252

Tue 10 Feb 2015 11:52:29 AM   0   0008AF6D   (TR3001) The IBM Cognos gateway is unable to connect to the IBM Cognos BI server. The server may be unavailable or the gateway may not be correctly configured. Try again or contact your administrator.
Tue 10 Feb 2015 11:52:29 AM   2   0008AF6D   (TR0116) Transformer can't open the file iVP Sales Base-Mfg.   [->OK]
Transformer  Tue Feb 10 11:52:29 2015

The original command in the Batch file is:

"C:\Program Files (x86)\ibm\cognos\c10\bin\Cogtr.exe" -dLogFileDirectory=%logdir% -n2 -s -m"C:\cognos\Production\CubeModels\iVP all sales history.mdl" -g

I already review the sign-on configuration to be only user name and associate it to the datasource package.

I saw other person with a similar problem and he changed -n2 for -n which launch the transformer when the batch is running.

I tried and in fact the cube built. Why is this happening and there is any way to avoid to launch the transformer?

Thanks.

bdbits

It looks to me like whatever credentials the batch file is running under does not have access to " iVP Sales Base-Mfg".

Are you running the batch file while logged in with the same credentials used when an interactive build works?

nybble

Is the dispatcher for external URI set properly in IBM Cognos Configuration? Double-check that.