Oracle SOA Suite (MOSC)

MOSC Banner

ORA-12899: value too large for column "PRODSOA_SOAINFRA"."SCA_COMMON_FAULT"."ERROR_CODE" (actual: 10

edited Jun 14, 2019 5:00AM in Oracle SOA Suite (MOSC) 2 commentsAnswered

Hi All,

I am having this issue in OSB 12.1.3,  when OSB is calling a BPEL service and the transaction fails. We see below error in logs:

********************************************************************************************************************************************************

JTA transaction unexpectedly rolled back (maybe due to a timeout); nested exception is weblogic.transaction.RollbackException: Unexpected exception in beforeCompletion: sync=org.eclipse.persistence.transaction.JTASynchronizationListener@52b5467f

Internal Exception: java.sql.SQLException: ORA-12899: value too large for column "PRODSOA_SOAINFRA"."SCA_COMMON_FAULT"."ERROR_CODE" (actual: 1072, maximum: 100)

INSERT INTO SCA_COMMON_FAULT (ID, RETRY_COUNT, ADDITIONAL_PROPERTIES, CIKEY, COMPONENT_FAULT_KEY, COMPOSITE_ID, COMPOSITE_SCA_ENTITY_ID, CREATION_DATE, ENRICHED_MESSAGE, ERROR_CODE, EVENT_NAME, EXCEPTION_TRACE, FAULT_NAME, FAULT_TYPE, FLEX_FIELD_1, FLEX_FIELD_2, FLEX_FIELD_3, FLEX_FIELD_4, FLEX_FIELD_5, FLEX_FIELD_6, FLOW_ID, INTERNAL_ID, JNDI_LOCATION, ERROR_MESSAGE, MODIFY_DATE, NATIVE_ID, OWNER_CIKEY, OWNER_COMPONENT_TYPE, OWNER_COMPOSITE_SCA_ENTITY_ID, OWNER_SCA_ENTITY_ID, OWNER_SCA_PARTITION_ID, PARTITION_DATE, RES_SCA_ENTITY_ID, SCA_ENTITY_ID, SCA_PARTITION_ID, SRM_NAMESPACE, STATE, STATE_CHANGE_DATE, TARGET_HOST, TENANT_ID, COMPONENT_TYPE, VERSION, WORKLIST_ROLE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center