Kbase P43442: Microsoft SQL Server text fields cause Access Violation errors when using field lists and NO-LOCK
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
27/04/2010 |
|
Status: Verified
SYMPTOM(s):
Microsoft SQL Server text fields cause Access Violation errors when using field lists and NO-LOCK.
Progress client generates a GPF
FACT(s) (Environment):
Using NO-LOCK in the query
A text field is in field list
Progress 9.1D
Windows
MS SQL DataServer
CAUSE:
Bug# OE00093124
FIX:
Upgrade to 9.1D09 or later.
or
Upgrade to OpenEdge 10.0A or later.
If you cannot upgrade to one of the above versions, there are two workarounds:
1. Do not use NO-LOCK, use either SHARED-LOCK or EXCLUSIVE-LOCK in your query.
2. Do not use field lists.