Hello,
as part of a standard use of document storage based on IBM Content Manager product (version 8.6.0.6, DB Oracle 12.1.0.2) we see several strange errors in icmrm.logfile. Specifically, this is the activity of replacing a document attachment with another attachment.
ICMRM:BEGINEND 2024-08-05 07:17:43.838000 context:replace xxcaphan [WebContainer : 0] - Order: replace System elapsed time(ms) - without IO: 47 - with IO: 78 - doUpdate(ICMResourceManager.java:2604)
ICMRM:ERROR 2024-08-05 07:17:44.229000 context:end-trans xxcaphan [WebContainer : 5] - ORA-00001: unique constraint (ICMADMIN.SYS_C004443) violated
SQLCODE:1 - updateObjectMetadata(RMMetadataManagerOra.java:2716)
com.ibm.websphere.ce.cm.DuplicateKeyException: ORA-00001: unique constraint (ICMADMIN.SYS_C004443) violated
ICMADMIN.SYS_C004443 is the primary key over RMOBJECTS table and OBJ_COLLECTIONID, OBJ_ITEMID, OBJ_VERSION, OBJ_LIBRARYID columns
In the vast majority of cases, everything is fine. But sometimes this type of error appears, when due to the above error, the entire transaction does not complete correctly and the corresponding record remains in the RMTRANSACTION table. As a result, the document cannot be manipulated and the following error is returned:
DGL0403A: Error in transaction commit - Resource Manager end-trans error: ICM9879: End of transaction processing cannot be performed for transaction ID 21N092kus0Gd19B42431I95310. [RM RC = 9879, HTTP RC = 214: Undefined]
The only solution is to manually delete this record from the RMTRANSACTIONS table.
I have two questions about this:
Q1: Please do you know what specifically could cause this problem?
Q2: Is there any automatic RM process that would try to settle the pending transactions again after some time?
Thank you!
------------------------------
Petr Slepánek
------------------------------