Wednesday, November 20, 2013

WSM error on adding new service or updating existing (Policy Manager Service encountered an operational exception)

Error:
 WSM admin console:
java.lang.Exception: Policy Manager Service encountered an operational exception - Error Message : unknown

Ccore logs:
2013-11-20 19:30:24,492 INFO  [AJPRequestHandler-HTTPThreadGroup-4] cfluent.JSPLogs - Failed to save service protocol policy
com.cfluent.policymanager.sdk.base.exception.ServerException: java.lang.Exception: Policy Manager Service encountered an operational exception - Error Message : unknow
n
        at com.cfluent.policymanager.sdk.client.soap.SoapPolicyConfigurator.updatePolicySet(SoapPolicyConfigurator.java:80)
        at com.cfluent.webui.uibeans.policy.PolicySetBean.saveInternal(PolicySetBean.java:435)
        at com.cfluent.webui.uibeans.policy.PolicySetBean.save(PolicySetBean.java:241)
        at _com._cfluent._coresv._policymgmt._registry._ServiceProtocol._jspService(_ServiceProtocol.java:659)
        at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
        at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
        at oracle.i18n.servlet.filter.ServletFilter.doFilter(ServletFilter.java:130)
        at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)
        at oracle.security.jazn.oc4j.JAZNFilter.doFilter(JAZNFilter.java:440)
       

...
or

The following is the cause of the above exception
java.sql.SQLException: ORA-01502: index 'ORAWSM.PK_SERVICES' or partition of such index is in unusable state

        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
        at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
        at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPre


Or this
java.sql.SQLException: ORA-01502: index 'ORAWSM.PK_MEASUREMENT_PERSISTED_STORE' or partition of such index is in unusable state

        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
        at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
        at oracle.jdbc.driver.T4CSt

Root cause: some objects of WSM repository ( ORAWSM schema ) got invalid.

Solution : inform your DBA to rebuild those or if you have access perform the same.
for me below one was creating problem.



SQL>  ALTER INDEX ORAWSM.IDX_MPSTORE_DBM0 REBUILD ONLINE ;
ALTER INDEX ORAWSM.IDX_MPSTORE_KEY0 REBUILD ONLINE ;
ALTER INDEX ORAWSM.IDX_MPSTORE_KEY1 REBUILD ONLINE ;
ALTER INDEX ORAWSM.IDX_SERVICE_NAME REBUILD ONLINE ;
ALTER INDEX ORAWSM.PK_COMPONENT_GROUP_MAPPINGS REBUILD ONLINE ;
ALTER INDEX ORAWSM.PK_MEASUREMENT_GROUP_MAPPINGS REBUILD ONLINE ;
ALTER INDEX ORAWSM.PK_MEASUREMENT_PERSISTED_STORE REBUILD ONLINE ;
ALTER INDEX ORAWSM.PK_MEASUREMENT_RESOURCE_STORE REBUILD ONLINE ;
ALTER INDEX ORAWSM.PK_MEASUREMENT_VIEWS REBUILD ONLINE ;
ALTER INDEX ORAWSM.PK_POLICY_MANAGER_OBJECTS REBUILD ONLINE ;
ALTER INDEX ORAWSM.PK_SERVICES REBUILD ONLINE ;
Index altered.

--ps: Please leave comment if it helped.

No comments:

Post a Comment