we see following error when post timesheet JOB was started:
ERROR 2015-01-05 08:46:39,544 [Dispatch pool-4-thread-6 : bg@domain (tenant=clarity)] niku.xql2 (clarity:ADMIN:20683442__30D8C7AC-F2AF-437D-A645-C8D04AC172B7:Post Timesheets) 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.SQLException: [CA Clarity][Oracle JDBC Driver]Value can not be converted to requested type.
at com.ca.clarity.jdbc.oraclebase.ddcg.b(Unknown Source)
at com.ca.clarity.jdbc.oraclebase.ddcg.a(Unknown Source)
at com.ca.clarity.jdbc.oraclebase.ddcf.b(Unknown Source)
at com.ca.clarity.jdbc.oraclebase.ddcf.a(Unknown Source)
at com.ca.clarity.jdbc.oraclebase.dda_.a(Unknown Source)
at com.ca.clarity.jdbc.oraclebase.dddv.getBytes(Unknown Source)
at com.niku.xql2.jdbc.JDBCUtil.fromSQL(JDBCUtil.java:144)
at com.niku.xql2.jdbc.JDBCRecord.populate(JDBCRecord.java:188)
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:860)
at com.niku.xql2.XQLVisitor.getField(XQLVisitor.java:1427)
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:1078)
at com.niku.xql2.XQLVisitor.eval(XQLVisitor.java:1052)
at com.niku.xql2.handlers.MatchHandler.preProcess(MatchHandler.java:59)
at com.niku.xql2.XQLVisitor.preProcess(XQLVisitor.java:1377)
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:384)
at com.niku.xql2.handlers.LoopHandler.processSet(LoopHandler.java:255)
at com.niku.xql2.handlers.LoopHandler.preProcess(LoopHandler.java:212)
at com.niku.xql2.XQLVisitor.preProcess(XQLVisitor.java:1377)
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:50)
at com.niku.xql2.XQLVisitor.preProcess(XQLVisitor.java:1377)
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:1377)
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:384)
at com.niku.xql2.handlers.LoopHandler.processSet(LoopHandler.java:255)
at com.niku.xql2.handlers.LoopHandler.preProcess(LoopHandler.java:212)
at com.niku.xql2.XQLVisitor.preProcess(XQLVisitor.java:1377)
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:362)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:724)
ERROR 2015-01-05 08:46:39,545 [Dispatch pool-4-thread-6 : bg@domain (tenant=clarity)] xql2.xbl (clarity:ADMIN:20683442__30D8C7AC-F2AF-437D-A645-C8D04AC172B7:Post Timesheets) ****POSTTIMESHEET: Error posting timesheet - unknown error-->timesheetID=5848047
java.lang.Exception: Invalid expression assignmentQuery: java.sql.SQLException: [CA Clarity][Oracle JDBC Driver]Value can not be converted to requested type.
at com.niku.xql2.XQLVisitor.eval(XQLVisitor.java:1126)
at com.niku.xql2.XQLVisitor.eval(XQLVisitor.java:1052)
at com.niku.xql2.handlers.MatchHandler.preProcess(MatchHandler.java:59)
at com.niku.xql2.XQLVisitor.preProcess(XQLVisitor.java:1377)
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:384)
at com.niku.xql2.handlers.LoopHandler.processSet(LoopHandler.java:255)
at com.niku.xql2.handlers.LoopHandler.preProcess(LoopHandler.java:212)
at com.niku.xql2.XQLVisitor.preProcess(XQLVisitor.java:1377)
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:50)
at com.niku.xql2.XQLVisitor.preProcess(XQLVisitor.java:1377)
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:1377)
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:384)
at com.niku.xql2.handlers.LoopHandler.processSet(LoopHandler.java:255)
at com.niku.xql2.handlers.LoopHandler.preProcess(LoopHandler.java:212)
at com.niku.xql2.XQLVisitor.preProcess(XQLVisitor.java:1377)
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:362)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:724)
Caused by: java.lang.RuntimeException: java.sql.SQLException: [CA Clarity][Oracle JDBC Driver]Value can not be converted to requested type.
at com.niku.xql2.XQLVisitor.getObjectSet(XQLVisitor.java:879)
at com.niku.xql2.XQLVisitor.getField(XQLVisitor.java:1427)
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:1078)
... 42 more
Caused by: java.sql.SQLException: [CA Clarity][Oracle JDBC Driver]Value can not be converted to requested type.
at com.ca.clarity.jdbc.oraclebase.ddcg.b(Unknown Source)
at com.ca.clarity.jdbc.oraclebase.ddcg.a(Unknown Source)
at com.ca.clarity.jdbc.oraclebase.ddcf.b(Unknown Source)
at com.ca.clarity.jdbc.oraclebase.ddcf.a(Unknown Source)
at com.ca.clarity.jdbc.oraclebase.dda_.a(Unknown Source)
at com.ca.clarity.jdbc.oraclebase.dddv.getBytes(Unknown Source)
at com.niku.xql2.jdbc.JDBCUtil.fromSQL(JDBCUtil.java:144)
at com.niku.xql2.jdbc.JDBCRecord.populate(JDBCRecord.java:188)
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:860)
... 46 more