Extracts are failing in production error message - ORA-12899
Business Intelligence Exchange (BIX) extracts are failing in production, when the data from BLOB (value of property for one of the instance of case) is more than the data defined in the database column.
Batch Update Exception: ORA-12899: value too large for column "dbname"."schemaname"."propertyname" (actual: 136, maximum: 128)
Steps to Reproduce
Following is the details of the BIX Schema
1. Create an extract rule.
2. Include the table and column mapping in the extract rule.
3. Execute the extract rule.
User has modified the DDL script which generates for the first time when doing extraction to database to create table.
The default DDL will create columns to take length in terms of char.
User modified the DDL which will create columns to take length in terms of Byte.
There is a mismatch between the number of characters that user is trying to truncate and the actual bytelength of the column that is, column length is exceeding the byte length and truncation is failing with ORA-12899.
Use default DDL generated to create the table and column length must be in terms of characters.
0% found this useful