My Oracle Support Banner

ORA-12899: Value Too Large for Column "REV_OBJECT_REPOSITORY_TL"."OBJECT_DESCRIPTION" Error Executing MDBPublishExecution.sh (Doc ID 2182094.1)

Last updated on MARCH 28, 2019

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.2 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
MDBPublishExecution

Symptoms

In OFSAA Infrastructure 8.0.2, when executing MDBPublishExecution.sh from $FIC_DB_HOME/bin to publish metadata in Metadata Browser, you get ORA-12899 errors in the MDB_1465894834638.LOG located in the web server's OFSAA log directory.

ERROR
-----------------------
[MDBLOG][14-06-16 17:04:38 PM]javax.persistence.RollbackException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: ORA-12899: value too large for column "OFSAACONF"."REV_OBJECT_REPOSITORY_TL"."OBJECT_DESCRIPTION" (actual: 1133, maximum: 1000)

Error Code: 12899
Call: INSERT INTO REV_OBJECT_REPOSITORY_TL (ID, MLS_CD, OBJECT_DESCRIPTION, OBJECT_NAME) VALUES (?, ?, ?, ?)
bind => [4 parameters bound]
Query: InsertObjectQuery(com.ofs.aai.mdb.dao.entity.RevObjectRepositoryTl@6286318b)
       at org.eclipse.persistence.internal.jpa.transaction.EntityTransactionImpl.commit(EntityTransactionImpl.java:157)
       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.fusion.impl.EntityMDBImpl.publish(EntityMDBImpl.java:133)
       at com.ofs.aai.mdb.service.adapter.MDBPublishExecutionAdapter.executeListOfClasses(MDBPublishExecutionAdapter.java:288)
       at com.ofs.aai.mdb.service.adapter.MDBPublishExecutionAdapter.publishMetadataExecution(MDBPublishExecutionAdapter.java:382)
       at com.ofs.aai.mdb.service.adapter.MDBPublishExecutionAdapter.publishObjects(MDBPublishExecutionAdapter.java:158)
       at com.ofs.aai.mdb.ws.service.MetadataBrowserPublishServiceImpl.invokeMetadataBrowserPublishService(MetadataBrowserPublishServiceImpl.java:61)
       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
       at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
       etc.

As a result of the errors, not all items are published to be viewed in the Metadata Browser.

Changes

 

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
Changes
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.