|
Problem IT09585
|
Status: Closed |
IWA: LOAD OF DATA MART CAN FAIL WITH ERROR AQT10205I WHEN VIEW REFERS TO MORE THAN ONE SERIAL COLUMN |
| product: |
INFORMIX WHSE A / 5725D1400 / C10 - IDS 12.10 |
| Problem description: |
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 Summary: |
****************************************************************
* 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: |
|
| Solution |
Problem Fixed In IBM Informix Server 12.10.xC6. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 22.06.2015
30.12.2015
30.12.2015 |
| Problem solved at the following versions (IBM BugInfos) |
12.10.xC6
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 12.10.xC6
|
 |
