Uploaded image for project: 'camunda BPM'
  1. camunda BPM
  2. CAM-2445

HumanTasks older than 24 days in stored in MSSQLServer lost forever

XMLWordPrintable

    • Icon: Bug Report Bug Report
    • Resolution: Cannot Reproduce
    • Icon: L3 - Default L3 - Default
    • None
    • None
    • engine

      When accessing HumanTasks older than 24 days stored in an Microsoft SQL Server you end up getting such an exception:

      The datediff function resulted in an overflow. The number of dateparts separating two date/time instances is too large. Try to use datediff with a less precise datepart.. Stacktrace follows:
      com.microsoft.sqlserver.jdbc.SQLServerException: The datediff function resulted in an overflow. The number of dateparts separating two date/time instances is too large. Try to use datediff with a less precise datepart.

      Microsoft's DATEDIFF function returns an INT, which explains the ~ 24 days limit, cf.:

      http://msdn.microsoft.com/de-de/library/ms189794.aspx

      Could this be fixed by overriding/adding values to databaseSpecificDateDiff[123] in:

      https://github.com/camunda/camunda-bpm-platform/blob/master/engine/src/main/java/org/camunda/bpm/engine/impl/db/DbSqlSessionFactory.java

        This is the controller panel for Smart Panels app

          1. camunda-datediff-exception.txt
            3 kB

            [CAM-2445] HumanTasks older than 24 days in stored in MSSQLServer lost forever

            Matthias Schmidt created issue -
            Robert Gimbel made changes -
            Fix Version/s New: 7.2.0 [ 12997 ]

            Robert Gimbel added a comment -

            Hi Matthias,

            Thanks for your Bug Report.

            We will look into this in Kontext of our 7.2 Release.

            Cheers
            Robert

            Robert Gimbel added a comment - Hi Matthias, Thanks for your Bug Report. We will look into this in Kontext of our 7.2 Release. Cheers Robert
            Robert Gimbel made changes -
            Labels New: EasyPick
            Daniel Meyer made changes -
            Fix Version/s New: 7.1.5 [ 13392 ]
            Daniel Meyer made changes -
            Labels Original: EasyPick New: AD EasyPick
            Thorben Lindhauer made changes -
            Status Original: Open [ 1 ] New: In Progress [ 3 ]
            Thorben Lindhauer made changes -
            Assignee New: Thorben Lindhauer [ thorben.lindhauer ]

            Thorben Lindhauer added a comment -

            Hi Matthias,

            I am not able to reproduce your problem in an isolated test case.
            Furthermore, I do not know how the "datediff" function is called because the engine in its current state always uses "<" and ">" operators to compare dates.

            Thus, I close this issue. Should you still have this problem, feel free to reopen the issue and please provide more details on what calls the "datediff" function or a failing test case.

            Cheers,
            Thorben

            Thorben Lindhauer added a comment - Hi Matthias, I am not able to reproduce your problem in an isolated test case. Furthermore, I do not know how the "datediff" function is called because the engine in its current state always uses "<" and ">" operators to compare dates. Thus, I close this issue. Should you still have this problem, feel free to reopen the issue and please provide more details on what calls the "datediff" function or a failing test case. Cheers, Thorben
            Thorben Lindhauer made changes -
            Fix Version/s Original: 7.2.0 [ 12997 ]
            Fix Version/s Original: 7.1.5 [ 13392 ]
            Resolution New: Cannot Reproduce [ 5 ]
            Status Original: In Progress [ 3 ] New: Closed [ 6 ]
            Remaining Estimate New: 0 minutes [ 0 ]
            Original Estimate New: 0 minutes [ 0 ]

              thorben.lindhauer Thorben Lindhauer
              ms140569 Matthias Schmidt
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Created:
                Updated:
                Resolved: