Informix - Problem description
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 |