In your ZENLoader Log do you see this???

[TRACE] [02/08/2024 10:40:00.491] [17] [ZENLoader] [20876] [] [Exception while performing migration clean up] [] [java.lang.NullPointerException

at java.util.Objects.requireNonNull(Objects.java:203)

at java.util.Arrays$ArrayList.<init>(Arrays.java:3813)

at java.util.Arrays.asList(Arrays.java:3800)

at com.microfocus.zenworks.patch.helpers.migration.PatchSystemVariablesCleanupHelper.removePatchSystemVariables(PatchSystemVariablesCleanupHelper.java:84)

Craig, yep that is the error. Show 5 times:

migration clean up] [] [java.lang.NullPointerException

       at java.util.Objects.requireNonNull(Objects.java:203)

       at java.util.Arrays$ArrayList.<init>(Arrays.java:3813)

       at java.util.Arrays.asList(Arrays.java:3800)

       at com.microfocus.zenworks.patch.helpers.migration.PatchSystemVariablesCleanupHelper.removePatchSystemVariables(PatchSystemVariablesCleanupHelper.java:84)

       at com.microfocus.zenworks.patch.helpers.migration.PatchSystemVariablesCleanupHelper.removeAllPatchSystemVariables(PatchSystemVariablesCleanupHelper.java:66)

       at com.microfocus.zenworks.patch.helpers.migration.AirgapMigrationHelper.modifyAirgapRelatedSystemVariables(AirgapMigrationHelper.java:54)

       at com.microfocus.zenworks.patch.helpers.migration.AirgapMigrationHelper.migrateAirgapZone(AirgapMigrationHelper.java:39)

       at com.microfocus.zenworks.patch.helpers.migration.MigratePatchManagementHelper.cleanupAndMigrateAirgapData(MigratePatchManagementHelper.java:157)

       at com.microfocus.zenworks.patch.helpers.migration.MigratePatchManagementHelper.migrateZenworksPatchManagement(MigratePatchManagementHelper.java:70)

       at com.microfocus.zenworks.patch.loader.modules.queue.handlers.PatchMigrationCleanupHandler.migrateZenworksPatchManagement(PatchMigrationCleanupHandler.java:111)

       at com.microfocus.zenworks.patch.loader.modules.queue.handlers.PatchMigrationCleanupHandler.processAction(PatchMigrationCleanupHandler.java:75)

       at com.novell.zenworks.loader.modules.queue.runner.QueueThreadWorker.processAction(QueueThreadWorker.java:228)

       at com.novell.zenworks.loader.modules.queue.runner.QueueThreadWorker.run(QueueThreadWorker.java:149)

       at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)

       at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)

       at java.lang.Thread.run(Thread.java:750)

] [] [] [] [ZENServer]

Run the Query....I think it will return some bundles that have a bad value for SYSTEM Variables.

In the Picture above the Variable "PET" does not have a value.  This will lead to that error.  This is not supposed to be possible and I had to edit the picture to demonstrate.  You can delete the bundle if its no longer needed or update it to have a value.  In most cases these were old unused bundles.  I'm not sure if it matters if the bundle is the published or just an old bundle version.  So if you see a bundle in the report and lit looks correct...try deleting the old versions. 

Note: Many components of ZPM are actually just bundles...which is why non-ZPM bundles impacted ZPM...

Craig, thanks for the reply. Excuse me for being stupid, but where do I execute that query?

If you have the internal DB, you can use DBeaver:

https://portal.microfocus.com/s/article/KM000001612?language=en_US

Just grab the Free Community Edition: https://dbeaver.io/

If you have MSSQL you will want to use their tools but my guess if you have the internal DB.

It is the Internal DB. What is the SQL quet scrip that you used?

Thanks

select zzenobject.path, zzenobject.primarytype, zzenobject.subtype, zsystemsetting.objectuid, zsystemsetting.name, zsystemsetting.data,
zsystemsetting.modifiedtime from zSystemSetting join zzenobject on zzenobject.zuid=zsystemsetting.objectuid
where zsystemsetting.name like 'zenworks.system.variables' and zsystemsetting.data='<Variables></Variables>';

Sorry I could have sworn I included it previously...I guess not....

That query runs clean now.  There were 5 bundles/shortcuts that were defective. Now how do I get the number of the Database clean-up attempts back to 5 or any number besides zero?

Thanks

Are you able to just try the migration again?  I have not worked with these failures often...I just knew about that one cause.   What does the ZCC show?