IBM Support

SI77300 - WQX-UNPRED AN EDIT OF A .FEX WITH DEFINE FIELDS MAY RESULT I

PTF Cover Letter


PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

WQX-UNPRED AN EDIT OF A .FEX WITH DEFINE FIELDS MAY RESULT I


Pre/Co-Requisite PTF / Fix List

REQ  LICENSED      PTF/FIX  LEVEL

TYPE PROGRAM  REL  NUMBER   MIN/MAX  OPTION
---- -------- ---  -------  -------  ------
PRE  5733WQX  221  SI78840   NONE     0000
CO   5733WQX  221  SI77307   NONE     0000
CO   5733WQX  221  SI77308   NONE     0000
CO   5733WQX  221  SI77309   NONE     0000
CO   5733WQX  221  SI78886   NONE     0000
CO   5733WQX  221  SI77311   NONE     0000
CO   5733WQX  221  SI77301   NONE     0000
CO   5733WQX  221  SI79243   NONE     0000
CO   5733WQX  221  SI79257   NONE     0000
CO   5733WQX  221  SI79049   NONE     0000
CO   5733WQX  221  SI77136   NONE     0000
CO   5733WQX  221  SI77289   NONE     0000
CO   5733WQX  221  SI78313   NONE     0000
CO   5733WQX  221  SI77291   NONE     0000
CO   5733WQX  221  SI77318   NONE     0000
CO   5733WQX  221  SI77319   NONE     0000
CO   5733WQX  221  SI78294   NONE     0000
CO   5733WQX  221  SI78330   NONE     0000
CO   5733WQX  221  SI79109   NONE     0000
CO   5733WQX  221  SI78349   NONE     0000
CO   5733WQX  221  SI78471   NONE     0000
CO   5733WQX  221  SI78225   NONE     0000
CO   5733WQX  221  SI78226   NONE     0000
CO   5733WQX  221  SI78227   NONE     0000
CO   5733WQX  221  SI78228   NONE     0000
CO   5733WQX  221  SI78843   NONE     0000
CO   5733WQX  221  SI78845   NONE     0000
CO   5733WQX  221  SI78846   NONE     0000
CO   5733WQX  221  SI79071   NONE     0000
CO   5733WQX  221  SI78847   NONE     0000
CO   5733WQX  221  SI77306   NONE     0000
CO   5733WQX  221  SI73887   NONE     0000
CO   5733WQX  221  SI73886   NONE     0000
CO   5733WQX  221  SI73881   NONE     0000
CO   5733WQX  221  SI73880   NONE     0000
CO   5733WQX  221  SI73874   NONE     0000
CO   5733WQX  221  SI73862   NONE     0000
CO   5733WQX  221  SI73859   NONE     0000
CO   5733WQX  221  SI73858   NONE     0000
CO   5733WQX  221  SI73894   NONE     0000
CO   5733WQX  221  SI73899   NONE     0000
CO   5733WQX  221  SI73861   NONE     0000
CO   5733WQX  221  SI73906   NONE     0000
CO   5733WQX  221  SI73907   NONE     0000
CO   5733WQX  221  SI73920   NONE     0000
CO   5733WQX  221  SI73921   NONE     0000
CO   5733WQX  221  SI73935   NONE     0000
CO   5733WQX  221  SI73936   NONE     0000
CO   5733WQX  221  SI73937   NONE     0000
CO   5733WQX  221  SI74240   NONE     0000
CO   5733WQX  221  SI74298   NONE     0000
CO   5733WQX  221  SI74284   NONE     0000
CO   5733WQX  221  SI75141   NONE     0000
CO   5733WQX  221  SI74719   NONE     0000
CO   5733WQX  221  SI73943   NONE     0000
CO   5733WQX  221  SI73537   NONE     0000
CO   5733WQX  221  SI73557   NONE     0000
CO   5733WQX  221  SI73070   NONE     0000
CO   5733WQX  221  SI73071   NONE     0000
CO   5733WQX  221  SI73056   NONE     0000
CO   5733WQX  221  SI72345   NONE     0000
CO   5733WQX  221  SI73538   NONE     0000
CO   5733WQX  221  SI72627   NONE     0000
CO   5733WQX  221  SI73540   NONE     0000
CO   5733WQX  221  SI73057   NONE     0000
CO   5733WQX  221  SI73336   NONE     0000
CO   5733WQX  221  SI73337   NONE     0000
CO   5733WQX  221  SI73358   NONE     0000
CO   5733WQX  221  SI73344   NONE     0000
CO   5733WQX  221  SI73437   NONE     0000
CO   5733WQX  221  SI73413   NONE     0000
CO   5733WQX  221  SI73438   NONE     0000
CO   5733WQX  221  SI73486   NONE     0000
CO   5733WQX  221  SI73567   NONE     0000
CO   5733WQX  221  SI72432   NONE     0000
CO   5733WQX  221  SI71482   NONE     0000
CO   5733WQX  221  SI71693   NONE     0000
CO   5733WQX  221  SI71893   NONE     0000
CO   5733WQX  221  SI71695   NONE     0000
CO   5733WQX  221  SI71820   NONE     0000
CO   5733WQX  221  SI71159   NONE     0000
CO   5733WQX  221  SI71257   NONE     0000
CO   5733WQX  221  SI71110   NONE     0000
CO   5733WQX  221  SI70376   NONE     0000
CO   5733WQX  221  SI70375   NONE     0000
CO   5733WQX  221  SI70335   NONE     0000
CO   5733WQX  221  SI70423   NONE     0000
CO   5733WQX  221  SI70382   NONE     0000
CO   5733WQX  221  SI71492   NONE     0000
CO   5733WQX  221  SI70965   NONE     0000
CO   5733WQX  221  SI70954   NONE     0000
CO   5733WQX  221  SI71320   NONE     0000
CO   5733WQX  221  SI69110   NONE     0000
CO   5733WQX  221  SI66589   NONE     0000
CO   5733WQX  221  SI66632   NONE     0000
CO   5733WQX  221  SI66633   NONE     0000
CO   5733WQX  221  SI66634   NONE     0000
CO   5733WQX  221  SI66592   NONE     0000
CO   5733WQX  221  SI66590   NONE     0000
CO   5733WQX  221  SI66591   NONE     0000
CO   5733WQX  221  SI66635   NONE     0000
CO   5733WQX  221  SI69337   NONE     0000
CO   5733WQX  221  SI69467   NONE     0000
CO   5733WQX  221  SI69459   NONE     0000
CO   5733WQX  221  SI69550   NONE     0000
CO   5733WQX  221  SI68841   NONE     0000
CO   5733WQX  221  SI68918   NONE     0000
CO   5733WQX  221  SI69113   NONE     0000
CO   5733WQX  221  SI68470   NONE     0000
CO   5733WQX  221  SI67928   NONE     0000
CO   5733WQX  221  SI67933   NONE     0000
CO   5733WQX  221  SI67896   NONE     0000
CO   5733WQX  221  SI68511   NONE     0000
CO   5733WQX  221  SI68531   NONE     0000
CO   5733WQX  221  SI68571   NONE     0000
CO   5733WQX  221  SI67310   NONE     0000
CO   5733WQX  221  SI67468   NONE     0000
CO   5733WQX  221  SI67546   NONE     0000
CO   5733WQX  221  SI67547   NONE     0000
CO   5733WQX  221  SI67790   NONE     0000
CO   5733WQX  221  SI67830   NONE     0000
CO   5733WQX  221  SI66608   NONE     0000
CO   5733WQX  221  SI66794   NONE     0000
CO   5733WQX  221  SI66805   NONE     0000
CO   5733WQX  221  SI67115   NONE     0000
CO   5733WQX  221  SI67203   NONE     0000
CO   5733WQX  221  SI66218   NONE     0000
CO   5733WQX  221  SI66481   NONE     0000



