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.
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?
Is the dispatcher for external URI set properly in IBM Cognos Configuration? Double-check that.