ddm_load fails with the error "Load Completed Unsuccessfuly"

Products

• CA Spectrum
• CA eHealth

Issue/Introduction

While trying to load a 10.3.1 DDM database on another server the ddm_load command was failing with the following error:

Environment

Release : 10.3

Component : MITS SPECTRUM INTEGRATION

Cause

The DDM database backup was saved in the myisam format and needed to be converted to the Innodb format for the ddm_load to run successfully. 

Resolution

The $SPECROOT/SS/DDM/scripts/convert_save_myisam_to_innnodb.pl needs to be run on the DDM backup to convert the database to the Innodb format. Once the database has been converted. The ddm_load command will successfully load the database.