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

Cognos 8.4 & TWS (Tivoli Workload Scheduler)

Started by Miggy74, 28 Jan 2011 02:45:42 AM

Previous topic - Next topic

Miggy74

I'd like to trigger Cognos reports via TWS so to do this we're using the following script

set JAVA_HOME=D:/Progra~1/cognos/c8/bin/jre/1.5.0/bin/java.exe
set CRN_HOME=D:/Progra~1/cognos/c8

set JAR_HOME=D:/progra~1/cognos/c8/sdk/java/lib

set CLASSPATH=.
set CLASSPATH=%CLASSPATH%;%JAR_HOME%/axis.jar
set CLASSPATH=%CLASSPATH%;%JAR_HOME%/axisCognosClient.jar
set CLASSPATH=%CLASSPATH%;%JAR_HOME%/commons-discovery.jar
set CLASSPATH=%CLASSPATH%;%JAR_HOME%/commons-logging.jar
set CLASSPATH=%CLASSPATH%;%JAR_HOME%/jaxrpc.jar
set CLASSPATH=%CLASSPATH%;%JAR_HOME%/saaj.jar
set CLASSPATH=%CLASSPATH%;%JAR_HOME%/xml-apis.jar
set CLASSPATH=%CLASSPATH%;%JAR_HOME%/xercesImpl.jar

rem Following 5 lines added on recomendation of IBM

set ALLUSERSPROFILE=C:\Documents and Settings\All Users
set APPDATA=C:\Documents and Settings\maestro\Application Data
set CommonProgramFiles=C:\Program Files\Common Files
set ProgramFiles=C:\Program Files
set LOGNAME=INTERNAL\maestro

rem "%JAVA_HOME%" -classpath %CLASSPATH% Trigger %1 %2 %3 %4 %5

"%JAVA_HOME%" -classpath %CLASSPATH% Trigger http://SERVERNAME/cognos8/cgi-bin/cognosisapi.dll Username Password SL_ELAD %1
-------------

The above works via a batch file and you get a message back saying triggered
We then converted to a exe using exescript, again works but no message saying triggered

When we run the 'exe TRIGGER' via TWS the reports are again triggered successfully but something is return a 1 to TWS indicating an error.

Any ideas?