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