SAP Knowledge Base Article - Preview

2591078 - Non-Fatal IQ Internal Error Detected at slib/s_ohcidx.cxx:955 GetIdentity FlushIndexIdentity SAP IQ

Symptom

Looking at the stored procedure, the following is seen:

DB.#temp.x1 - does have

CREATE HG INDEX x1 on #temp (colm1)

There are times when this shows the following error:

The follow shows up in the message file and errorlog:

I.  Insert for '#temp' completed in 49 seconds.  2875581 rows inserted.
I. Delete of 10156705 rows started for table:
I. Update Started:
I.  #temp
I. Update Pass 1 completed in 0 seconds.
I. Update Pass 2 completed in 0 seconds.
I. Update for '#temp' completed in 0 seconds.  0 rows updated.
I. Update Started:
I. #temp
I. Update Pass 1 completed in 0 seconds.
I. Update Pass 2 completed in 0 seconds.


Update for '#temp' completed in 0 seconds. 0 rows updated.
Insert for '#temp' completed in 0 seconds. 0 rows inserted.
Ebm Count: 0 Dbm Count: 1181464
_isPhysicallyEmpty : 0 _isEmpty0 IsConstraintViolation: 0 Unique(): 0
_OID._recCount: 0 _OID._inUse: GetNumEntries():583650 _pConjugateBT->GetNumEntries(): 0

********************************************************
**
** Non-Fatal IQ Internal Error Detected
** at slib/s_ohcidx.cxx:955 on thread 864 (TID 48)
**
** Please report this to SAP IQ support
** with the following diagnostic information,
** and, if possible, with the user's command.
**
** Error from IQ connection: SA connHandle: XXX SA connID: XXX IQ connID: XXXXX User: myuser
** Time of error: 20XX-01-17 11:28:50
** IQ Version: SAP IQ/16.0.110/10364/P/sp11.06
** OS info: IQ built on: Sun_Sparc/OS 5.10, Executed on: SunOS/XXXXXX/5.10/Generic_150400-30/sun4v
** Command status when error occured: CURSOR ACTIVE
** Command text:

In the message file:

O/S Err#: 0, ErrID: 2068 (hs_idxexception); SQLCode: -1006003, SQLState: 'QBA03', Severity: 23
Exception Thrown from slib/s_ohcidx.cxx:955, Err#16, tid 48 origtid 48
O/S Err#: 0, ErrID: 9216 (df_Exception); SQLCode: -1006003, SQLState: 'QBA03', Severity: 23
IQ Internal error. Please report this to SAP IQ support. DB.#temp_.x1 5 ???
Exception Thrown from dblib/db_index.cxx:837, Err#7, tid 48 origtid 48
O/S Err#: 0, ErrID: 1025 (db_catalogException); SQLCode: -1006000, SQLState: 'QBA00', Severity: 23
IQ Internal error. Please report this to SAP IQ support.
Double Throw Exception Thrown from dblib/db_index.cxx:837, Err#7, tid 48 origtid 48

 **************************************************
 *** SAP IQ Abort:
 *** From: slib/s_ohcidx.cxx:955
 *** Rethrown from: oslib/hos_throw.cxx:278
 *** PID: 7683
 *** Exception Location: 0x1005c44b8
 *** Error ID: 9216, Exception Type: df_Exception
 *** Thread: 864 (TID: 48, Original TID: 48)
 *** Error #: 16, O/S Error #: 0
 *** Argument:
 *** Argument: DB.#temp.x1
 *** Argument: 5

Stack includes:

hs_ThrowIdxException
hs_subohcIdentity
hs_ohcidentity
GetIdentity
FlushIndexIdentity
db_IndexDef::CloseSIndex
df_Table::CloseIdxAndInserters
dfo_Scheduler::CompleteOpus
dfo::Complete
dfo_Root::Complete
db_dmlcommand::ExecuteDFOTree
db_InsertRoot::Execute
st_command::DoCmdThroughResourceGate()


Read more...

Environment

SAP IQ 16.0 SP11 PL06

Product

SAP IQ 16.0

Keywords

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.