Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Forms 12.2.1.3 - Configuration - JPS-00260: Database access error. SQL state: 42000, error code: 942

Laurent F.Sep 19 2017 — edited Sep 25 2017

Hello,

I receive this error when I run config.bat for the configuration part of Forms Installation (latest version 12.2.1.3). I already have installed weblogic and launched RCU part. The connection tests during the configuration are working fine. I receive this error after pushing the button "Create".

Here the complete error:

2017-09-19 08:19:07,486 SEVERE [65] com.oracle.cie.domain.progress.AbstractProgressGenerator - Error occurred in phase {OPSS Processing} execution.

com.oracle.cie.domain.security.external.ConfigSecurityException: oracle.security.opss.tools.lifecycle.LifecycleException: Error during configuring DB security store. Exception oracle.security.opss.tools.lifecycle.LifecycleException: JPS-00260: Database access error. SQL state: 42000, error code: 942..

at oracle.security.opss.tools.lifecycle.cie.OpssSecurityConfiguration.initializeSubsystem(OpssSecurityConfiguration.java:191)

at com.oracle.cie.domain.progress.domain.generation.OPSSProcessingPhase.initialize(OPSSProcessingPhase.java:211)

at com.oracle.cie.domain.progress.domain.generation.OPSSProcessingPhase.processOPSS(OPSSProcessingPhase.java:154)

at com.oracle.cie.domain.progress.domain.generation.OPSSProcessingPhase.execute(OPSSProcessingPhase.java:54)

at com.oracle.cie.domain.progress.AbstractProgressGenerator.run(AbstractProgressGenerator.java:94)

at java.lang.Thread.run(Thread.java:748)

Caused by: oracle.security.opss.tools.lifecycle.LifecycleException: Error during configuring DB security store. Exception oracle.security.opss.tools.lifecycle.LifecycleException: JPS-00260: Database access error. SQL state: 42000, error code: 942..

at oracle.security.opss.tools.lifecycle.OpssDomainConfigImpl.configureDBSecurityStore(OpssDomainConfigImpl.java:616)

at oracle.security.opss.tools.lifecycle.OpssDomainConfigImpl.configureSubsystem(OpssDomainConfigImpl.java:489)

at oracle.security.opss.tools.lifecycle.OpssDomainConfigImpl.initializeSubsystem(OpssDomainConfigImpl.java:269)

at oracle.security.opss.tools.lifecycle.cie.OpssSecurityConfiguration.initializeSubsystem(OpssSecurityConfiguration.java:188)

... 5 more

Caused by: oracle.security.opss.tools.lifecycle.LifecycleException: JPS-00260: Database access error. SQL state: 42000, error code: 942.

at oracle.security.opss.tools.lifecycle.OpssLifecycleUtil.checkIfFarmExists(OpssLifecycleUtil.java:735)

at oracle.security.opss.tools.lifecycle.OpssDomainConfigImpl.checkIfFarmExists(OpssDomainConfigImpl.java:907)

at oracle.security.opss.tools.lifecycle.OpssDomainConfigImpl.configureDBSecurityStore(OpssDomainConfigImpl.java:600)

... 8 more

Caused by: oracle.security.jps.service.policystore.PolicyStoreException: JPS-00260: Database access error. SQL state: 42000, error code: 942.

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.beginTransaction(JpsDBDataManager.java:2136)

at oracle.security.jps.internal.policystore.rdbms.JpsDBDataManager.beginTransaction(JpsDBDataManager.java:2132)

at oracle.security.jps.internal.common.rdbms.util.JpsDbBootstrapImpl.<init>(JpsDbBootstrapImpl.java:189)

at oracle.security.opss.tools.lifecycle.OpssLifecycleUtil.getJpsDbBootstrap(OpssLifecycleUtil.java:784)

at oracle.security.opss.tools.lifecycle.OpssLifecycleUtil.checkIfFarmExists(OpssLifecycleUtil.java:706)

... 10 more

Caused by: oracle.security.jps.service.policystore.PolicyStoreException: JPS-00260: Database access error. SQL state: 42000, error code: 942.

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)

... 18 more

2017-09-19 08:19:07,486 SEVERE [65] com.oracle.cie.domain.progress.domain.generation.ExceptionHandlingPhase - Domain Creation Failed!

Domain Location: D:\Oracle\Middleware\Oracle_Home\user_projects\domains\dmn_etelec_dev

Reason: oracle.security.opss.tools.lifecycle.LifecycleException: Error during configuring DB security store. Exception oracle.security.opss.tools.lifecycle.LifecycleException: JPS-00260: Database access error. SQL state: 42000, error code: 942..

Exception:

oracle.security.opss.tools.lifecycle.LifecycleException: Error during configuring DB security store. Exception oracle.security.opss.tools.lifecycle.LifecycleException: JPS-00260: Database access error. SQL state: 42000, error code: 942..