My Oracle Support Banner

MDB publish fails due to ORA-01461 (Doc ID 2614759.1)

Last updated on JUNE 02, 2020

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.3 and later
Information in this document applies to any platform.

Symptoms

On : 8.0.7 version, Technical_metadata_OFSS

When attempting to perform MDB publish, the following error occurs.

ERROR
-----------------------
 [23-07-19 08:05:20,202 GMT AM] - javax.persistence.RollbackException: Exception [EclipseLink-4002] (Eclipse Persistence Services -2.6.3.v20160526-8f41838):
org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLException: ORA-01461: can bind a LONG value only for insert into a LONG column

Error Code: 1461
Call: INSERT INTO REV_OBJECT_ATTRIBUTE_DTL (ID, ATTR_DYN_ROWSET, ATTRIBUTE_ID, ATTRIBUTE_VALUE, ATTRIBUTE_VALUE_1, ATTRIBUTE_VALUE_2, GROUP_ID, MEMBER_CODE, PARAM_VALUE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
bind => [9 parameters bound]
Query:InsertObjectQuery(com.ofs.aai.mdb.dao.entity.RevObjectAttributeDtl@f46b182)
at org.eclipse.persistence.internal.jpa.transaction.EntityTransactionImpl.commit(EntityTransactionImpl.java:159)
at com.ofs.aai.mdb.dao.controller.MDBJpaController.create(MDBJpaController.java:64)
at com.ofs.aai.mdb.service.adapter.MDBPublishAdapter.addObject(MDBPublishAdapter. java:36)
at com.ofs.aai.mdb.impl.dmt.DMTHelper.addObject(DMTHelper.java:232)
at com.ofs.aai.mdb.impl.dmt.PublishDataMapping.addDataMappingObject(PublishDataMapping.java:233)
at com.ofs.aai.mdb.impl.dmt.PublishDataMapping.publish(PublishDataMapping.java:130)
at com.ofs.aai.mdb.service.adapter.MDBPublishExecutionAdapter.executeListOfClasses(MDBPublishExecutionAdapter.java:288)


STEPS
-----------------------
1. T2T should have join condition more than 12000 characters.
2.Trigger MDB publish

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot successfully complete MDB publish.

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.