SE64720 - F/QDBCHGCT-MSGCPD32B2 DURING UPGRADE TO R730, 5770SS1 OPTION 1
INSTALL FAILS, FILE SYSPARMS CONSTRAINT ERROR

APAR (Authorized Program Analysis Report)

Abstract

F/QDBCHGCT-MSGCPD32B2 DURING UPGRADE TO R730, 5770SS1 OPTION 1
INSTALL FAILS, FILE SYSPARMS CONSTRAINT ERROR

Error Description

During R720 to R730 upgrade, product 57780SS1 option 1 fails    
with:                                                          
                                                               
CPD32B2 f/QDBCHGCT QSYS x/0FCD t/QDBCHGFI QSYS x/*STMT          
To module . . . . . . . . . : QDBCHGFI                          
To procedure . . . . . . . : CRT_NEW_FILE                      
Statement . . . . . . . . . : 31905                            
Message . . . . : Constraint cannot be changed for file        
SYSPARMS.                                                      
Cause . . . . . : The constraint *GEN, TYPE *N cannot be        
changed for file                                                
SYSPARMS in library QSYS2 for STATE value *DISABLED. The        
constraint was not changed because of errors. The reason code  
is 3 -- The constraint name was not valid.                      
                                                               
CPD43A7 QQQSRVV1 QSYS *STMT QSQCRTT QSYS *STMT                  
From module . . . . . . . . : QQQVFILE                          
From procedure . . . . . . : QQQSNDPMSG                        
Statement . . . . . . . . . : 7734                              
To module . . . . . . . . . : QSQCRTT                          
To procedure . . . . . . . : QSQCRTT                            
Statement . . . . . . . . . : 13654                            
Message . . . . : Period specification or period clause for    
period SYSTEM_TIME not valid for query.                        
Cause . . . . . : The period specification or period clause for
period                                                          
SYSTEM_TIME specified for file SYSROUTINE in library QSYS2 is  
not valid for                                                  
the query for reason code 2 -- The SYSTEM_TIME period was      
specified, but the table is not a system-period temporal table  
                                                               
CPF4278 Query definition template 1 not valid.                  

Problem Summary

****************************************************************
* PROBLEM: (SE64720) Licensed Program = 5770SS1                *
*           Save/Restore Problem Preventing Backup and/or      *
*            Recovery of Objects                               *
****************************************************************
* USERS AFFECTED: All IBM i operating system users.            *
****************************************************************
* RECOMMENDATION: Apply PTF SI60544 for i 7.3.               *  
****************************************************************
********                                                        
During R720 to R730 upgrade, product 5770SS1 option 1 fails with
msgCPD43A7 f/QQQSRVV1 t/QSQCRTT "Period specification or period
clause for period SYSTEM_TIME not valid for query" for views    
based on system catalogs.                                      
                                                               
This error can also be seen outside of an install for views    
based on user created files.                                    

Problem Conclusion

A flag in an SQL view was incorrectly set to indicate the view  
contains a system-time period.   The checking and setting of    
this flag is corrected.                                        
                                                               
This PTF is corrective.  Following the apply of this PTF, retry
the operation that caused the error message.                    
                                                               
If the CPD43A7 message is seen in the SCPF joblog for the      
upgrade from R720 to R730 no action is required for these views.
 The operating system will correct the views the first time the
views access plan is rebuilt.                                  

Temporary Fix

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

Comments

Circumvention

PTFs Available

R730 SI60527  6299

Affected Modules

Affected Publications

Summary Information

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, 2018, 2019, 2020, 2021, 2022, 2023, 2024 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