Kbase P98624: Simple query hangs after upgrading the MS SQL Server DataServer to Progress 9.1E/OpenEdge 10.0B
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
9/17/2008 |
|
Status: Verified
SYMPTOM(s):
Simple query hangs after upgrading the MS SQL Server DataServer to Progress 9.1E/OpenEdge 10.0B
FACT(s) (Environment):
A query similar to the following is performed:
DEFINE QUERY Q-state
FOR state FIELDS(State Region)
SCROLLING.
OPEN QUERY Q-state
FOR EACH state NO-LOCK
BY state.
GET NEXT Q-state.
Windows
MS SQL DataServer
Progress 9.1x
OpenEdge 10.x
The schema holder is created by dumping and loading the .df from progress 9.1D schema holder to 9.1E/10.0B empty database
CAUSE:
The dumping and loading of the progress 9.1D schema holder is the reason for the query to hang.
FIX:
Create a new schema holder from the scratch in Progress 9.1E or in OpenEdge 10.0B. The reason a new schema holder must be created is there has been a new configuration flag added for the implementation of a new cursor management system. This makes any schema holder created prior to 9.1E for V9 or created in 10.0A obsolete. Dumping and loading of a .df will not add the configuration flag.