[IQUG] [iqug] Insert failed with error code SQLCode: -1006003, SQLState: 'QBA03' on HG index

Ray Naugle rnaugle at dssolutions.com
Wed Jan 17 08:47:11 MST 2018


Hm… Space issue?  My example of dropping, creating, then doing a rebuild of an index consistently crashes on a quiet DB (no other activity going on) and our DBs are at 80%.  How is it that I can drop/create the index, but immediately following not successfully rebuild that index?  It produces this exact error.  Is 80% not enough free space (3TB IQ_USER_MAIN)?  Sorry, but I just don’t understand.  I have had this issue for months and no resolution.

 

drop index DJO.mps_claims.pharmacy_npi_hg;

create hg index pharmacy_npi_hg on DJO.mps_claims(pharmacy_npi);

call sp_iqrebuildindex('DJO.mps_claims', 'index pharmacy_npi_hg');

 

 

 

I. 01/17 07:24:15. 0002488885     ******************* End of STACKTRACE ******************

I. 01/17 07:24:15. 0002488885     **

I. 01/17 07:24:15. 0002488885     **       End of stack trace from Non-Fatal IQ Internal Error slib/s_ohcidx.cxx:9331

I. 01/17 07:24:15. 0002488885     **

I. 01/17 07:24:15. 0002488885     ********************************************************

I. 01/17 07:24:15. 0002488885

I. 01/17 07:24:15. 0002488885 Exception Thrown from slib/s_ohcidx.cxx:9331, Err# 16, tid 641 origtid 641

I. 01/17 07:24:15. 0002488885    O/S Err#: 0, ErrID: 2068 (hs_idxexception); SQLCode: -1006003, SQLState: 'QBA03', Severity: 23

I. 01/17 07:24:15. 0002488885 [20241]: IQ Internal error. Please report this to  SAP IQ support. DJO.mps_claims.pharmacy_npi_hg 15 ???

I. 01/17 07:24:15. 0002488885 Exception Thrown from slib/s_ohcidx.cxx:9331, Err# 16, tid 8 origtid 641

I. 01/17 07:24:15. 0002488885    O/S Err#: 0, ErrID: 2068 (hs_idxexception); SQLCode: -1006003, SQLState: 'QBA03', Severity: 23

I. 01/17 07:24:15. 0002488885 [20241]: IQ Internal error. Please report this to  SAP IQ support. DJO.mps_claims.pharmacy_npi_hg 15 ???

I. 01/17 07:24:15. 0002488885 Exception Thrown from slib/s_ohcidx.cxx:9331, Err# 16, tid 8 origtid 641

I. 01/17 07:24:15. 0002488885    O/S Err#: 0, ErrID: 2068 (hs_idxexception); SQLCode: -1006003, SQLState: 'QBA03', Severity: 23

I. 01/17 07:24:15. 0002488885 [20241]: IQ Internal error. Please report this to  SAP IQ support. DJO.mps_claims.pharmacy_npi_hg 15 ???

I. 01/17 07:24:15. 0002488885 Cmt 331741506

I. 01/17 07:24:15. 0002488885 PostCmt 0

 

 

From: iqug-bounces at iqug.org [mailto:iqug-bounces at iqug.org] On Behalf Of Baker, Chris
Sent: Wednesday, January 17, 2018 8:29 AM
To: Tran, Honglan
Cc: iqug at dssolutions.com
Subject: Re: [IQUG] [iqug] Insert failed with error code SQLCode: -1006003, SQLState: 'QBA03' on HG index

 

Absolutely.

 

Chris Baker | Database Engineering Evangelist | CERT | PI HANA Platform Data Management | SAP

T  <tel:+1%20416-226-7033> +1 416-226-7033 | M  <tel:+1%20647-224-2033> +1 647-224-2033 | TF  <tel:+1%20866-716-8860> +1 866-716-8860

SAP Canada Inc.  <x-apple-data-detectors://17/1> 445 Wes Graham Way, Waterloo, N2L 6R2

 <mailto:c.baker at sap.com> c.baker at sap.com |  <http://www.sap.com/> www.sap.com

 

 <https://sap.na.pgiconnect.com/I826572> https://sap.na.pgiconnect.com/I826572

Conference tel:  <tel:1-866-312-7353,,9648565377%23> 1-866-312-7353,,9648565377#

 

From: Tran, Honglan [mailto:honglan.tran at optum.com] 
Sent: Wednesday, January 17, 2018 9:59 AM
To: Baker, Chris <c.baker at sap.com>
Cc: Mumy, Mark <mark.mumy at sap.com>; Louie, David <David.Louie at blackrock.com>; iqug at dssolutions.com
Subject: RE: [IQUG] [iqug] Insert failed with error code SQLCode: -1006003, SQLState: 'QBA03' on HG index

 

            Chris,

            Space could be the cause of this issue?  I am at 95%  

