Informix - Problem description
Problem IT30737 | Status: Closed |
392: SYSTEM ERROR - UNEXPECTED NULL POINTER ENCOUNTERED | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
Running query with union all may lead to: -392 error in complex ANSI JOIN query when it includes a UNION ALL view and another view with group by and aggregation. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC14 and 14.10.xC3. * * * * * * Name * * * * * * Component ID * * * * * * RETAIN Release - needs to be 3 digits. Cannot have letters, * * dots or special characters. * * * * State * * * * * * Status Detail * * * * * * Change Team * * Severity * * * * * * System Level * * * * * * High Impact PERvasive * * * * * * Security/Integrity * * * * * * Company Name * * Type * * * * * * IBM Customer Number (ICN) OR CMR number in Salesforce * * * * * * Found In Version * * Product * * Component * * Found In Platform * * Symptom * * Keyword * * * * * * Close Code * * * * Submit Date * * * * Receipt Date * * * * Closed Date * * * * Last Changed Date/Time * * Reopened and needs triage * * Tags * * * * * * Sysrouted From * * * * Sysrouted To * * 392: SYSTEM ERROR - UNEXPECTED NULL POINTER ENCOUNTERED. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to Informix Server 12.10.xC14 or 14.10.xC3. * **************************************************************** | |
Local Fix: | |
disable IFX_FOLDVIEW for temporary workaround onmode -wm IFX_FOLDVIEW=0 | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC14 and 14.10.xC3. * * * * * * Name * * * * * * Component ID * * * * * * RETAIN Release - needs to be 3 digits. Cannot have letters, * * dots or special characters. * * * * State * * * * * * Status Detail * * * * * * Change Team * * Severity * * * * * * System Level * * * * * * High Impact PERvasive * * * * * * Security/Integrity * * * * * * Company Name * * Type * * * * * * IBM Customer Number (ICN) OR CMR number in Salesforce * * * * * * Found In Version * * Product * * Component * * Found In Platform * * Symptom * * Keyword * * * * * * Close Code * * * * Submit Date * * * * Receipt Date * * * * Closed Date * * * * Last Changed Date/Time * * Reopened and needs triage * * Tags * * * * * * Sysrouted From * * * * Sysrouted To * * 392: SYSTEM ERROR - UNEXPECTED NULL POINTER ENCOUNTERED. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to Informix Server 12.10.xC14 or 14.10.xC3. * **************************************************************** | |
Comment | |
Fixed in Informix Server 12.10.xC14 and 14.10.xC3. | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 29.10.2019 26.02.2020 26.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) |