Migration of OAM 10g to 11gR2 Fails with Error "java.sql.BatchUpdateException: ORA-01461" (Doc ID 1984063.1)

Last updated on APRIL 30, 2015

Applies to:

Oracle Access Manager - Version 11.1.2.2.1 and later
Information in this document applies to any platform.

Goal

We attempted to migrate our OAM10g (10.1.4.3) BP03 policies/webates etc to OAM11g (11.1.2.2) BP02 but it fails with the following error in Admin Server log;

Caused by: 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

Error Code: 1461
Query:
@ InsertObjectQuery(oracle.security.jps.internal.policystore.rdbms.entity.JpsDES
CRIPTION@1176ee27)
at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseExce ption.java:324)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeJDK12B
at chStatement(DatabaseAccessor.java:873)

What might be the root cause of this?

Solution

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