Main IQ Blocks Used:      561511013 of 586849200, 95%=4283Gb

 

Lan  Tran 
Database Administrator 
OPTUM / Pharmacy Analytic Strategy 
400 Capital Boulevard, Rocky Hill, CT 06067 
Office: 860-221-0330     Cell: 860-268-8395 
 <mailto:HONGLAN.TRAN at OPTUM.COM> HONGLAN.TRAN at OPTUM.COM

 

From: Baker, Chris [mailto:c.baker at sap.com] 
Sent: Wednesday, January 17, 2018 9:53 AM
To: Tran, Honglan
Cc: Mumy, Mark; Louie, David; iqug at dssolutions.com
Subject: Re: [IQUG] [iqug] Insert failed with error code SQLCode: -1006003, SQLState: 'QBA03' on HG index

 

Check your space available and versions. 

 

Chris

 

Chris Baker | Database Engineering Evangelist | CERT | PI HANA Platform Data Management | SAP

T +1 416-226-7033 <tel:+1%20416-226-7033>  | M +1 647-224-2033 <tel:+1%20647-224-2033>  | TF +1 866-716-8860 <tel:+1%20866-716-8860> 

SAP Canada Inc. 445 Wes Graham Way, Waterloo, N2L 6R2 <x-apple-data-detectors://17/1> 

c.baker at sap.com | www.sap.com <http://www.sap.com/> 

 

https://sap.na.pgiconnect.com/I826572

Conference tel: 1-866-312-7353,,9648565377# <tel:1-866-312-7353,,9648565377%23> 


On Jan 17, 2018, at 8:59 AM, Tran, Honglan <honglan.tran at optum.com> wrote:

            Hello,

            We are on SAP IQ/16.0.110.2337/10364/P/sp11.06/RS6000MP/AIX 6.1.0/64bit/2017-01-25 13:42:04   

            We have a select insert monthly  job that run successfully for years.  Yesterday, it failed after 147000000 Rows.   I modified the job to insert a shorter range of data. Second time it failed at 7500000 rows.

            Has anyone ran into this issue?   Is this some limitation on HG index?  If so, would dropping the index help? 

 

 

I. 01/16 18:15:03. 0000193130 Exception Thrown from slib/s_ohcidx.cxx:13626, Err# 16, tid 23 origtid 387

I. 01/16 18:15:03. 0000193130    O/S Err#: 0, ErrID: 2068 (hs_idxexception); SQLCode: -1006003, SQLState: 'QBA03', Severity: 23

I. 01/16 18:15:03. 0000193130 [20241]: IQ Internal error. Please report this to  SAP IQ support. PCRS.pcrs_claimfact_even.clm_carrierid_hg 14 ??? 

I. 01/16 18:15:07. 0000193130 Exception Thrown from slib/s_ohcidx.cxx:13626, Err# 16, tid 23 origtid 387

I. 01/16 18:15:07. 0000193130    O/S Err#: 0, ErrID: 2068 (hs_idxexception); SQLCode: -1006003, SQLState: 'QBA03', Severity: 23

I. 01/16 18:15:07. 0000193130 [20241]: IQ Internal error. Please report this to  SAP IQ support. PCRS.pcrs_claimfact_even.clm_carrierid_hg 14 ??? 

 

 

Lan  Tran 
Database Administrator 
OPTUM / Pharmacy Analytic Strategy 
400 Capital Boulevard, Rocky Hill, CT 06067 
Office: 860-221-0330     Cell: 860-268-8395 
 <mailto:HONGLAN.TRAN at OPTUM.COM> HONGLAN.TRAN at OPTUM.COM


This e-mail, including attachments, may include confidential and/or
proprietary information, and may be used only by the person or entity
to which it is addressed. If the reader of this e-mail is not the intended
recipient or his or her authorized agent, the reader is hereby notified
that any dissemination, distribution or copying of this e-mail is
prohibited. If you have received this e-mail in error, please notify the
sender by replying to this message and delete this e-mail immediately.

_______________________________________________
IQUG mailing list
IQUG at iqug.org
http://iqug.org/mailman/listinfo/iqug


This e-mail, including attachments, may include confidential and/or
proprietary information, and may be used only by the person or entity
to which it is addressed. If the reader of this e-mail is not the intended
recipient or his or her authorized agent, the reader is hereby notified
that any dissemination, distribution or copying of this e-mail is
prohibited. If you have received this e-mail in error, please notify the
sender by replying to this message and delete this e-mail immediately.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://iqug.org/pipermail/iqug/attachments/20180117/b023c1c7/attachment-0001.html>


More information about the IQUG mailing list