VERIFIED SOLUTION i
X

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

Issue

Error 

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.

Cause

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.

Resolution

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.

Environment Details

Product Feature: Mapping

 

Downloads

  • No Downloads