Hi there.

I need a little help. I work for a University in Brazil and we're facing problems with the upgrade.

We just upgraded ZEN from 11.3.2 to 11.4.2 with all the steps in the middle.

After the first upgrade (11.3.2 -> 11.4.0) ZDC showed a lot of problems when verifying system files and also some problems when checking the database.

The systemfiles consisted mostly of files missing.

ERROR Missing file:
C:\Program Files (x86)\Novell\ZENworks\install\downloads\msi\novell-proxydhcp-11.4.0.7249.msi
ERROR Missing file:
C:\Program Files (x86)\Novell\ZENworks\install\downloads\msi\novell-tftp-11.4.0.7249.msi
I checked the folder and it showed a higher version.

The database errors were:
Following objects missing are in tables' structures.

ERROR Missing object in table 'zDevice'
Object type: [Constraint] , Object name: [uniq_zDevice_SerialNumber]
Detail: [Name: uniq_zDevice_SerialNumber, Type: UNIQUE, Table: zDevice]

Following mismatches were found in tables' structures.

ERROR Mismatch in table 'PatchScanAuditLog' structure.
Object type: [Column] , Object name: [createdDate]
Expected: [Name: createdDate, Size: 23, Type: TIMESTAMP, Nullable: true]
Found: [Name: createdDate, Size: 27, Type: VARCHAR, Nullable: true]
ERROR Mismatch in table 'PatchScanAuditLog' structure.
Object type: [Column] , Object name: [modifiedDate]
Expected: [Name: modifiedDate, Size: 23, Type: TIMESTAMP, Nullable: true]
Found: [Name: modifiedDate, Size: 27, Type: VARCHAR, Nullable: true]
I decided to go with it since we had two more steps to go.

I just finished the upgrade to 11.4.2 and now there's only one error in system files: the usual snoozeList.xml that already was there before.

The Database check now lists only one error:
ERROR Missing object in table 'zDevice'
Object type: [Constraint] , Object name: [uniq_zDevice_SerialNumber]
Detail: [Name: uniq_zDevice_SerialNumber, Type: UNIQUE, Table: zDevice]
The database is hosted on a SQL Server.

I checked the 'PatchScanAuditLog' fields that were showing as VARCHAR of size 27 and ZDC was expecting a DATETIME of size 23 and now both show as datetime2(7). Am I right to assume that it corrected itself on the last steps?.

But the uniq_zDevice_SerialNumber is not present on the zDevice table. At least not as a constraint. It is listed as an index. A "Non-Unique, Non-Clustered" index.

I tried setting as Unique and it failed me. It showed that there's duplicate values.

So... what should I do here? Rollback to the VM and the DB to 11.3.2? Look for all the duplicate SerialNumbers and try to fix it? Wouldn't I risk it screwing it further? How should I do that?

Thanks for your help!

PS: We are under an Academic Bundle and we don't have any valid SR tickets.