Kbase P122736: The Progress 9.1x SQL engine crashes on AIX with parameterized statements that use the CONVERT funct
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
09/03/2007 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1x
IBM AIX
SYMPTOM(s):
The SQL engine crashes when a parameterized statement is executed
The SQL statement is run as a normal statement instead of a Prepared Statement
The CONVERT function is also being used in the SQL statement
The same statement returns error 7481 on other platforms
Inconsistent types (7481)
Stack trace from _sqlsrv2 reads:
sfv_convert
sfv_odbc_convert
xec_describe_param
CAUSE:
The exact cause is unknown at the time of this writing.
FIX:
Upgrade to 10.1B01 or later.
The error message has also been corrected. The SQL engine will now return:
"Value has not been specified for parameter 1"