Consultor Eletrônico

Status: Unverified

FACT(s) (Environment):

OpenEdge 10.1x

SYMPTOM(s):

Getting error 8011 and 8010 when updating columns of the _File table through ABL

add_sql92_index: column update failed, table# = -32750 (4, -1215) (8011)

scfxdk: Failure building default index (6) (8010)

CAUSE:

This error happens when a 4GL / ABL application is trying to modify SQL specific data from the System Tables. New SQL specific system tables have been added in OpenEdge 10.1A which do not have negative table numbers, these tables have the table numbers 32768 and higher. So the following ABL code will cause this problem:
for each _file where _file-number > 0:
_can-write = "user".
end.

FIX:

Change your code to prevent it from modifying SQL specific data, for example:
for each _file where _file-number > 0 and _file-number < 32768:
_can-write = "user".
end.