IBM Support

MA46398 - OSP-DB-OTHER-F/DBPMTRAP-MSGMCH3203 QRYDFN FAILS W/ MCH3203 F/DBPMTRAP WHERE FIELDPROC IS SET TO FIRE WITHIN ALTERNATE FIELD

 APAR (Authorized Program Analysis Report)

Abstract

OSP-DB-OTHER-F/DBPMTRAP-MSGMCH3203 QRYDFN FAILS W/ MCH3203
F/DBPMTRAP WHERE FIELDPROC IS SET TO FIRE WITHIN ALTERNATE FIELD

Error Description

Query/400 qrydfn fails where a FieldProc is defined to fire    
within an Alternate Field.                                      

Problem Summary

****************************************************************
* PROBLEM: (MA46398) Licensed Program = 5770999 for i 7.2 and  *
*                                       i 7.3                  *
*           Crash/Hang Requiring an IPL to Recover             *
****************************************************************
* USERS AFFECTED: All IBM i operating system users.            *
****************************************************************
* RECOMMENDATION: Apply LIC PTF MF63645 for i 7.2.             *
*                 Apply LIC PTF MF63747 for i 7.3.             *
****************************************************************
Query/400 qrydfn fails where a FieldProc is defined to fire    
within an Alternate Field.                                      

Problem Conclusion

Customer had a Query/400 defined over views one of which used a
column value with a field procedure defined over that column for
encoding and decoding purposes.  That view was used in the      
Query/400 in a Left Outer context  The default value for        
Query/400 or any Native query request for a column is not NULL  
(as in SQL) but the column default value which is then provided
to the field procedure.  This default value per a field        
procedure call was being invoked on a SQE run time node that    
didn't support that type of upcall to the field procedure, so a
function check occurred. This PTF logic will move the default  
upcall for alternate values when the join is to no row (left    
outer) to a different node supporting the upcall.              

Temporary Fix

                       *********                                
                       * HIPER *                                
                       *********                                

Comments

Circumvention


PTFs Available

R720 MF63645 PTF Cover Letter   7290
R730 MF63747 PTF Cover Letter   7283

Affected Modules

         
         

Affected Publications

Summary Information

Status............................................ CLOSED PER
HIPER........................................... Yes
Component.................................. 9400DG3DB
Failing Module.......................... RCHMGR
Reported Release................... R720
Duplicate Of..............................




System i Support

IBM disclaims all warranties, whether express or implied, including, but not limited to, the implied warranties of merchantability and fitness for a particular purpose. By furnishing this document, IBM grants no licenses to any related patents or copyrights. Copyright © 1996,1997,1998, 1999, 2000, 2001, 2002, 2003, 2004, 2005, 2006, 2007, 2008, 2009, 2010, 2011, 2012, 2013, 2014, 2015, 2016, 2017 IBM Corporation. Any trademarks and product or brand names referenced in this document are the property of their respective owners. Consult the Terms of use link for trademark information

Document information

More support for: i family

Software version: V7R2M0, V7R3M0

Operating system(s): OS/400

Reference #: MA46398

Modified date: 28 October 2017