NOTICE:
-------
Application of this PTF may disable or render ineffective programs that
use system memory addresses not generated by the IBM translator,
including programs that circumvent control technology designed to limit
interactive capacity to purchased levels.  This PTF may be a prerequisite
for future PTFs.  By applying this PTF you authorize and agree to the
foregoing.

This PTF is subject to the terms of the license agreement which
accompanied, or was contained in, the Program for which you are obtaining
the PTF.  You are not authorized to install or use the PTF except as part
of a Program for which you have a valid Proof of Entitlement.

SUBJECT TO ANY WARRANTIES WHICH CAN NOT BE EXCLUDED OR EXCEPT AS EXPLICITLY
AGREED TO IN THE APPLICABLE LICENSE AGREEMENT OR AN APPLICABLE SUPPORT
AGREEMENT, IBM MAKES NO WARRANTIES OR CONDITIONS EITHER EXPRESS OR IMPLIED,
INCLUDING BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OR CONDITIONS OF
MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, AND NON INFRINGEMENT,
REGARDING THE PTF.

The applicable license agreement may have been provided to you in printed
form and/or may be viewed using the Work with Software Agreements (WRKSFWAGR)
CL command.





APAR Error Description / Circumvention

-----------------------------------------------
This PTF provides a portion of the proddata refresh for DB2 Web
Query 2.2.1 Hotfix 13.

