query generates stacktrace

[kimon_moschandreou]

a specific query generates the attached stacktrace and returns to the user the query below, I don't know how to troubleshoot it. IQ 15.4 ESD#3 on W2008R2SP1

-iqmc 40000

-iqtc 50000

main Bufman: Blockmap info error;
bmp={bl=1,uid=48804,txn=39129064,sp=1,nentr=4134,rb=368500166,nlnk=2,flags=0xd,vsn=1,fan=8,flags2=0x0,nper=14348,fa=0,max=2}.
-- (s_blockmap.cxx 2989)
SQLCODE=-1009047, ODBC 3 State="HY000"

During the weekend many indexes were changed to FP3 (from flat FP)

Thank you in advance

mis_error.txt.zip

[former_member333181 · Accepted solution]

You need to open a support case for this issue. Untile you open a support case, you can try to force column to avoide FP(3) index and use flat FP. Simple way to do that is to increase Unique value for the column to be more than 16 million.

Regards

Shashi

[kimon_moschandreou · Accepted solution]

thank you for the advice, I was just considering something like this

[former_member333181 · Accepted solution]

Hi,

  You can try following ,

set option public.core_Options13=33554432;

Regards

Shashi

[kimon_moschandreou · Accepted solution]

Just amazing!! It worked perfectly, is there anywhere any document for these CORE_OPTIONS?

[saroj_bagai · Accepted solution]

NO there are no docs,  this stack trace was due to CR 691261 fixed in IQ 16.

w/a  is to disable enhanced column scan  introduced in 15.3 with core_options13=33554432