In my Prodaction environtment, when LOAD data from file
~12000000 records, 1-5 times on month IQ stop load and wrote
error message in Windows Application Log:
A device or program has requested attention. Device or
application: C:\Sybase\IQ-15_3\bin64\iqsrv15.exe. Message
title: Microsoft Visual C++ Runtime Library.

After this error i did full restart server, and it work
fine several days.

sp_iqcontext - showed 1-2 commands. ussualy it LOAD and
INSERT

Sybase IQ 15.3 on Windows Server 2008 x64


IQMSG:
Error was 09.03.2013 03:31:26 in Windows Log
iqmsg file contains:
normal load ....
I. 03/09 03:31:05. 0000013501 [20535]:
FPVALUE(FPORDINAL(dwh.Shop_Hist.End_Date`(65), 2))
I. 03/09 03:31:05. 0000013501 [20535]:
Output 4 Data Type: date (10, 0)
I. 03/09 03:31:05. 0000013501 [20535]:
Output 4 Base Distincts: 569
I. 03/09 03:31:05. 0000013501 [20535]:
Column 1: FPORDINAL(dwh.Shop_Hist.End_Date`(65), 2)
I. 03/09 03:31:05. 0000013501 [20535]:
Column 1 Data Type: date (10, 0)
I. 03/09 03:31:05. 0000013501 [20535]:
Column 1 Base Distincts: 569
I. 03/09 03:31:05. 0000013501 [20535]:
Column 1 Note: FP(2) index used by optimizer
I. 03/09 03:31:05. 0000013501 [20535]:
Column 1 Indexes: FP(2), DATE
I. 03/09 03:31:05. 0000013501 [20535]:
Column 2: FPORDINAL(dwh.Shop_Hist.Contragent_Id`(65), 2)
I. 03/09 03:31:05. 0000013501 [20535]:
Column 2 Data Type: unsigned integer (10, 0)
I. 03/09 03:31:05. 0000013501 [20535]:
Column 2 Base Distincts: 836
I. 03/09 03:31:05. 0000013501 [20535]:
Column 2 Note: HG index used by optimizer
I. 03/09 03:31:05. 0000013501 [20535]:
Column 2 Indexes: FP(2), HG
I. 03/09 03:31:05. 0000013501 [20535]:
Column 3: FPORDINAL(dwh.Shop_Hist.Start_Date`(65), 2)
I. 03/09 03:31:05. 0000013501 [20535]:
Column 3 Data Type: date (10, 0)
I. 03/09 03:31:05. 0000013501 [20535]:
Column 3 Base Distincts: 907
I. 03/09 03:31:05. 0000013501 [20535]:
Column 3 Note: FP(2) index used by optimizer
I. 03/09 03:31:05. 0000013501 [20535]:
Column 3 Indexes: FP(2), DATE
I. 03/09 03:31:05. 0000013501 [20535]:
Maximum Row ID: 18350
I. 03/09 03:31:05. 0000013501 Generating HTML Query plan:
C:\tsibulnyak\Query_plans\dwh_20130309-033105_56300.html
I. 03/09 03:31:05. 0000013597 Txn 53531149 0 53531149
I. 03/09 03:31:05. 0000013597 Cmt 53531150
I. 03/09 03:31:05. 0000013597 PostCmt 0
I. 03/09 03:31:07. 0000013501 Error opening HTML Query plan:
C:\tsibulnyak\Query_plans\dwh_20130309-033105_56300.html
I. 03/09 03:31:07. 0000013500 Txn 53531151 0 53531151
I. 03/09 03:31:07. 0000013500 Connect: SA connHandle: 1393
SA connID: 46 IQ connID: 0000013500 User: dwh
I. 03/09 03:31:07. 0000013500 Cmt 53531152
I. 03/09 03:31:07. 0000013500 PostCmt 0
I. 03/09 03:31:07. 0000013500 Txn 53531153 0 53531153
I. 03/09 03:31:07. 0000013598 Txn 53531154 0 53531154
I. 03/09 03:31:08. 0000013598 Cmt 53531155
I. 03/09 03:31:08. 0000013598 PostCmt 0
I. 03/09 03:31:08. 0000013500 Insert Started:
I. 03/09 03:31:08. 0000013500 Invoice
I. 03/09 03:31:09. 0000013500 [20897]: 100000
Rows, 1 Seconds
I. 03/09 03:31:10. 0000013599 Txn 53531156 0 53531156
I. 03/09 03:31:10. 0000013599 Cmt 53531157
I. 03/09 03:31:10. 0000013599 PostCmt 0
I. 03/09 03:31:12. 0000013500 [20897]: 200000
Rows, 3 Seconds
I. 03/09 03:31:12. 0000013600 Txn 53531158 0 53531158
I. 03/09 03:31:12. 0000013600 Cmt 53531159
I. 03/09 03:31:12. 0000013600 PostCmt 0
I. 03/09 03:31:12. 0000013500 [20897]: 300000
Rows, 0 Seconds
I. 03/09 03:31:13. 0000013500 [20897]: 400000
Rows, 1 Seconds
I. 03/09 03:31:14. 0000013500 [20895]: Insert Pass 1
completed in 6 seconds.
I. 03/09 03:31:14. 0000013601 Txn 53531160 0 53531160
I. 03/09 03:31:14. 0000013601 Cmt 53531161
I. 03/09 03:31:14. 0000013601 PostCmt 0
I. 03/09 03:31:16. 0000013602 Txn 53531162 0 53531162
I. 03/09 03:31:16. 0000013602 Cmt 53531163
I. 03/09 03:31:16. 0000013602 PostCmt 0
I. 03/09 03:31:16. 0000013284
BEGIN ERROR
I. 03/09 03:31:16. 0000013284
**************************************************
I. 03/09 03:31:16. 0000013284 *** Sybase IQ Abort:
I. 03/09 03:31:16. 0000013284 *** From:
st_server.cxx:670
I. 03/09 03:31:16. 0000013284 *** PID: 1932
I. 03/09 03:31:16. 0000013284 *** Message: Program
Abort
I. 03/09 03:31:16. 0000013284 *** Thread: 4988 (TID:
541)
I. 03/09 03:31:16. 0000013284
**************************************************
I. 03/09 03:31:16. 0000013284
I. 03/09 03:31:16. 0000013284 ** Error from IQ
connection: SA connHandle: 1370 SA connID: 33 IQ connID:
0000013284 User: dwh
I. 03/09 03:31:16. 0000013284 ** Time of error:
2013-03-09 03:31:16
I. 03/09 03:31:16. 0000013284 ** IQ Version: Sybase
IQ/15.3.0/110506/P/GA
I. 03/09 03:31:16. 0000013284 ** OS info: IQ built on:
MS/Windows 2003, Executed on:
Windows/DWHSRV/WinNT/6.1/Build 7601/Service Pack 1/x86
Family/level 6/Model 44/Stepping 2/16 CPU(s)
I. 03/09 03:31:16. 0000013284 ** Command status when
error occured: COMMAND ACTIVE
I. 03/09 03:31:16. 0000013284 ** Command text:
I. 03/09 03:31:16. 0000013284 unt_Accounting_Price_End ,
Day_Code , Week_Code , Week_Last_Day , Month_Code ,
Month_Last_Day , Quarter_Code , Quarter_Last_Day , Year_Code
, Year_Last_Day , Amount_Purchase_with_Discount_Beg ,
Amount_Purchase_with_Discount_End , Price_Beg , Price_End )
SELECT DateDim.Day_Id , Contragent.Contragent_Id ,
isnull( Store.Store_Id , 0, Store.Store_Id ) ,
MRKT_P_FILE.PROD_ID , isnull( Product_Params.Retail_Price ,
0, Product_Params.Retail_Price ) , MRKT_P_FI
I. 03/09 03:31:16. 0000013284 LE.DISC , isnull(
Shop_Hist.Shop_Hist_Id , 0, Shop_Hist.Shop_Hist_Id ) ,
isnull( Product_Hist.Product_Hist_Id , 0,
Product_Hist.Product_Hist_Id ) , isnull(
Product_Params.Assortment_Type_Id , 0,
Product_Params.Assortment_Type_Id ) , isnull(
Product_Params.Supply_Source_Id , 0,
Product_Params.Supply_Source_Id ) , isnull(
Product_Params.Product_Promotion_Id , 0,
Product_Params.Product_Promotion_Id ) ,
Markdown_Pct_Range.Markdown_Pct_Range_Id , isnull( M
I. 03/09 03:31:16. 0000013284 RKT_P_FILE.BEGIN_QTY , 0,
MRKT_P_FILE.BEGIN_QTY ) , isnull(( MRKT_P_FILE.BEGIN_QTY *
Product_Params.Retail_Pack_Weight ), 0, (
MRKT_P_FILE.BEGIN_QTY * Product_Params.Retail_Pack_Weight
)) , isnull( MRKT_P_FILE.BEGIN_SUM , 0,
MRKT_P_FILE.BEGIN_SUM ) , ( MRKT_P_FILE.BEGIN_QTY *
Product_Params.Retail_Price ) , ( MRKT_P_FILE.BEGIN_QTY *
Product_Params.Purchase_Price_AvgDiscAdj ) , isnull(
MRKT_P_FILE.BEGIN_SUM , 0, MRKT_P_FILE.BEGIN_SUM ) ,
isnull( MRKT
I. 03/09 03:31:16. 0000013284 _P_FILE.END_QTY , 0,
MRKT_P_FILE.END_QTY ) , isnull(( MRKT_P_FILE.END_QTY *
Product_Params.Retail_Pack_Weight ), 0, (
MRKT_P_FILE.END_QTY * Product_Params.Retail_Pack_Weight ))
, isnull( MRKT_P_FILE.END_SUM , 0, MRKT_P_FILE.END_SUM )
, ( MRKT_P_FILE.END_QTY * Product_Params.Retail_Price ) ,
( MRKT_P_FILE.END_QTY *
Product_Params.Purchase_Price_AvgDiscAdj ) , isnull(
MRKT_P_FILE.END_SUM , 0, MRKT_P_FILE.END_SUM ) ,
DateDim.Day_Code , DateDim.Week_
I. 03/09 03:31:16. 0000013284 Code , DateDim.Week_Last_Day
, DateDim.Month_Code , DateDim.Month_Last_Day ,
DateDim.Quarter_Code , DateDim.Quarter_Last_Day ,
DateDim.Year_Code , DateDim.Year_Last_Day , (
MRKT_P_FILE.BEGIN_QTY *
Product_Params.Purchase_Price_with_Discount ) , (
MRKT_P_FILE.END_QTY *
Product_Params.Purchase_Price_with_Discount ) ,
MRKT_P_FILE.BEG_PRICE , MRKT_P_FILE.END_PRICE FROM
((((((((stage.MRKT_Package MRKT_Package INNER JOIN
stage.MRKT_Package_Structu
I. 03/09 03:31:16. 0000013284 re MRKT_Package_Structure ON (
MRKT_Package_Structure.Package_ID =
MRKT_Package.Package_ID )) INNER JOIN stage.MRKT_P_FILE
MRKT_P_FILE ON ( MRKT_P_FILE.Package_ID =
MRKT_Package.Package_ID ) AND
I. 03/09 03:31:16. 0000013284 ct_Params Product_Params ON (
Product_Params.Contragent_Id = Contragent.Contragent_Id )
AND
I. 03/09 03:31:16. 0000013284 ist.End_Date >
MRKT_Package.Package_Date )) LEFT OUTER JOIN dwh.Shop_Hist
Shop_Hist ON ( Shop_Hist.Contragent_Id =
Contragent.Contragent_Id ) AND
I. 03/09 03:31:16. 0000013284 Dump all thread stacks at
st_server.cxx:670 for PID: 1932
I. 03/09 03:31:17. 0000013284
I. 03/09 03:31:17. 0000013284
I. 03/09 03:31:18. 0000013284


....................................................


I. 03/09 03:31:26. 0000013284
I. 03/09 03:31:26. 0000013284 pc: 0x0000000077B8135A:
NtWaitForSingleObject + 10
I. 03/09 03:31:26. 0000013284 pc: 0x00000000FE2F10DC:
__catch$??$?6U?$char_traits@D@std@@@std@@YAAEAV?$basic_ostream@DU?$char_traits@D@std@@@0@AEAV10@D@Z$0
000000018000000f f s_textIdx.o +0xdc3810cd
I. 03/09 03:31:26. 0000013284 pc: 0x00000000201E7EFC:
private: unsigned short __cdecl W32Task::do_wait(unsigned
short,int) __ptr64 00000000201e7e40 f ntkernel.obj +0xbc
I. 03/09 03:31:26. 0000013284 pc: 0x00000000201E6C44:
public: void __cdecl CondVar::wait(class Mutex & __ptr64)
__ptr64 00000000201e6bf0 f kernel.obj +0x54
I. 03/09 03:31:26. 0000013284 pc: 0x00000000201EC1DC:
public: void __cdecl CountingSemaphore::wait(void) __ptr64
00000000201ec1a0 f ksynch.obj +0x3c
I. 03/09 03:31:26. 0000013284 pc: 0x00000000201D26E3:
private: static void __cdecl
c_engine_env_notifier::listener(void * __ptr64)
00000000201d2660 f rnstream.obj +0x83
I. 03/09 03:31:26. 0000013284 pc: 0x00000000201E7C6E:
private: static void __cdecl W32Task::pre_body(void *
__ptr64) 00000000201e7bf0 f ntkernel.obj +0x7e
I. 03/09 03:31:26. 0000013284 pc: 0x00000000778D652D:
BaseThreadInitThunk + 13
I. 03/09 03:31:26. 0000013284 pc: 0x0000000077B5C521:
RtlUserThreadStart + 33
I. 03/09 03:31:26. 0000013284 pid = 1932
tEntry.th32OwnerProcessID 1932 tEntry.th32ThreadID 8836 ctid
4988
I. 03/09 03:31:26. 0000013284
I. 03/09 03:31:26. 0000013284 pc: 0x0000000077B82C1A:
ZwWaitForWorkViaWorkerFactory + 10
I. 03/09 03:31:26. 0000013284 pc: 0x0000000077B4FE0B:
RtlValidateHeap + 955
I. 03/09 03:31:26. 0000013284 pc: 0x00000000778D652D:
BaseThreadInitThunk + 13
I. 03/09 03:31:26. 0000013284 pc: 0x0000000077B5C521:
RtlUserThreadStart + 33
I. 03/09 03:31:26. 0000013284 ******************* End of
STACKTRACE ******************
I. 03/09 03:31:26. 0000013284
I. 03/09 03:31:28. 0000013608 Txn 53531174 0 53531174
I. 03/09 03:31:28. 0000013608 Cmt 53531175
I. 03/09 03:31:28. 0000013608 PostCmt 0
I. 03/09 03:31:30. 0000013609 Txn 53531176 0 53531176
I. 03/09 03:31:30. 0000013609 Cmt 53531177
I. 03/09 03:31:30. 0000013609 PostCmt 0



Last message - I. 03/09 03:31:26. 0000013284
******************* End of STACKTRACE ******************

Its ERROR?

Before 03:31:26 messages were similar on 26 second
After 03:31:26 server not load data.