1966851 - [SAP IQ] IQ aborted at "dfo::CheckMarkInvariant". | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

1966851 - [SAP IQ] IQ aborted at "dfo::CheckMarkInvariant".


A Query (which used a Nested loop pushdown (NLPD) join with more than one uncorrelated IN subquery) leads to server crash.


            SELECT a11.NPS_NO NPNO,
            WHERE (((a11.NPS_NO) in ( SELECT c22.PNSR_NPS_NO
                             FROM NPSPDW01.D_SK001800 c21
                              JOIN NPSPDW01.W_TB_GDC00100 c22
                                      on (c21.FG_CD = c22.STOP_BRKD_EXSTN)
                           WHERE c21.FG_CD not in ('Y')))
               AND ((a11.NPS_NO) in ( SELECT c22.JGMT_TRGTP_NPS_NO
                             FROM NPSPDW01.D_SK002000 c21
                              JOIN NPSPDW01.W_TB_GJS00100 c22
                                      on (c21.DT_CD = c22.PRVS_DCSN_DT)
            GROUP by a11.NPS_NO

  Dump all thread stacks at st_server.cxx:1412 for PID: 24707566
  ***************** This is the STACKTRACE ***************
  ===== Thread Number 36752 (IQ connID: 0000156739) =====
  ...DumpAllThreads(const char*,unsigned int,int)+0x1bc()
  ...hos_ABORT(const char*,unsigned int,const char*,char*,char*)+0x160()
  ...dfo::CheckMarkInvariant(const hos_vector_noerror&,int)+0x90()
  ...dfo_Join::CheckMarkInvariant(const hos_vector_noerror&,int)+0x1a4()
  ...dfo::CheckMarkInvariant(const hos_vector_noerror&,int)+0x90()
  ...dfo_SubQuery::CheckMarkInvariant(const hos_vector_noerror&,int)+0xb4()
  ...dfo::CheckMarkInvariant(const hos_vector_noerror&,int)+0x90()
  ...dfo::CheckMarkInvariant(const hos_vector_noerror&,int)+0x90()



SAP IQ15.2, IQ15.4


SAP Sybase IQ 15.2 ; SAP Sybase IQ 15.4


CheckMarkInvariant, Nested loop pushdown, st_server.cxx:1412, uncorrelated subquery, IQ, CR #705510, CR 705510, 705510 , KBA , BC-SYB-IQ , Sybase IQ , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , Bug Filed

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.