The Spectrum ddm_load command returns error about open database

Products

• DX NetOps
• CA Spectrum

Issue/Introduction

After migrating to a new system when running the ddm_load command we see the following error.

Error: Attempt to load to an open database.

The ddm_load doesn't complete and returns to the command line.

The ddm_load is being run as the Spectrum install owner. It is being run with the SpectroSERVER running, ProcessD running and Archive Manager down.

Environment

All supported DX NetOps Spectrum releases

Cause

There is a .DDMDB.LOCK file left in the $SPECROOT/SS/DDM directory while Archive Manager is down.

Resolution

When Archive Manager shuts down it should remove the $SPECROOT/SS/DDM/.DDMDB.LOCK file. It if does not the ddm_load will see it and think that Archive Manager is running when it is not. The ddm_load needs Archive Manager down when it runs and will fail if it thinks it is running.

Is Archive Manager down? In Linux run "ps -ef | grep -i arch" to check.

If it's down is there a .DDMDB.LOCK file left behind? Run "ls -al" from within, or against, the $SPECROOT/SS/DDM directory. If Archive Manager is down and a .DDMDB.LOCK file is seen, delete it.

Once removed the ddm_load should succeed.