Inventory files cannot be imported with error ?Cannot insert the value NULL into column 'ComputerOUID', table 'ManageSoft.dbo.Computer_MT'; column does not allow nulls. INSERT fails.?

[#1]

Summary

Inventory files cannot be imported with error ?Cannot insert the value NULL into column 'ComputerOUID', table 'ManageSoft.dbo.Computer_MT'; column does not allow nulls. INSERT fails.?

Cause

This is caused because the ?ManageSoft? Domain / Organization records in the database have either been incorrectly created or were not created at all.

Resolution

The solution is to create valid entries. Most often the ManageSoft domain exists in dbo.Domain but the Organization entry was not created, you can resolve this by running:

EXEC OrganizationAdd NULL, NULL, 1, 0

Additional Information

If the above stored procedure does not resolve the problem, please get an export of the dbo.Domain and dbo.Organization tables and results of the SQL script below and send these to Support so that other scenarios can be investigated.

declare @DomainID int
declare @OUID int
select @DomainID = OrganizationID from Domain where DN = 'DC=MANAGESOFT'
select @OUID = OrganizationID from Organization where DomainID = @DomainID
select
OrganizationCount = (select COUNT(*) from Organization where DomainID = @DomainID),
ComputerCount = (select COUNT(*) from [Computer] where ComputerOUID = @OUID),
UserCount = (select COUNT(*) from [User] where UserOUID = @OUID),
GroupCount = (select COUNT(*) from [Group] where GroupOUID = @OUID),
LicenseAllocCount = (select COUNT(*) from LicenseAllocation where OrganizationID = @OUID),
LicensePurchCount = (select COUNT(*) from LicensePurchase where OrganizationID = @OUID),
PackageCount = (select COUNT(*) from PackageApplies where TargetOUID = @OUID),
PolicyCount = (select COUNT(*) from PolicyApplies where TargetOUID = @OUID)