"Set Row Lock off" fails after due to custom index name containing special characters (4381189)

After upgrading to Identity Manager 9.2.2, the DB Queue may get stuck on the task "Set Row Lock off".

The System Journal logs an SQL error similar to:

ALTER INDEX UID_ADSDomain,IsLocal on ADSGroup SET (ALLOW_PAGE_LOCKS = OFF) – Incorrect syntax near ','.

This occurs because custom index names containing special characters such as commas (",") or hyphens ("-") cause SQL syntax errors during execution.

As a temporary workaround, avoid using special characters in index names.

• Rename or modify the custom index names to avoid special characters, or enclose them in square brackets [].
• Example: [UID_ADSDomain,IsLocal]

The issue is tracked under defect ID #645782 and will be fixed in a future release.