Uploaded image for project: 'SET - Setups'
  1. SET - Setups
  2. SET-132

The primary key of the table INVENTORY_CALENDAR_USAGE for MS SQL Server should be specified as IDENTITY for auto incremental support

    XMLWordPrintable

Details

    • Fix
    • Status: Released (View Workflow)
    • Major
    • Resolution: Fixed
    • None
    • 1.12.3
    • None
    • MS SQL Server

    Description

      Current Situation

      The primary key "ID" of the table INVENTORY_CALENDAR_USAGE should be an auto incremental field.
      So, it should be specified as IDENTITY for MS SQL Server what hasn't been done.

      This affects that you cannot assign a Calendar to a Job, Order or Schedule in JOC Cockpit.
      The following error occurs:

      SQL Error: 515, SQLState: 23000 
      515 Cannot insert the value NULL into column 'ID', table 'p_gems.dbo.INVENTORY_CALENDAR_USAGE'; column does not allow nulls. INSERT fails
      

      Desired Behavior

      Specify the primary key "ID" of the table INVENTORY_CALENDAR_USAGE with IDENTITY for auto incremental support.

      Workaround

      Copy the attached file to your JobScheduler installation path into the folder ./db/mssql/reporting.
      Then, depending on the operating system, run the cmd or sh script ./install/scheduler_install_tables

      Attachments

        Activity

          People

            sp Santiago Aucejo Petzoldt
            oh Oliver Haufe
            Oliver Haufe Oliver Haufe
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: