-
Type:
Bug
-
Resolution: Unresolved
-
Priority:
Low
-
Affects Version/s: 5.12.29, 10.3.13, 11.2.0
-
Component/s: Assets - Object, Type and Schema
-
Severity 3 - Minor
Issue Summary
When conducting an assets import, integers representing a datetime parsed using Windows NT time format do not retain the two most significant digits of the year; any year is set to 20xx, even if the provided year does not match the 20 prefix.
Steps to Reproduce
- Adjust your Jira look and feel datetime format to have a four digit year (to allow you to see the incorrect year)

- Create a new empty assets object schema and assets object type, which includes a new attribute of type 'DateTime'

- Construct a csv with the following content
name,integer_datetime_representation
"Test Object",638292024000000000

(Representing a date in year 3623 when parsed using WindowsNT datetime format)
- Create a new csv import configuration for the new assets object schema, uploading the above csv file (all other configuration can remain unchanged).

- Create an object type mapping to the new csv import (all configuration in the create modal can remain default), set data locators and matching assets attributes after creation.

- Run a sync.


- Review the newly imported assets object.
Actual Results
Imported assets object shows a date in 2023.

(note this server is configured with UTC timezone)
Expected Results
Imported asset object should show a date in 3623.

(note this server is configured with timezone offset of GMT +09:00)
Workaround
Currently there is no known workaround for this behavior. A workaround will be added here when available
Versions Tested
Please confirm all versions that have been tested for this issue, and indicate whether the tested version is affected or not affected, below:
| Testing Requirements | Version | Affected Version |
|---|---|---|
| Customers Reported Version | ||
| Most Recent Bug-Fix Release | ||
| Previous Major Release | ||
| Most Recent LTS | 11.3.0 | No |
| Previous Supported LTS | 10.3.13 | Yes |
| Previous Supported LTS | 5.12.29 | Yes |
| Other Versions.. | 11.2.0 | Yes |
| (Add rows as needed) |
- relates to
-
JSDSERVER-16315 Epoch format date values imported from a database into asset object attributes are incorrect
-
- Closed
-
-
JSDSERVER-16451 When conducting an assets import, integers representing a datetime in Unix Epoch time format with nanosecond precision are incorrectly parsed using the WindowsNT datetime parser
-
- Gathering Impact
-
- Testing discovered
-
JRASERVER-31291 2-digit year on Jira Date Picker converted to 1900 if 20 years or more in the future
-
- Closed
-
- links to
- mentioned in
-
Page Loading...