SAP Knowledge Base Article - Preview

2803530 - Internal state violation for a HASH + SUBRANGE partitioned table - SAP IQ

Symptom

Internal state violation when querying and changing data on a HASH + SUBRANGE partitioned table on a SAP IQ SP11 PL13 database, on a multiplex environment.

In the iqmsgs there is a stack trace with following functions:

======

********************************************************
**
** Non-Fatal IQ Internal Error Detected
** at slib/s_blockmap.cxx:14066 on thread XXX (TID YYY)
** Unknown buffer manager internal error
**
....
....

O/S Err#: 0, ErrID: 2091 (s_internalexception); SQLCode: -1001012, SQLState: 'QFA12', Severity: 18
20521]: Internal state violation, please contact SAP IQ support -- (slib/s_blockmap.cxx 14066)
Exception Thrown from slib/s_blockmap.cxx:14066, Err# 0, tid XXX origtid VVV

_Z23StackTraceForThisThreadPKciS0_S0_S0_
_ZN10s_blockmap10ThrowErrorE18s_bufman_errorInfoPKci
_ZN18s_ROBlockmapCursor4FindEysiP19s_bufmanCallerStats
_ZN14s_bArrayCursor4FindEyjj
_ZN15s_bArrayLocater9LoadBlockERy
_ZN15s_bArrayLocater8LoadPageEy
_ZN15s_bArrayLocater17LocateTokenRecordEy
_ZN10hs_dpfetch21FetchNoCopyContiguousEyP9hos_datum
_ZN10s_fetchRow15FetchContiguousEv
_ZN10s_fetchRow5FetchEv
_ZN9vp_Cursor5FetchEv
_ZN22dfo_VerticalLeafCursor
_ZN3dfo5FetchEv
_ZN15dfjo_HashParaT19FetchOpusEv
_ZN8dfo_Join9FetchOpusEv
_ZN10dfo_Filter9FetchOpusEv
_Z21CombinerFetchCallbackPv
_ZN8hc_dfrun7FillRunERjii
_ZN9hc_dmfrun16InitNextWorkUnitEjij
_ZN9hc_dmfrun8ExecWorkERij
_ZN13workAllocator6DoWorkEj
_ZN13workAllocator7sDoWorkEPS_j
_ZN10hos_thread4MainEv
_ZN10hos_lwtask5StartEPS_
_Z15IQWorkerStarterPv

=======

The stack trace has function names beginning with "_ZN". This occurs on HPIA only. The translation of the functions (valid for all platforms):

======

StackTraceForThisThread
s_blockmap::ThrowError
s_ROBlockmapCursor::Find
s_bArrayCursor::Find
s_bArrayLocater::LoadBlock
s_bArrayLocater::LoadPage
s_bArrayLocater::LocateTokenRecord
hs_dpfetch::FetchNoCopyContiguous
s_fetchRow::FetchContiguous
s_fetchRow::Fetch
vp_Cursor::Fetch
dfo_VerticalLeafCursor::FetchOpus
dfo::Fetch
dfjo_HashParaT1::FetchOpus
dfo_Join::FetchOpus
dfo_Filter::FetchOpus
CombinerFetchCallback
hc_dfrun::FillRun
hc_dmfrun::InitNextWorkUnit
hc_dmfrun::ExecWork
workAllocator::DoWork
workAllocator::sDoWork
hos_thread::Main
hos_lwtask::Start
IQWorkerStarter

=======


Read more...

Environment

  • SAP IQ 16.0 SP11 PL13 

Product

SAP IQ 16.0

Keywords

Internal state violation HASH SUBRANGE partitioned table s_ROBlockmapCursor::Find s_bArrayCursor::Find s_bArrayLocater::LoadBlock s_bArrayLocater::LoadPage s_bArrayLocater::LocateTokenRecord hs_dpfetch::FetchNoCopyContiguous s_fetchRow::FetchContiguous SQLCode -1001012 QFA12 819477 , 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.