Details
-
Fix
-
Status: Released (View Workflow)
-
Major
-
Resolution: Fixed
-
None
-
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