Kbase P26592: error 1461 running application against SQL server
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/06/2003 |
|
Status: Unverified
FACT(s) (Environment):
MS SQL 2000
FACT(s) (Environment):
Progress 9.1D
FACT(s) (Environment):
MS SQL DataServer
FACT(s) (Environment):
Progress 9.1D
SYMPTOM(s):
Schema holder does not match database schema - file OWNER.TABLENAME field <FIELDNAME> (1461)
Application deployed in the following manner
Development has a SQL script to update SQL database, then rebuild a new
schema holder and recompile application. The SQL script for SQL database, new schema holder and recompiled r code are shipped to customers sites
Only 3 sites are having the problem
skip_schema_check switch worked
Schema holder and r code from a working site are identical to that from a non-working site
Pull the schema for this table into a new schema holder and compare that to the same table in the deployed schema holder reviews that foreign-pos' are different
The order of the columns in SQL server for the table as in TABLENAME is different than the order of fields for the same table in the schema holder
CAUSE:
The 3 sites, after loading the SQL script, then runs another script, which changes order of fileds on SQL server side, thus foreign-pos' changed.
FIX:
Create a script to recreate the tables swapping the field order back to
the standard sequence on the SQL server side.