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
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.