Registration

Dear SCN Member,
In order to fully benefit from what SCN has to offer, please register at:
http://scn.sap.com/login.jspa
Thank you,
The SCN team
We are improving!
The SCN wiki will not be available for new content submission starting September 11th 6PM CET until September 14th 6PM CET. Please plan your SCN wiki tasks accordingly.
Skip to end of metadata
Go to start of metadata

Problem

Upgrade fails with "SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-725, SQLSTATE=42721".And each retry with "A configuration with the path "deploy_controller/lock/single_thread" does already exist."

Keywords

• DB2
• deploy_controller/lock/single_thread
• update/upgrade

Symptoms

In "DEPLOY SOFTWARECOMPONENTS" phase fails deployment with :
"com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-725, SQLSTATE=42721"
or
"Cannot perform 'unlock' operation in 'DB' for argument 'deploy_controller/lock/single_thread' and user 'Deploy'."

Where the database is* *

DB2.

The root cause is in the DB2 jdbc driver and it's fixed in its later versions

Solution

  • Check  SAP Note No. 1763924

Sample logs