DB2 - Problem description
Problem IT29786 | Status: Closed |
SQL0901N: UNEXPECTED ERROR AT QUERYINFOCONTAINER.HPP:395 | |
product: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
Problem description: | |
A SQL query including a stored procedure call can return the following error: SQL0901N The SQL statement or command failed because of a database system error. (Reason "unexpected error at QueryInfoContainer.hpp:395".) SQLSTATE=58004" In the db2diag.log you may see a message like this as well: 2019-06-03-11.34.37.648739-240 I8375A3247 LEVEL: Error PID : 7208996 TID : 61422 PROC : db2sysc 0 INSTANCE: abcdefgh NODE : 000 DB : XYZ APPHDL : 0-42512 APPID: *LOCAL.123456.190603150808 AUTHID : ABCDEFGH HOSTNAME: 123456 EDUID : 61422 EDUNAME: db2agntcol (IFDWATT1) 0 FUNCTION: DB2 UDB, CDE Trace, cdeDiagnosticsFacility, probe:395 DATA #1 : String, 242 bytes AssertionFailedException: An assertion 'mCseTempMap.find(cseTempName) == mCseTempMap.end()' failed. Additional info: CSE temp TEMP0 already exists Thrown at /view/db2_v111m3if1_aix64_s1804271300/vbs/engn/cde/query/QueryIn foContainer.hpp : 395 DATA #2 : Function name in Library, 74 bytes ibm_cde::query::CommonStmtInfo::addCseTemp(cde_string &, SpillableStore *) DATA #3 : File name, 79 bytes /view/db2_v111m3if1_aix64_s1804271300/vbs/engn/cde/query/QueryIn foContainer.hpp | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 11.1 Mod 4 Fixpack 5 or higher * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 19.07.2019 16.01.2020 16.01.2020 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |