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
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 for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.