| Latest versions | fixlist |
| 14.10.xC10 |
 |
| 12.10.xC16.X5 |
|
| 11.70.xC9.XB |
|
| 11.50.xC9.X2 |
|
| 11.10.xC3.W5 |
|
| Have problems? - contact us. | |
| Register for free |
|
| Contact form |
|
Informix - Problem description
| Problem IT30226 | Status: Closed |
SERVER ASSERT FAIL IN UDTLOAD RUNNING QUERY WITH GETELEM AND NESTED TSROLLUP | |
| product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
| Problem description: | |
Query being ran:
select substr(primkey,11,7) as premise,
NVL(GetElem(TSRollup(vee_intvl_tr, 'SUM($rdng_value),
start(' ||
'2013-01-01 00:00:00' || '), end(' || '2013-01-02 17:00:00'
||
')')::timeseries(ROW(rdng_dtmgmt DATETIME YEAR TO
FRACTION(5) ,rdng_sum
DECIMAL(14,3))),'2013-01-02 17:00:00').rdng_sum * 4,0) as
kw, enrgy_dir,
meas_unit from t3 group by premise, kw, enrgy_dir, meas_unit
Stack from assertion failure file:
udtload
rdatavalUdt
valload
geval
geval
routine_evalargs
exroutine
geval
geval
geval
geval
ev_geval
new_eval
next_row
get_first_row_from_producer
hash_process_all_groups
group_open
prepselect
open_cursor
sql_open
sq_open
sqmain | |
| Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC14 and 14.10.xC3. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to Informix Server 12.10.xC14 or 14.10.xC3. * **************************************************************** | |
| Local Fix: | |
| Solution | |
| Workaround | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC14 and 14.10.xC3. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to Informix Server 12.10.xC14 or 14.10.xC3. * **************************************************************** | |
| Comment | |
Update to Informix Server 12.10.xC14 or 14.10.xC3. | |
| Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 09.09.2019 25.02.2020 25.02.2020 |
| Problem solved at the following versions (IBM BugInfos) | |
12.10.xC14, 14.10.xC3 | |
| Problem solved according to the fixlist(s) of the following version(s) | |
