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 IT09585 Status: Geschlossen

IWA: LOAD OF DATA MART CAN FAIL WITH ERROR AQT10205I WHEN VIEW REFERS TO
MORE THAN ONE SERIAL COLUMN

Produkt:
INFORMIX WHSE A / 5725D1400 / C10 - IDS 12.10
Problembeschreibung:
You can observe an error 
 
(U0001) - severe: AQT10205I:  An internal processing error 
occurred in the stored procedure. Diagnostic information: An 
assertion 'false' failed. Additional info: unloading data 
failed, check 
/tmp/iwaunld.7605e19c-3eb3-4297-8513-4638252ca3ad.out 
Error in line 1 
 
when attempting to load a data mart into the Informix Warehouse 
Accelerator. 
 
This can happen when one of the loaded objects is a view which 
refers to more than one SERIAL/SERIAL8/BIGSERIAL column. 
 
The error in the *.out file is pointing to this: 
 
create external table ... 
; 
  362: Can have only one column of serial/(serial8 or bigserial) 
type. 
 
As a temporary relief you can change the view by casting the 
offending columns to an appropriate non-SERIAL type or, when the 
columns are not supposed to be processed by excluding those 
columns.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* IWA users with data mart containing a view that has multiple * 
* serial columns (from multiple base tables) get error for     * 
* loadMart.                                                    * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Update to IBM Informix Server 12.10.xC6.                     * 
****************************************************************
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:
22.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