Kbase P70111: Error -20217 when running a select statement.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/10/2008 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1D.
OpenEdge 10.0A
SYMPTOM(s):
Error -20217 when running a select statement.
_sqlsrv2.exe has generated errors and will be closed by Windows.
You will need to restart the program.An error log is being created
Unable to connect to the server.
The tablename which is referenced in the ORDER BY clause is wrong.
FIX:
This is an example of the Query which causes the issue:
SELECT DocumentResource.Description, DocumentResource.DocumentResourceID, DocumentResource.DocumentType, DocumentResource.Version FROM Pub.DocumentResource WHERE DocumentResource.DocumentType LIKE 'XSLT%' ORDER BY DocumentResources.Description.
Removing the tablename and leaving just the name of the field.If the sentence involves fields with the same name in different tables,then use aliasing for the tables.