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 ONE Support launchpad (Login required).

Search for additional results

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