OPSS - Replacing ROOT_CERT_DETAILS by SHA2 Root CA usign EM Fails with ORA-01461

(Doc ID 2257801.1)

Last updated on MAY 03, 2017

Applies to:

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


On : version, Java Platform Security

When attempting to add certificates using Enterprise Manager and the following error occurs.

[2017-01-16T15:35:00.291+01:00] [AdminServer] [WARNING] [JPS-01048] [oracle.jps.credstore] [tid: [ACTIVE].ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: weblogic] [ecid: bf567e7ce017c0f3:56404afa:159a7afb32d:-8000-0000000000000035,0] [DSID: 0000LabgZYqDwWj5H39Dif1OVD^2000006] Modifying of credential failed. Reason oracle.security.jps.service.policystore.PolicyStoreConnectivityException: JPS-00027: There was an internal error: javax.persistence.RollbackException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.3.1.v20111018-r10243): org.eclipse.persistence.exceptions.DatabaseException[[
Internal Exception: java.sql.BatchUpdateException: ORA-01461: can bind a LONG value only for insert into a LONG column

After Add certificates SHA2 root cert is 2228 characters and the SHA1 root CA is 2199 characters long




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