Querying Change Requests (CR) with modify_time set to beyond year 2038 fetches all the CRs in Rational Change

Technote (troubleshooting)


Problem(Abstract)

Attempts to query Change Requests with modify_time set to beyond year 2038 fetches all the CRs in IBM Rational Change.

Symptom

Steps to reproduce:

Run the following query in Rational Change user interface:

(cvtype='problem') and (modify_time>time('01/01/2039 0:00:00'))  

This fetches all the Change Request created in Rational Change.

Setting the modify date to year 2039 in a CR query fetches all the CR's whereas when set to year before 2039, it does show any result in the query output.

Cause

This is a side effect of a limitation in the underlying Rational Synergy database which stores all dates as signed 32-bit integers. Dates after 2038 are not valid.

Resolving the problem

This is working as designed.

Related information

Year_2038_problem wiki

Rate this page:

(0 users)Average rating

Document information


More support for:

Rational Change
General Information

Software version:

5.2, 5.2.0.1, 5.2.0.2, 5.2.0.3, 5.2.0.4, 5.2.0.5, 5.2.0.6

Operating system(s):

Windows

Reference #:

1595637

Modified date:

2012-05-18

Translate my page

Machine Translation

Content navigation