Environment
Novell ZENworks 11 Configuration Management Support Pack 1 - ZCM 11 SP1 Migration
Novell ZENworks 11 Configuration Management Support Pack 2 - ZCM 11 SP2 Migration
Novell ZENworks 11 Configuration Management Support Pack 2 - ZCM 11 SP2 Migration
Situation
Unable to migrate custom ZAM 7.5 reports that contain LastSuccessfulScanDate, DefaultGateway or SubnetMask.
Resolution
This is fixed in version 11.2.1 - see KB 7010042 "ZENworks Configuration Management 11.2.1 - update information and list of fixes" which can be found at https://support.microfocus.com/kb/doc.php?id=7010042
The current workaround to this issue is about removing checks from DBConfig.xml.
1. Open the DBConfig.xml file from the ZAM migration utility installed location.(C:\Program Files\Novell\ZENworks\ZAMMigration\DBConfig.xml)
2. Remove the below 3 lines from the file.
3. Save the file and restart the utility to test the fix.
-- these three were added as columns to 7.5, but not yet to ZCM
exec zMarkInvalidCustomReports N'NC_Workstation.LastSuccessfulScanDate__dt';
exec zMarkInvalidCustomReports N'NC_Workstation.DefaultGateway';
exec zMarkInvalidCustomReports N'NC_Workstation.SubnetMask';
Cause
Analyzing the ZAM migration code and looks like the check (which says gateway, subnetmask and lastsuccessfulscandate cannot be migrated) was added long back when these columns did not exist in ZCM. As has been found, these columns do exist in ZCM now.