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 ONE Support launchpad (Login required).

Search for additional results

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