Kbase P19778: Pulled SQL schema definitions into SH and now program is stuck in endless loop
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/17/2010 |
|
Status: Unverified
SYMPTOM(s):
Program remains in loop with SQL Server tables
Client accessing both Progress db and SH holder db
SH tables have no indexes defined
Progress tables have index defined
Table created within SQL Server first and schema is pulled into SH
Program Fails:
FOR EACH <SH.table1>.
DISPLAY <SH.table1.field>.
FIND FIRST <SH.table2>.
DISPLAY <SH.table2.field>.
FIND FIRST <PR.table> EXCLUSIVE-LOCK.
DISPLAY <PR.table.field>.
END.
Program Passes:
FOR EACH <SH.table1>.
DISPLAY <SH.table1.field>.
FIND FIRST <SH.table2>.
DISPLAY <SH.table2.field>.
FIND FIRST <PR.table>.
DISPLAY <PR.table.field>.
END.
FACT(s) (Environment):
Progress 9.1D
MS SQL DataServer
MS SQL
CAUSE:
The exact cause is unknown at the time of this writing
FIX:
Create an index for the first SQL Server table, SH.table1. Create a single component field within the index.