PH19076: CICS: UNABLE TO FILTER CICS REGIONS ON START UP DATE IN CICS EXPLORER

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When using the CICS Explorer "Regions" view, there is a column
  showing the region's Startup Date. But when trying to create a
  quick filter for one of the values, this results in an empty
  view and error message:
  .
   CNX0226W A filter contained an
  invalid value.
  .
  
  As a side note, when looking at the general
  help for this field, it states: "The date is expressed in local
  time."
  .
  This apar is being raised to address this from the
  CICS server side in addition to the CICS Explorer apar IJ18172.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: CICSPlex SM V5R5M0 users.                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: The CMCI GraphQL interface returns      *
  *                      clock unit time attributes in the       *
  *                      format "0:00:00.000000 - 0". The        *
  *                      startup time attribute for a CICS       *
  *                      Region is returned in the format        *
  *                      "yyyy-mm-dd". In both cases a different *
  *                      format is required when used as input   *
  *                      in a query filter.                      *
  *                      When attempting to filter using these   *
  *                      attributes, the user will see the error *
  *                      "CNX0220E A connection error has        *
  *                      occurred: Query partially failed with   *
  *                      error responses" and the query will     *
  *                      fail.                                   *
  *                      This would occur for any client using   *
  *                      the CMCI GraphQL interface, for example *
  *                      CICS Explorer when using the            *
  *                      aggregation feature.                    *
  ****************************************************************
  * RECOMMENDATION: After applying the PTF which resolves        *
  *                 PH19076, all CICSplex SM V5R5M0 WUI servers  *
  *                 should be restarted.                         *
  ****************************************************************
  When applying a filter on a clock unit time value, CPSM requires
  the time to be formatted without the period information. If the
  filter is provided with period information, the GraphQL query
  returns an error similar to this:
  "Exception while fetching data (/cicsplex/cicsResources/task) :
  Response was FAILED, EXCEPTION"
  .
  
  When applying a filter on Region startup time, CPSM requires the
  time to be formatted as yyyy/ddd (year and day of the year). The
  CMCI GraphQL server application does not translate input into
  this format, so queries specifying a filter value for region
  startup time will return an error similar to this:
  "Exception while fetching data (/cicsplex/cicsResources/cicsrgn)
  : Response was INVALIDATA, CRITERIA"
  .
  CICS Explorer uses should also apply CICS Explorer APAR IJ18172
  to correct similar queries issued by the Explorer.
  
  Additional Keywords:
  SixteenMSDataType ClockUnitsDataType
  SClockDataType Sclock12DataType
  microseconds seconds packed_decimal_seconds sixteen_ms
  clock_units
  

Problem conclusion

• The CMCI JVM server has been modified to return the correct
  format for clock unit time attributes, and to translate the
  displayed region startup time values into the correct format
  for filtering, when responding to GraphQL requests.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UI67092

Modules/Macros

• DFJ@H531 DFJ@H532 DFJ@H533
  

Fix information

• Fixed component name

  CICS TS Z/OS V5

• Fixed component ID

  5655Y0400

Applicable component levels

• R200 PSY UI67092

     UP19/12/19 P F912

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.