SAP Knowledge Base Article - Preview

2813061 - "Stack at point where server ran out of unprivileged space" error - SAP IQ

Symptom

Select into a permanent or a temp table when FP_NBIT_AUTOSIZE_LIMIT is smaller than the number of distinct values in the table will cause the select into to fail with

  • "Stack at point where server ran out of unprivileged space..." or
  • "s_blockmap::ThrowError for user locked blockmap"

First a diagnostic stacktrace gets dumped in the .iqmsg then you will see a non-fatal stacktrace with the following stack:

s_blockmap::ThrowIfOutOfSpace
s_blockmap::Create
hs_btCacheItem::FCreate
hs_btcursor::FInsert
hs_btcursor::Insert
s_RidMapCursor::RemoveNBitPagesForRollover
s_mergeFINALWriter::PrepareForRollover
hs_dpInsert::Rollover
df_FPRolloverIterator::ExecWork
...
db_InsertRoot::Execute
st_command::DoCmdThroughResourceGate
st_iqdml::Insert
UIQDML_Insert


Read more...

Environment

  • SAP IQ 16.1 
  • SAP IQ 16.0 SP11 PL23

Product

SAP IQ 16.0 ; SAP IQ 16.1

Keywords

sybase ; dbcc ; corruption ; "out of space "; ThrowIfOutOfSpace ; "s_blockmap::Create" ; s_RidMapCursor::RemoveNBitPagesForRollover ; "user locked blockmap" ; sp_iqrebuildindex ; FP_NBIT_AUTOSIZE_LIMIT ; 2147483647 ; , 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 ONE Support launchpad (Login required).

Search for additional results

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