Resolve the 'ORA-12899: value too large for column "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx" (actual: 255, maximum: 254) .' Confirm referential integrity error message

Product Feature: Mapping




DBMS Msg=ORA-12899: value too large for column "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx" (actual: 255, maximum: 254) .

encountered on the RI Agent, where xxxxxxxxxxxxxxxxxxxxxxxxxxxx is the map layer.


Caused by size of the data being too large for the map field.

If the number of characters in the field referenced is below or the same as the field length it can be caused by the use of certain characters such as "?" which take up more than 1 byte of data when inserted into the database.

The 254 field size for a map layer is the result of Mapinfo tab files only allowed 254 characters in size.

The Refential Integrity Agent looks at the length of the source field and truncates the data to the max 254 field size. If however there is a ? character surrounded by " " in the first 254 characters the error will be thrown by the RI agent.


UPDATED: May 30, 2017
If it is the use of "?" and similar characters then remove these characters or other characters or words that are not needed.

This has been raised as a software defect and the fix will released in due course.