My Oracle Support Banner

Error Deploying Cartridge with Custom char on Place Spec and Char Extension Framework On (Doc ID 2695638.1)

Last updated on APRIL 27, 2021

Applies to:

Oracle Communications Unified Inventory Management - Version 7.4.1.0.0 and later
Information in this document applies to any platform.

Goal

On : 7.4.1.0.0 version, Other Issues

Error deploying cartridge after adding custom char to place spec; char extension framework en

Place Specification is created with name State with no custom char. Cartridge deployed successfully
Enabled the char extension framework. Added a char with name testcode to place spec "State".
Facing below error while deploying the cartridge:

ERROR

Error installing cartridges: {=java.io.IOException: The model data can not be imported. - Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.5.v20170607-b3d05bd): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: The transaction is no longer active - status: 'Marked rollback. [Reason=weblogic.transaction.internal.AppSetRollbackOnlyException: setRollbackOnly called on transaction]'. No further JDBC access is allowed within this transaction.
Error Code: 0
Call: INSERT INTO EntityLinkCharSpecValue (QUERYSOURCE, QUERYSOURCETYPE, ENTITYID) VALUES (?, ?, ?)
  bind => [3 parameters bound]
Query: DataModifyQuery(sql="UPDATE CharacteristicSpecValue SET CHARACTERISTICSPECIFICATION = ? WHERE (ENTITYID = ?)")
 Please verify logs for more Information}
<[Error Code]: RUNTASKS_ERROR [Stage]: POST_DEPLOY [Description]: UNKNOWN.
[Remedy Action]: UNKNOWN.
[Details]: Error installing cartridges: {=java.io.IOException: The model data can not be imported. - Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.5.v20170607-b3d05bd): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: The transaction is no longer active - status: 'Marked rollback. [Reason=weblogic.transaction.internal.AppSetRollbackOnlyException: setRollbackOnly called on transaction]'. No further JDBC access is allowed within this transaction.
Error Code: 0
Call: INSERT INTO EntityLinkCharSpecValue (QUERYSOURCE, QUERYSOURCE ..



From UIM Log


Internal Exception: java.sql.SQLSyntaxErrorException: ORA-01031: insufficient privileges
ORA-06512: at "***.CREATE_CHAR_EXT_TABLE", line 15
ORA-06512: at "***.ADD_CHAR_COLUMN_TRIGGER", line 103
ORA-04088: error during execution of trigger '***.ADD_CHAR_COLUMN_TRIGGER'

Solution

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
Goal
Solution


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