Kbase P124176: Error 91 when attempting to create a field in a table in an OpenEdge Database
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
6/13/2007 |
|
Status: Unverified
SYMPTOM(s):
Cannot create a field in a table in the database.
Create field via prowin32 fails with error 91
** No <file-name> record is available. (91)
** No _Area record is available. (91)
Can create a field using the character procedure editor _progres
Can create fields with prowin32 against other databases without receiving an error
Dumping and loading the database does not resolve the problem.
proutil dbname -C idxfix does not report any errors.
proutil dbname -C dbanalys does not report any errors.
Can create fields with prowin32.exe on certain tables within the database but not all tables.
There isn't table level security for any tables in the database.
The Data Definitions file (.df) associated with the problem tables, contain foreign-pos, foreign-name and foreign-type entries in the table definitions.
CAUSE:
The Data Definition file (.df) contains table and field definitions of: foreign-pos, foreign-name and foreign-type. These entries are reserved for schema holder database which are used to reference information in a 3rd party database. These are not valid data definitions for an OpenEdge database that is not used as a schema holder.
FIX:
Remove all foreign-pos, foreign-name and foreign-type table and field entries from the data definition file (.df). Then create a new database. Load the modified data definition file (.df) in the newly created database and then reload the data.