Kbase P178133: Error code -210012 on haggr temp table when running a SQL query
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
30/11/2010 |
|
Status: Unverified
SYMPTOM(s):
Error code -210012 on haggr temp table when running a SQL query
SQLState=HY000
ErrorCode=-210012
[DataDirect][OpenEdge JDBC Driver][OpenEdge] Column gkeystr in table haggr table has value exceeding its max length or precision.
FACT(s) (Environment):
OpenEdge 10.2B
UNIX
Windows
Running a complex SQL query that contains a GROUP BY clause on many values
CAUSE:
SQL has created an internal temp table to do aggregation via a hash table. It?s attempting to extract a field value from a row in the temp table, but the buffer it?s extracting to is not large enough.
CAUSE:
Bug# OE00202509
FIX:
It is possible to work around this bug by grouping on fewer values, or by using the substring() scalar function if grouping by character fields that may contain a lot of data.