SAP Knowledge Base Article - Preview

3755026 - Tasks reading from two or more IBP source tables fail with error: "E: MESSAGE - Locking error when trying to update processing status of query" - SAP Cloud Integration for data services

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.