Hi all,
When invastigating LDAP job error I have seen another job issue
Does any one has any idea about this issue? Where can I start to dig?
I have check PRJ_BLB_SLICE_RESET_ALL_SP and does not have a sub query.
Regards
ERROR 2017-01-18 08:28:15,108 [Dispatch Time Slicing : bg@S0134CAAPP01 (tenant=clarity)] niku.njs (clarity:admin:5644473__5369318E-9BE3-4519-BEBC-23528CFD2CBE:Time Slicing) Error executing job: 1030 error The timeslice job has failed.
ERROR 2017-01-18 08:29:15,614 [Dispatch Time Slicing : bg@S0134CAAPP01 (tenant=clarity)] niku.blobcrack (clarity:admin:5644476__AFB37282-4E11-472C-B3D2-684F200B4606:Time Slicing) Exception during blobcrack process
com.niku.union.persistence.PersistenceException:
SQL error code: 512
Error message: [CA Clarity][SQLServer JDBC Driver][SQLServer]Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
SQL error code: 3621
Error message: [CA Clarity][SQLServer JDBC Driver][SQLServer]The statement has been terminated.
Executed:
{call PRJ_BLB_SLICE_RESET_ALL_SP(?,?)}
Derived from statement:
<?xml version="1.0" encoding="UTF-8"?>
<statement sortColumnPath="/data/header/sortInfo/@sortColumn" sortDirectionPath="/data/header/sortInfo/@sortDirection" slicePath="/data/header/pagination/sliceInfo/@slice" sliceSizePath="/data/header/pagination/sliceInfo/@sliceSize" inputSource="map" xmlns="http://schemas.niku.com/2002/pmd">
<sql dbVendor="all">
<text>
{call PRJ_BLB_SLICE_RESET_ALL_SP(?,?)}
</text>
<param type="string" direction="IN" constantValue="PRJ_RESOURCES" expressionListDelimiter=","/>
<param name="sliceStatusFlag" type="int" direction="IN" expressionListDelimiter=","/>
</sql>
</statement>
Referenced by:
<?xml version="1.0" encoding="UTF-8"?>
<statementRef id="blobcrack.setAllResourcesModified_set_nested_0" inputSource="map" inputMapIndex="0" sortColumnPath="/data/header/sortInfo/@sortColumn" sortDirectionPath="/data/header/sortInfo/@sortDirection" slicePath="/data/header/pagination/sliceInfo/@slice" sliceSizePath="/data/header/pagination/sliceInfo/@sliceSize" defaultSliceSize="20" ignoreIfError="false" hideResultSets="false" xmlns="http://schemas.niku.com/2002/pmd"/>
Using input:
{sliceStatusFlag=3, parameters=[int:sliceStatusFlag:3:]}
at com.niku.union.persistence.PersistenceController.createException(PersistenceController.java:2085)
at com.niku.union.persistence.PersistenceController.handleSQLException(PersistenceController.java:2189)
at com.niku.union.persistence.PersistenceController.processSql(PersistenceController.java:2823)
at com.niku.union.persistence.PersistenceController.processStatement(PersistenceController.java:869)
at com.niku.union.persistence.PersistenceController.processStatements(PersistenceController.java:769)
at com.niku.union.persistence.PersistenceController.doProcessRequest(PersistenceController.java:577)
at com.niku.union.persistence.PersistenceController.processRequest(PersistenceController.java:307)
at com.niku.xql2.pmd.PMDDataSource.execute(PMDDataSource.java:213)
at com.niku.blobcrack.BlobCrackDB.resetRequest(BlobCrackDB.java:306)
at com.niku.blobcrack.BlobCrackDB.resetRequests(BlobCrackDB.java:336)
at com.niku.blobcrack.BlobCrackDB.prepareSliceStatus(BlobCrackDB.java:1996)
at com.niku.blobcrack.BlobCrackDB.sliceCurves(BlobCrackDB.java:1720)
at com.niku.blobcrack.BlobCrackDB.createSlices(BlobCrackDB.java:1252)
at com.niku.blobcrack.xql2.handlers.BlobCracker.processExpiredRequests(BlobCracker.java:233)
at com.niku.blobcrack.xql2.handlers.BlobCracker.postProcess(BlobCracker.java:45)
at com.niku.xql2.XQLVisitor.postProcess(XQLVisitor.java:1419)
at com.niku.union.xml.dom.DOMWalker.postProcess(DOMWalker.java:210)
at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:94)
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.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)
Caused by: java.sql.SQLException: [CA Clarity][SQLServer JDBC Driver][SQLServer]Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
at com.ca.clarity.jdbc.sqlserverbase.ddcw.b(Unknown Source)
at com.ca.clarity.jdbc.sqlserverbase.ddcw.a(Unknown Source)
at com.ca.clarity.jdbc.sqlserverbase.ddcv.b(Unknown Source)
at com.ca.clarity.jdbc.sqlserverbase.ddcv.a(Unknown Source)
at com.ca.clarity.jdbc.sqlserver.tds.ddr.v(Unknown Source)
at com.ca.clarity.jdbc.sqlserver.tds.ddr.a(Unknown Source)
at com.ca.clarity.jdbc.sqlserver.tds.ddq.a(Unknown Source)
at com.ca.clarity.jdbc.sqlserver.tds.ddr.a(Unknown Source)
at com.ca.clarity.jdbc.sqlserver.tds.ddr.q(Unknown Source)
at com.ca.clarity.jdbc.sqlserver.dda_.a(Unknown Source)
at com.ca.clarity.jdbc.sqlserverbase.dddd.j(Unknown Source)
at com.ca.clarity.jdbc.sqlserverbase.ddea.next(Unknown Source)
at com.niku.union.persistence.PersistenceResponse.extractNormalResultSet(PersistenceResponse.java:191)
at com.niku.union.persistence.PersistenceController.extractResultSet(PersistenceController.java:1833)
at com.niku.union.persistence.PersistenceController.extractResultSets(PersistenceController.java:1882)
at com.niku.union.persistence.PersistenceController.processSql(PersistenceController.java:2796)
... 31 more