Uploaded image for project: 'JBoss BPMS Platform'
  1. JBoss BPMS Platform
  2. RHBPMS-4232

Tasks List shows incorrect time in CreatedOn column when running on Oracle database

XMLWordPrintable

    • ER2
    • Hide

      1. Run the EAP server with the Oracle database.
      2. Switch to Tasks perspective.
      3. Create several ad-hoc tasks.
      Expected result: CreatedOn time in the new task matches the current system time.
      Actual result: The hours of the CreatedOn match the system time, but the minutes are seamingly random number between 0 and 60. This also affects sorting (tasks are not sorted correctly).

      Show
      1. Run the EAP server with the Oracle database. 2. Switch to Tasks perspective. 3. Create several ad-hoc tasks. Expected result: CreatedOn time in the new task matches the current system time. Actual result: The hours of the CreatedOn match the system time, but the minutes are seamingly random number between 0 and 60. This also affects sorting (tasks are not sorted correctly).

      After creation of a new task in the Tasks perspective, the CreatedOn column shows incorrect time (e.g. task created on 14:16 shows time 14:32 and another task created at the same time shows time 14:29). Moreover, after sorting in the CreatedOn column the tasks are not sorted correctly. More in the attachment (note that all tasks were created within several seconds).

      This is problem specific for Oracle database. Sorting on CreatedOn date on all other databases works correctly.

              david.magallanes David Gutierrez
              lpetrovi@redhat.com Lukáš Petrovický (Inactive)
              Jan Hrcek Jan Hrcek (Inactive)
              Jan Hrcek Jan Hrcek (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated:
                Resolved: