Effective Demand failed to run showing "already running" message

Products

• CA Software Asset Manager (CA SAM)

Issue/Introduction

When run Effective demand, it fails due to "already running".

Environment

Release : 17.3

Component : CA SOFTWARE ASSET MANAGER

Resolution

The primary key constraint on the inv_device_tracking table is missing.
The log file states:
ERROR          missing foreign key constraint in table [inv_device_tracking]: column [inv_device_id]

Please try to rebuild it using the rebuild system tables script at Admin>Maintenance>Rebuild system tables.
First click the 'Repair indexes'. This will take a while. After that (just to be sure) click the 'Repair sequences' link (this also will take a while).

The scripts will probably inform you about the missing index.

After that has been done, navigate to  Admin>Maintenance>Tools>Inspect system locks and release all locks. Just follow the instructions in the 'How to unlock?' column. Mostly it is about deleting the system configuration record.

One other thing to do (from the check installation log): set the 'refresh_tmp_tables' cron job to 'ok'!

After all of this has been fixed, re-run the check_installation script to see if the errors have been solved.