Skip to main content
Delphix

Resolving ORA-12899 Error: value too large for column (KBA1838)

 

 

KBA

KBA# 1838

At a Glance

ORA Error: ORA-12899: value too large for column
Description: The page describes the error 'ORA-12899: value too large for the column' and how to resolve it.
OERR:  12899, 00000, "value too large for column %s (actual: %s, maximum: %s)"
// *Cause: An attempt was made to insert or update a column with a value
//         which is too wide for the width of the destination column.
//         The name of the column is given, along with the actual width
//         of the value, and the maximum allowed width of the column.
//         Note that widths are reported in characters if character length
//         semantics are in effect for the column, otherwise widths are
//         reported in bytes.
// *Action: Examine the SQL statement for correctness.  Check source
//          and destination column data types.
//          Either make the destination column wider, or use a subset
//          of the source column (i.e. use substring).
Root Cause: The returned masked value from the Continuous Compliance Engine is larger (in the number of characters) than available in the updated column.  The masked value is too wide for the destination column. Two causes are known: 
  1. The masked value is too long - usually from an incorrectly configured algorithm.
  2. The masked character set is in Unicode and the column datatype is in 8-bit code. 

This issue is not common as most algorithms trim the masked value prior to updating the value. 

Solution: To resolve this issue ensure that the algorithm is correctly configured and that the masked value is using the correct character encoding. 

Applicable Delphix Versions

Click here to view the versions of the Delphix engine to which this article applies
Major Release All Sub Releases
6.0 6.0.0.0, 6.0.1.0, 6.0.1.1, 6.0.2.0, 6.0.2.1, 6.0.3.0, 6.0.3.1, 6.0.4.0, 6.0.4.1, 6.0.4.2, 6.0.5.0, 6.0.6.0, 6.0.6.1, 6.0.7.0, 6.0.8.0, 6.0.8.1, 6.0.9.0, 6.0.10.0, 6.0.10.1, 6.0.11.0, 6.0.12.0, 6.0.12.1, 6.0.13.0

5.3

5.3.0.0, 5.3.0.1, 5.3.0.2, 5.3.0.3, 5.3.1.0, 5.3.1.1, 5.3.1.2, 5.3.2.0, 5.3.3.0, 5.3.3.1, 5.3.4.0, 5.3.5.0, 5.3.6.0, 5.3.7.0, 5.3.7.1, 5.3.8.0, 5.3.8.1, 5.3.9.0

5.2

5.2.2.0, 5.2.2.1, 5.2.3.0, 5.2.4.0, 5.2.5.0, 5.2.5.1, 5.2.6.0, 5.2.6.1

5.1

5.1.0.0, 5.1.1.0, 5.1.2.0, 5.1.3.0, 5.1.4.0, 5.1.5.0, 5.1.5.1, 5.1.6.0, 5.1.7.0, 5.1.8.0, 5.1.8.1, 5.1.9.0, 5.1.10.0

5.0

5.0.1.0, 5.0.1.1, 5.0.2.0, 5.0.2.1, 5.0.2.2, 5.0.2.3, 5.0.3.0, 5.0.3.1, 5.0.4.0, 5.0.4.1, 5.0.5.0, 5.0.5.1, 5.0.5.2, 5.0.5.3, 5.0.5.4

Issue

This issue happens if an algorithm is incorrectly configured or there is an error. This can happen in a Custom Algorithm. To resolve that please contact the provider of the Custom Algorithm. 

The issue can also happen if the character set in the masked value uses more bytes than the character set defined on the column on the database. 

Troubleshooting

To troubleshoot this issue:

  1. Verify the error and take note of the table and column name (the column name might not be returned). 
  2. Take note of the returned number of characters and what the max is for the column. 
  3. Check the datatype on the masked column on the database. 
  4. Check what type of algorithm is used for this column. 
  5. Try to run Oracle database profiler to see what value was inserted and why it was too large. 

 


Related Articles

The following articles may provide more information or related information to this article: