SAP Knowledge Base Article - Preview

2023219 - [SAP IQ] Non-Fatal IQ Internal Error Detected at vplib/vpp_In.cxx:1133

Symptom

A SQL failed to execute due to internal error (vplib/vpp_In.cxx:1133).

[SQL]

SELECT E.COL001
, ISNULL(b.COL002, '9999') AS COL0021
, b.COL003
, ( CASE
WHEN b.COL004 IN ( 'AAA', 'BBB', 'CCC', 'DDD' ) THEN 'B'
ELSE 'C'
END ) AS COL005
, Count(*) AS COL006
, Sum(b.COL007) AS COL0071
FROM TAB001 b
, #TEMP1 C
, TAB002 D
, TAB003 E
WHERE b.COL003 = c.COL008
AND B.COL009 = D.COL009
AND D.COL010 = E.COL010
AND b.COL004 IN ( 'AAA', 'BBB', 'CCC', 'DDD', 'EEE', 'FFF', 'GGG' )
AND ( b.COL007 IS NOT NULL
AND b.COL007 != 0 )
AND SUBSTR(b.COL011, 1, 2) < '17'
AND E.COL001 NOT IN (SELECT COL012 FROM #TEMP2
GROUP BY COL012
)
GROUP BY E.COL001
, b.COL002
, b.COL003
, COL005


         
[Stacktrace]
 
  ********************************************************                                             
  **                                                                                                   
  **       Non-Fatal IQ Internal Error Detected                                                        
  **       at vplib/vpp_In.cxx:1133  on thread 1890 (TID 1881)                                         
  **                                                                                                   
  **       Please report this to Sybase IQ support                                                     
  **       with the following diagnostic information,                                                  
  **       and, if possible, with the user's command.                                                  
  **                                                                                                   
  **  Error from IQ connection:  SA connHandle: 8994  SA connID: 52  IQ connID: 0000658159  User: user001
  **  Time of error:  2014-05-02 11:41:06                                                              
  **  IQ Version:  Sybase IQ/16.0.0/131122/P/sp03                                                       
  **  OS info:  IQ built on: ITANIUM/HP-UXi 11.31,  Executed on: HP-UX/host001/B.11.31/U/ia64          
  **  Command status when error occured:  CURSOR ACTIVE                                                
  **  Command text:                                                                                   
 
   ...
   ...              
  ...vpp_In11ExecuteOpusE...
  ...vpp7ExecuteEPP4s_bmPKS0_S4_10hos_boolop...
  ...vpp_Combiner8ExecWorkERij...
  ...workAllocator6DoWorkEj...
  ...workAllocator7sDoWorkEPS_j...
    ...
    ...


Read more...

Environment

SAP IQ16 SP03

Product

SAP IQ 16.0

Keywords

vpp_In.cxx:1133, 762222, SAP IQ, SYBASE, vpp_In::ExecuteOpus, ExecuteOpus , KBA , BC-SYB-IQ , Sybase IQ , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , Problem

About this page

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

Search for additional results

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