Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Unique constraint errors in 9.1

Highlighted
TylerGlenn
Acclaimed Contributor

Unique constraint errors in 9.1

Greetings,

 

We are running PPM v. 9.1 and regularly find this error in our server logs.

 

Could not store message: 651 msg=49535 hard NOT_STORED PERSISTENT queue=QUEUE.ppmLightServiceQueue priority=4 lateClone=false hashCode=4864572; - nested throwable: (java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (<ppmschema>.SYS_C0025975) violated

 

I can trace the constraint to the JMS_MESSAGES table, but would appreciate some tips on where the message or msg is referencing, and how this can be resolved.

 

Thanks,

Tyler

1 REPLY
dirkf
Honored Contributor

Re: Unique constraint errors in 9.1

Hi TylerGlenn,

 

I would have to see the whole stack for this to be 100% sure, but there are some issues known for this part of the error-message.

There is a hotfix available on top of 9.11 (to be installed first) that you can obtain via a support case and verification via the kSupport-Output of your nodes.

 

Please log a support case, indicate if you are running 9.11, submit the error-message and kSupport and ask for the hotfix "9.1-SP1-COMBINED-CLUSTER-COMMS-ONEOFF.zip" and deployment instructions for the same.

 

Best regards and good luck,

Dirk

//Add this to "OnDomLoad" event