SAP Knowledge Base Article - Preview

3608457 - CI-DS task fails with error: Database returned the SQL code 131 - SAP Cloud Integration for data services

Symptom

  • CI-DS task fails with error:
    ODP source returned error: <E: MESSAGE - Error while accessing. E: MESSAGE - Error with extractor call <extractor name>.
                                                                   MESSAGE_V1 - <extractor name>. E: MESSAGE - An exception with the type CX_SY_OPEN_SQL_DB occurred, but was neither handled
                                                                   locally, nor declared in a RAISING clause. MESSAGE_V1 - An exception with the type CX_SY_OPEN_SQL_DB occur. MESSAGE_V2 - red,
                                                                   but was neither handled locally, nor declared. MESSAGE_V3 -  in a RAISING clause. E: MESSAGE - Database returned the SQL code
                                                                   131. Error text: transaction rolled back by lock wait timeout: TrexColumnUpdate failed on table <table name> with
                                                                   error: transaction rolled back by lock wait timeout: Lock-wait. MESSAGE_V1 - Database returned the SQL code 131. Error text:
                                                                   tr. MESSAGE_V2 - ansaction rolled back by lock wait timeout: TrexCo. MESSAGE_V3 - lumnUpdate failed on table
                                                                   <table name>. MESSAGE_V4 - ' with error: transaction rolled back by lock wait.>. 
  • SM21 / ST22 does not show any additional information.


Read more...

Environment

SAP Cloud Integration for data services

Product

SAP Cloud Integration for data services 1.0

Keywords

ECC, IBP, CIDS, integration job, failure, deadlock, ST04, SM21, error, dump, log, data transfer. , KBA , LOD-HCI-DS , HANA Cloud Integration for Data Services , 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.