AnsweredAssumed Answered

Again a question about time slicing job

Question asked by Yaman_Yazgan on Jan 18, 2017
Latest reply on Jan 19, 2017 by Yaman_Yazgan

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

Outcomes