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/ASSERT-MSGMCH3203-RC1720-MOD/ASSERT SP UPDATE SQL SENTENCE
FAILS WITH MCH3203 AFTER CUM6320 AND SF99701-41 WAS APPLIED
Error Description
MCH3203 Escape 60 03/06/17 07:02:12.731680 assert 000004
QQQOOODBOP QSYS *STMT
To module . . . . . . . . . : QQQOOOINV
To procedure . . . . . . . : CALLDBMAINTFOROPENOROPTIMIZE
Statement . . . . . . . . . : 4720
Thread . . . . : 0000142F
Message . . . . : Function error X'1720' in machine instruction.
Internal dump identifier (ID)
VLOGS
0600 BADD DATABASE
0200 1720 FUNCTION CHECK
0600 BADD DATABASE
query(UPDATE MAS_STYLE_LIST_MAP_XREF SET MMSX_BATCH_PROC_STAT =
'PROCESSING' WHERE MMSX_MAP_DEF_ID IN ( SELECT MPDF_MAP_DEF_ID
FRO
M MAS_STYLE_LIST_MAP_DEF INNER JOIN MAS_MERCH_DIVISION ON
MMDV_MERCH_DIV_ID = MPDF_MERCH_DIVISION_ID AND
MMDV_BRAND_GRP_ID = : H :
H AND MPDF_MERCH_SEASON_ID = : H : H AND MPDF_THEME_GRP = : H :
H ) AND MMSX_BATCH_PROC_STAT = 'UPDATED' AND MMSX_STATUS =
'INACT
IVE' )
Problem Summary
MCH3203 Escape 60 03/06/17 07:02:12.731680 assert 000004
QQQOOODBOP QSYS *STMT
To module . . . . . . . . . : QQQOOOINV
To procedure . . . . . . . : CALLDBMAINTFOROPENOROPTIMIZE
Statement . . . . . . . . . : 4720
Thread . . . . : 0000142F
Message . . . . : Function error X'1720' in machine instruction.
Internal dump identifier (ID)
VLOGS
0600 BADD DATABASE
0200 1720 FUNCTION CHECK
0600 BADD DATABASE
query(UPDATE MAS_STYLE_LIST_MAP_XREF SET MMSX_BATCH_PROC_STAT =
'PROCESSING' WHERE MMSX_MAP_DEF_ID IN ( SELECT MPDF_MAP_DEF_ID
FRO
M MAS_STYLE_LIST_MAP_DEF INNER JOIN MAS_MERCH_DIVISION ON
MMDV_MERCH_DIV_ID = MPDF_MERCH_DIVISION_ID AND MMDV_BRAND_GRP_ID
= : H :
H AND MPDF_MERCH_SEASON_ID = : H : H AND MPDF_THEME_GRP = : H :
H ) AND MMSX_BATCH_PROC_STAT = 'UPDATED' AND MMSX_STATUS =
'INACT
IVE' )
Problem Conclusion
Internally passed host variables passed may be different access
plan saved version. This causes problems when processing this
variables. Problem may be seen when running an SQL UPDATE SET
statement. Problem has been fixed.
Temporary Fix
Comments
Circumvention
PTFs Available
R710 SI75298 1000
R720 SI64796 7290
R730 SI64962 7283
Affected Modules
Affected Publications
Summary Information
Status............................ CLOSED PERHIPER............................. No
Component......................... 5770SS1DBSI8
Failing Module.................... RCHMGR
Reported Release.................. R710
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