Uploaded image for project: 'WebTop'
  1. WebTop
  2. WT-601

DB error when inserting a new task

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • High
    • Resolution: Done
    • Tasks
    • 5.3.1
    • release
    • 5.3.2
    • wt-5.6.4
    • 0237

    Description

      Steps to reproduce:

      • Start with a fresh (not already upgraded) WebTop installation that have task service v.5.3.0
      • Create a new task, fill details and save

      Expected behaviour:

      • New task is created

      Current behaviour:

      • A generic error is displayed. Under the hood the below db error is thrown.

       

      Caused by: org.jooq.exception.DataAccessException: SQL [insert into "tasks"."tasks" ("task_id", "category_id", "revision_status", "revision_timestamp", "public_uid", "subject", "description", "start_date", "due_date", "completed_date", "importance", "is_private", "status", "completion_percentage", "reminder_date", "reminded_on", "revision_sequence", "href", "etag", "creation_timestamp") values (?, ?, ?, cast(? as timestamp), ?, ?, ?, cast(? as timestamp), cast(? as timestamp), cast(? as timestamp), ?, ?, ?, ?, cast(? as timestamp), cast(? as timestamp), ?, ?, ?, cast(? as timestamp))]; ERROR: null value in column "creation_timestamp" violates not-null constraint  Detail: Failing row contains (12, 13, N, 2019-04-19 10:57:39.196+02, 0, null, dc34c2491511eadd57d9d058c7356671@studiorocchi.net, test, null, null, null, null, 1, f, notstarted, 0, null, null, null, null).        at org.jooq.impl.Utils.translate(Utils.java:1553)        at org.jooq.impl.DefaultExecuteContext.sqlException(DefaultExecuteContext.java:609)        at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:355)        ... 63 common frames omitted Caused by: org.postgresql.util.PSQLException: ERROR: null value in column "creation_timestamp" violates not-null constraint  Detail: Failing row contains (12, 13, N, 2019-04-19 10:57:39.196+02, 0, null, dc34c2491511eadd57d9d058c7356671@studiorocchi.net, test, null, null, null, null, 1, f, notstarted, 0, null, null, null, null).

      Attachments

        Activity

          People

            Unassigned Unassigned
            matteo.albinola Matteo Albinola
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Packages

                Version Package