[IQUG] [iqug] IQ 16.0 post upgrade error

Louie, David David.Louie at blackrock.com
Tue Aug 1 12:56:58 MST 2017

Thanks for the input Toni.

Shashi from SAP says this is a known CR in 16.0 which IQ engineering is working on.

I’ve open an incident and will report this to them.


From: Toni Berry [mailto:Toni.Berry at tpgtelecom.com.au]
Sent: Friday, July 28, 2017 8:43 PM
To: Louie, David <David.Louie at blackrock.com>; 'iqug at dssolutions.com' <iqug at dssolutions.com>
Subject: Re: [IQUG] [iqug] IQ 16.0 post upgrade error

Hi David,

We encountered -1006000 when we upgraded from IQ 15 to 16.0 SP11.06, though not for doing an sp_iqrebuildindex conversion from FP to NBit. We ran into it where the NBit stats were incorrect or sometimes the error cropped up in a NOT EXISTS clause.

The nasty issue we ran into after the upgrade was the: SQL Anywhere ERROR -1001012: Internal state violation, please contact SAP IQ support
This we had to recreate the tables affected which affected 3% of our tables. While there were tables in this state we were unable to do a DBCC on the database until all tables were recreated and the errored tables were force dropped as the DBCC would crash IQ.

Regards, Toni.

From: <iqug-bounces at iqug.org<mailto:iqug-bounces at iqug.org>> on behalf of David Louie <David.Louie at blackrock.com<mailto:David.Louie at blackrock.com>>
Date: Saturday, 29 July 2017 at 2:53 am
To: IQ Group <iqug at dssolutions.com<mailto:iqug at dssolutions.com>>
Subject: [IQUG] [iqug] IQ 16.0 post upgrade error

So I’m rebuilding indices post 15.4 to 16.0 upgrade and some of the index rebuilds are encountering this error:

DEVEWD_IQ.dlouie.master.0.1> sp_iqrebuildindex 'dbo.agency_strats', 'index ASIQ_IDX_T934_C28_FP'
Msg 21, Level 23, State 0
SQL Anywhere Error -1006000: IQ Internal error. Please report this to SAP IQ support.
-- (/remote/rip/iqbuild/views/links/r16.0.0_sp11_git_linux_64/gitsrc/cm/iqa/include/s_bm.h 970)
(1 row affected)

I’ve followed the instructions and reported it to AAP however just wondering if anyone has encountered this?


This message may contain information that is confidential or privileged. If you are not the intended recipient, please advise the sender immediately and delete this message. See http://www.blackrock.com/corporate/en-us/compliance/email-disclaimers for further information.  Please refer to http://www.blackrock.com/corporate/en-us/compliance/privacy-policy for more information about BlackRock’s Privacy Policy.
For a list of BlackRock's office addresses worldwide, see http://www.blackrock.com/corporate/en-us/about-us/contacts-locations.

© 2017 BlackRock, Inc. All rights reserved.
Confidentiality: This email and any attachments are confidential and may be subject to copyright, legal or some other professional privilege. They are intended solely for the attention and use of the named addressee(s). They may only be copied, distributed or disclosed with the consent of the copyright owner. If you have received this email by mistake or by breach of the confidentiality clause, please notify the sender immediately by return email and delete or destroy all copies of the email. Any confidentiality, privilege or copyright is not waived or lost because this email has been sent to you by mistake.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://iqug.org/pipermail/iqug/attachments/20170801/5fc92233/attachment-0001.html>
-------------- next part --------------
An embedded message was scrubbed...
From: "Bhandari, Shashikant" <shashikant.bhandari at sap.com>
Subject: Re: [IQUG] [iqug] IQ 16.0 post upgrade error
Date: Fri, 28 Jul 2017 21:38:08 +0000
Size: 50481
URL: <http://iqug.org/pipermail/iqug/attachments/20170801/5fc92233/attachment-0001.mht>

More information about the IQUG mailing list