Kbase P93043: SQL server Data server errors out and GPFs when calling stored procedure Using view as buffer
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
22/03/2010 |
|
Status: Unverified
SYMPTOM(s):
Data server errors when calling stored procedure
SYSTEM ERROR: _type_sqlc : Bad Datatype 0. (6227)
After error 6227, data server GPFs
stack trace from prowin32.exe reads:
odbc_type_sqlc
odbc_dorec_tobuf
odbc_rec_tobuf
odbc_proc_close
Stored procedure and view contains more than 4 fields
The procedure crashes in 9.1D and 10.0A
The same procedure works in 9.1C and 10.0B
Code contains CLOSE STORED_PROC
The code is not using proc-text-buffer defined by Progress
In SQL server, a view is defined that serves as a buffer to retrieve database results in their original data types.
If the stored procedure and the view have less than four fields, it does not crash
The application has to use buffer view containing more than three fields.
FACT(s) (Environment):
Windows NT 32 Intel/Windows 2000
Progress 9.1D
OpenEdge 10.0A
MS SQL DataServer
CAUSE:
The exact cause is unknown at the time of this writing
FIX:
Upgrade to 9.1E, 10.0B or later