Kbase P133807: Updating or creating records through the Application is being written to a wrong MS SQL Server Datab
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
8/1/2008 |
|
Status: Unverified
SYMPTOM(s):
Updating or creating records through the Application is being written to a wrong MS SQL Server Database that has identical tables
FACT(s) (Environment):
Identical Database exist on the MS SQL Server with different names
Two separate ODBC system DSN exist to connect to each MS SQL Server database
Correct ODBC DSN is being used to connect to the MS SQL Server database
A delta.df is loaded into the existing schema holder for "database A" that has the QUALIFIER name point to "database B" on the meta-schema
Windows NT 32 Intel/Windows 2000
Progress 9.1x
OpenEdge 10.x
MS SQL DataServer
CAUSE:
The QUALIFIER for the table in the schema holder is pointing to a different but identical MS SQL Server database that has the same tables and fields names. Despite the correct ODBC DSN is used, the QUALIFIER name in the meta-schema dictates where the records are being created or updated.
FIX:
Follow the steps to correct the QUALIFIER name on the tables that are introduced by loading the delta.df:
1. Connect the the schema holder in a single user mode.
2. Dump the .df for the tables that has different QUALIFIER name.
3. Edit the dumped .df to reflect the correct QUALIFIER name and save the change
4. Delete the DataServer schema using Data Administration > DataServer > MS SQL Server Utilities > Delete DataServer Schema...
5. Load the .df back to the schema holder.