We have had instances where there is a foreign key constraint error that is displayed when the user tries to copy a job. The error message references the ENPRISE_HIRE_HIREFREQUENCY table.
This error should be limited to databases that have early versions of the Eralis Rent product applied.
In order to resolve these issues, please run the two SQL scripts below:
UPDATE ENPRISE_JOBCOST_JOBLINES
SET HIRE_FREQUENCY=NULL
WHERE HIRE_FREQUENCY=-1
UPDATE ENPRISE_JOBCOST_JOBLINES
SET HIRE_EQUIPMENTNO=NULL
WHERE HIRE_EQUIPMENTNO IN (0,-1)
Copy Job Foreign Key Constraint
Comments
0 comments
Please sign in to leave a comment.