Technote (troubleshooting)
Problem(Abstract)
When adding a security member for permissions or capabilities object, getting the error:
message CM-SYS-5092
Symptom
CM-SYS-5092
[jcc][10429][12554][3.63.75] A processing error occurred on the server
which resulted in an unrecoverable error. Please set deferPrepares
property to false and re-establish the connection. If the problem still
persists, please contact support. ERRORCODE=-4225, SQLSTATE=24514
Cause
DB2 issue with jdbc driver (type 4)
Environment
Content Store on database , server DB2 v9.7 FP5 (jdbc type 4)
Diagnosing the problem
In logs diagnose the error message ERRORCODE=-4225, SQLSTATE=24514
deferPrepares' is a DB2 property,
Please see the link below for more detail:
http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/ad/c0010273.htm
DB2 Technote : http://www-01.ibm.com/support/docview.wss?uid=swg21168955
Resolving the problem
Set deferPrepares property to false and re-establish the connection.
If the problem still persists, please contact DB2 support.
http://www-01.ibm.com/support/docview.wss?uid=swg21598094