A TMS job is stuck at start with an error message in the description
A job created in TMS shows all tasks are stuck at the Start step. The following error message is shown in the job description:
Cannot insert the value NULL into column 'MatrixID', table 'DATABASE.dbo.tblCostBreakdown';
column does not allow nulls. INSERT fails. Cannot insert the value NULL into column 'MatrixID', table 'DATABASE.dbo.tblCostBreakdown';
column does not allow
The configuration for this job was created with a mismatched Vendor and Cost model. Because the Cost Model in the configuration did not belong to the Vendor, TMS was unable to create a job.
Updating the Configuration to have a Vendor that matches the Cost Model, or vice versa will allow jobs to be created. The original job would have to be terminated and a new job created in its place.