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.