ORA-12899: value too large for column "PRODSOA_SOAINFRA"."SCA_COMMON_FAULT"."ERROR_CODE" (actual: 10
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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)