DB2 - Problem description
Problem IT27904 | Status: Closed |
QUERY FAILS WITH SQLCODE -901 | |
product: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
Problem description: | |
2019-01-22-17.51.59.884727-300 I3400A888 LEVEL: Severe PID : 11075818 TID : 2058 PROC : db2sysc INSTANCE: agkoile NODE : 000 DB : PANNA APPHDL : 0-84 APPID: *LOCAL.agkoile.190122224749 AUTHID : AGKOILE HOSTNAME: bugdbug EDUID : 2058 EDUNAME: db2agent (PANNA) FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc, probe:250 DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes sqlcaid : SQLCA sqlcabc: 136 sqlcode: -901 sqlerrml: 33 sqlerrmc: Missing mapping for function 1931 sqlerrp : SQLNT011 sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000 (4) 0x00000000 (5) 0xFFFFDA69 (6) 0x00000000 sqlwarn : (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) (11) sqlstate: 2019-01-22-17.52.00.124685-300 E101537A3336 LEVEL: Info (Origin) PID : 11075818 TID : 2058 PROC : db2sysc INSTANCE: agkoile NODE : 000 DB : PANNA APPHDL : 0-84 APPID: *LOCAL.agkoile.190122224749 AUTHID : AGKOILE HOSTNAME: bugdbug EDUID : 2058 EDUNAME: db2agent (PANNA) FUNCTION: DB2 UDB, SW- common services, sqlnn_cmpl, probe:650 MESSAGE : ZRC=0x803100AF=-2144272209=SQLNN_E_BADNEWS "unexpected error but state is OK" DATA #1 : String, 62 bytes An unexpected error was detected during statement compilation. DATA #2 : Boolean, 1 bytes true DATA #3 : Boolean, 1 bytes false DATA #4 : Boolean, 1 bytes true DATA #5 : Boolean, 1 bytes false DATA #6 : Hex integer, 4 bytes 0x00000000 DATA #7 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes sqlcaid : SQLCA sqlcabc: 136 sqlcode: -901 sqlerrml: 33 sqlerrmc: Missing mapping for function 1931 sqlerrp : SQLNT011 sqlerrd : (1) 0x801A006D (2) 0x00000000 (3) 0x00000000 (4) 0x00000000 (5) 0xFFFFDA69 (6) 0x00000000 sqlwarn : (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) (11) sqlstate: DATA #8 : Hex integer, 4 bytes 0x00000040 DATA #9 : String with size, 1000 bytes select case when UB2_66_VTE_41_45_LEB_HH.UB2_RIEHZ_LEB_ST_MIN > 10101 THEN round(months_between( date( replace(substr(cast(cast(UB2_66_VTE_41_45_LEB_HH.UB2_RIEHZ_LEB_S T_MIN as INTEG ER) as varchar(10)),1,4),'.','')||'-'|| replace(substr(cast(cast(UB2_66_VTE_41_45_LEB_HH.UB2_RIEHZ_LEB_S T_MIN as INTEGER) as varchar(10)),5,2),'.','')||'-'|| replace(substr(cast(cast( UB2_66_VTE_41_45_LEB_HH.UB2_RIEHZ_LEB_ST_MIN as INTEGER) as varchar(10)),7,2),'.','')), last_day(replace(substr(cast(cast(MDS_MEDIZDUO_PROPH_ZV_0_1_HH_S 4a.MONATSID as INTEGER) as varc har(10)),1,4),'.','')||'-'|| replace(substr(cast(cast(MDS_MEDIZDUO_PROPH_ZV_0_1_HH_S4a.MONATS ID as INTEGER) as varchar(10)),5,2),'.','')||'-01')),0) ELSE 0 END as UB2_RIEHZ_LEB_ST_MIN from ANA_ADS.MDS_MEDIZDUO_PROPH_ZV_0_1_HH_S4A as MDS_MEDIZDUO_PROPH_ZV_0_1_HH_S4a inner join ANA_ADS.HH_UBX_PARTNER_02 as HH_UBX_Partner_02 on ( (MDS_MEDIZDUO_PROPH_ZV_0_1_HH_S4a.MON ATSID = HH_UBX_Partner_02.MONATSID and MDS_MEDIZDUO_PROPH_ZV_0_1_HH_S4a.TMP_GRP1_ID = DATA #10: String, 974 bytes Compiler error stack for rc = -2144272209: sqlnn_cmpl[380] sqlno_exe[2020] sqlno_final_phase[150] sqlnt_main[140] sqlnt_walk_[355] sqlnt_walk_[326] sqlnt_walk_remote[568] sqlnt_translate_ship[1339] sqlnt_add_select_list[5023] sqlnt_add_select_list[4763] sqlnt_add_column_reference[9090] sqlnt_add_column_reference[8791] sqlnt_add_column_reference[8547] sqlnt_add_expression[13127] sqlnt_add_expression[13085] sqlnt_add_function[12868] sqlnt_add_function[10684] sqlnt_add_expression[13127] sqlnt_add_expression[13085] sqlnt_add_function[12868] sqlnt_add_function[11309] sqlnt_add_expression[13127] sqlnt_add_expression[13085] sqlnt_add_function[12868] sqlnt_add_function[10684] sqlnt_add_expression[13127] sqlnt_add_expression[13085] sqlnt_add_function[12868] sqlnt_add_function[10684] sqlnt_add_expression[13127] sqlnt_add_expression[13085] sqlnt_add_function[12868] sqlnt_add_function[10684] sqlnt_add_expression[13127] sqlnt_add_expression[13085] sqlnt_add_function[12868] | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * QUERY FAILS WITH SQLCODE -901 * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * First fixed in v11.1 fp6 * **************************************************************** | |
Local Fix: | |
n/a | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 28.01.2019 09.03.2020 09.03.2020 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |