Environment
Novell ZENworks 7.5 Asset Management - ZAM7.5
Situation
Scan Now was working.
Scan Now stopped working one day.
Error: "You requested that workstation 'PC name’ to be scanned. The scan was unable to complete because the load has failed."
Resolution
To fix it, run these two queries from a query analyzer (part of a database client tool set):
ALTER TABLE NC_WkstnChanges DROP CONSTRAINT FK_WkstnChg_WkstnOID;
GO
ALTER TABLE NC_WkstnChanges ADD CONSTRAINT FK_WkstnChg_WkstnOID
FOREIGN KEY (WorkstationOID) REFERENCES NC_Workstation (WorkstationOID);
GO
ALTER TABLE NC_WkstnChanges DROP CONSTRAINT FK_WkstnChg_WkstnOID;
GO
ALTER TABLE NC_WkstnChanges ADD CONSTRAINT FK_WkstnChg_WkstnOID
FOREIGN KEY (WorkstationOID) REFERENCES NC_Workstation (WorkstationOID);
GO
Additional Information
The problem is that the constraint on the nc_wkstnchanges table is incorrect. The constraint is on wkstnchangesoid, instead of workstationoid.