Symantec Access Management

  • 1.  sm-xpsxps ERRORS after upgrade 12.5 SP3 to 12.52 sp1

    Posted Aug 15, 2016 07:49 AM

    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?



  • 2.  Re: sm-xpsxps ERRORS after upgrade 12.5 SP3 to 12.52 sp1
    Best Answer

    Posted Aug 15, 2016 02:50 PM

    Hi Paulo,

    I understand that you opened a case with support.  The errors are related to agent discovery and the issue was resolved after restarting the policy server.  Please mark this post as correct if it did in fact resolve the issue.

    thank you,

    Justin