Kbase P1168: Recreating a new SDO corrects errors 425 and 725 when creati
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
29/01/2005 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1B
SYMPTOM(s):
Error: Table <table> is in database <db name> and <db name> (425)
Error: Unknown or ambiguous table <table>. (725)
Trying to create a HTML mapping
Connected to two databases.
Error occurs when slecting the SDO while using the mapping wizard
These errors occur when the databases have tables with the same name in common.
Unable to modify the existing SDO
CAUSE:
This is a normal behavior when the SDO you selected has been created against only one of the databases, and it was connected with another logical name. In this case the wizard doesn't know which table to use, even if the database that was used to create it is connected under another logical name.
The SDO keeps information about what database was used to create it even when the Options > Preferences > Qualify Database Fields Database Name was not enabled at the time of creation.
FIX:
Recreate the SDO to reflect the new logical database name, save the SDO and retry the creation of the HTML Mapping.