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:
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 18.104.22.168, 22.214.171.124, 126.96.36.199, 188.8.131.52, 184.108.40.206, 220.127.116.11, 18.104.22.168, 22.214.171.124, 126.96.36.199, 188.8.131.52, 184.108.40.206, 220.127.116.11, 18.104.22.168, 22.214.171.124, 126.96.36.199, 188.8.131.52, 184.108.40.206, 220.127.116.11, 18.104.22.168, 22.214.171.124, 126.96.36.199, 188.8.131.52, 184.108.40.206
220.127.116.11, 18.104.22.168, 22.214.171.124, 126.96.36.199, 188.8.131.52, 184.108.40.206, 220.127.116.11, 18.104.22.168, 22.214.171.124, 126.96.36.199, 188.8.131.52, 184.108.40.206, 220.127.116.11, 18.104.22.168, 22.214.171.124, 126.96.36.199, 188.8.131.52, 184.108.40.206
220.127.116.11, 18.104.22.168, 22.214.171.124, 126.96.36.199, 188.8.131.52, 184.108.40.206, 220.127.116.11, 18.104.22.168
22.214.171.124, 126.96.36.199, 188.8.131.52, 184.108.40.206, 220.127.116.11, 18.104.22.168, 22.214.171.124, 126.96.36.199, 188.8.131.52, 184.108.40.206, 220.127.116.11, 18.104.22.168, 22.214.171.124
126.96.36.199, 188.8.131.52, 184.108.40.206, 220.127.116.11, 18.104.22.168, 22.214.171.124, 126.96.36.199, 188.8.131.52, 184.108.40.206, 220.127.116.11, 18.104.22.168, 22.214.171.124, 126.96.36.199, 188.8.131.52, 184.108.40.206
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.
To troubleshoot this issue:
- Verify the error and take note of the table and column name (the column name might not be returned).
- Take note of the returned number of characters and what the max is for the column.
- Check the datatype on the masked column on the database.
- Check what type of algorithm is used for this column.
- Try to run Oracle database profiler to see what value was inserted and why it was too large.
The following articles may provide more information or related information to this article:
- How to Troubleshoot Masking Jobs and Access Masking Logs (KBA7988)
- Algorithm: Summary (KBA4066)
- Algorithm Framework: Summary (KBA7880)