AnsweredAssumed Answered

"Time Slicing Job" is failing constantly

Question asked by Yaman_Yazgan on Jan 19, 2017
Latest reply on Jan 20, 2017 by Dave_3.0

Hi all,

 

 

Does any one has any idea about this issue? Also is it related with resource related reports? 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 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.niku.union.persistence.PersistenceController.processSql(PersistenceController.java:2796)
... 31 more

Outcomes