topic Re: SMS Manager Upgrade to R82 from R81 Fails during Database Import in Firewall and Security Management

SMS Manager Upgrade to R82 from R81 Fails during Database Import

Edward_Waithaka — Fri, 01 Aug 2025 10:52:22 GMT

After the SMS server has been upgraded and hotfix applied, the upgrade process fails during database import with the following error message:

Importing the Management Database Start Time01-Aug-2025 13:06:11 | End Time01-Aug-2025 13:15:08 | Duration8 min 57 sec.
Creating Default Objects and Restarting Services8 min 23 sec.
Check Point Data1 sec.
System Data
Error Message Failed to execute command /opt/CPupgrade-tools-R82/bin/migrate import --config_only -n -l -x --include-uepm-msi-files --smartlog /home/admin/temp-export/a0eebc99-afed-4ef8-bb6d-fedfedfedfed.txz. Failed to execute
Execution finished with errors. See log file '/opt/CPshrd-R82/log/migrate-2025.08.01_13.14.38.log' for further details
Objects 166

After checking the /home/admin folder, I could not trace the /temp-export/ folder as it was deleted shortly after extraction.

Also, the migrate logs ends with the following part section.

...

[1 Aug 13:15:06] [DbFilesImporter::CheckAllowedDestinations] Checking allowed destinations for 'rtdir' (source dir is '/opt/CPsuite-R82/fw1/tmp/migrate/regular_files/rtdir/')
[1 Aug 13:15:06] [DbFilesImporter::CheckAllowedDestinations] Checking component 'conf'
[1 Aug 13:15:06] [DbFilesImporter::CheckAllowedDestinations] Checking component 'log_indexes'
[1 Aug 13:15:06] [DbFilesImporter::CheckAllowedDestinations] ERR: Destination 'log_indexes' is illegal for environment variable 'rtdir'
[1 Aug 13:15:06] ..<-- DbFilesImporter::CheckAllowedDestinations
[1 Aug 13:15:06] .<-- DbFilesImporter::DoPostDbImportTasks
[1 Aug 13:15:06] [DbFilesImporter::exec] ERR: Failed to perform post import tasks
[1 Aug 13:15:06] <-- DbFilesImporter::exec
[1 Aug 13:15:06] [ActivitiesManager::exec] ERR: Activity 'DbFilesImporter' failed
[1 Aug 13:15:06] [ActivitiesManager::exec] WRN: Activities execution finished with errors
[1 Aug 13:15:06] [ActivitiesManager::exec] WRN: Activities 'DbFilesImporter' have failed
[1 Aug 13:15:06] [ActivitiesManager::exec] Designated exit code is 1
[1 Aug 13:15:06] --> CleanupManager::Instance
[1 Aug 13:15:06] <-- CleanupManager::Instance
[1 Aug 13:15:06] --> CleanupManager::DoCleanup
[1 Aug 13:15:06] [CleanupManager::DoCleanup] Starting to perform cleanup

.....

Re: SMS Manager Upgrade to R82 from R81 Fails during Database Import

Edward_Waithaka — Fri, 01 Aug 2025 11:35:46 GMT

I believe this may be a bug with the default CPupgrade-tools-R82 scripts.

From my analysis, it appears that the R82 upgrade images (both ISO and Blink-HF34) ship with an older version of the CPupgrade-tools-R82 package, which seems to have a bug. On the affected system, the build number is:

[Expert@SMS-PRI:0]# cpprod_util CPPROD_GetValue CPupgrade-tools-R82 BuildNumber  
1998001093

After deploying a new management server with R82 JHF34 and manually updating to the latest CPupgrade-tools-R82, I no longer encounter the error when importing the database. The updated build shows:

[Expert@SMS-PRI:0]# cpprod_util CPPROD_GetValue CPupgrade-tools-R82 BuildNumber  
1998001165

I will let you know if the upgrade is successful.

Re: SMS Manager Upgrade to R82 from R81 Fails during Database Import

Edward_Waithaka — Fri, 01 Aug 2025 11:43:19 GMT

@Eran_Habad the R82 ISO/Blink images need to be updated with working upgrade tools.

Re: SMS Manager Upgrade to R82 from R81 Fails during Database Import

Edward_Waithaka — Fri, 01 Aug 2025 11:45:37 GMT

Import was successful with the latest upgrade tools.

Importing the Management Database
Operation started at Fri Aug 1 14:05:29 EAT 2025

[==================================================] 100% Done
Detailed upgrade report is available at /opt/CPsuite-R82/fw1/log/upgrade_report/upgrade_report.html

The import operation finished successfully.

Re: SMS Manager Upgrade to R82 from R81 Fails during Database Import

KeonNg — Thu, 30 Oct 2025 10:36:34 GMT

Hi @Edward_Waithaka

I faced the same issue , however after upgrading the upgrade tools and import again i faced another issue which saying the disk space is not enough but its actually a new box with no config and the disk space is sufficient.

Re: SMS Manager Upgrade to R82 from R81 Fails during Database Import

Licensing_User — Wed, 26 Nov 2025 12:52:48 GMT

Hi.

Did you ever resolve this? I'm getting the same issue.

Re: SMS Manager Upgrade to R82 from R81 Fails during Database Import

KeonNg — Wed, 26 Nov 2025 12:55:51 GMT

Hi,

I managed to resolved this by upgrading the deployment agent as well. Which means we have to make sure upgrade tools and deployment agents is up to date to the latest. Hopes this helps.

Best Regards,

Keon