Kbase P21850: Error 1461 while compiling the code after updating the schem
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
06/06/2003 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.1C
FACT(s) (Environment):
Windows NT 32 Intel/Windows 2000
FACT(s) (Environment):
MS SQL DataServer
FACT(s) (Environment):
ODBC DataServer
SYMPTOM(s):
Fields were added after after the PROGRESS_RECID_IDENT_ field in a MS SQL Server table
Error 1461 while compiling the code after updating the SQL Server schema holder
Schema holder does not match database schema --file <DB_Name>.<Owner_Name>.Table_Name> field <Field_Name> (1461)
CAUSE:
Bug# 20020402-001
CAUSE:
The bug was from assuming the Progress_Recid_ident field being at the end of all other columns in the MSS Database for each table. Therefore, the last foreign position is reserved for the Progress_recid column which is hidden in the schema holder. When a new field is added in the MSS Database and updated in the schema holder, it assigns the last value that was reserved for progress_recid to the new field in the schema holder by the DataServer. Being the same foreign position for both progress_recid value and one of the newly added fields in the DataServer schema holder causes the error to be displayed.
FIX:
The issue has been fixed in Progress 9.1D. The bug is fixed in 9.1D so it increments the value by 1 for the foreign position that was reserved for progress_recid field for the newly added field(s) while performing the 'Update/Add Table Definition' utility in the DataServer menu.