Clarity

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.

Have you check the below conditions?

The following criteria must be fulfilled:
-The timesheet has not been in the 'Approved' status for at least 5 minutes before running the Post Timesheets job.
-The time period is closed.
-The resource is not "Open For Time Entry".
-The investment is not "Open For Time Entry".
-The investment "Track Mode" is not set.
-Is setting in Administration, Project Settings: "Allow posting of future timesheets" checkmarked?
  If not, the current time period has not yet ended, therefore the timesheet will not post.
-If there is a custom process involving the timesheet, make sure the conditions are met.

Also, check if the below 2 help:

Post TimeSheet Error : Timesheet Not Getting Posted 

Invalid prextension column in PRASSIGNMENT table 

NJ

Hi,

These things to be checked when status is not changing from approved to posted. We are facing job failure instantly with Net8 protocol error

Looks like you are hitting one of oracle bug 

Progress KB - "Object has been closed" or "Internal error: Net8 protocol error" error with Oracle JDBC driver when execu… 

Hi,

    we have a similar problem.

    How have you solved your problem?

Cheers.