IQ 16.0 SP08 engine crash (ntdll.dll cause) during LOAD TABLE statement

[stefano_bolli]

Hi all,
    from 10 days I have a very strange issue related to load data in IQ using LOAD TABLE command.

Executing a "LOAD TABLE" statement the IQ engine crashed down reporting the hereafter detailed erorrs and no data is imported in IQ tables.

The machine is a virtual machine over HyperV infrastructure with Windows 2012 R2 installed.
The IQ version is:

select @@version
-- SAP IQ/16.0.0.807/140507/P/sp08/MS/Windows 2003/64bit/2014-05-07 20:54:43

The strange thing is that:
-> until 2 weeks this kind of queries (they are scheduled) works correctly without any issue
-> no updates were executed in the operating system or virtual infrastructure
-> no upgrade was done to the IQ engine

In iqlog and iqmsg files no more infos and no stacktraces are reported.

******** ERROR QUERY ********

LOAD TABLE TEST_LOAD (
FIELD_01,
FIELD_02
)
FROM 'W:\IMPORT_EXPORT\IN\TEST_LOAD.bcp'
DELIMITED BY '|' ESCAPES OFF QUOTES OFF PREVIEW ON STRIP OFF FORMAT ASCII WITH CHECKPOINT ON

******** ERROR IN InteractiveSQL Client ********
Error! The connection to the database was closed by the server.
Communication error
SQLCODE=-85, ODBC 3 State="08S01"
Line 1, column 1

LOAD TABLE TEST_LOAD (FIELD_01, FIELD_02)
FROM 'W:\IMPORT_EXPORT\IN\TEST_LOAD.bcp'
DELIMITED BY '|' ESCAPES OFF QUOTES OFF PREVIEW ON STRIP OFF FORMAT ASCII WITH CHECKPOINT ON

*** EVENT VIEWER DETAILS **
In Windows Logs --> Application I found:

Faulting application name: iqsrv16.exe, version: 16.0.0.807, time stamp: 0x5369b2d6
Faulting module name: ntdll.dll, version: 6.3.9600.17031, time stamp: 0x530895af
Exception code: 0xc0000374
Fault offset: 0x00000000000f8c9c
Faulting process id: 0x814
Faulting application start time: 0x01d08bbb948ccd1d
Faulting application path: C:\SAPSybaseIQ\IQ-16_0\bin64\iqsrv16.exe
Faulting module path: C:\Windows\SYSTEM32\ntdll.dll
Report Id: 95fd8700-f7b3-11e4-80e5-00155d09051e
Faulting package full name:
Faulting package-relative application ID:

Do yuo have any suggestions about this strange error?

Best regards,
Stefano

[saroj_bagai]

Can you please post .iqmsg /stktrace? Your IQ server is on sp08GA, since then lot of N-bit issues have been fixed,  please upgrade your IQ server to IQ 16 sp08.30 and run sp_iqcheckdb  'verify database' and then rebuild all N-bit indexes

Thanks

Saroj

[stefano_bolli]

Hi Saroj,

        the iqmsg was empty withou any strage strings and errors.

Anyway, I updated both Win 2012 R2 using Win update (I installed only all mandatory updates, not the optional ones) and IQ engine to IQ 16.0SP08 PL30, and the 1st test passed not showing "ntdll" error.

To rebuild N-bit indexes I used:

sp_iqrebuildindex(' table name ’, ' index index name ’)

Is it what do you mean?

I keep you update tomorrow when I am running a more complete test sets.

Regards,
Stefano

[stefano_bolli]

Hi Saroj,

       I am running sp_iqcheckdb 'verify database' as you suggested.

In my DEV engine it started 24 hours ago, and now it is already running....

How can I check its progress in order to have an estimation fo the remaing time?

Thank you and regards,

Stefano

[saroj_bagai]

if  you have set option dbcc_log_progress='on'  database option, then  dbcc messages are logged in the .iqmsg

Yes. your syntax for sp_iqrebuildindex is correct.

[saroj_bagai]

What is your database size? if you have -zr logging enabled , you can check -zr log or .iqmsg if dbcc_log_progress='on'  option was set, without that it is hard to determine the  time

Thanks

Saroj