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.
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
Status............................ CLOSED PERHIPER............................. Yes
Component......................... 5770SS1DBSI8
Failing Module.................... RCHMGR
Reported Release.................. R730
Duplicate Of......................
IBM 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, 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
Document Information
Modified date:
12 March 2024