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) |