home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
15.0.xC1.2 FixList
14.10.xC13.3 FixList
12.10.xC16.X5 FixList
11.70.xC9.XB FixList
11.50.xC9.X2 FixList
11.10.xC3.W5 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

Informix - Problembeschreibung

Problem IT09482 Status: Geschlossen

IWA: OFFLOADING OF A QUERY WITH IN CLAUSE CAN FAIL WITH ERROR CODES -904,
57011

Produkt:
INFORMIX WHSE A / 5725D1400 / C10 - IDS 12.10
Problembeschreibung:
When you are running a query which is offloaded to the Informix 
Warehouse Accelerator the query execution can be canceled with 
an error: 
 
26561: cannot map to Informix sqlcode: DRDA OPEN IWA 
error:-904,'57011', Query compilation failed... 
 
In the message log of the operating system the Informix 
Warehouse Accelerator is running on you will find an exception: 
 
AssertionFailedException: An assertion 'mCodesAndValues != 
__null' failed. Additional info:  Pointer to CodesValues is NULL 
 
followed by 
 
CompilerException: Query compilation failed with error condition 
'An assertion 'mCodesAndValues != __null' failed. Additional 
info:  Pointer to CodesValues is NULL 
 
When the IN clause is rewritten with OR the exception will not 
occur.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* IWA acceleration with IN clause inside CASE ... WHEN         * 
* construct within WHERE clause of SELECT query.               * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description.                                       * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Update to IBM Informix Server 12.10.xC6 or newer version.    * 
****************************************************************
Local-Fix:
Lösung
Problem Fixed In IBM Informix Server 12.10.xC6
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
16.06.2015
30.12.2015
30.12.2015
Problem behoben ab folgender Versionen (IBM BugInfos)
12.10.xC6
Problem behoben lt. FixList in der Version
12.10.xC6 FixList