I've recently set up our development instance of Information Server 9.1 on AIX 6.1. I had a lot of fun (!) setting up Operations Console which is now far more complicated to install than on 8.7. We're using the bundled DB2 for xmeta but a separate Oracle repository to drive the Ops Console. Many features appear to work, and many don't. Most notably, I get errors such as this in the DSODB/logs directory ...
Code: Select all
2013-02-22 19:49:57,692 ERROR com.ibm.datastage.runtime.common.db.DBManager.insertRecordCmd(DBManager.java:819) - Error executing insert statement: INSERT INTO dev.JobStage (STAGEID,JOBID,StageName,ContainerPath,StageDescription,StageTypeName) VALUES (?,?,?,?,?,?). Values: [-8841748148679787574, -8581750872848403646, , -, , ]
java.sql.SQLIntegrityConstraintViolationException: [IBM][Oracle JDBC Driver][Oracle]ORA-01400: cannot insert NULL into ("DEV"."JOBSTAGE"."STAGENAME")
at com.ibm.isf.jdbc.oraclebase.ddcg.b(Unknown Source)
at com.ibm.isf.jdbc.oraclebase.ddcg.a(Unknown Source)
at com.ibm.isf.jdbc.oraclebase.ddcf.b(Unknown Source)
at com.ibm.isf.jdbc.oraclebase.ddcf.a(Unknown Source)
at com.ibm.isf.jdbc.oracle.ddn.s(Unknown Source)
at com.ibm.isf.jdbc.oraclebase.ddes.v(Unknown Source)
at com.ibm.isf.jdbc.oraclebase.ddes.x(Unknown Source)
at com.ibm.isf.jdbc.oraclebase.dddm.executeUpdate(Unknown Source)
at com.ibm.datastage.runtime.common.db.DBManager.insertRecordCmd(DBManager.java:807)
at com.ibm.datastage.runtime.common.db.DBManager.insertRecord(DBManager.java:753)
at com.ibm.datastage.runtime.common.GeneratedKeyInserter.insertRecord(GeneratedKeyInserter.java:74)
at com.ibm.datastage.runtime.engmonapp.FileManager.insertGenKeyRecord(FileManager.java:1766)
at com.ibm.datastage.runtime.engmonapp.FileManager.insertGenKeyRecord(FileManager.java:1749)
at com.ibm.datastage.runtime.engmonapp.FileManager.getOrAddStageRecord(FileManager.java:1909)
at com.ibm.datastage.runtime.engmonapp.FileManager.processStageRun(FileManager.java:1439)
at com.ibm.datastage.runtime.engmonapp.FileManager.processFile(FileManager.java:809)
at com.ibm.datastage.runtime.engmonapp.FileManager.processDirectory(FileManager.java:526)
at com.ibm.datastage.runtime.engmonapp.FileManager.watchForDirectories(FileManager.java:397)
at com.ibm.datastage.runtime.engmonapp.EngMonApp.run(EngMonApp.java:102)
at com.ibm.datastage.runtime.engmonapp.EngMonApp.main(EngMonApp.java:133)
2013-02-22 19:49:57,694 ERROR com.ibm.datastage.runtime.engmonapp.FileManager.discardEventFile(FileManager.java:2531) - Content of event file 4948_000_10224342_00004_9.dsv:
ODBEVENT=9
AT=2013-02-22 08:49:48+0000
J.ProjectName=ANALYZERPROJECT
J.JobName=BaseProfileLoad1_ColumnAnalysisTask95321104
J.CompilationTimestamp=2013-02-22 08:41:30
R.InvocationId=
R.CreationTimestamp=2013-02-22 08:48:10.881+0000
S.StageName=
S.ContainerPath=
S.StageDescription=
S.StageTypeName=
T.StageEndTimestamp=2013-02-22 08:49:48+0000
T.ElapsedRunSecs=0
T.StageStatus=RDY
T.NumInstances=1
T.InstancePidList=
T.InstanceCPUList=0
T.TotalCPU=0
2013-02-22 19:49:57,694 INFO com.ibm.datastage.runtime.engmonapp.FileManager.discardEventFile(FileManager.java:2543) - Event file removed: 4948_000_10224342_00004_9.dsv
Thanks,
John.
PS. @Moderator: You need to add "9.1" to the list of available DataStage releases when submitting a new post!