Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-21746

Insane but technically valid values in the datevalue field of the customfieldvalue table

    XMLWordPrintable

Details

    Description

      The datevalue field of the customfieldvalue table occasionally contains values such as 0008-06-13 10:09:24-05:50:36 which, while technically valid, send JIRA into conniptions and cause pre-upgrade backups to fail with messages such as this:

      org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while
getting value:  (Bad value for type timestamp : 0008-06-1310:09:24-05:50:36)
org.postgresql.util.PSQLException: Bad value for type timestamp :0008-06-13 10:09:24-05:50:36
Caused by: java.lang.NumberFormatException: Trailing junk on timestamp: ''
       at org.postgresql.jdbc2.TimestampUtils.loadCalendar(TimestampUtils.java:226)

      Even if we can't do anything about external libraries choking on the retrieve values, can we add some validation logic to ensure the correct value is stored?

      Attachments

        Issue Links

          duplicates

          Bug - A problem which impairs or prevents the functions of the product. JRASERVER-20117 UI allows entry of invalid dates which causes errors

          • Medium - Medium priority issues
          • Gathering Impact

          Bug - A problem which impairs or prevents the functions of the product. JRASERVER-21366 Cannot index Customfield Datepicker with date < 1970

          • Medium - Medium priority issues
          • Gathering Impact
          relates to

          Bug - A problem which impairs or prevents the functions of the product. JRASERVER-21366 Cannot index Customfield Datepicker with date < 1970

          • Medium - Medium priority issues
          • Gathering Impact

          Activity

            People

              Unassigned Unassigned
              jfleming James Fleming (Inactive)
              Votes:
              4 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: