OPSS - Unable To Create OHS Domain getting SQLException: Data size bigger than max size for this type JPS-08531: Failed to create audit metadata in audit store
(Doc ID 2193458.1)
Last updated on MARCH 01, 2023
Applies to:
Oracle Platform Security for Java - Version 12.1.3.0.0 and laterInformation in this document applies to any platform.
Symptoms
Unable to create OHS 12C domain, the configuration domain wizard shows"
Observing the next error in logs:
2016-09-23 10:58:44,331 SEVERE [59] oracle.security.opss.tools.lifecycle.provision.OpssProvisionTool - Data migration failed for configurator oracle.security.jps.internal.config.db.DbAuditStoreServiceConfigurator
2016-09-23 10:58:59,810 SEVERE [59] oracle.security.opss.tools.lifecycle.OpssDomainConfigImpl - Error during configuring DB security store. Exception oracle.security.opss.tools.lifecycle.LifecycleException: JPS-08531: Failed to create audit metadata in audit store. Reason: oracle.security.audit.config.dynamic.DynAuditDefinitionException: Failed to create system audit definition. Reason: oracle.security.jps.service.policystore.PolicyStoreException: javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: Data size bigger than max size for this type: 76652
Error Code: 17070
Call: INSERT INTO JPS_ATTRS_BINARY (JPS_ATTRS_ID, ATTRNAME, ATTRVAL, JPS_DN_ENTRYID) VALUES (?, ?, ?, ?)
bind => [4 parameters bound]..
2016-09-23 10:58:59,811 SEVERE [59] oracle.security.opss.tools.lifecycle.cie.OpssSecurityConfiguration - Error while processing initializeSubsystem. Exception oracle.security.opss.tools.lifecycle.LifecycleException: Error during configuring DB security store. Exception oracle.security.opss.tools.lifecycle.LifecycleException: JPS-08531: Failed to create audit metadata in audit store. Reason: oracle.security.audit.config.dynamic.DynAuditDefinitionException: Failed to create system audit definition. Reason: oracle.security.jps.service.policystore.PolicyStoreException: javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java
2016-09-23 10:58:59,810 SEVERE [59] oracle.security.opss.tools.lifecycle.OpssDomainConfigImpl - Error during configuring DB security store. Exception oracle.security.opss.tools.lifecycle.LifecycleException: JPS-08531: Failed to create audit metadata in audit store. Reason: oracle.security.audit.config.dynamic.DynAuditDefinitionException: Failed to create system audit definition. Reason: oracle.security.jps.service.policystore.PolicyStoreException: javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: Data size bigger than max size for this type: 76652
Error Code: 17070
Call: INSERT INTO JPS_ATTRS_BINARY (JPS_ATTRS_ID, ATTRNAME, ATTRVAL, JPS_DN_ENTRYID) VALUES (?, ?, ?, ?)
bind => [4 parameters bound]..
2016-09-23 10:58:59,811 SEVERE [59] oracle.security.opss.tools.lifecycle.cie.OpssSecurityConfiguration - Error while processing initializeSubsystem. Exception oracle.security.opss.tools.lifecycle.LifecycleException: Error during configuring DB security store. Exception oracle.security.opss.tools.lifecycle.LifecycleException: JPS-08531: Failed to create audit metadata in audit store. Reason: oracle.security.audit.config.dynamic.DynAuditDefinitionException: Failed to create system audit definition. Reason: oracle.security.jps.service.policystore.PolicyStoreException: javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java
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 |
Cause |
Solution |
References |