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
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.
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.T4CStRoot 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