Spectrum - ddm backup fails after upgrade to 10.4.1

book

Article ID: 192757

calendar_today

Updated On:

Products

CA Spectrum CA eHealth

Issue/Introduction

The ddm backup is failing after upgrading to 10.4.1

The error in ddm_backup.log show next

200610 23:01:54 RDR1    INFO: Starting to lock all the tables...
200610 23:01:54 RDR1 ERROR: No tables to copy.

Cause

The ddm_save, ddm_load and ddm_backup binaries coming with the previous releases has been deprecated in 10.4.1. From 10.4.1 onward, instead, the ddm_save.pl is used to backup the DDM db.

This script rely on mysqlbackup client. The same client is used for performing different types of backup and restore operations, as well as other related tasks like backup compression, decompression and validation. This ensure improved performance with the MySQL backup and save the DDM Db without having to stop the Archive Manager.

However the client will only work on tables with Innodb engine. Tables using MyIsam engine will be ignored, hence the message "No tables to copy"

Next query can be used to confirm the tables engine: SHOW TABLE STATUS from ddmdb

Environment

Release : 10.4.1

Component : Spectrum Core / SpectroSERVER

Resolution

To resolve the issue, please convert the tables from MyIsam, to InnoDB, using the script convert_current_myisam_to_innodb.pl

This is described in product documentation: Post Migration Tasks

 

Additional Information

ddm_save

ddm_backup

ddm_load

post_olb_script