Kbase P130888: Error 7498 occurs when running SQL query in OpenEdge 10.1B01 and later
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/8/2008 |
|
Status: Unverified
SYMPTOM(s):
Error 7498 occurs when executing SQL query that uses multiple joins, aggregate functions (SUM) and group bys
Error: Invalid number string (7498) (State:S1000, Native Code: FFFFB0F8)
=== SQL Exception 1 ===
SQLState=HY000
ErrorCode=-20232
[DataDirect][OpenEdge JDBC Driver][OpenEdge] Invalid number string (7498)
FACT(s) (Environment):
OpenEdge 10.1B01 32-bit Service Pack
OpenEdge 10.1B02 32-bit Service Pack
OpenEdge 10.1B03 32-bit Service Pack
OpenEdge 10.1B01 64-bit Service Pack
OpenEdge 10.1B02 64-bit Service Pack
OpenEdge 10.1B03 64-bit Service Pack
OpenEdge 10.1C
All Supported Operating Systems
Problem does not occur in 10.1A02 or 10.1B00
No implicit data-type conversions are apparent
Query is not using UNION, ROUND or NULLIF
Error occurs when query is run via JDBC and ODBC
CHANGE:
Upgraded to 10.1B01 or later
CAUSE:
Bug# OE00167739
FIX:
Upgrade to 10.1C02 or later.