CORRECTION FOR APAR SE76281 :
-----------------------------
This PTF provides a portion of the proddata refresh for DB2 Web
Query 2.2.1 Hotfix 13.

CIRCUMVENTION FOR APAR SE76281 :
--------------------------------
None.


DESCRIPTION OF PROBLEM FIXED FOR APAR SE75844 :
-----------------------------------------------
When editing an Web Query .fex with DEFINE fields may result in
those DEFINE fields not being found

CORRECTION FOR APAR SE75844 :
-----------------------------
This is fixed in 2.2.1 group PTF level 13.

CIRCUMVENTION FOR APAR SE75844 :
--------------------------------
None.


DESCRIPTION OF PROBLEM FIXED FOR APAR SE77146 :
-----------------------------------------------
Reports using Excel synonyms will not load and do not prompt for
parameters. Canceling the report results in the following
Autoprompt error:

Error Occurred During Autoprompt Processing

<You Synonym Name>

Bad XML Exception: (Error: Agent terminated by Operator)

CORRECTION FOR APAR SE77146 :
-----------------------------
This is fixed in 2.2.1 group PTF level 13.

CIRCUMVENTION FOR APAR SE77146 :
--------------------------------
None.


Activation Instructions


None.




Special Instructions


End Web Query server before applying the PTF.

********************************************************************
THE FOLLOWING ARE SUPERSEDED SPECIAL INSTRUCTIONS. IF THE SUPERSEDED
PTF HAS ALREADY BEEN APPLIED AND ITS SPECIAL INSTRUCTION FOLLOWED,
IT IS NOT NECESSARY TO FOLLOW THAT SPECIAL INSTRUCTION AGAIN.
********************************************************************

SPECIAL INSTRUCTIONS FOR SUPERSEDED PTF SI70559 :
=================================================

End Web Query server before applying the PTF.

This PTF, included in Web Query group PTF level 7, introduces a
redesigned user interface for the Reporting Server. The interface for
creating and editing metadata, adding adapter connections, and
uploading data has been modernized. Please see the New Features
document at http://ibm.biz/wq-newfeatures for details on the new
interface and for other changes in behavior.


Default Instructions

THIS PTF CAN BE APPLIED IMMEDIATE OR DELAYED.



Supersedes

