Advanced ZPM Database Clean-up Failed

Zenworks 23.4.0.88

Valid ZPM license is valid

Platform: Zenworks appliance

The database clean-up faild on the migration process. Installed all of the current FTF's for 23.4 Zenworks. At this point the mogration process is stalled since there are no more retrys available.

Process directs to contact Micro Focus Customer Center.

How to enable additional attempts to clean-up the database?  What could be the DB issue?

Thanks, JoeK

  • 0  

    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)

    --

    If you found this post useful, give it a “Like” or click on "Verify Answer" under the "More" button

    Be sure to "Like" My (and a few others) Cool Solutions below! 

    https://community.microfocus.com/members/craigdwilson/bookmarks

  • 0 in reply to   

    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]

  • 0   in reply to 

    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. 

    --

    If you found this post useful, give it a “Like” or click on "Verify Answer" under the "More" button

    Be sure to "Like" My (and a few others) Cool Solutions below! 

    https://community.microfocus.com/members/craigdwilson/bookmarks

  • 0   in reply to   

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

    --

    If you found this post useful, give it a “Like” or click on "Verify Answer" under the "More" button

    Be sure to "Like" My (and a few others) Cool Solutions below! 

    https://community.microfocus.com/members/craigdwilson/bookmarks

  • 0 in reply to   

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

  • 0   in reply to 

    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.

    --

    If you found this post useful, give it a “Like” or click on "Verify Answer" under the "More" button

    Be sure to "Like" My (and a few others) Cool Solutions below! 

    https://community.microfocus.com/members/craigdwilson/bookmarks

  • 0 in reply to   

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

    Thanks

  • 0   in reply to 

    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....

    --

    If you found this post useful, give it a “Like” or click on "Verify Answer" under the "More" button

    Be sure to "Like" My (and a few others) Cool Solutions below! 

    https://community.microfocus.com/members/craigdwilson/bookmarks

  • 0 in reply to   

    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

  • 0   in reply to 

    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?

    --

    If you found this post useful, give it a “Like” or click on "Verify Answer" under the "More" button

    Be sure to "Like" My (and a few others) Cool Solutions below! 

    https://community.microfocus.com/members/craigdwilson/bookmarks