jdkoerner Honored Contributor.
Honored Contributor.
391 views

2017 Appliance to Zenworks 2020

I have dug through the documents and wanted to see if I have this all clear before I try to upgrade.

Looks like I have to update my database from embedded Sybase to embedded PostgreSQL on my current appliance first.  I then need to do a migration to a new Zenworks 2020 appliance.  With the appliance I am not doing an in-place upgrade.

Jim Koerner
Server - ZCM 2017 Update 4.1a Appliance
Clients - ZCM 17.4.1.26 on Win10/1803x64

Labels (1)
0 Likes
12 Replies
Micro Focus Expert
Micro Focus Expert

Re: 2017 Appliance to Zenworks 2020

One key point to remember, after you migrate from Sybase to PostgreSQL, it is easy to migrate back to Sybase if there are any issues SO LONG AS YOU ARE STILL ON 17.x.

Once you upgrade from ZCM 17.x to 2020, it is not possible rollback.

Thus I would recommend treating the PostGreSQL migration to be one project and allow things to run for a few days at least until moving on to the ZCM 2020 Upgrade.  It will minimize troubleshooting any issues that may arise if you do both during a single maintenance Window and may be unsure if any issue is due to the DB Migration or the OS Upgrade.

 

--
Please give a hearty thumbs up to any post you find helpful!
To find articles by Craig Wilson simply follow the link: Craig Wilson's Tips!
0 Likes
jdkoerner Honored Contributor.
Honored Contributor.

Re: 2017 Appliance to Zenworks 2020

Well off to a good start.  Trying to run the ZDC to verify the databases but I am getting  "The baseline file does not contain data for verifier 'zendatabase'  did the command exactly like in the docs.  Anyone have an idea on this one.  Baseline file is baseline_17.4.0.zdc

 

Jim

0 Likes
Micro Focus Frequent Contributor
Micro Focus Frequent Contributor

Re: 2017 Appliance to Zenworks 2020

What version are you running ZDC against?
0 Likes
jdkoerner Honored Contributor.
Honored Contributor.

Re: 2017 Appliance to Zenworks 2020

running 17.4.1,  I downloaded the ZDC under that version but the baseline file in it is baseline_17.4.0.zdc.  Is there a specific 17.4.1 baseline file?

 

Jim

0 Likes
jdkoerner Honored Contributor.
Honored Contributor.

Re: 2017 Appliance to Zenworks 2020

I also just tried the ZDC for 20 with the same message.
0 Likes
Micro Focus Expert
Micro Focus Expert

Re: 2017 Appliance to Zenworks 2020

I presume you are doing this portion...

https://www.novell.com/documentation/zenworks-2020/zen_sybase_postgre_migration/data/zen_sybase_postgre_migration.html#t4a4xn09fmoj

Did you download db-migration-tool-1.0.zip?

This contains zcm_pre_20.0.0.zdc that you can use as part of your PostGres Migration.

Note: This did give me an error about [{"tableName":"zVPPAssignment","inconsistentItems":null}], but it let me proceed.  I believe this is a erroneous as I saw an earlier bug about this table being erroneously listed as a problem.  However, I believe this is a  false error based on my readings and can likely be ignored.

--
Please give a hearty thumbs up to any post you find helpful!
To find articles by Craig Wilson simply follow the link: Craig Wilson's Tips!
0 Likes
Micro Focus Expert
Micro Focus Expert

Re: 2017 Appliance to Zenworks 2020

./zdc verify -v zendatabase -b ./data/zcm_pre_20.0.0.zdc

ZDC folder extracted from the DBMigration Zip to the /tmp folder is what I just used on my system.

 

--
Please give a hearty thumbs up to any post you find helpful!
To find articles by Craig Wilson simply follow the link: Craig Wilson's Tips!
0 Likes
Micro Focus Expert
Micro Focus Expert

Re: 2017 Appliance to Zenworks 2020

This is the ZDC The Migration Tool will run as part of the DB migration....but can be run manually in advance to verify any database only errors.

--
Please give a hearty thumbs up to any post you find helpful!
To find articles by Craig Wilson simply follow the link: Craig Wilson's Tips!
0 Likes
jdkoerner Honored Contributor.
Honored Contributor.

Re: 2017 Appliance to Zenworks 2020

That was my issue it was not clears as to which ZDC I should of ran.  I got the one from the data migration tool to run.

The only errors I ended up with are trigger errors about 20 of them.

Mismatch in table 'NC_LDAPImportMappings' structure.
Object type: [Trigger] , Object name: [tg_NC_LDAPImportMappings_del]
Expected: [Name: tg_NC_LDAPImportMappings_del, Table: NC_LDAPImportMappings, Definition hash: d5cb4451]
Found: [Name: tg_NC_LDAPImportMappings_del, Table: NC_LDAPImportMappings, Definition hash: f4e4617] 

0 Likes
Micro Focus Expert
Micro Focus Expert

Re: 2017 Appliance to Zenworks 2020

I'm going to avoid commenting on if that is or is not a concern to do the migration.

There are others who are a little better than I in cleaning those errors up or knowing if its an issue.

--
Please give a hearty thumbs up to any post you find helpful!
To find articles by Craig Wilson simply follow the link: Craig Wilson's Tips!
0 Likes
jdkoerner Honored Contributor.
Honored Contributor.

Re: 2017 Appliance to Zenworks 2020

Dropped in a SR with the error report to see if these need to be taken care of.

 

Thanks,

Jim

0 Likes
jdkoerner Honored Contributor.
Honored Contributor.

Re: 2017 Appliance to Zenworks 2020

In my case it was determined the trigger errors were not an issue as they get recreated during the database migration.  The run of ZDC after the migration came back clean.

 

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.