SAP IQ Procedure getting Fatal Error during DQP Execution. reporting SQLSTATE=QBA00 SQLCODE=-1006000

[Former Member]

Hi Experts ,

Execution of Procedure in DQP Mode in Failing in Multiplex consisting of 2 Nodes from Either one of them.

Error 1006000

%1"

Constant EMSG_PROGERROR

SAP Sybase Error Number 20238

SQL State QBA00

SQL Code -1006000L

ODBC 2 State ERROR

ODBC 3 State ERROR

Severity Code 23 on page 2

Parameter 1 location of the exception

Severity Code 23 – Hardware Error or system corruption

Procedure Failing at below points Updates points like below. .

update table1 set b.srno = a.srno from table2 a,table1 b where a.id = b.id;

update table1 set b.TYPE = s.TYPE from table2 a,table1 b, master s where s.id=1 and s.CD = a.CD and a.col2=b.col2 and b.TYPE = 's' and b.key > (select key from temp where max_key = 'y' and = 's');

Multiplex Configuration.

1. 2 Node Multiplex

2. Startup parameter for both nodes

-iqmc 15360 -iqtc 15360 -iqlm 15360 -c 500m -gc 20 -gd dba -gl all -gm 100 -gn 115 -gp 8192 -ti 4400 -tl 600.

3. Other Parameters -MPX_WORK_UNIT_TIMEOUT=600 (Changed as the dataset is large)

4. DQP IS ENABLED,Private Connections High bandwidth Fiber channel.

Post Failure checked the integrity of all the Indexes of the Object table1,table2 . No Failures reported from sp_iqcheckdb.

sp_iqcheckdb verify table OK. sp_iqmpxinfo Status OK. Heartbeat OK. ping OK.

5. sp_iqmpxvalidate reported no errors.

IQMESSAGE_LOG

