Avensoft Help Desk - Submit Service Request error Object cannot be cast from DBNull to other types

Submit Service Request error Object cannot be cast from DBNull to other types

Submit Service Request Error

Object cannot be cast from DBNull to other types. at System.DBNull.System.IConvertible.ToInt32(IFormatProvider provider) at a3.ac(be A_0) at a3.ag() at Sr_AddPage.OnInitialDisplay()

This is caused by a technician not assigned to any organization. Run these SQL statements in MS SQL Management Studio against your nService 4 database.

SELECT * FROM ns4_user WHERE usr_org_id IS NULL
GO
SELECT * FROM ns4_user WHERE usr_org_id NOT IN (SELECT org_id FROM ns4_organization)
GO

UPDATE ns4_user SET usr_org_id = 90 WHERE usr_org_id IS NULL
GO