SAP Knowledge Base Article - Preview

2300442 - NTILE on SA_ROWGENERATOR causes IQ abort in dfv_Row::CopyFromMemRow - SAP IQ 16

Symptom

  • SQL below with NTILE on SA_ROWGENERATOR causes IQ abort in dfv_Row::CopyFromMemRow.

select ROW_NUM,
NTILE(200) over(order by ROW_NUM asc)
from SA_ROWGENERATOR (1,500) 

  • IQMSG Excerpt


**************************************************
**      SAP IQ Abort:
**      From:  stcxtlib/st_server.cxx:1919
**      PID: 24472
**      Message: caught signal 11, program abort
**      Thread: 1122249024  (TID: 3)
**************************************************


**  Parser command text: 
select "ROW_NUM",
"NTILE"(200) over(order by "ROW_NUM" asc)
from "SA_ROWGENERATOR"(1,500)

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

===== Thread Number  1122249024  (IQ connID: 0000000010) =====

pcstkwalk(stk_trace*, int, db_log*, hos_fd*)+0x32
ucstkgentrace(int, int)+0x121
DumpAllThreads(char const*, unsigned int, int)+0x12e
hos_ABORT(char const*, unsigned int, char const*, char*, char*)+0x19e
SigHndlr+0x4f
 
dfv_Row::CopyFromMemRow(df_MemRow*, df_MemRowCarver*, IDBHeap*, bool)+0x63
df_WindowIterator::Get()+0x5f
dfo_Window::DoFetch(a_cursor_orientation)+0x39
dfo_Base::Fetch(a_cursor_orientation)+0x6c
dfo_MaterializePack::PopulateFully(a_cursor_orientation)+0x5e
dfo_Materialize::DoFirstFetch(a_cursor_orientation)+0x22
dfo_Base::Fetch(a_cursor_orientation)+0x102
dfo_Root::DoFetch(a_cursor_orientation)+0x4b
dfo_Root::DoFirstFetch(a_cursor_orientation)+0x2f
dfo_Base::Fetch(a_cursor_orientation)+0x102
dfo_Root::DoFetchRelative(int, int*)+0xc2
dfo_Root::FetchRelative(int, int*)+0xf7
DB_Search_fetch(a_db_cursor*, unsigned int, int, int*)+0x7d
do_move_cursor(a_db_cursor*, int, unsigned int, unsigned int, unsigned int)+0x92
dbi_fetch(a_db_cursor*, int, unsigned short, unsigned int, unsigned int, unsigned int, unsigned int, unsigned int, unsigned int)+0x2b5
db__fetch(Connection*, an_sqlpres_receive*)+0x1c4
RequestProcedure::call()+0xcd4
Context::call(Procedure*, Context**)+0x4e
Worker::call_on_stack(Procedure*)+0x56
TopProcedure::call()+0x3d
Worker::spawn(Procedure*)+0x49
EngStream::handle_ind(unsigned char, unsigned int)+0x13c
EngStream::execute()+0xd65
RQBaseItem::do_work(Worker*)+0x25
RequestQueue::worker_body()+0x66
request_task(void*)+0x65
run_task_body+0x2d
UnixTask::pre_body(void*)+0x77


Read more...

Environment

SAP IQ 16 any SP

Product

SAP IQ 16.0

Keywords

CR797389 ; 797389 ; NTILE ; SA_ROWGENERATOR ; dfv_Row::CopyFromMemRow ; dfv_Row ; CopyFromMemRow ; df_WindowIterator::Get ; df_WindowIterator ; dfo_Window::DoFetch : dfo_Window ; DoFetch ; dfo_Base::Fetch ; dfo_Base ; dfo_MaterializePack::PopulateFully ; dfo_MaterializePack ; PopulateFully ; dfo_Materialize::DoFirstFetch ; dfo_Materialize ; DoFirstFetch ; , KBA , BC-SYB-IQ , Sybase IQ , Problem

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.