Clarity

  • 1.  Invalid prextension column in PRASSIGNMENT table

    Posted Dec 30, 2014 05:51 PM

    Hello everyone,

     

    does anyone have experience with invalid blob ca ppm schema column? We found some (28rows) as invalid. there are 28 assignments with error within application. These rows(assignments) cannot be added(used) to timesheets -> returns server error again.It can not be repaired on DB level and we have no backup from time when these rows had been as valid. Because of this, Post timesheet job is not working - timesheets are not converted from approved to posted status. time slicing where is sliced value from mentioned column is also not working(finishing with error).

     

    We tried in dev to delete content of this column, but this is not recommended step after CA support discussion and we have lost all data about assignment. Do you have any idea how to solve it?

     

    Thank you very much



  • 2.  Re: Invalid prextension column in PRASSIGNMENT table

    Posted Dec 31, 2014 03:22 AM

    What exactly is the error that you get when you try to add those tasks to a timsheet?

    Can you open those projects in OWB and edit the assignments there?



  • 3.  Re: Invalid prextension column in PRASSIGNMENT table

    Posted Dec 31, 2014 03:24 AM

    What error do you see in the logs ?

     

    NJ



  • 4.  Re: Invalid prextension column in PRASSIGNMENT table

    Posted Dec 31, 2014 03:26 AM

    Have you tried to soft reset the slice(s) as mentioned in the below thread ?

     

    https://communities.ca.com/thread/241700038

     

    NJ



  • 5.  Re: Invalid prextension column in PRASSIGNMENT table

    Posted Jan 05, 2015 09:15 AM

    no, we can not try soft reset because time slicing job can not finish because of corrupted lob column prextension which can not be read.

     

    but thank you for your recommendation

    LJ



  • 6.  Re: Invalid prextension column in PRASSIGNMENT table

    Posted Jan 05, 2015 09:24 AM

    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



  • 7.  Re: Invalid prextension column in PRASSIGNMENT table

    Posted Jan 06, 2015 08:08 AM

    If the blobs are corrupted then you more or less have lost the values, but you could try to make the assignments usable and to accept new blos.

    Just wondering if you can use any of the supported methods writing to the blobs without any questions asked?