PM76855: Date format for query result set may not display due or produce status 500 error on localized CMservers, affecting OSLC/REST

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

• When working with date_time field values in IBM Rational
  ClearQuest over OSLC, the Date format for query result set may
  not display or produce status 500 errors on CM Servers that are
  localized to non-English numbering systems when using OSLC/REST.
  
  To reproduce:
  1. On any Windows host that has ClearQuest Web 7.1.2.8
  installed, change the locale [Windows Control Panels ? Windows
  Regional and Language Options ? Standards and formats setting]
  to French (Canada), Chinese, German, etc.
  Note: The long date format has no 'day in week' in it.
  2. Restart CM Server.
  3. Send an OSLC request to retrieve a date_time field, such as
  Submit_Date of a Defect record.
  4. The response contains the error in French Canadian for
  example:
  ?message?Unparseable date: 'jeu. juin 15 00:00:00 Heure avanc?e
  de l?Est (?UA) 2000'?/message?
  
  The symptom in Chinese, Korean and other language systems is the
  same, but the date string is translated into the corresponding
  language. So the date string in the error message has the same
  format which is '(day in week/name), month/name (day in month)
  time (time zone) year'. Such format is not used in either China,
  Korea, French Canadian, etc.
  
  Workaround if English is acceptable:
  1. On Windows, set the locale to English(US) before starting up
  CM Server.
  2. On Linux, set LC_ALL=en_US.utf8 before starting up CM Server.
  3. On both Windows and Linux, add WebSphere JVM parameter
  '-Duser.language=en -Duser.region=US' via Application servers ?
  server1 ? Process Definition ? Java Virtual Machine ? General
  JVM parameters.
  
  Changing the locale (on Linux setting LC_ALL=en_US.utf8) also
  changes the error messages from CM Server to English (which may
  or may not be acceptable).
  
  Looking back at past versions:
  Desired behavior in CQ 7.1.2.3 with French Canadian locale:
  ?cq:Submit_Date?2000-06-15T04:00:00Z?/cq:Submit_Date?
  
  Problem in 7.1.2.8:
  ?Error?
          ?message?Unparseable date: 'jeu. juin 15 00:00:00 Heure
  avanc?e de l?Est (?UA) 2000'?/message?
          ?statusCode?500?/statusCode?
  ?/Error?
  
  The following example OSLC request can be used to reproduce the
  issue against the SAMPL Defect Tracking Database:
  http://host/cqweb/oslc/repo/7.0.0/db/SAMPL/simpleQuery/16777224?
  oslc.select=cq:Submit_Date
  ??Look for the statusCode/error.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  ClearQuest Web users on some non-English locales receive a
  error message when requesting a date time field using a OSLC
  request like the following:
  "http://9.32.253.123/cqweb/oslc/repo/7.0.0/db/SAMPL/simpleQu
  ery/16777224?oslc.select=cq:Submit_Date"
  

Problem conclusion

• A fix is available in ClearQuest 7.1.2.9 and 8.0.0.5.
  
  When calling OSLC requests as in the above example,
  ClearQuest Web query result sets are correctly displayed 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 UNIX

• Fixed component ID

  5724G3601

Applicable component levels

• R712 PSN

     UP