Hi all,
I am trying to run the LDAP jobs (LDAP sync users& LDAP delete obsolete users) but both are failing with the error below. Actullay I have a look at PRJ_BLB_SLICE_RESET_ALL_SP and PRJ_RESOURCES tables but no idea about what is happening.
Any recommendation on what to do?
Regards
ERROR 2017-01-17 19:27:14,131 [Dispatch Time Slicing : bg@S0134CAAPP01 (tenant=clarity)] niku.blobcrack (clarity:admin:5642475__2D487667-C9E3-41DD-8138-D4819A0B56EA: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 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
ERROR 2017-01-17 19:27:14,131 [Dispatch Time Slicing : bg@S0134CAAPP01 (tenant=clarity)] niku.njs (clarity:admin:5642475__2D487667-C9E3-41DD-8138-D4819A0B56EA:Time Slicing) Error executing job: 1030 error The timeslice job has failed.