In the event log, you may encounter an error like this:
Error committing on table MANUFACTURER: CANNOT INSERT THE VALUE NULL INTO COLUMN 'SEQKEY', TABLE 'LDMS.DBO.MANUFACTURER'; COLUMN DOES NOT ALLOW NULLS. INSERT FAILS.
Increased column size might be necessary, Thread ID: 13540.
To fix this issue:
- Back up the file “C:\Program Files\LANDesk\ManagementSuite\Datamart.xml”
- Edit this file
- Search for <table name=MANUFACTURER for this example
- Increase the SEQKEY value, typically to
- Varchar(255) or Varchar(MAX)
- Then run “C:\Program Files\LANDesk\ManagementSuite\CoreDbUtil.exe” and click on “Build Components”
- From the LANDESK console, go to the configure menu, select “Service,” and then restart the service in the Inventory tab
