Submitted by Stacie_Ray on

You must be logged in and have a current support plan to view the full content of this page.

Click to login »
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.


 
Product Line