Loading
search-img
Title
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.?

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)
Was this helpful?
Support Hub
Product
FlexNet Manager Suite
Deployment type
On-premises
Visibility
Guest
URL Name
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

Related Articles

Create a case with Support
0/255
Upload Attachment
File Upload
Maximum file size allowed is 3 MB.
File type not supported.
Supported file types:
Documents (.txt, .doc, .docx, .pdf), Images (.jpg, .png), Comma Separated Files (.csv) Speadsheets (.xlsx, .xls)

Are you sure you want to cancel the case creation?

Are you sure you want to close this case

Get Hotline support
Products Region Phone Numbers
FlexNet Operations
FlexNet Embedded
FlexNet Publisher
FlexNet Connect
FlexNet Code Insight
InstallAnywhere
InstallShield 		North America  * +1 630-332-2513 (toll)
+1 877-279-2853 (toll-free in North America)
Europe  * +44 1925 944367 (toll)
+44 800 047 8642 (toll-free in Europe)
Japan  * +81 3-4540-5335 (select option 2)
Australia  * +61 3 9895 2177
+61 1800 560 603 (toll-free in Australia)
Usage Intelligence (formerly Revulytics)
Compliance Intelligence 		Please use the Case Portal to submit your support ticket or reach out to your Revenera contact.
Book an Appointment
File Upload
Maximum file size allowed is 3 MB.
File type not supported.
Supported file types:
Documents (.txt, .doc, .docx, .pdf), Images (.jpg, .png), Comma Separated Files (.csv) Speadsheets (.xlsx, .xls)
+1.800.374.4353
CONTACT US REVENERA.COM FLEXERA.com
© 2026 Flexera Software. All Rights Reserved.
Privacy policy Terms and conditions Flexera Community Contact Us
Loading
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.?