SAP Knowledge Base Article - Preview

2784962 - DELETE statement may have caused a server hang on some NBit FP columns, with error 's_dpidx.cxx:7742' -- SAP IQ

Symptom

A DELETE statement may have caused a server hang on some NBit FP columns. This could also have lead to "Non-Fatal IQ Internal Error Detected" ... "at slib/s_dpidx.cxx:7742". This has been fixed.
But A sp_iqcheckdb VERIFY returned no errors. The load jobs were resubmitted again and ran through fine.

*.iqmsg >>
.. ********************************************************
.. **
.. ** Non-Fatal IQ Internal Error Detected
.. ** at slib/s_dpidx.cxx:7742 on thread 779 (TID 773)
.. ** with Query_Name: Dynamic
.. **
.. ** 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: 47916 SA connID: 4 IQ connID: 0000064653 User: dc
.. ** Time of error: 2019-03-27 19:02:11
.. ** IQ Version: SAP IQ/16.1.020/12305/P/sp02.14
.. ** OS info: IQ built on: Sun_x64/OS 5.11, Executed on: SunOS/ieatrcxb6502/5.11/11.3/i86pc
.. ** Command status when error occured: CURSOR ACTIVE


Stack trace >>

.. void StackTraceForThisThread(const char*,int,const char*,const char*,const char*)+0x47c(ffff80ff86d73b68, 4b831558e8)
.. void hs_dp::CheckIndexConsistency(int)+0x48ed(0, ffff80ffa0ef5def)
.. void hdb_delete_indices::Unit_of_Work(int)+0x2ac(ffff80ffa29968a0, 30500000001)
.. int hdb_delete_indices::hdb_delete_index_iter::ExecWork(int&,unsigned)+0x156(0, 468e8b5650)
.. void workAllocator::DoWork(unsigned)+0x21d(0, ffff80ffa2bf9810)
.. int hos_thread::Main()+0x3a0(0, 0)
.. int hos_lwtask::Start(hos_lwtask*)+0x241(1000, ffff80ff86cfd000)
.. void IQWorkerStarter(void*)+0x49(8, e24850)
.. void*UnixTask::pre_body(void*)+0x1b3(0, 0)
.. _fini+0x19c17009(0, 0)
..
..
.. Exception Thrown from slib/s_dpidx.cxx:7743, Err# 16, tid 773 origtid 773
.. O/S Err#: 0, ErrID: 2068 (hs_idxexception); SQLCode: -1006000, SQLState: 'QBA00', Severity: 23
.. [20238]: IQ Internal error. Please report this to SAP IQ support.
..


Read more...

Environment

SAP IQ16.1 SP02.14

Product

SAP IQ 16.1

Keywords

's_dpidx.cxx' , CheckIndexConsistency , 'hdb_delete_indices' , , 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.