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
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.