2394242 - The IQ table can't sort the analytic functions of the catalog table - SAP IQ | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2394242 - The IQ table can't sort the analytic functions of the catalog table - SAP IQ


When using RANK () or ROW_NUMBER () for catalog table, the IQ table can't sort this result.

    **  Error from IQ connection:  SA connHandle: 3  SA connID: 4  IQ connID: 0000000062  User: DBA
    **  Time of error:  2016-11-09 13:36:16
    **  IQ Version:  SAP IQ/16.0.110/10339/P/sp11.04
    **  OS info:  IQ built on: Enterprise Linux64 - x86_64 - 2.6.18-194.el5,  Executed on: Linux/saneagle.tyo.sap.corp/2.6.32-431.el6.x86_64/#1 SMP Sun Nov 10 22:19:54 EST 2013/x86_64
    **  Command status when error occured:  CURSOR ACTIVE
    **  Command text:
select "UID" from(select "UID","ROW_NUMBER"() over(order by "UPDATE_DT" asc) as
"ORD_NUM" from "CAT_TBL") as "TMP" where "TMP"."ORD_NUM" <= (select cast('60' as
 integer) from "iq_dummy") order by 1 asc
Dump all thread stacks at stcxtlib/st_server.cxx:1926 for PID: 26645

    ***************** This is the STACKTRACE ***************

===== Thread Number  139701922006784  (IQ connID: 0000000062) =====
pc: 0x7f0ed96867b2 pcstkwalk(stk_trace*, int, db_log*, hos_fd*)+0x32
pc: 0x7f0ed9686e21 ucstkgentrace(int, int)+0x121
pc: 0x7f0ed96881f9 DumpAllThreads(char const*, unsigned int, int)+0x259
pc: 0x7f0ed940471a hos_ABORT(char const*, unsigned int, char const*, char*, char
pc: 0x7f0eda1a9aef SigHndlr+0x4f
pc: 0x384120f7e0
pc: 0x7f0ed91822d1 dfo_Ranking::FetchOpus()+0x1e1
pc: 0x7f0ed91ad55d dfo_SubQueryFilter::FetchOpus()+0x8d
pc: 0x7f0ed91f1845 dfo_cOrderBy::PrefetchAndSort()+0x435
pc: 0x7f0ed91e285e dfo_cOrderBy::FetchOpus()+0x14e
pc: 0x7f0ed91a3801 dfo_Cursor::FetchOpus()+0x111
pc: 0x7f0ed919ad89 dfo_Root::FetchOpus()+0x1b9
pc: 0x7f0eda162e68 st_cursorIQtoSA::FetchRows(unsigned int)+0x88
pc: 0x7f0eda163985 st_cursorIQtoSA::Execute()+0x105
pc: 0x7f0ed8f7f28b df_OpenCursor::Execute()+0x3b
pc: 0x7f0eda1558d2 st_command::DoCmdThroughResourceGate()+0x82
pc: 0x7f0eda1a6dc8 st_iqdml::OpenCursor(a_statement*, UIConnection*, UICursor*,
a_cursor_spec*, a_cursor_orientation)+0x78
pc: 0x7f0ed8f1a5e5 UIQDML_OpenCursor+0x25
pc: 0x7f0eda1ae346 st_SAIQInterfaceInfo::callFunction()+0x26
pc: 0x7f0eda219c2e st_SAIQInterface::RunIQFunc(st_SAIQInterfaceInfo*)+0x1ac
pc: 0x7f0eda1aecba st_SAIQInterface::Execute(int, void*, unsigned int (*)+0x20a
pc: 0x7f0ed9699c11 saint_iqthresholddml::OpenCursor(a_statement*, IConnection*,
ICursor*, a_cursor_spec*, a_cursor_orientation)+0x91
pc: 0x7f0f0221f7db df_OmniRowScan::Restart(a_cursor_orientation)+0x2cb
pc: 0x7f0f021fa241 dfo_Scan::DoFetch(a_cursor_orientation)+0xd1
pc: 0x7f0f021f8ac2 dfo_Scan::DoFirstFetch(a_cursor_orientation)+0xd2
pc: 0x7f0f021da337 dfo_Base::Fetch(a_cursor_orientation)+0x107
pc: 0x7f0f021e0d36 dfo_Root::DoFetch(a_cursor_orientation)+0x96
pc: 0x7f0f021dce32 dfo_Root::DoFirstFetch(a_cursor_orientation)+0x42
pc: 0x7f0f021da337 dfo_Base::Fetch(a_cursor_orientation)+0x107
pc: 0x7f0f021dc992 dfo_Root::DoFetchRelative(int, int*)+0xc2



  • SAP Sybase IQ 12.x and later
  • SAP IQ 15.x and later
  • SAP IQ 16.0


SAP IQ 16.0 ; SAP Sybase IQ 15.2 ; SAP Sybase IQ 15.4 ; Sybase IQ 12.7



About this page

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

Search for additional results

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