Skip to Content
0
Former Member
Mar 28, 2016 at 09:40 PM

SAP IQ 16 sp10.06 after upgrade crashes, stacktrace generated, CURSORS ACTIVE error

150 Views

Hi all,

I currently have a this problem with my SAP Sybase IQ 16 IQ Version: SAP IQ/16.0.102.2/20080/P/sp10.06.

Its only crash when I run a bigger query, It doen't happend when I run the same query with little data.

I want to know if you have some idea about this case, 'cause I am looking for this simmilar case but I am not finding answers.

Please if you have some idea I will apreciate it.

I have a lot of memory assigned to SAP IQ 16, in first place It has:

##-iqtc 9830

##-iqmc 6554

Now It has:

-iqmc 16384

-iqtc 14336

The first situation I can appreciate is that the memory in the NMON in my performance tool marks a lot more than the SAP IQ 16 has assigned.

x Top-Processes-(114) qqqqqMode=4 [1=Basic 2=CPU 3=Perf 4=Size 5=I/O 6=Cmds]qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqx

x PID %CPU Size Res Res Res Char RAM Paging Command x

x Used KB Set Text Data I/O Use io other repage x

x 5767188 335.5 31799536 31799560 24 31799536 222787 85% 0 13053 0 iqsrv16

This day was 31 GB, but now is 35 GB, this memory is constantly.

Second situation, when I execute a query with large data SAP IQ 16 crash, and send me an stacktrace, always with the same query:

** Error from IQ connection: SA connHandle: 56 SA connID: 10 IQ connID: 0000000243

User: DBA

** Time of error: 2016-03-23 16:12:41

** IQ Version: SAP IQ/16.0.102.2/20080/P/sp10.06

** OS info: IQ built on: RS6000MP/AIX 6.1.0, Executed on: AIX/bgdcmigiq/1/7/00F79C114C00

** Command status when error occured: CURSOR ACTIVE

** Command text:

select "a11"."AR_FNC_ST_TP_ID" as "AR_FNC_ST_TP_ID",

"max"("a111"."AR_FNC_ST_TP_NM") as "AR_FNC_ST_TP_NM",

"a15"."GRUPO_ECONOMICO_ID" as "GRUPO_ECONOMICO_ID",

"max"("a113"."GRUPO_ECONOMICO_NM") as "GRUPO_ECONOMICO_NM",

"max"("a113"."GRUPO_ECONOMICO_ID_FUENTE") as "GRUPO_ECONOMICO_ID_FUENTE",

"a14"."IP_ID" as "IP_ID",

"max"("a15"."EN_ENTE") as "EN_ENTE",

"max"("a15"."FULL_NM") as "FULL_NM",

"a11"."AR_ID" as "AR_ID",

"max"("a19"."NO_DE_OPERACION") as "NO_DE_OPERACION",

"a11"."AR_LCS_TP_ID" as "AR_LCS_TP_ID",

"max"("a112"."AR_LCS_TP_NM") as "AR_LCS_TP_NM",

"a11"."MSR_PRD_ID" as "MSR_PRD_ID",

"max"("a110"."MES_SHORT") as "MES_SHORT",

"max"("a110"."MES_DEL_ANO_ID") as "MES_DEL_ANO_ID",

"a15"."RLN_OFCR_EMPE_ID" as "RLN_OFCR_EMPE_ID",

"max"("a16"."OFICIAL") as "OFICIAL",

"max"("a16"."BG_LOGIN") as "BG_LOGIN",

"count"(distinct "a11"."AR_ID") as "CANTIDADDECONTRATOSVIGENTES",

"sum"((case when "a11"."BG_SALDO_AJUSTADO" >= 0.0 then("a11"."BG_SALDO_AJUSTADO"-"a11"."BG_VALOR_SUSPENSO") else 0.0 end)) as "SALDOVIGENTES"

from "DMT_CON"."ANALISIS_DE_CONTRATOS" as "a11"

join "MSTRDW"."LU_SUB_PRODUCTO" as "a12"

on("a11"."PD_ID" = "a12"."SUBPRODUCTOBG_ID")

join "DMT_PAR"."PARTICIPANTE_X_CONTRATO" as "a13"

on("a11"."AR_ID" = "a13"."AR_ID"

and "a11"."MSR_PRD_ID" = "a13"."MSR_PRD_ID")

join "DMT_PAR"."ANALISIS_PARTICIPANTES" as "a14"

on("a13"."IP_ID" = "a14"."IP_ID"

and "a13"."MSR_PRD_ID" = "a14"."MSR_PRD_ID")

join "MSTRDW"."LU_MERCADEO_CLIENTES" as "a15"

on("a14"."IP_ID" = "a15"."CST_ID")

join "MSTRDW"."LU_OFICIAL_ACTUAL" as "a16"

on("a15"."RLN_OFCR_EMPE_ID" = "a16"."OFICIAL_ID")

join "MSTRDW"."SUBGRUPO_OFICIAL" as "a17"

