PM74838: CQWeb: Date field values are not displayed in query resultsset if Web server on a non-English OS

Rational ClearQuest Fix Pack 09 (7.1.2.9) for 7.1.2
Rational ClearQuest Fix Pack 05 (8.0.0.5) for 8.0
Rational ClearQuest Fix Pack 14 (7.1.2.14) for 7.1.2
Rational ClearQuest Fix Pack 11 (8.0.0.11) for 8.0
Rational ClearQuest Fix Pack 12 (8.0.0.12) for 8.0
Rational ClearQuest Fix Pack 15 (7.1.2.15) for 7.1.2
Rational ClearQuest Fix Pack 13 (8.0.0.13) for 8.0
Rational ClearQuest Fix Pack 16 (7.1.2.16) for 7.1.2
Rational ClearQuest Fix Pack 17 (7.1.2.17) for 7.1.2
Rational ClearQuest Fix Pack 14 (8.0.0.14) for 8.0
Rational ClearQuest Fix Pack 18 (7.1.2.18) for 7.1.2
Rational ClearQuest Fix Pack 15 (8.0.0.15) for 8.0
Rational ClearQuest Fix Pack 19 (7.1.2.19) for 7.1.2
Rational ClearQuest Fix Pack 16 (8.0.0.16) for 8.0
Rational ClearQuest Fix Pack 17 (8.0.0.17) for 8.0
Rational ClearQuest Fix Pack 18 (8.0.0.18) for 8.0
Rational ClearQuest Fix Pack 19 (8.0.0.19) for 8.0
Rational ClearQuest Fix Pack 20 (8.0.0.20) for 8.0
Rational ClearQuest Fix Pack 21 (8.0.0.21) for 8.0

APAR status

• Closed as program error.

Error description

• Date fields values are not displayed in query resultsset if CQ
  Web server is on a non-English OS, example: German. This
  behavior is only on CQWeb client. Date fields values are
  displayed as expected on the query resultset on both Eclipse and
  Windows clients.
  
  Steps to reproduce:
  1- Install CQWeb server v. 8.0.0.4 on a non English OS; i.e.
  German (Windows and/or Linux)
  2- Add to the DefectTracking schema on the Defect record a date
  field called 'Date'
  3- Modify or submit record(s) to fill in the date field with
  values
  4- Create a query to display the following fields:
  id, Headline, Date
  5- Run the query on the CQWeb client (any browser; IE or FF)
  The query resultset shows only values in the: id and Headline
  fields but empty value in Date column
  see attached screenshots and CQtrace during running the queries
  on both browsers, IE and FF
  
  If resultset is exported, the field value is exported in the
  file. see attached
  If CQWeb on Linux and the date field is included in the table of
  a reference list the following error is shown:
       Unparseable date: 'Do. Mai 31 16:05:48 Mitteleurop?ische
  Sommerzeit 2012'
  
  This was working as expected until 8.0.0.3.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Date field values are not displayed in a query result set if
  the ClearQuest Web server is on certain non-English
  operating systems such as German or French.
  

Problem conclusion

• A fix is available in ClearQuest 7.1.2.9 and 8.0.0.5.
  
  ClearQuest Web date field values now display in query result
  sets on all locales.
  

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:

Fix information

• Fixed component name

  CLEARQUEST WIN

• Fixed component ID

  5724G3600

Applicable component levels

• R800 PSN

     UP