Symptom
- Tasks reading from two or more IBP source tables fail with error:
E: MESSAGE - Locking error when trying to update processing status of query.
E: MESSAGE - The used database cursor was invalid, for example, it was already closed.
E: MESSAGE - Error occurred when locking query status table to set status to FINISHED. - Joining Row Generation (or other source object) with IBP source table(s) causes above error.
Read more...
Environment
SAP Cloud Integration for data services
Product
SAP Cloud Integration for data services 1.0
Keywords
E: MESSAGE - Locking error, task failed, locking error, update processing status of query, used database cursor was invalid, cursor closed, join cache, source cache, join rank, ibp_number_of_threads, multiple ibp sources, dataflow failure, integration join , KBA , LOD-HCI-DS-AGNT , On-Premise Agent, Connectivity, Task Run errors , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview