AnsweredAssumed Answered

sm-xpsxps ERRORS after upgrade 12.5 SP3 to 12.52 sp1

Question asked by PauloPoffal on Aug 15, 2016
Latest reply on Aug 15, 2016 by justin_leong

Hi guys, this weekend we upgrade 2 of 4 policy servers, one of this policy server is showing in logs some sm-xpsxps errors. The other SMPS is working fine, with no errors.

Our environment today is two SMPS in 12.5 sp3 version and two SMPS in 12.52 SP1 CR5 version.


[20783/-381891696][Mon Aug 15 2016 08:32:38][HSTMT.cpp:148][ShowError][ERROR][sm-xpsxps-00870] An error occurred when calling "SQLExecDirect" for "Create Object" query

[20783/-381891696][Mon Aug 15 2016 08:32:38][HSTMT.cpp:241][Error][ERROR][sm-xpsxps-00810] Native Diagnostic: 23000:1 [NS][ODBC Oracle Wire Protocol driver][Oracle]ORA-00001: unique constraint (SMOBJSTORE.IX_XPSOBJECT_GUID) violated

[20783/-381891696][Mon Aug 15 2016 08:32:38][XPSIO.cpp:1594][CreateObject][ERROR][sm-xpsxps-00540] Previous error occurred on object "CA.SM::AgentInstance@PS-0000000000000000000000002f544dc9-web2quiosqu001p-web-host"

[20783/-381891696][Mon Aug 15 2016 08:32:38][XPSPolicyData.cpp:1244][CommitOrTestRollback][ERROR][sm-xpsxps-00740] XPS Transaction COMMIT has failed.

[20783/-381891696][Mon Aug 15 2016 08:32:38][XPSPolicyData.cpp:409][CreateOrUpdateImpl][ERROR][CA-SM-Assert] Assert failed: Commit()



You guys have any clue about this errors?