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

Last updated on JANUARY 21, 2017

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.

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