CIF error: DBIF_DSQL2_SQL_ERROR-

[bkreddy]

Hi Folks,

We are facing regular CIF failures with error "SQL error 600 occurred when executing Native SQL" A note found for this issue note-21141518

Resolution

Avoid more than 256 changes of the same PO item schedule line within the same transaction (Batch split is only typical example).

If the error happens, then delete invalid queue and solve inconsistencies by deltareport.

Unfortunately there is no technical solution available due to unwanted side effects. It has been verified already by development support.

Can some one please help me if there is any alternate solution for these errors and also clarify me what does it mean "Avoid more than 256 changes of the same PO item schedule line within the same transaction (Batch split is only typical example)."

if i try to delete each LUW, it is trying to reprocess but failing again. After deleting LUW multiple times, Queues are getting cleared.

Thanks,

Kishore

[kenneth_snyder]

Curious, the oss note you mentioned does not exist.  21141518.  I even tried 2141518