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 OCTOBER 17, 2016

Applies to:

Oracle Platform Security for Java - Version 12.1.3.0.0 and later
Information 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

 

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