AnsweredAssumed Answered

Post Timesheet job is failing in 14.3

Question asked by Piyush_Agrawal on Sep 28, 2016
Latest reply on Nov 16, 2016 by Franvu

We have upgraded from 14.2 to 14.3. After this, Post Timesheet job is failing with below error in bg-ca.log:

 

ERROR 2016-09-28 08:24:35,805 [Dispatch Post Timesheets 28sep1 : bg2@APSED1904 (tenant=clarity)] niku.xql2 (clarity:PAGRAWA1:22149101__B6A76872-1233-49CD-9271-F969B51F004F:Post Timesheets 28sep1) SQLException with query:
    select  PRAssignment.*, PRTASK.PRPROJECTID
    from    PRAssignment, PRTimeEntry, PRTimeSheet, PRJ_RESOURCES,PRTimePeriod, PRTASK
    where   PRAssignment.prID=PRTimeEntry.prAssignmentID
    and   PRTimeEntry.prTimeSheetID=PRTimeSheet.prID
    and   PRTimeSheet.prStatus=3
    and   PRTimeSheet.prModTime<?
    and   PRTimeSheet.prResourceID=PRJ_RESOURCES.prID
    and   PRJ_RESOURCES.prTrackMode=2
    and   PRTimeSheet.prTimePeriodID=PRTimePeriod.prID
    and   PRTimePeriod.prFinish<?
    and   PRAssignment.PRTASKID = PRTASK.PRID
   
java.sql.SQLNonTransientConnectionException: [CA Clarity][Oracle JDBC Driver]Internal error: Net8 protocol error.
at com.ca.clarity.jdbc.oraclebase.ddcr.b(Unknown Source)
at com.ca.clarity.jdbc.oraclebase.ddcr.a(Unknown Source)
at com.ca.clarity.jdbc.oraclebase.ddcq.b(Unknown Source)
at com.ca.clarity.jdbc.oraclebase.ddcq.a(Unknown Source)
at com.ca.clarity.jdbc.oracle.OracleImplConnection.a(Unknown Source)
at com.ca.clarity.jdbc.oracle.ddag.a(Unknown Source)
at com.ca.clarity.jdbc.oracle.ddj.a(Unknown Source)
at com.ca.clarity.jdbc.oraclebase.ddd6.getBytes(Unknown Source)
at com.niku.xql2.jdbc.JDBCUtil.fromSQL(JDBCUtil.java:144)
at com.niku.xql2.jdbc.JDBCRecord.populate(JDBCRecord.java:191)
at com.niku.xql2.jdbc.JDBCRecordSet.<init>(JDBCRecordSet.java:169)
at com.niku.xql2.jdbc.JDBCDataSource.createNewRecordSet(JDBCDataSource.java:254)
at com.niku.xql2.jdbc.JDBCDataSource.select(JDBCDataSource.java:237)
at com.niku.xql2.XQLVisitor.getObjectSet(XQLVisitor.java:868)
at com.niku.xql2.XQLVisitor.getField(XQLVisitor.java:1480)
at com.niku.xql2.eval.XQLPropertyNode.eval(XQLPropertyNode.java:92)
at com.niku.xql2.eval.XQLEvaluator.parse(XQLEvaluator.java:40)
at com.niku.xql2.XQLVisitor.eval(XQLVisitor.java:1086)
at com.niku.xql2.XQLVisitor.eval(XQLVisitor.java:1060)
at com.niku.xql2.handlers.MatchHandler.preProcess(MatchHandler.java:59)
at com.niku.xql2.XQLVisitor.preProcess(XQLVisitor.java:1385)
at com.niku.union.xml.dom.DOMWalker.preProcess(DOMWalker.java:194)
at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:74)
at com.niku.union.xml.dom.DOMWalker.traverse(DOMWalker.java:51)
at com.niku.xql2.handlers.LoopHandler.processObject(LoopHandler.java:388)
at com.niku.xql2.handlers.LoopHandler.processSet(LoopHandler.java:259)
at com.niku.xql2.handlers.LoopHandler.preProcess(LoopHandler.java:216)
at com.niku.xql2.XQLVisitor.preProcess(XQLVisitor.java:1385)
at com.niku.union.xml.dom.DOMWalker.preProcess(DOMWalker.java:194)
at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:74)
at com.niku.union.xml.dom.DOMWalker.traverse(DOMWalker.java:51)
at com.niku.xql2.handlers.TryHandler.preProcess(TryHandler.java:54)
at com.niku.xql2.XQLVisitor.preProcess(XQLVisitor.java:1385)
at com.niku.union.xml.dom.DOMWalker.preProcess(DOMWalker.java:194)
at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:74)
at com.niku.union.xml.dom.DOMWalker.traverse(DOMWalker.java:51)
at com.niku.xql2.handlers.LockHandler.preProcess(LockHandler.java:100)
at com.niku.xql2.XQLVisitor.preProcess(XQLVisitor.java:1385)
at com.niku.union.xml.dom.DOMWalker.preProcess(DOMWalker.java:194)
at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:74)
at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:92)
at com.niku.union.xml.dom.DOMWalker.traverse(DOMWalker.java:51)
at com.niku.xql2.handlers.LoopHandler.processObject(LoopHandler.java:388)
at com.niku.xql2.handlers.LoopHandler.processSet(LoopHandler.java:259)
at com.niku.xql2.handlers.LoopHandler.preProcess(LoopHandler.java:216)
at com.niku.xql2.XQLVisitor.preProcess(XQLVisitor.java:1385)
at com.niku.union.xml.dom.DOMWalker.preProcess(DOMWalker.java:194)
at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:74)
at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:92)
at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:92)
at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:92)
at com.niku.union.xml.dom.DOMWalker.traverse(DOMWalker.java:36)
at com.niku.xql2.XQLProcessor.process(XQLProcessor.java:257)
at com.niku.njs.xbl.XBLService.process(XBLService.java:127)
at com.niku.njs.xbl.XBLService.process(XBLService.java:75)
at com.niku.njs.listeners.XBLJob.scheduledEventFired(XBLJob.java:44)
at com.niku.njs.Dispatcher$BGTask.run(Dispatcher.java:395)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
ERROR 2016-09-28 08:24:35,805 [Dispatch Post Timesheets 28sep1 : bg2@APSED1904 (tenant=clarity)] xql2.xbl (clarity:PAGRAWA1:22149101__B6A76872-1233-49CD-9271-F969B51F004F:Post Timesheets 28sep1) ****POSTTIMESHEET: Error posting timesheet - unknown error-->timesheetID=7986678
java.lang.Exception: Invalid expression assignmentQuery: java.sql.SQLNonTransientConnectionException: [CA Clarity][Oracle JDBC Driver]Internal error: Net8 protocol error.

Outcomes