Symptom
When attempting to assign an approver in E-Req the error ‘Cannot insert the value NULL into column ‘uidCategoryUserID’, table ‘DB name here.db.tblEReqCategoryApprovers’ displays.
Full error:
Cannot insert the value NULL into column ‘uidCategoryUserID’, table ‘DBNAME.db.tblEReqCategoryApprovers’;
Column does not allow nulls. INSERT fails. Procedure spEReqCategoryApproverInsert:
annot perform insert in tblEReqCategoryApprovers Transaction count after EXECUTE indicates
a mismatching number of BEGIN and COMMIT statements. Previous count = 1, current count = 0.
The statement has been terminated.