Kbase P14641: Migrating application from version 8 to 9 that connects to t
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
08/02/2005 |
|
Status: Unverified
SYMPTOM(s):
Migrating application from version 8 to 9 that connects to two Databases with same fields hit errors 425 725 198 when running .p
In version 8 it didn't happen
The fields are not qualified with the DB name
Table <table> is in database <db name> and <db name> (425)
Unknown or ambiguous table <table>. (725)
** <program> Could not understand line <number>. (198)
In the second Database log file there are messages about user being connected but not about the user being disconnected
pseudocode
connect to 1st DB
...
references to first DB fields
...
connect to second DB
run external procedure with references to second DB fields
disconnect second DB
...
references to first DB fields
CAUSE:
Behaviour changed from version 8 to 9.
Besides we saw when running the application that after click ok in the errors message boxes the transaction for second DB was backed out, that means that the disconnect was done with the transaction not yet finished and for that the errors.
FIX:
Wrap the run external procedure between:
do transaction
end