SAP Knowledge Base Article - Preview

2813061 - Select into a permanent or a temp table hit Error "Stack at point where server ran out of unprivileged space" - 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 for Me (Login required).

Search for additional results

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