3169886 - While a regular query is working with DQP processing, it often causes server crash with stack hos_BaseSerializer::write & vpp::CreateVPPWorkerPlan -- SAP IQ

While a regular query was called, from time to time it encounters server crash.

*.iqmsg =>>

...
I. 03/25 03:36:03. 0003140175
I. 03/25 03:36:03. 0003140175 **************************************************
I. 03/25 03:36:03. 0003140175 *** SAP IQ Abort:
I. 03/25 03:36:03. 0003140175 *** From: stcxtlib/st_server.cxx:2455
...
...
I. 03/25 03:36:03. 0003140175 ** Command text:

SELECT datefloor(day,View_001.report_date),
entry_Tab_002.Tab_002name,
Tab_001.Tab_001id,
Tab_001.Tab_001name,
CS_TRAF.enum,
...
sum(View_001.total_sent_by_recvtm)
from Tab_001
join View_001 on (Tab_001.Tab_001id = View_001.Tab_001_id)
join Tab_002 as entry_Tab_002 on (entry_Tab_002.Tab_002id = View_001.entry_Tab_002_id)
join (select enum,enumdescription from Tab_003 where target = 'AAAAAA' and targetfield = 'BBBB') as CS_TRAF
on (CS_TRAF.enum = View_001.traffic_id)
where (View_001.total_sent_by_recvtm <> 0)
and (View_001.report_date >= dateadd(day,-31,(datefloor(day,getdate())))
and View_001.report_date < datefloor(day,getdate())
and Tab_001.Tab_001id in( 1249,1266,....,13227,13278 )
and CS_TRAF.enum in( 1,2 ) )
group by datefloor(day,View_001.report_date),
...
Tab_001.Tab_001name,
Tab_001.Tab_001ipaddress
having sum(View_001.end_to_end_time_by_recvtm-View_001.time_in_dtw_by_recvtm) / sum(View_001.total_sent_by_recvtm) > 20

... ** Dump all thread stacks at stcxtlib/st_server.cxx:2455 for PID: 66051

===== Thread Number ...
..
.. hos_ABORT( ..
.. SigHndlr ...
.. <unknown>
.. <unknown>
.. hos_BaseSerializer::write( ..
.. vpe_Constant::Serialize( ..
.. hos_Serializer::writeRoot( ..
.. vpp::CreateVPPWorkerPlan( ..
.. vpp::ExecuteParallelFind( ..
.. vpp_Between::ExecuteOpus( ..
.. vpp::Execute( ..
.. vpp_Boolean::ExecuteOpus( ..
.. vpp::Execute( ..
.. vpp_Boolean::ExecuteOpus( ..
.. vpp::Execute( ..
.. vpp_Boolean::ExecuteOpus( ..
.. vpp::Execute( ..
.. vp_Predicates::PreExecute( ..
.. vp_Cursor::PreExecute( ..
.. opt_QueryExpExecTopIter::ExecWork( ..
..

SAP IQ16.1 SP04.X

hos_Serializer,  hos_BaseSerializer , writeRoot , CreateVPPWorkerPlan , CreateVPPWorkerPlan , CR826373 , 826373 , DQP , DQP_Enabled , "How to disable DQP", , KBA , BC-SYB-IQ , Sybase IQ , Problem