XML Extract Skipped because Database Locks Exists on Text Search Index

[former_member186587]

We are having issue with Schedule Task "Search XML Extract" for our CLM Application. I checked DB for CLM but could not find any locks at native DB level. I could not find any jobs to run within CLM 7.0 Application to release these locks. Is there a way to release Database Locks that exist on Text Search Index?

Schedule Task: Search XML Extract

Error Message: XML Extract Skipped because Database Locks Exists on Text Search Index. If this condition persists, conctact system administrator

Version:

SAP CLM Application Version: 7.0.02.09 build 148562:2012-08-22 05:25 EDT running on SAP CE 7.11

Database version for CLM is "DB2 v9.7.0.7", "special_31006", "IP23367_31006"

Bhavin

[former_member186587 · Accepted solution]

Solution:

To find TS Lock at DB level:  db2 "select * from SYSIBMTS.TSLOCKS"

Ref: IBM Knowledge Center

Solution to clear DB Lock:

db2ts CLEAR COMMAND LOCKS FOR TEXT