AnsweredAssumed Answered

Datamart Job has failed after running for 13 hours

Question asked by Thilak.Kesavan on Apr 18, 2013
Latest reply on Apr 21, 2013 by Thilak.Kesavan
Hi Every one

We have an issue with the Datamart job, we run the financial jobs evry week end, after tis the monday run of Datamart always takes a long time and fails with the below error

Please suggest how to fix this issue


Datamart Job has failed after running for 13 hours :blink:


ERROR 2013-04-02 10:04:50,067 persistence.PersistenceControllert (none:none:none) Exception due to DB Connection failure
ERROR 2013-04-02 10:04:50,068 niku.njs (none:none:none) Error executing job: 6329542
com.niku.union.persistence.DBConnectionException: java.sql.SQLException: [CA Clarity][Oracle JDBC Driver]No more data available to read.
at com.niku.union.persistence.PersistenceController.handleSQLException(PersistenceController.java:1823)
at com.niku.union.persistence.PersistenceController.processSql(PersistenceController.java:2349)
at com.niku.union.persistence.PersistenceController.processStatement(PersistenceController.java:702)
at com.niku.union.persistence.PersistenceController.processStatements(PersistenceController.java:611)
at com.niku.union.persistence.PersistenceController.doProcessRequest(PersistenceController.java:451)
at com.niku.union.persistence.PersistenceController.processRequest(PersistenceController.java:222)
at com.niku.njs.listeners.PMDJob.scheduledEventFired(PMDJob.java:75)
at com.niku.njs.Dispatcher$BGTask.run(Dispatcher.java:277)
at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:727)
at java.lang.Thread.run(Thread.java:619)

Outcomes