Informix Error 392
a UNION ALL view and another view with group by and aggregation. Subscribe to this APAR By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product. Notify me when this APAR changes. Notify me when an APAR for this component changes. APAR status Closed as program error. Error description The error "392: SYSTEM ERROR - UNEXPECTED NULL POINTER ENCOUNTERED." may occur on 12.10.FC3XB and 12.10.FC3XE. A UNION ALL view folding enhancement was included in these releases. As a result of the fixes for two other defect fixes and this enhancement, the UNION ALL gets folded but the other part of the view is improperly materialized when there is a group by and aggregation in the view definition. Local fix Problem summary **************************************************************** * USERS AFFECTED: * * Users of 12.10.xC4 * **************************************************************** * PROBLEM DESCRIPTION: * * A query may return -392 error under the following * * conditions: * * - at least two views are involved, one UNION ALL view, and * * another view which contains group by and aggregation in its * * definition * * - the UNION ALL view is folded into the main query (i.e. * * no temp table creation) * * - the other view with group by and aggregation is * * materialized into a temp table * **************************************************************** * RECOMMENDATION: * * Update to IDS-12.10.xC5 * **************************************************************** Problem conclusion Problem Fixed In IDS-12.10.xC5 Temporary fix Comments APAR Information APAR numberIT03042 Reported component nameINFORMIX SERVER Reported component ID5725A3900 Reported releaseC10 StatusCLOSED PER PENoPE HIPERNoHIPER Special AttentionNoSpecatt Submitted date2014-07-09 Closed date2015-10-16 Last modified date2015-10-16 APAR is sysrouted FROM one or more of the following: APAR is sysrouted TO one or more of the following: Fix information Fixed component nameINFORMIX SERVER Fixed component ID5725A3900 Applicable component levels RC10 PSNUP Document information More support for: Informix Servers Software version: C10 Reference #: IT03042 Modified date: 2015-10-16 Site availability Site assistance Contact and feedback Need support? Submit feedback to IBM Support 1-800-IBM-7378 (USA) Directory of worldwide contacts Contact Privacy Terms of use Accessibility
list Fix list Fix list Fixlist Fixlists List of Updates List of Updates List of Updates list of defects list of defects list of defects FixListDocument FixListDocument maintenance refresh pack cumulative fix fix pack service pack 12.10 12.10.xC7W1 12.10.FC7W1 12.10.UC7W1 12.10.TC7W1 Product documentation Abstract Informix Server provides periodic fixes for release12.10. The following list is the most recent report of fixes for customer-reported http://www.ibm.com/support/docview.wss?uid=swg1IT03042 defects in Version 12.10.xC7W1 and 12.10.xC7. This report combines both Windows- and UNIX-specific defect fixes, and is more current than the defect information included in the product release. Content Fix list for Informix Server 12.10.xC7 and PID 12.10.xC7W1 Fix release date: 24 Jul 2016 Last modified: 24 Jul 2016 Status: Recommended Download http://www-01.ibm.com/support/docview.wss?uid=swg27048491 information Back to Top xC7W1 APARs Description IT05483 INCORRECT RESULTS POSSIBLE FOR SELECT ON SMI TABLE SYSONLINELOG IT05919 INCORRECT RESULTS POSSIBLE FOR SIMPLE SELECT WITH GROUP BY ON LVARCHAR COLUMN IT10492 DBEXPORT -O SEGMENTATION FAULTS IF DIRECTORY SPECIFIED DOES NOT EXIST IT14643 SELECT FROM SYSBUFHDR WILL ASSERT FAIL IN PSTPOSIT() IT14738 ONSMSYNC -G MIGHT CRASH WITH BAR_DEBUG TURNED ON IT14770 ALTERING TABLE TO ADD ROWIDS TO TABLE FRAGMENTED BY RANGE RETURNS -212/-772 ERROR IT14969 DBACCESS MAY TRUNCATE A STRING IF CLIENT_LOCALE IS SET TO A MULTIBYTE CODESET IT15002 ON SOLARIS, A SEGMENTATION FAULT (SIGSEGV) RESULTS IN RECURSIVE EXCEPTION AND EXIT IT15054 INVALID MUTEX TYPE ASSERTION FAILURE ON POLL THREAD IN BREAK_SESSION DUE TO RACE CONDITION WITH THREAD EXITING VIA DESTROY_SESSI IT15068 THE TEXT ERROR MESSAGE FOR ERROR -860 CONTAINS SOME SPELLING MISTAKES IT15183 DBSPACES MISSING AFTER UPGRADE IT15239 MEMORY LEAK IN CSM VP WHEN OPENING AND CLOSING PASSWORD ENCRYPTED CONNECTIONS IT15261 HIGH PE
Tag: Informix Error Code -392 Informix Error Messages and Error Codes From Error 389 to 395 March 6, 2015 SQLServerF1 Leave a comment Informix Error Code -389 No DBA http://www.sqlserverf1.com/tag/informix-error-code-392/ permission. This statement cannot be executed because your account has not been granted DBA privilege to this database. Contact a person who has DBA privilege to the database and ask to be granted DBA privileges to it (or simply ask to have this statement executed for you). Informix Error Code -390 Synonym already used as table name or synonym. This CREATE SYNONYM statement informix error names a synonym that is already in use. To see all the synonym and table names currently defined, query systables as follows: SELECT tabname, owner FROM systables WHERE tabid > 99 Informix Error Code -391 Cannot insert a null into column column-name. This statement tries to put a null value in the noted column. However, that column has been defined as NOT NULL. informix error 392 Roll back the current transaction. If this is a program, review the definition of the table, and change the program logic to not use null values for columns that cannot accept them. Informix Error Code -392 System error - unexpected null pointer encountered. This internal error should not occur. If the error recurs, please note all circumstances and contact Informix Technical Support. Informix Error Code -393 A condition in the where clause results in a two-sided outer join. This query requests an outer join, but one or more conditions in the WHERE clause interfere with the dominant-subservient relationship. Review the query to ensure that every condition that relates two tables is actually necessary. Informix Error Code -394 View view-name not found. The named view cannot be dropped as it does not exist. To see names of existing views, query systables as follows: SELECT tabname FROM systables WHERE tabtype = ‘V' Informix Error Code -395 The where clause contains an outer cartesian product. This query requests an outer join, but the WHERE clause is written so as to imply selecting every row of the subservient table for e