Kbase P109157: Getting error 3782 whe using empty fields list and no-lock on temp-table query
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/03/2010 |
|
Status: Verified
SYMPTOM(s):
Getting a runtime error 3782 whe using empty fields list and no-lock on temp-table query
Field <field-num> from <file-name> record (recid <RECID>) was missing from FIELDS phrase. (3782)
FACT(s) (Environment):
Has existing procedure that defines TEMP-TABLE.
Procedure has DEFINE QUERY for TEMP-TABLE using an empty field list
Same procedure has Open Query for TEMP-TABLE using NO-LOCK
OpenEdge 10.0B
All Supported Operating Systems
CHANGE:
Just applied service pack OE10.0B3
CAUSE:
Bug# OE00120726
FIX:
Upgrade to:
Version 9 9.1E04 or higher
Release 10 10.0B05 or higher
If you can not upgrade there are three possible workarounds
1. Remove the empty FIELDS list from the DEFINE QUERY statement
2. Change the lock statement to share or exclusive lock on the OPEN QUERY statement.
3. Use the -fldisable startup parameter to disable all field lists.