Database has been migrated from Oracle 11 to Oracle 12 and the time slicing job fails since. What could be the reason?
Log file shows following errors:
ERROR 2018-06-16 18:45:32,699 [Dispatch Time Slicing :
[email protected] (tenant=clarity)] niku.blobcrack (clarity:admin:220669523__03591DA0-5327-422B-9385-54EC6152CBA1:Time Slicing) Exception during blobcrack process/r/ncom.niku.union.persistence.PersistenceException:
SQL error code: 1752
Error message: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01752: cannot delete from view without exactly one key-preserved table
ORA-06512: at line 1
ORA-06512: at "CLARITY_USER.PRJ_BLB_SLICE_MERGE_SP", line 125
ORA-06512: at line 1
Executed:
{call PRJ_BLB_SLICE_MERGE_SP(?) }
Derived from statement:
<?xml version="1.0" encoding="UTF-8"?>
<statement batchable="true" 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%22%3E
<sql dbVendor="all">
<text>
{call PRJ_BLB_SLICE_MERGE_SP(?) }
</text>
<param name="tableName" type="string" direction="IN" expressionListDelimiter=","/>
</sql>
</statement>