Hi !
I’ve got a problem when I export data from a table to another table (same metadata) under Oracle.
The two tables are not on the same server and instance.
When the second table is empty there is no problem : all of the data are transfered to the 2nd one.
Now When I execute a 2nd time my graph it fails with an “OALL8 is in an inconsistent state” error.
It fails just when it reads the records of the second table.
I’ve tried to change Oracle jdbc driver but nothing to do !
Can someone help me ?
This is the log :
25 juil. 2006 12:01:40 org.jetel.graph.TransformationGraph init
INFO: Initializing DB connection:
25 juil. 2006 12:01:40 org.jetel.graph.TransformationGraph init
INFO: DBConnection driver[oracle.jdbc.driver.OracleDriver]:url[jdbc:oracle:thin:@lancelot:1522:or52]:user[production] … OK
25 juil. 2006 12:01:40 org.jetel.graph.TransformationGraph init
INFO: Initializing DB connection:
25 juil. 2006 12:01:40 org.jetel.graph.TransformationGraph init
INFO: DBConnection driver[oracle.jdbc.driver.OracleDriver]:url[jdbc:oracle:thin:@localhost:1521:dmbo]:user[infocentre] … OK
25 juil. 2006 12:01:41 org.jetel.graph.TransformationGraph run
INFO: Starting WatchDog thread …
25 juil. 2006 12:01:41 org.jetel.graph.WatchDog run
INFO: Thread started.
25 juil. 2006 12:01:41 org.jetel.graph.WatchDog run
INFO: Running on 1 CPU(s) max available memory for JVM 1140 KB
25 juil. 2006 12:01:41 org.jetel.graph.Phase init
INFO: [Clover] Initializing phase: 0
25 juil. 2006 12:01:46 org.jetel.graph.Phase init
INFO: [Clover] phase: 0 initialized successfully.
25 juil. 2006 12:01:46 org.jetel.graph.WatchDog runPhase
INFO: Starting up all nodes in phase [0]
25 juil. 2006 12:01:48 org.jetel.graph.WatchDog runPhase
INFO: Sucessfully started all nodes in phase!
25 juil. 2006 12:01:52 org.jetel.graph.WatchDog watch
GRAVE: !!! Fatal Error !!! - graph execution is aborting
25 juil. 2006 12:01:52 org.jetel.graph.WatchDog watch
GRAVE: Node INFOCENTRE finished with fatal error: org.jetel.exception.JetelException : OALL8 is in an inconsistent state
25 juil. 2006 12:01:52 org.jetel.graph.WatchDog abort
ATTENTION: Interrupted node: PRODUCTION
25 juil. 2006 12:01:52 org.jetel.graph.WatchDog abort
ATTENTION: Interrupted node: INFOCENTRE
25 juil. 2006 12:01:52 org.jetel.graph.WatchDog abort
ATTENTION: Interrupted node: BUFFER_COMPARE0
java.lang.InterruptedException
at java.lang.Object.wait(Native Method)
at java.lang.Object.wait(Unknown Source)
at org.jetel.graph.DirectEdge.fillReadBuffer(Unknown Source)
at org.jetel.graph.DirectEdge.readRecord(Unknown Source)
at org.jetel.graph.Edge.readRecord(Unknown Source)
at org.jetel.component.DBOutputTable.runInNormalMode(Unknown Source)
at org.jetel.component.DBOutputTable.run(Unknown Source)
25 juil. 2006 12:01:52 org.jetel.graph.WatchDog abort
ATTENTION: Interrupted node: INFOCENTRE_SUPPR
25 juil. 2006 12:01:52 org.jetel.graph.WatchDog abort
ATTENTION: Interrupted node: INFOCENTRE_MAJ
25 juil. 2006 12:01:52 org.jetel.graph.WatchDog$PrintTracking printProcessingStatus
INFO: ---------------------** Start of tracking Log for phase [0] **-------------------
25 juil. 2006 12:01:52 org.jetel.graph.WatchDog$PrintTracking printProcessingStatus
INFO: Time: 25/07/06 12:01:52
25 juil. 2006 12:01:52 org.jetel.graph.WatchDog$PrintTracking printProcessingStatus
INFO: Node Status Port #Records
25 juil. 2006 12:01:52 org.jetel.graph.WatchDog$PrintTracking printProcessingStatus
INFO: ---------------------------------------------------------------------------------
25 juil. 2006 12:01:52 org.jetel.graph.WatchDog$PrintTracking printProcessingStatus
INFO: PRODUCTION FATAL_ERROR
25 juil. 2006 12:01:52 org.jetel.graph.WatchDog$PrintTracking printProcessingStatus
INFO: Out:0 1267
25 juil. 2006 12:01:52 org.jetel.graph.WatchDog$PrintTracking printProcessingStatus
INFO: INFOCENTRE FATAL_ERROR
25 juil. 2006 12:01:52 org.jetel.graph.WatchDog$PrintTracking printProcessingStatus
INFO: Out:0 720
25 juil. 2006 12:01:52 org.jetel.graph.WatchDog$PrintTracking printProcessingStatus
INFO: BUFFER_COMPARE0 FATAL_ERROR
25 juil. 2006 12:01:52 org.jetel.graph.WatchDog$PrintTracking printProcessingStatus
INFO: In:0 1267
25 juil. 2006 12:01:52 org.jetel.graph.WatchDog$PrintTracking printProcessingStatus
INFO: In:1 720
25 juil. 2006 12:01:52 org.jetel.graph.WatchDog$PrintTracking printProcessingStatus
INFO: Out:0 0
25 juil. 2006 12:01:52 org.jetel.graph.WatchDog$PrintTracking printProcessingStatus
INFO: Out:1 0
25 juil. 2006 12:01:52 org.jetel.graph.WatchDog$PrintTracking printProcessingStatus
INFO: Out:2 0
25 juil. 2006 12:01:52 org.jetel.graph.WatchDog$PrintTracking printProcessingStatus
INFO: INFOCENTRE_SUPPR FATAL_ERROR
25 juil. 2006 12:01:52 org.jetel.graph.WatchDog$PrintTracking printProcessingStatus
INFO: In:0 0
25 juil. 2006 12:01:52 org.jetel.graph.WatchDog$PrintTracking printProcessingStatus
INFO: INFOCENTRE_MAJ ERROR
25 juil. 2006 12:01:52 org.jetel.graph.WatchDog$PrintTracking printProcessingStatus
INFO: In:0 0
25 juil. 2006 12:01:52 org.jetel.graph.WatchDog$PrintTracking printProcessingStatus
INFO: ---------------------------------** End of Log **--------------------------------
25 juil. 2006 12:01:52 org.jetel.graph.WatchDog run
GRAVE: !!! Phase finished with error - stopping graph run !!!
25 juil. 2006 12:01:52 org.jetel.graph.TransformationGraph run
INFO: WatchDog thread finished - total execution time: 11 (sec)
25 juil. 2006 12:01:52 org.jetel.graph.TransformationGraph run
GRAVE: !!! Graph execution finished with errors !!!
Failed starting graph !