My Oracle Support Banner

OPSS - Unable start admin Server Observing Invalid Object Name 'JPS_DN' Using MS SQL Server as Policy Store. Error JPS-00260: Database access error. SQL state: 42S02, error code: 208 , JPS-01055 (Doc ID 2540040.1)

Last updated on MARCH 25, 2024

Applies to:

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

Symptoms

On : 12.2.1.3.0 version, Java Platform Security

WebLogic 12.2.1.3.0 -

AdminServer instance is failing to start up.

Observing the next error:

Apr 29, 2019 7:20:19 PM oracle.security.jps.internal.policystore.rdbms.JpsDBDataManager handleDatabaseException
SEVERE:
Local Exception Stack:
Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.5.v20170607-b3d05bd): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLSyntaxErrorException: [FMWGEN][SQLServer JDBC Driver][SQLServer]Invalid object name 'JPS_DN'.
Error Code: 208
Call: SELECT t1.JPS_ATTRS_ID, t1.ATTRNAME, t1.ATTRVAL, t1.JPS_DN_ENTRYID FROM JPS_DN t0, JPS_ATTRS t1 WHERE ((((t1.JPS_DN_ENTRYID = t0.ENTRYID) AND (t0.RDN = ?)) AND (t0.PARENTDN = ?)) AND (t1.ATTRNAME IN (?, ?, ?)))
bind => [5 parameters bound]
Query: ReadAllQuery(referenceClass=JpsStore sql="SELECT t1.JPS_ATTRS_ID, t1.ATTRNAME, t1.ATTRVAL, t1.JPS_DN_ENTRYID FROM JPS_DN t0, JPS_ATTRS t1 WHERE ((((t1.JPS_DN_ENTRYID = t0.ENTRYID) AND (t0.RDN = ?)) AND (t0.PARENTDN = ?)) AND (t1.ATTRNAME IN (?, ?, ?)))")
FetchGroup(){jpsParent, jpsDnEntryid, attrval, attrname, jpsAttrsId}
at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:340)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:684)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:560)
at org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:2062)
at org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:570)
...............
Caused by: java.sql.SQLSyntaxErrorException: [FMWGEN][SQLServer JDBC Driver][SQLServer]Invalid object name 'JPS_DN'.
at weblogic.jdbc.sqlserverbase.ddcw.b(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddcw.a(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddcv.b(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddcv.a(Unknown Source)
at weblogic.jdbc.sqlserver.tds.ddr.v(Unknown Source)
at weblogic.jdbc.sqlserver.tds.ddr.a(Unknown Source)
...........
Apr 29, 2019 7:20:19 PM oracle.security.jps.internal.policystore.rdbms.JpsDBDataManager getVersion
WARNING: Unable to get the Policy Store Version from Store returning the default
Apr 29, 2019 7:20:19 PM oracle.security.jps.internal.common.config.AbstractSecurityStore getSecurityStoreVersion
WARNING: Unable to get the Version from Store returning the default. Reason: oracle.security.jps.service.policystore.PolicyStoreException: JPS-00260: Database access error. SQL state: 42S02, error code: 208..
Apr 29, 2019 7:20:19 PM oracle.security.jps.internal.policystore.rdbms.JpsDBDataManager handleDatabaseException
SEVERE:
Local Exception Stack:
Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.5.v20170607-b3d05bd): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLSyntaxErrorException: [FMWGEN][SQLServer JDBC Driver][SQLServer]Invalid object name 'JPS_DN'.
Error Code: 208
Call: SELECT t1.JPS_ATTRS_ID, t1.ATTRNAME, t1.ATTRVAL, t1.JPS_DN_ENTRYID FROM JPS_DN t0, JPS_ATTRS t1 WHERE ((((t1.JPS_DN_ENTRYID = t0.ENTRYID) AND (t0.RDN = ?)) AND (t0.PARENTDN = ?)) AND (t1.ATTRNAME IN (?, ?, ?)))
bind => [5 parameters bound]
Query: ReadAllQuery(referenceClass=JpsStore sql="SELECT t1.JPS_ATTRS_ID, t1.ATTRNAME, t1.ATTRVAL, t1.JPS_DN_ENTRYID FROM JPS_DN t0, JPS_ATTRS t1 WHERE ((((t1.JPS_DN_ENTRYID = t0.ENTRYID) AND (t0.RDN = ?)) AND (t0.PARENTDN = ?)) AND (t1.ATTRNAME IN (?, ?, ?)))")
FetchGroup(){jpsParent, jpsDnEntryid, attrval, attrname, jpsAttrsId}
at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:340)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:684)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:560)
at org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:2062)
..................
Caused by: java.sql.SQLSyntaxErrorException: [FMWGEN][SQLServer JDBC Driver][SQLServer]Invalid object name 'JPS_DN'.
at weblogic.jdbc.sqlserverbase.ddcw.b(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddcw.a(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddcv.b(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddcv.a(Unknown Source)
..............
Apr 29, 2019 7:20:19 PM oracle.security.jps.internal.policystore.rdbms.JpsDBDataManager getVersion
WARNING: Unable to get the Policy Store Version from Store returning the default
Apr 29, 2019 7:20:19 PM oracle.security.jps.internal.credstore.ldap.LdapCredentialStore init
WARNING: Could not create credential store instance. Reason oracle.security.jps.service.policystore.PolicyStoreException: JPS-00260: Database access error. SQL state: 42S02, error code: 208.
Apr 29, 2019 7:20:19 PM oracle.security.jps.internal.config.OpssCommonStartup start
INFO: Jps startup failed.
<Apr 29, 2019 7:20:19,992 PM EDT> <Critical> <WebLogicServer> <BEA-000362> <Server failed. Reason:

There are 1 nested errors:

oracle.security.jps.JpsException: JPS-01055: Could not create credential store instance. Reason oracle.security.jps.service.policystore.PolicyStoreException: JPS-00260: Database access error. SQL state: 42S02, error code: 208.
at oracle.security.jps.internal.config.OpssCommonStartup.start(OpssCommonStartup.java:228)
at oracle.security.jps.wls.JpsWlsStartup.start(JpsWlsStartup.java:105)
at oracle.security.jps.JpsStartup.startWithRetry(JpsStartup.java:287)
.....................
Caused by: oracle.security.jps.service.credstore.CredStoreException: JPS-01055: Could not create credential store instance. Reason oracle.security.jps.service.policystore.PolicyStoreException: JPS-00260: Database access error. SQL state: 42S02, error code: 208.
at oracle.security.jps.internal.credstore.ldap.LdapCredentialStore.init(LdapCredentialStore.java:191)
at oracle.security.jps.internal.credstore.ldap.LdapCredentialStore.start(LdapCredentialStore.java:1030)
at oracle.security.opss.internal.runtime.ServiceContextImpl.start(ServiceContextImpl.java:220)
at oracle.security.opss.internal.runtime.ServiceContextManagerImpl.createDefaultContext(ServiceContextManagerImpl.java:325)
at oracle.security.opss.internal.runtime.ServiceContextManagerImpl.initialize(ServiceContextManagerImpl.java:242)
at oracle.security.jps.internal.config.OpssCommonStartup$1.run(OpssCommonStartup.java:166)
at java.security.AccessController.doPrivileged(Native Method)
at oracle.security.jps.internal.config.OpssCommonStartup.start(OpssCommonStartup.java:159)
... 27 more
Caused by: oracle.security.jps.service.policystore.PolicyStoreException: JPS-00260: Database access error. SQL state: 42S02, error code: 208.
at oracle.security.jps.internal.policystore.rdbms.JpsDBDataManager.getVersion(JpsDBDataManager.java:1561)
at oracle.security.jps.internal.policystore.rdbms.JpsDBDataManager.createEMFAndSubject(JpsDBDataManager.java:1828)
at oracle.security.jps.internal.policystore.rdbms.JpsDBDataManager.getEMFAndSubject(JpsDBDataManager.java:1754)
at oracle.security.jps.internal.policystore.rdbms.JpsDBDataManager.init(JpsDBDataManager.java:1402)
at oracle.security.jps.internal.policystore.rdbms.JpsDBDataManager.jpsObjectBaseQuery(JpsDBDataManager.java:3877)
at oracle.security.jps.internal.policystore.AbstractJpsDataManager.queryBaseObjects(AbstractJpsDataManager.java:285)
at oracle.security.jps.internal.credstore.ldap.CsfStoreManager.existsStore(CsfStoreManager.java:299)
at oracle.security.jps.internal.credstore.ldap.CsfStoreManager.completeInit(CsfStoreManager.java:177)
at oracle.security.jps.internal.credstore.rdbms.CsfDbmsManager.<init>(CsfDbmsManager.java:91)
at oracle.security.jps.internal.credstore.rdbms.CsfDbmsManager.createInstance(CsfDbmsManager.java:72)
at oracle.security.jps.internal.credstore.ldap.CsfStoreManager.getInstance(CsfStoreManager.java:121)
at oracle.security.jps.internal.credstore.ldap.LdapCredentialStore.init(LdapCredentialStore.java:188)
... 34 more
Caused by: oracle.security.jps.service.policystore.PolicyStoreException: JPS-00260: Database access error. SQL state: 42S02, error code: 208.
at oracle.security.jps.internal.policystore.rdbms.JpsDBDataManager.handleDatabaseException(JpsDBDataManager.java:2214)
at oracle.security.jps.internal.policystore.rdbms.JpsDBDataManager.processJPAException(JpsDBDataManager.java:2695)
at oracle.security.jps.internal.policystore.rdbms.JpsDBDataManager.executeBaseQuery(JpsDBDataManager.java:3989)
at oracle.security.jps.internal.policystore.rdbms.JpsDBDataManager.jpsObjectBaseQuery(JpsDBDataManager.java:3925)
at oracle.security.jps.internal.policystore.rdbms.JpsDBDataManager.getVersion(JpsDBDataManager.java:1536)
... 45 more

>
<Apr 29, 2019 7:20:20,005 PM EDT> <Notice> <WebLogicServer> <BEA-000365> <Server state changed to FAILED.>

 

Another example of Admin Server log errors reported:

 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.