Support Article

BIX ORA-12899 value too large for column QMARS_STAGING

SA-35727

Summary



Reported for BIX 7.2.2
Inserting a record into the Complaint table in QMARS_STAGING schema, which is the BIX Database schema, throws the SQL Exception ORA-12899.


Error Messages



Exception:
SQL Exception: ORA-12899: value too large for column "QMARS_STAGING"."COMPLAINT"."COMPLAINTDESCRIPTION" (actual: 514, maximum: 512)<CR>][STACK][java.sql.BatchUpdateException: ORA-12899: value too large for column "QMARS_STAGING"."COMPLAINT"."COMPLAINTDESCRIPTION" (actual: 514, maximum: 512)<CR><CR>


Steps to Reproduce



Run BIX as a standalone application using the Extract rule.


Root Cause



A defect or configuration issue in the operating environment
The value stored in the database column is more than the size of the column.

Resolution



Perform the following local-change:

For column QMARS_STAGING, change the column type to CHAR.

Published March 29, 2017 - Updated May 1, 2017

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.