on("a16"."SUBGRUPO_OFICIAL_ID" = "a17"."SUBGRUPO_OFICIAL_ID")

join "DMT_CON"."GRUPO_OFICIAL" as "a18"

on("a17"."GRUPO_OFICIAL_ID" = "a18"."GRUPO_OFICIAL_ID")

join "MSTRDW"."VW_MERCADEO_CONTRATOS" as "a19"

on("a11"."AR_ID" = "a19"."AR_ID")

join "MSTRDW"."MES" as "a110"

on("a11"."MSR_PRD_ID" = "a110"."Mes_ID")

join "MSTRDW"."AR_FNC_ST_TP" as "a111"

on("a11"."AR_FNC_ST_TP_ID" = "a111"."AR_FNC_ST_TP_ID")

join "DMT_CON"."AR_LCS_TP" as "a112"

on("a11"."AR_LCS_TP_ID" = "a112"."AR_LCS_TP_ID")

join "DMT_CON"."GRUPO_ECONOMICO" as "a113"

on("a15"."GRUPO_ECONOMICO_ID" = "a113"."GRUPO_ECONOMICO_ID")

where("a11"."MSR_PRD_ID" = convert(numeric(38),(("datepart"("yy","getdate"())*12)+"datepart"("mm","getdate"())-23165))

and "a12"."TIPOPRODUCTO_ID" in( 62,60 )

and "a18"."SECTOR_OFICIAL_ID" in( 174 )

and "a13"."TIPO_ROL_ID" in( 6738,1955 )

and "a11"."CANTIDAD_DIAS_MOROSIDAD" >= 1

and "a11"."AR_LCS_TP_ID" not in( 1123,1166,1119,1171 )

and "a11"."AR_LCS_TP_ID" not in( 1119,1166,1169,1118,1124,1164,1125,1126,1129,8700 ) )

group by "a11"."AR_FNC_ST_TP_ID",

"a15"."GRUPO_ECONOMICO_ID",

"a14"."IP_ID",

"a11"."AR_ID",

"a11"."AR_LCS_TP_ID",

"a11"."MSR_PRD_ID",

"a15"."RLN_OFCR_EMPE_ID"

Dump all thread stacks at stcxtlib/st_server.cxx:1921 for PID: 6488080

***************** This is the STACKTRACE ***************

===== Thread Number 168595 (IQ connID: 0000000243) =====

pc: 0x900000003eb5948 .pcstkwalk(stk_trace*,int,db_log*,hos_fd*)+0x1c8()

pc: 0x900000003eb5258 .ucstkgentrace(int,int)+0xb8()

pc: 0x900000003eb3a44 .DumpAllThreads(const char*,unsigned int,int)+0x184()

pc: 0x900000003d3e994 .hos_ABORT(const char*,unsigned int,const char*,char*,char*)+0x1b4()

pc: 0x90000000520ba68 .SigHndlr+0x68()

pc: 0x9000000063f19d4 .dfo_Join::SkipRec(dfo*)+0x94()

pc: 0x9000000063f19bc .dfo_Join::SkipRec(dfo*)+0x7c()

pc: 0x900000004d36350 .dfjo_MergeKeyed::FetchOpus()+0x6b0()

pc: 0x9000000063f28d0 .dfo_Join::FetchOpus()+0x30()

pc: 0x900000004a1e664 .dfjo_HashParaT1::FetchOpus()+0x1a4()

pc: 0x9000000063f28d0 .dfo_Join::FetchOpus()+0x30()

pc: 0x900000004a1e664 .dfjo_HashParaT1::FetchOpus()+0x1a4()

pc: 0x9000000063f28d0 .dfo_Join::FetchOpus()+0x30()

pc: 0x900000005099f38 .dfo_cOrderByParaIn::ExecWork(int&,unsigned int)+0xeb8()

pc: 0x900000004d5b324 .workAllocator::DoWork(unsigned int)+0xe4()

pc: 0x900000004d5ef30 .workAllocator::sDoWork(workAllocator*,unsigned int)+0x30()

pc: 0x9000000047ccdc8 .hos_thread::Main()+0x228()

pc: 0x900000003d42384 .hos_lwtask::Start(hos_lwtask*)+0x64()

pc: 0x900000002190c2c .IQWorkerStarter(void*)+0x6c()

pc: 0x900000001f3ca88 .run_task_body+0x48()

pc: 0x900000001f37154 .UnixTask::pre_body(void*)+0x134()

pc: 0x9000000007e0d94 ()

Third situation:

I just upgrade my SAP IQ 16 from a SAP Sybase IQ 15.4

The error is presenting from today, yesterday was done to upgrade SAP SAP IQ / 16.0.102.2 / 20080 / P / sp10.06 from Versn: 15.4.0.3046/141204/P/ESD 5 / RS6000MP / AIX 6.1 .0 / 64bit / 04/12/2014 17:25:56

I ran the sp_iqrebuildindex over all the tables in SAP IQ 16, but the behavior is still occurs.

I Attached some files.

Thanks for the help

Greetings

Santiago