Oracle & Events Help

DavidMusser

I'm trying to use Oracle 9i with OD for reporting.

I configured the db as per the adming guide pg 278, and was able to use the DB tools.bat to created the tables.

I am getting the following error in the admin log.

005-11-22 15:15:19 EST - SQLException: SQLState(23000) vendor code(2291)
2005-11-22 15:15:19 EST - java.sql.SQLException: ORA-02291: integrity constraint (IWOD60.SYS_C002864) violated - parent key not found

2005-11-22 15:15:19 EST - at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
2005-11-22 15:15:19 EST - at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
2005-11-22 15:15:19 EST - at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:582)
2005-11-22 15:15:19 EST - at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1986)
2005-11-22 15:15:19 EST - at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1144)
2005-11-22 15:15:19 EST - at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2152)
2005-11-22 15:15:19 EST - at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:2035)
2005-11-22 15:15:19 EST - at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2876)
2005-11-22 15:15:19 EST - at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:609)
2005-11-22 15:15:19 EST - at com.interwoven.deploy.event.TReceiverEventListener.onPathReceiveMessage(TReceiverEventListener.java:859)
2005-11-22 15:15:19 EST - at com.interwoven.deploy.event.TReceiverEventListener.onMessage(TReceiverEventListener.java:175)
2005-11-22 15:15:19 EST - at org.exolab.jms.client.JmsMessageConsumer.onMessage(JmsMessageConsumer.java:292)
2005-11-22 15:15:19 EST - at org.exolab.jms.client.JmsSession.execute(JmsSession.java:669)
2005-11-22 15:15:19 EST - at org.exolab.jms.client.JmsSession.onMessage(JmsSession.java:607)
2005-11-22 15:15:19 EST - at org.exolab.jms.client.mipc.IpcJmsMessageListener.onMessage(IpcJmsMessageListener.java:154)
2005-11-22 15:15:19 EST - at org.exolab.jms.client.mipc.IpcJmsMessageListener.run(IpcJmsMessageListener.java:225)
2005-11-22 15:15:19 EST - at java.lang.Thread.run(Thread.java:534)
2005-11-22 15:15:19 EST - SQLException: SQLState(null) vendor code(17055)

Any ideas?

The configuration in my admineventreportingconfig.xml is

<!-- Uncomment for using Oracle database. Replace the parameters. -->
<database name="ReportingDB"
className="oracle.jdbc.driver.OracleDriver"
connectionString="jdbcracle:thin:@myserver:1521:mydb">
<property name="user" value="myuser" />
<property name="password" value="mypassword" />
</database>


David R Musser
Eye Street Software
540-542-5257
dmusser@eyestreet.com
Win2k, TS 6.5 SP1, OD 6.01

DavidMusser

This error is with an updated jdbc driver.

2005-11-22 15:15:19 EST - SQLException: SQLState(null) vendor code(17055)
2005-11-22 15:15:19 EST - java.sql.SQLException: Invalid character encountered in: failAL32UTF8Conv

The other was with the classes12.zip. I pasted the wrong error before. I had to use the newer driver in order to get the tables to be able to be created. I was gettign error: 7 with the default jdbc drivers.

David R Musser
Eye Street Software
540-542-5257
dmusser@eyestreet.com
Win2k, TS 6.5 SP1, OD 6.01