OPSS - Observing several JPS-10603, JPS-10628 and JPS-00027 cannot allocate resources to applications, Errors messages on Logs

(Doc ID 2319717.1)

Last updated on OCTOBER 25, 2017

Applies to:

Oracle Platform Security for Java - Version 12.2.1.2.0 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.1.2.0 version, Java Platform Security

 Observing several JPS-10603, JPS-10628 and JPS-00027 cannot allocate resources to applications, Errors messages written To WebLogic Server Logs

[2017-10-14T04:41:28.265-04:00] [AdminServer] [ERROR] [JPS-10603] [oracle.jps.policymgmt] [tid: [ACTIVE].ExecuteThread: '8' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: c101e0d9-1b58-4a5e-bd1d-e8ac7ac29428-000004c0,0] [partition-name: DOMAIN] [tenant-name: GLOBAL] FAILURE: Retry getAppPolicyNames failed after 3 times retries due to following exception oracle.security.jps.service.policystore.PolicyStoreConnectivityException: JPS-00027: There was an internal error: weblogic.jdbc.extensions.PoolDisabledSQLException: weblogic.common.resourcepool.ResourceDisabledException: Pool opss-data-source is Suspended, cannot allocate resources to applications...
[2017-10-14T04:41:38.293-04:00] [AdminServer] [NOTIFICATION] [JPS-10628] [oracle.jps.policymgmt] [tid: [ACTIVE].ExecuteThread: '8' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: c101e0d9-1b58-4a5e-bd1d-e8ac7ac29428-000004c0,0] [partition-name: DOMAIN] [tenant-name: GLOBAL] Retry getAllAppPolicyNames for the 0 times.
[2017-10-14T04:42:03.324-04:00] [AdminServer] [NOTIFICATION] [JPS-10628] [oracle.jps.policymgmt] [tid: [ACTIVE].ExecuteThread: '8' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: c101e0d9-1b58-4a5e-bd1d-e8ac7ac29428-000004c0,0] [partition-name: DOMAIN] [tenant-name: GLOBAL] Retry getAllAppPolicyNames for the 1 times.
[2017-10-14T04:42:28.355-04:00] [AdminServer] [NOTIFICATION] [JPS-10628] [oracle.jps.policymgmt] [tid: [ACTIVE].ExecuteThread: '8' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: c101e0d9-1b58-4a5e-bd1d-e8ac7ac29428-000004c0,0] [partition-name: DOMAIN] [tenant-name: GLOBAL] Retry getAllAppPolicyNames for the 2 times.
[2017-10-14T04:42:53.385-04:00] [AdminServer] [NOTIFICATION] [JPS-10628] [oracle.jps.policymgmt] [tid: [ACTIVE].ExecuteThread: '8' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: c101e0d9-1b58-4a5e-bd1d-e8ac7ac29428-000004c0,0] [partition-name: DOMAIN] [tenant-name: GLOBAL] Retry getAllAppPolicyNames for the 3 times.
.............................
[2017-10-14T04:43:08.394-04:00] [AdminServer] [ERROR] [JPS-10603] [oracle.jps.policymgmt] [tid: [ACTIVE].ExecuteThread: '8' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: c101e0d9-1b58-4a5e-bd1d-e8ac7ac29428-000004c0,0] [partition-name: DOMAIN] [tenant-name: GLOBAL] FAILURE: Retry getAllAppPolicyNames failed after 3 times retries due to following exception oracle.security.jps.service.policystore.PolicyStoreConnectivityException: JPS-00027: There was an internal error: weblogic.jdbc.extensions.PoolDisabledSQLException: weblogic.common.resourcepool.ResourceDisabledException: Pool opss-data-source is Suspended, cannot allocate resources to applications...
[2017-10-14T04:43:18.414-04:00] [AdminServer] [WARNING] [JPS-07603] [oracle.jps.authorization] [tid: [ACTIVE].ExecuteThread: '8' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: c101e0d9-1b58-4a5e-bd1d-e8ac7ac29428-000004c0,0] [partition-name: DOMAIN] [tenant-name: GLOBAL] Cannot purge changelog. Reason oracle.security.jps.service.policystore.PolicyStoreConnectivityException: JPS-00027: There was an internal error: weblogic.jdbc.extensions.PoolDisabledSQLException: weblogic.common.resourcepool.ResourceDisabledException: Pool opss-data-source is Suspended, cannot allocate resources to applications...
[2017-10-14T04:53:28.443-04:00] [AdminServer] [ERROR] [] [oracle.jps.policymgmt] [tid: [ACTIVE].ExecuteThread: '27' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: c101e0d9-1b58-4a5e-bd1d-e8ac7ac29428-000004cb,0] [partition-name: DOMAIN] [tenant-name: GLOBAL] Error reading java policies for Application: cn=SystemPolicy,cn=opssSecurityStore,cn=JPSContext,cn=opssRoot, Reason: oracle.security.jps.service.policystore.PolicyStoreConnectivityException: JPS-00027: There was an internal error: weblogic.jdbc.extensions.PoolDisabledSQLException: weblogic.common.resourcepool.ResourceDisabledException: Pool opss-data-source is Suspended, cannot allocate resources to applications..[[
oracle.security.jps.service.policystore.PolicyStoreConnectivityException: JPS-00027: There was an internal error: weblogic.jdbc.extensions.PoolDisabledSQLException: weblogic.common.resourcepool.ResourceDisabledException: Pool opss-data-source is Suspended, cannot allocate resources to applications..
at oracle.security.jps.internal.policystore.rdbms.JpsDBDataManager.handleDatabaseException(JpsDBDataManager.java:2164)
at oracle.security.jps.internal.policystore.rdbms.JpsDBDataManager.processJPAException(JpsDBDataManager.java:2656)
at oracle.security.jps.internal.policystore.rdbms.JpsDBDataManager.pagingListQuery(JpsDBDataManager.java:4479)
at oracle.security.jps.internal.policystore.rdbms.JpsDBDataManager.jpsObjectListQueryInDoAs(JpsDBDataManager.java:4206)
at oracle.security.jps.internal.policystore.rdbms.JpsDBDataManager.jpsObjectListQuery(JpsDBDataManager.java:4113)
at oracle.security.jps.internal.policystore.rdbms.JpsDBDataManager.jpsObjectListQuery(JpsDBDataManager.java:4089)
at oracle.security.jps.internal.policystore.entitymanager.impl.InternalQueryManagerImpl.getGrantees(InternalQueryManagerImpl.java:725)
at oracle.security.jps.az.internal.management.pd.service.JavaPolicyUtil.getGranteeEntries(JavaPolicyUtil.java:477)
at oracle.security.jps.az.internal.management.pd.service.JavaPolicyUtil.getJavaPolicyEntries(JavaPolicyUtil.java:303)
at oracle.security.jps.az.internal.management.pd.service.JavaPolicyUtil.getJavaPolicyEntries(JavaPolicyUtil.java:261)
at oracle.security.jps.az.internal.management.pd.service.JavaPolicyUtil.getSystemJavaPolicy(JavaPolicyUtil.java:186)
at oracle.security.jps.az.internal.management.pd.service.GenericPolicyDistributionService.internalGetSystemPolicyEntry(GenericPolicyDistributionService.java:399)
at oracle.security.jps.az.internal.management.pd.service.GenericPolicyDistributionService.getSystemPolicyEntry(GenericPolicyDistributionService.java:367)
at oracle.security.jps.az.internal.runtime.notifier.PolicyChangeNotifierImpl.getSystemTimedoutModifiedChange(PolicyChangeNotifierImpl.java:865)
at oracle.security.jps.az.internal.runtime.notifier.PolicyChangeNotifierImpl.getChange(PolicyChangeNotifierImpl.java:308)
at oracle.security.jps.az.internal.common.scanner.PolicyChangeScanner.scanSystemPolicy(PolicyChangeScanner.java:346)
at oracle.security.jps.az.internal.common.scanner.PolicyChangeScanner.scan(PolicyChangeScanner.java:293)
at oracle.security.jps.az.internal.common.scanner.PolicyChangeScanner.access$200(PolicyChangeScanner.java:113)
.................
Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: weblogic.jdbc.extensions.PoolDisabledSQLException: weblogic.common.resourcepool.ResourceDisabledException: Pool opss-data-source is Suspended, cannot allocate resources to applications..
Error Code: 0
Call: SELECT /*+  FIRST_ROWS(10) */  attr.* FROM JPS_ATTRS attr, JPS_DN DN WHERE DN.PARENTDN = ? AND DN.ENTRYID = attr.JPS_DN_ENTRYID  and ((exists ( select /*+ INDEX(A_0 IDX_CT_13_ATTRVAL) */ 1 from CT_13 A_0 where ( A_0.JPS_DN_ENTRYID = DN.entryid ) and ( A_0.attrval = ? ))))
bind => [2 parameters bound]
Query: ReadAllQuery(referenceClass=JpsStore sql="SELECT /*+  FIRST_ROWS(10) */  attr.* FROM JPS_ATTRS attr, JPS_DN DN WHERE DN.PARENTDN = ? AND DN.ENTRYID = attr.JPS_DN_ENTRYID  and ((exists ( select /*+ INDEX(A_0 IDX_CT_13_ATTRVAL) */ 1 from CT_13 A_0 where ( A_0.JPS_DN_ENTRYID = DN.entryid ) and ( A_0.attrval = ? ))))")
FetchGroup(){jpsParent, jpsDnEntryid, attrval, attrname, jpsAttrsId}
at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:316)
at org.eclipse.persistence.sessions.JNDIConnector.connect(JNDIConnector.java:147)
at org.eclipse.persistence.sessions.DatasourceLogin.connectToDatasource(DatasourceLogin.java:162)
at org.eclipse.persistence.internal.databaseaccess.DatasourceAccessor.connectInternal(DatasourceAccessor.java:346)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.connectInternal(DatabaseAccessor.java:309)
at org.eclipse.persistence.internal.databaseaccess.DatasourceAccessor.reconnect(DatasourceAccessor.java:581)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.reconnect(DatabaseAccessor.java:1634)
at org.eclipse.persistence.internal.databaseaccess.DatasourceAccessor.incrementCallCount(DatasourceAccessor.java:321)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:615)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:560)
at org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:2056)
at org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:570)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:242)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:228)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:299)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.selectAllRows(DatasourceCallQueryMechanism.java:694)
at org.eclipse.persistence.queries.ReadAllQuery.executeObjectLevelReadQuery(ReadAllQuery.java:559)
at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeDatabaseQuery(ObjectLevelReadQuery.java:1175)
at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:904)
at org.eclipse.persistence.queries.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:1134)
at org.eclipse.persistence.queries.ReadAllQuery.execute(ReadAllQuery.java:460)
at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeInUnitOfWork(ObjectLevelReadQuery.java:1222)
at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2896)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1857)
...........................
... 33 more
Caused by: weblogic.jdbc.extensions.PoolDisabledSQLException: weblogic.common.resourcepool.ResourceDisabledException: Pool opss-data-source is Suspended, cannot allocate resources to applications..
at weblogic.jdbc.common.internal.JDBCUtil.wrapAndThrowResourceException(JDBCUtil.java:269)
at weblogic.jdbc.common.internal.RmiDataSource.getPoolConnection(RmiDataSource.java:529)
at weblogic.jdbc.common.internal.RmiDataSource.getConnectionInternal(RmiDataSource.java:620)
at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:571)
at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:564)
at org.eclipse.persistence.sessions.JNDIConnector.connect(JNDIConnector.java:135)
... 72 more

]]

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms