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

Invalid date format specified in CSV Importer is not being handled consistently

    XMLWordPrintable

Details

    Description

      Steps to reproduce:

      1. Download the attached CSV file and configuration file
      2. Import into JIRA by using CSV Importer

      The invalid date format exception will be thrown in the first time when importing the data.

      2008-01-16 16:36:56,564 Thread-33 INFO [imports.importer.impl.ImportLogger] ************************************************************** (0.0s)
      2008-01-16 16:36:56,564 Thread-33 INFO [imports.importer.impl.ImportLogger] IMPORTING STARTED (0.0s)
      2008-01-16 16:36:56,564 Thread-33 INFO [imports.importer.impl.ImportLogger] ************************************************************** (0.0s)
      2008-01-16 16:36:56,564 Thread-33 INFO [imports.importer.impl.ImportLogger]
       (0.0s)
      2008-01-16 16:36:56,564 Thread-33 INFO [imports.importer.impl.ImportLogger] Importing with ImportBeanType: com.atlassian.jira.imports.csv.CsvDataBean (0.0s)
      2008-01-16 16:36:56,564 Thread-33 INFO [imports.importer.impl.ImportLogger]
       (0.0s)
      2008-01-16 16:36:56,565 Thread-33 INFO [imports.importer.impl.ImportLogger] -------------------------- (0.0010s)
      2008-01-16 16:36:56,565 Thread-33 INFO [imports.importer.impl.ImportLogger] Importing of Users started (0.0010s)
      2008-01-16 16:36:56,565 Thread-33 INFO [imports.importer.impl.ImportLogger] Only new Users will be imported (0.0010s)
      2008-01-16 16:36:56,565 Thread-33 INFO [imports.importer.impl.ImportLogger] FAILED: Unexpected failure occurred. Importer will stop immediately. Data maybe in an unstable state (0.0010s)
      2008-01-16 16:36:56,566 Thread-33 INFO [imports.importer.impl.ImportLogger] java.lang.IllegalArgumentException: Illegal pattern character 'Y'
              at java.text.SimpleDateFormat.compile(SimpleDateFormat.java:678)
              at java.text.SimpleDateFormat.initialize(SimpleDateFormat.java:497)
              at java.text.SimpleDateFormat.<init>(SimpleDateFormat.java:446)
              at java.text.SimpleDateFormat.<init>(SimpleDateFormat.java:427)
              at com.atlassian.jira.imports.csv.PropertiesCsvMapper.init(PropertiesCsvMapper.java:50)
              at com.atlassian.jira.imports.csv.MindProdCsvProvider.startSession(MindProdCsvProvider.java:48)
              at com.atlassian.jira.imports.csv.CsvDataBean.populateCache(CsvDataBean.java:122)
              at com.atlassian.jira.imports.csv.CsvDataBean.refreshCache(CsvDataBean.java:105)
              at com.atlassian.jira.imports.csv.CsvDataBean.getUsers(CsvDataBean.java:251)
              at com.atlassian.jira.imports.importer.impl.DefaultJiraDataImporter.importUsers(DefaultJiraDataImporter.java:223)
              at com.atlassian.jira.imports.importer.impl.DefaultJiraDataImporter.doImport(DefaultJiraDataImporter.java:94)
              at com.atlassian.jira.imports.importer.impl.ImporterThread.run(ImporterThread.java:21)
       (0.0020s)
      2008-01-16 16:36:56,566 Thread-33 INFO [imports.importer.impl.ImportLogger] Flushing issue cache (0.0020s)
      2008-01-16 16:36:56,574 Thread-33 INFO [imports.importer.impl.ImportLogger] No issues need to be reindexed. (0.0090s)
      2008-01-16 16:36:56,574 Thread-33 INFO [imports.importer.impl.ImportLogger]
       (0.01s)
      2008-01-16 16:36:56,574 Thread-33 INFO [imports.importer.impl.ImportLogger] ************************************************************** (0.01s)
      2008-01-16 16:36:56,574 Thread-33 INFO [imports.importer.impl.ImportLogger] IMPORTING FINISHED (0.01s)
      2008-01-16 16:36:56,574 Thread-33 INFO [imports.importer.impl.ImportLogger] ************************************************************** (0.01s)
      

      3. Try to run the CSV Importer again with the same files (without making any changes to the date format). There is no invalid date format exception being thrown.

      2008-01-16 16:37:20,981 Thread-36 INFO [imports.importer.impl.ImportLogger] ************************************************************** (0.0s)
      2008-01-16 16:37:20,981 Thread-36 INFO [imports.importer.impl.ImportLogger] IMPORTING STARTED (0.0s)
      2008-01-16 16:37:20,981 Thread-36 INFO [imports.importer.impl.ImportLogger] ************************************************************** (0.0s)
      2008-01-16 16:37:20,981 Thread-36 INFO [imports.importer.impl.ImportLogger]
       (0.0s)
      2008-01-16 16:37:20,981 Thread-36 INFO [imports.importer.impl.ImportLogger] Importing with ImportBeanType: com.atlassian.jira.imports.csv.CsvDataBean (0.0s)
      2008-01-16 16:37:20,982 Thread-36 INFO [imports.importer.impl.ImportLogger]
       (0.0010s)
      2008-01-16 16:37:20,982 Thread-36 INFO [imports.importer.impl.ImportLogger] -------------------------- (0.0010s)
      2008-01-16 16:37:20,982 Thread-36 INFO [imports.importer.impl.ImportLogger] Importing of Users started (0.0010s)
      2008-01-16 16:37:20,982 Thread-36 INFO [imports.importer.impl.ImportLogger] Only new Users will be imported (0.0010s)
      2008-01-16 16:37:20,982 Thread-36 INFO [imports.importer.impl.ImportLogger] 0 users associated with import. (0.0010s)
      2008-01-16 16:37:20,982 Thread-36 INFO [imports.importer.impl.ImportLogger] 0 users successfully imported. (0.0010s)
      2008-01-16 16:37:20,982 Thread-36 INFO [imports.importer.impl.ImportLogger] Importing of Users finished (0.0010s)
      2008-01-16 16:37:20,982 Thread-36 INFO [imports.importer.impl.ImportLogger] --------------------------- (0.0010s)
      2008-01-16 16:37:20,983 Thread-36 INFO [imports.importer.impl.ImportLogger] Retrieving projects... (0.0020s)
      2008-01-16 16:37:20,983 Thread-36 INFO [imports.importer.impl.ImportLogger] No projects were found to import (0.0020s)
      2008-01-16 16:37:20,983 Thread-36 INFO [imports.importer.impl.ImportLogger] Flushing issue cache (0.0020s)
      2008-01-16 16:37:20,986 Thread-36 INFO [imports.importer.impl.ImportLogger] No issues need to be reindexed. (0.0050s)
      2008-01-16 16:37:20,986 Thread-36 INFO [imports.importer.impl.ImportLogger]
       (0.0050s)
      2008-01-16 16:37:20,986 Thread-36 INFO [imports.importer.impl.ImportLogger] ************************************************************** (0.0050s)
      2008-01-16 16:37:20,986 Thread-36 INFO [imports.importer.impl.ImportLogger] IMPORTING FINISHED (0.0050s)
      2008-01-16 16:37:20,987 Thread-36 INFO [imports.importer.impl.ImportLogger] ************************************************************** (0.0060s)
      

      This behavior is quite weird. The problem should be handled more consistently.

      Attachments

        1. conf.txt
          0.4 kB
        2. test.csv
          0.1 kB

        Activity

          People

            Unassigned Unassigned
            cychan Chai Ying Chan [Atlassian]
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: