Kbase P49914: Different clients (i.e., AppServer, GUI, CHUI) retrieve different ROWID values when connecting to Or
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
20/11/2006 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.1D
Oracle DataServer
SYMPTOM(s):
Different clients (i.e., AppServer, GUI, CHUI) retrieve different ROWID values when connecting to Oracle
Client A, (i.e., AppServer) connecting to one schema holder, i.e., oraholder1
Client B, (i.e., CHUI, GUI) connecting to a different schema holder, i.e., oraholder2
ROWID value retrieved by a Client A is different than the ROWID value retrieved Client B.
Multiple schema holders are present
ROWID function is being used
Client A and B are finding a record and passing values back and forth
Can not install 9.1D patch or upgrade to 10.0A
CHANGE:
Table/field updates were made to schema holder and to ORACLE
CAUSE:
Bug# 20031103-004
FIX:
Upgrade to:
Version 9 - 9.1D08 or higher
Release 10 - 10.0B or higher
If unable to upgrade then after applying changes to Oracle,
1. Create two new empty schema holders on both platforms, Windows and Unix
prodb oraholderwindows empty
prodb oraholderunix empty
2. Dump the df from development schema holder with modified dictinary code so the dump also dumps file number. Then load it into deployment schema holder