Description:
On USER SETTINGS after changing anything or adding a new user the APPLY does not work and in the taskoutput the following error messages are shown:
IO error sending or receiving native data: ca.datacom.db.DBIOException:
ca.datacom.db.DBIOException: ca.datacom.db.DBIOException:
MSM Deploy task fails in step Record_target_library_nam with a DataAccessResourceFailureException.
The error messages are starting like this:
An exception has occurred Message=:org.springframework.dao.DataAccessResourceFailureException: PreparedStatementCallback; SQL [insert into datasetoverride (datasetid, methodology_style_id, sysobjid, deploymentid, typeobj, overridemask, finalname, overridepath, finalpath, makecontainer, mountpoint, percentfree, containermask, rffustring, hash) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; IO error sending or receiving native data: ca.datacom.db.DBIOException: ca.datacom.db.DBIOException: ca.datacom.db.DBIOException: java.lang.ClassCastException: [B incompatible with java.lang.Stringin Jni(DBCall)in Node(DBCall)in Session(Exception executeImmediate); nested exception is java.sql.SQLException: IO error sending or receiving native data: ca.datacom.db.DBIOException: ca.datacom.db.DBIOException: ca.datacom.db.DBIOException: java.lang.ClassCastException: [B incompatible with java.lang.Stringin Jni(DBCall)in Node(DBCall)in Session(Exception executeImmediate)
Or you find the message :
MSM0050E - CA MSM database unavailable.......................................... Additional Diagnostic Data:................................................... Database Unavailable........................................................ There was a problem accessing the database. Consult the MSM logs for further Message: PreparedStatementCallback; SQL insert into Internallogin (logini flag2, binf, userpw)values (?, ?, ?, ?, ?, ?, ?, ?) ; IO error sending or ca.datacom.db.DBIOException: ca.datacom.db.DBIOException: ca.datacom.db.DB java.lang.ClassCastException: B incompatible with java.lang.Stringin Jni( Session(Exception executeImmediate); nested exception is java.sql.SQLExcep native data: ca.datacom.db.DBIOException: ca.datacom.db.DBIOException:
Solution:
These problems are fixed by an APAR for component CA Datacom Server - RO49599
with prereqs of PRE (RO11552, RO17432, RO47345, RO48169, RO48171)
After applying above fix in some cases a MSMDEPLY was necessary to resolve the problem.