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