ODF-0207: Data size cannot be reduced

Document ID : KB000055207
Last Modified Date : 14/02/2018
Show Technical Document Details

I have created a string attribute with a Maximum Size = 20. We want to reduce the maximum size from 20 to 14, but an error message appears. Why can't we change the size?

          ERROR:  ODF-0207 Data size cannot be reduced

The error message appears because the application prevents the loss of data within your database. Once a string attribute has been created, you can only increase the maximum size; you cannot decrease the maximum size.

One alternative is to create a new string attribute with the new maximum size and deactivate the existing attribute.