PTF/FIX NO(S).  APAR TITLE LINE
--------------  ------------------------------------------------------------
   SI76012      WQX-UNPRED WEB QUERY USING SSO MAY ENCOUNTER A REPORTING SER
   SI76012      WQX-UNPRED WEB QUERY MAY NOT CORRECTLY HANDLE DATE AND TIME
   SI76012      WQX-UNPRED WEB QUERY MAY NOT PROCESS DBCS DATA CORRECTLY
   SI76012      WQX-UNPRED "THIS SERVER REQUIRES AUTHENTICATION" ONCE SET TH
   SI76012      WQX-UNPRED THE DESCRIPTIONS OF FIELDS BELONGING TO A TAB ARE
   SI76012      A HOLD FILE OF WEB QUERY MAY NOT HAVE THE SAME OUTPUT COLUMN
   SI76012      WQX-UNPRED A WEB QUERY BUSINESS VIEW MAY HAVE ISSUES AFTER A
   SI76012      WQX-UNPRED WITHIN INFOASSIST AN OPTIONAL ATTRIBUTE ON A FILT
   SI76012      WQX-v221-HF10.2021 DB2 Web Query 2.2.1 Hotfix 10
   SI73288      WQX-v221-HF9.2020 DB2 Web Query 2.2.1 Hotfix 9
   SI73288      WQX-UNPRED A WEB QUERY REPORT MAY ENCOUNTER AN ERROR CODE: I
   SI73288      WQX-UNPRED WEB QUERY INFOASSIST EDIT MISSING FIELDS
   SI73288      WQX-PERFM WEB QUERY IS REALLY SLOW
   SI73288      OSP-UNPRED FOC1113 INVALID CONTROL COMMAND. IBFSEXCEPTION 60
   SI73288      WQX-PERFM AFTER HF7 ACCESSING META DATA PANELS TAKES MORE TH
   SI72563      WQX-UNPRED WEB QUERY WITH SOME WEB BROWSERS MAY NOT SHOW PUL
   SI72563      WQX-INCORROUT OLAP REPORT TABS NOT DISPLAYING CORRECTLY
   SI72563      WQX JVAB56D - JAVA/LANG/OUTOFMEMORYERROR - HEAP LEAK
   SI72563      OSP-UNPRED UNABLE TO SELECT A DEFINED FIELD
   SI72563      WQX-INCORROUT SPELLNUM "ZERO DOLLARS AND NO CENTS" AFTER HF7
   SI72563      OSP-UNPRED UNABLE TO CREATE SQL REPORTS DUE TO ERROR FOC205
   SI72563      WQX APPLYING SF99433-7 CAUSE PTF DAMAGE IN JAPANESE DBCS SYS
   SI72563      WQX-UNPRED INFOASSIST AUTO SAVE FREQUENTLY
   SI72563      WQX-UNPRED METADATA SEEMS TO BE REJECTING FIELDS WITH $ OR #
   SI72563      OSP-UNPRED UNABLE TO USE DROP DOWN BOXES ON THE FILTER PANEL
   SI72563      WQX-UNPRED WHEN TRYING TO START DB2 WEB QUERY FOR IBM I A JA
   SI72563      WQX-v221-HF8.2020 DB2 Web Query 2.2.1 Hotfix 8
   SI70559      WQX-v221-HF7.2019 DB2 Web Query 2.2.1 Hotfix 7
   SI70559      WQX-UNPRED SINCE R221 HOTFIX 6, IF YOU START THE PREFIX WITH
   SI70559      WQX-MSGFOC210 WHEN CHART IS SCHEDULED IN A GERMAN ENVIRONMEN
   SI70559      WQX-INCORROUT INFO ASSIST FAILS TO OPEN REPORT CONTAINING A
   SI70559      WQX-UNPRED EXISTING REPORTS MAY NOT OPEN WITH INFOASSIST AFT
   SI70559      WQX-UNPRED REPORT PROPERTIES MAY NOT SHOW DETAILS TAB
   SI70559      WQX-UNPRED XFDMINIT IA_190801_18006-1 WITH WEB QUERY
   SI70559      WQX-UNPRED UNABLE TO EDIT MIGRATED REPORTS IN INFOASSIST
   SI70559      WQX-UNPRED WEB QUERY ISSUE
   SI70559      WQX-UNPRED WEB QUERY - DATAMIGRATOR - ERROR ON FLOW
   SI70559      WEB QUERY DATAMIGRATOR WITH DATES
   SI70559      WQX-UNPRED DIMENSIONS NOT SHOWN IN NEW BI PORTAL REPORT AFTE
   SI70559      WQX WQ 221 - AN EXTRA "A" IS ADDED TO A NEW CREATED SYNONYM.
   SI70559      WQX WEBQUERY RUNNING IN CODEPAGE 37 ENVIRONMENT WITH JAPANES
   SI69286      WQX-v221-HF6.2019 DB2 Web Query 2.2.1 Hotfix 6
   SI69286      WQX-INCORROUT POPUP ERROR SAVING CANNOT BE COMPLETED
   SI69286      WQX-INCORROUT HTML REPORT WITH DYNAMIC AUTO PROMPT LISTBOX E
   SI69286      WQX-UNPRED A FILTERED OLAP REPORT MAY FAIL WITH A HARD KILL
   SI69286      OSP-INCORROUT UNABLE TO ACCESS PARAMETERS IN INFOASSIST.
   SI69286      WQX-UNPRED A BUSINESS VIEW OVER A SYNONYM WHERE THERE IS A D
   SI69286      WQX-UNPRED A WEB QUERY REPORT MAY SHOW A "THERE ARE TOO MANY
   SI68973      DB2 Web Query 2.2.1 fix
   SI67971      WQX-v221-HF5.2018 DB2 Web Query 2.2.1 Hotfix 5
   SI67971      AN EXISTING DASHBOARD MAY ENCOUNTER AN ERROR WHEN EDITING AF
   SI67971      WQX-INCORROUT DAY AND MONTH-NAMES NOT TRANSLATED TO GERMAN
   SI67971      OSP-INCORROUT MULTISELECT DYNAMIC PARAMETERS WITH FILTER FUN
   SI67971      WQX-UNPRED A SAVE REPORT OPTION IS MISSING WITH WEB QUERY 2.
   SI67971      WEB QUERY OLAP ISSUES WITH TABBED DIMENSIONS
   SI67971      WQX-UNPRED THERE IS A PROBLEM WITH DATE DECOMPOSITION WHILE
   SI67836      WQX-v221-HF3.2018 DB2 Web Query 2.2.1 Hotfix 3
   SI67836      OSP RUNTIME USER IS UNABLE TO APPEND TO A FILE THROUGH WQRAX
   SI67836      WQX-UNPRED WEB QUERY USER MAY NOT BE ABLE TO REMOVE
   SI67836      OSP JOB SCHEDULING COMPONENT ERRORS
   SI67836      WQX-UNPRED WEB QUERY AND EXCEL MAY NOT SHOW DROP DOWN LIST
   SI67836      WQX-INCORROUT DWB HTML REPORT REQUESTS RENAMED ON UPGRADE AN
   SI67836      WQX-UNPRED A WEB QUERY MAP MAY NOT DISPLAY CORRECTLY
   SI67836      WQX DYNAMIC LANGUAGES MISSING AFTER MIGRATION TO R221
   SI67048      WQX-v221-HF2.2018 DB2 Web Query 2.2.1 Hotfix 2
   SI67048      WQX SYNONYM EDITOR RETURN: FAILED TO LOAD, SERVER MAY BE DOW
   SI67048      WQX-INCORROUT SCHEDULE WITH EXCEL ATTACHMENT WILL CORRUPT FI
   SI66209      WQX-v221-HF1.2017 DB2 Web Query 2.2.1 Hotfix 1
   SI66209      WQX-INCORROUT OPENING A REPORT FROM MANAGE PRIVATE RESOURCES

Summary Information

System..............................i
Models..............................
Release.............................V2R2M1
Licensed Program...............5733WQX
APAR Fixed..........................View details for APAR SE76281
View details for APAR SE75844
View details for APAR SE77146
Superseded by:......................
Recompile...........................N
Library.............................QWEBQRY
MRI Feature ........................NONE
Cum Level...........................


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 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.

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"2.2.1","Product":{"code":"SWG60","label":"IBM i"},"Component":"5733WQX","Edition":"","Line of Business":{"code":"LOB57","label":"Power"}}]

Document Information

Modified date:
30 March 2022