Cognos Transformer Cube Refresh - Request Help

[cypherjobin]

Hi All,

I am trying to perform a cube refresh, however the script is throwing me the below error message in batch mode.

Sun 28 Jun 2015 12:18:37 AM   0   00000000   (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.
Sun 28 Jun 2015 12:18:37 AM   2   00000000   (TR0116) Transformer can't open the file TIme Day.   [->OK]
Transformer  Sun Jun 28 00:18:37 2015

The interactive mode over the batch (-n) is opening up the transformer and manually forcing me to login to the cognos server followed by selection of name space.

However the batch mode (-n2) is failing with the above error even after I created a signon over the namespace.

I have tried both the options below.

cogtr -n2 -c -gxxxx -s -pC:\Cognos\xxxx\Models\yyyyy.pyj

and

cogtr -n2 -dLoFileDirectory="C:\xxxx\logs" -c -lsignon=username/password -pC:\Cognos\xxxx\Models\yyyyy.pyj

both of these commands are throwing me the same error.

Can some one help me over here? Thanks a million in advance for your support.

Regards
JJ

[bdbits]

On the machine where the batch file is executing, does an interactive cube generation work? If not, get that working first or the batch file will likely never work either.

Is the batch file running with your credentials or a different logon name? If it is a different logon, does it have at least as much permission as a working, interactive cube generation user has? Is the file it is referencing on a local drive or a network drive, and if the latter does the logon the batch file is running under have the same drive mappings?

[cognostechie]

Hi All,

I am trying to perform a cube refresh, however the script is throwing me the below error message in batch mode.

Sun 28 Jun 2015 12:18:37 AM   0   00000000   (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.
Sun 28 Jun 2015 12:18:37 AM   2   00000000   (TR0116) Transformer can't open the file TIme Day.   [->OK]
Transformer  Sun Jun 28 00:18:37 2015

The interactive mode over the batch (-n) is opening up the transformer and manually forcing me to login to the cognos server followed by selection of name space.

However the batch mode (-n2) is failing with the above error even after I created a signon over the namespace.

I have tried both the options below.

cogtr -n2 -c -gxxxx -s -pC:\Cognos\xxxx\Models\yyyyy.pyj

and

cogtr -n2 -dLoFileDirectory="C:\xxxx\logs" -c -lsignon=username/password -pC:\Cognos\xxxx\Models\yyyyy.pyj

both of these commands are throwing me the same error.

Can some one help me over here? Thanks a million in advance for your support.

Regards
JJ

Don't try to pass the signon from the batch file. Open Transformer model and in the signon window, put the credentials, then save the model. You can also
specify the log file into in the model from the File menu. Remove the signon and the log file info from the batch file and run the script.