SAP Knowledge Base Article - Preview

2269361 - Stack trace from opt_QueryExp.cxx at ComputeMaxHashRows - SAP IQ

Symptom

  • Select query with explicit or implict 'Group by' over a column with an empty string value can result in a non-fatal stacktrace in opt_QueryExp.cxx
  • Error Message:
      There was an error reading the results of the SQL statement.
      The displayed results may be incorrect or incomplete.
      IQ Internal error. Please report this to Sybase IQ support.
      --
      (opt_QueryExp.cxx 309)
      SQLCODE=-1006000, ODBC 3 State="HY000"
  • Stack Trace:
    I. 01/18 12:04:56. 0000226609 ** Non-Fatal IQ Internal Error Detected
    I. 01/18 12:04:56. 0000226609 ** at opt_QueryExp.cxx:309 on thread 559647040 (TID 118)
    I. 01/18 12:04:56. 0000226609 **
    ...
    I. 01/18 12:04:56. 0000226609
    I. 01/18 12:04:56. 0000226609 pc: 0x2abb2e19b886 pcstkwalk(stk_trace*,int, db_log*, hos_fd*)+0x36
    I. 01/18 12:04:56. 0000226609 pc: 0x2abb2e19bac1 ucstkgentrace(int, int)+0x111
    I. 01/18 12:04:56. 0000226609 pc: 0x2abb2e19d053 StackTraceForThisThread(char const*, int, char const*, char const*, char const*)+0x313
    I. 01/18 12:04:56. 0000226609 pc: 0x2abb2ddd53e2 df_Exception::df_Exception(char const*, int, df_Exception::df_ErrorCode, char const*, char const*, dfo const*, df_Evaluable const*)+0x442
    I. 01/18 12:04:56. 0000226609 pc: 0x2abb2ddd6e19 df_Exception::ThrowException_0(char const*, int, df_Exception::df_ErrorCode)+0x39
    I. 01/18 12:04:56. 0000226609 pc: 0x2abb2e288983 opt_QueryExp::ComputeMaxHashRows(unsigned int, unsigned int, unsigned int, int) const+0x203
    I. 01/18 12:04:56. 0000226609 pc: 0x2abb2e262208 opt_GroupNode::GatherGroupingMetaData()+0x228
    I. 01/18 12:04:56. 0000226609 pc: 0x2abb2e2a46b1 opt_QueryTree::ProcessQueryTree()+0x81
    I. 01/18 12:04:56. 0000226609 pc: 0x2abb2e2b07af opt_Select::GenerateDFOs (df_Heap*, opt_QueryExp*)+0x1af
    I. 01/18 12:04:56. 0000226609 pc: 0x2abb2e25b19f opt_Driver::GenerateTree (QueryNode*, st_cursor*)+0xc0f
    ...


Read more...

Environment

 SAP IQ 15.4

Product

SAP Sybase IQ 15.4

Keywords

Sybase IQ ; 716563 ; , KBA , BC-SYB-IQ , Sybase IQ , Bug Filed

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.