2879980 - Error adding a Location using the Import Data Tool - The system could not add the record for one or more reasons: com.sap.db.jdbc.exceptions.JDBCDriverException

Symptom

When trying to add or update a Location using the Import Data Tool, the background job fails and the following error can be seen in the logs:

The system could not add the record for one or more reasons: com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: [461]: foreign key constraint violation: TrexUpdate failed on table 'SCHEMA_STAGE_TMS:PA_LOCN' with error: Row Locking failed on referenced Table;from table SCHEMA_STAGE_TMS:PA_LOCN to table SCHEMA_STAGE_TMS:PA_FACILITY, expected rowlocks 1 but processed rowlocks 0 differ, rc=1535.

Environment

SAP SuccessFactors Learning

Product

SAP SuccessFactors Learning all versions

Keywords

import data tool, error, location, com.sap.db.jdbc.exceptions.JDBCDriverException , KBA , LOD-SF-LMS-ADM , System Admin, Global Variables, References , 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.