I. 02/10 17:28:25. 0000000000 I. 02/10 17:28:25. 0000000000 ******************************************************** I. 02/10 17:28:25. 0000000000 ** I. 02/10 17:28:25. 0000000000 ** Non-Fatal IQ Internal Error Detected I. 02/10 17:28:25. 0000000000 ** at dflib/dfe_BaseColumn.cxx:1723 on thread 331 (TID 322) I. 02/10 17:28:25. 0000000000 ** I. 02/10 17:28:25. 0000000000 ** Please report this to Sybase IQ support I. 02/10 17:28:25. 0000000000 ** with the following diagnostic information, I. 02/10 17:28:25. 0000000000 ** and, if possible, with the user's command. I. 02/10 17:28:25. 0000000000 ** I. 02/10 17:28:25. 0000000000 ** Error from IQ connection: I. 02/10 17:28:25. 0000000000 ** Time of error: 2017-02-10 17:28:25 I. 02/10 17:28:25. 0000000000 ** IQ Version: Sybase IQ/16.0.0/130503/P/sp01 I. 02/10 17:28:25. 0000000000 ** OS info: IQ built on: Sun_Sparc/OS 5.10, Executed on: SunOS/dbsvr01/5.10/Generic_147147-26/sun4v I. 02/10 17:28:25. 0000000000 ** Command status when error occured: NO COMMAND OR CURSOR ACTIVE I. 02/10 17:28:25. 0000000000 I. 02/10 17:28:25. 0000000000 I. 02/10 17:28:25. 0000000000 pc: 0x0 (0xffffffff25280b00, 0x0, 0x0, 0xfffffffffffffff8, 0x0) I. 02/10 17:28:25. 0000000000 pc: 0xffffffff3f9e0378 void StackTraceForThisThread(const char*,int,const char*,const char*,const char*)+0x668(0xffffffff4181b217, 0xffffffff4181b5b7, 0x4, 0x5, 0x0) I. 02/10 17:28:25. 0000000000 pc: 0xffffffff3efd2338 df_Exception::df_Exception #Nvariant 1(const char*,int,df_Exception::df_ErrorCode,const char*,const char*,const dfo*,const df_Evaluable*)+0x2e24(0xffffffff25281db0, 0xffffffff416818f0, 0x6bb, 0x0, 0x0) I. 02/10 17:28:25. 0000000000 pc: 0xffffffff3efd400c void df_Exception::ThrowException_0(const char*,int,df_Exception::df_ErrorCode)+0x7c(0xffffffff416818f0, 0x6bb, 0x0, 0x0, 0x1) I. 02/10 17:28:25. 0000000000 pc: 0xffffffff3f050b14 const char*dfe_BaseColumn::GetFieldName()const+0x164(0x88d85faf8, 0x17, 0x2c3137c, 0x600400, 0xffffffff416818a7) I. 02/10 17:28:25. 0000000000 pc: 0xffffffff3f05146c RWCString&dfe_BaseColumn::Display(RWCString&)+0x1ac(0xffffffff25282390, 0xffffffff25282390, 0x88d85faf8, 0x8916e54e8, 0x890e95788) I. 02/10 17:28:25. 0000000000 pc: 0xffffffff3f072394 RWCString&dfe_Case::ArgVDisplay(RWCString&,const char*,const char*,void*,void(*)(void*,unsigned,RWCString&))+0x52c(0x890e980f8, 0xffffffff25282390, 0xffffffff4168a6f6, 0x8916e10a0, 0x2c0fec4) I. 02/10 17:28:25. 0000000000 pc: 0xffffffff3efc4d50 RWCString&df_Evaluable::ArgVDisplay(RWCString&,const char*,const char*,void*,void(*)(void*,unsigned,RWCString&))+0x150(0x890e96f28, 0xffffffff25282390, 0xffffffff4176bf9f, 0x0, 0x0) I. 02/10 17:28:25. 0000000000 pc: 0xffffffff3f3954e8 RWCString&dfp_Simple::Display(RWCString&)+0x308(0xffffffff25282390, 0xffffffff25282390, 0x890e96f28, 0xffffffff4168a6bf, 0x28ecb40) I. 02/10 17:28:25. 0000000000 pc: 0xffffffff3f072050 RWCString&dfe_Case::ArgVDisplay(RWCString&,const char*,const char*,void*,void(*)(void*,unsigned,RWCString&))+0x1e8(0x890e95e08, 0xffffffff25282390, 0xffffffff41689fc4, 0x890e95fa8, 0x890e95fa8) I. 02/10 17:28:25. 0000000000 pc: 0xffffffff3f0625d0 void dfe_BindVariable::ResetName()+0x150(0x89132c818, 0xffffffff252823b0, 0xffffffff25282390, 0xffffffff41684839, 0x89132cac0) I. 02/10 17:28:25. 0000000000 pc: 0xffffffff4062c174 int st_workerQueryFragment::Prepare(hos_Deserializer&)+0x9cc(0x18, 0xffffffff252828c0, 0x3, 0x890dbeab8, 0x89132c818) I. 02/10 17:28:25. 0000000000 pc: 0xffffffff4065b65c void st_workerQueryFragment::Exec()+0x64(0x890dbeab8, 0x0, 0xffffffff7c64a300, 0x891682d24, 0x0) I. 02/10 17:28:25. 0000000000 pc: 0xffffffff4062a74c void st_workerContextContainer::SetupWorkAllocatorExec(st_workerQueryFragment*)+0x474(0x89149a868, 0x890dbeab8, 0x10064e460, 0x1, 0xffffffff4195390b) I. 02/10 17:28:25. 0000000000 pc: 0xffffffff3f9dc608 int hos_thread::Main()+0x3e0(0x467400, 0x100678248, 0x88af263f8, 0x100678378, 0x29e400) I. 02/10 17:28:25. 0000000000 pc: 0xffffffff3f92a110 int hos_lwtask::Start(hos_lwtask*)+0x238(0x100678248, 0x167400, 0x29e668, 0xffffffff418027f2, 0x162704) I. 02/10 17:28:25. 0000000000 pc: 0xffffffff7d6dd52c void IQWorkerStarter(void*)+0x54(0x1006784c0, 0x172c78, 0x172c00, 0xffffffff7eb42b80, 0x1465698) I. 02/10 17:28:25. 0000000000 pc: 0xffffffff7d9fefd4 void*UnixTask::pre_body(void*)+0x124(0x10000000, 0x2000, 0x1006784c0, 0x1, 0xffffffff7eb42b80) I. 02/10 17:28:25. 0000000000 ******************* End of STACKTRACE ****************** I. 02/10 17:28:25. 0000000000 ** I. 02/10 17:28:25. 0000000000 ** End of stack trace from Non-Fatal IQ Internal Error dflib/dfe_BaseColumn.cxx:1723 I. 02/10 17:28:25. 0000000000 ** I. 02/10 17:28:25. 0000000000 ******************************************************** I. 02/10 17:28:25. 0000000000 I. 02/10 17:28:25. 0000000000 Exception Thrown from dflib/dfe_BaseColumn.cxx:1723, Err# 0, tid 322 origtid 322 I. 02/10 17:28:25. 0000000000 O/S Err#: 0, ErrID: 9216 (df_Exception); SQLCode: -1006000, SQLState: 'QBA00', Severity: 23 I. 02/10 17:28:25. 0000000000 [20238]: IQ Internal error. Please report this to Sybase IQ support. I. 02/10 17:28:25. 0000000000 DQP_CXT worker : st_workerQueryFragment::Run Exception throw Leader ID : 2, Txn ID : 20991063, DQP Context ID : 562949953421351, Work handle ID 2, Fragment ID 0 I. 02/10 17:28:25. 0000001932 Txn 20991400 0 20991400 I. 02/10 17:28:25. 0000001932 Cmt 20991401 I. 02/10 17:28:25. 0000001932 PostCmt 0 I. 02/10 17:28:25. 0000001605 Rbck.

The Procedure is working fine when the DQP is disabled in Simplex Mode.

It seems to be Network Hardware issue which is affecting the dqp worker process.

Need your expert opinions to locate the Error and resolve..