KB73059604: Automation Engine - Error when trying to create a new job in the Pilot"BG_EException.server.gen.db.DB_EDuplKeyExceptionCannot insert duplicate key row in object 'jobs' with unique index 'job_i1'."

Summary

The following error occurs when trying to create a new job in the Automation Engine Pilot: “The following exception occurred while trying to copy the job “<your job name>”: BG_EException.server.gen.db.DB_EDuplKeyException: Cannot insert duplicate key row in object ‘jobs’ with unique index ‘job_i1’”.

Cause

This error pops up when another job with the same name already exists in Automation Engine. Two jobs with the same name are not allowed in the Jobs database.

Solution

The solution is to either remove the old job or to provide a different name for the new job.

To remove the old job, proceed as follows:

1. Go to the Automation Engine Pilot and search for the existing job with the same name.
2. Select the job.
3. Navigate to Job menu and click Remove job….
4. Confirm the removal by clicking OK.

The old job will be removed from the database making it possible to create a new job with the same name.