Search Engine: Elastic

Article ID: 132254, created on Feb 16, 2018, last review on Feb 16, 2018

  • Applies to:
  • Operations Automation 7.3

Symptoms

Task "Configure WebHosting Plesk default content" fails with the following output:

...
'ERROR: insert or update on table "Plan" violates foreign key constraint "Plan_planCategoryID"\nDETAIL: Key (planCategoryID)=(1) is not present in table "PlanCategory".\n', 'extype_id': 1, 'module_id': 'BillingApiManager', 'error_code': 1
...

If restarted, the task will have the following output error message:

...
'status': -1, 'error_message': 'org.hibernate.exception.ConstraintViolationException: could not execute statement\norg.hibernate.exception.ConstraintViolationException: could not execute statement', 'extype_id': -1, 'module_id': '', 'error_code': -1
...

Cause

The issue is caused by software-related issue #WHM-10421 "Task "Configure WebHosting Plesk default content" fails with "violates foreign key constraint"".

Resolution

This issue will be resolved in one of the future product updates. Contact your Technical Account Manager or Pooled Technical Associate Team (pta@odin.com) in order to trace the current status of #WHM-10421.

In order to workaround the issue, delete all already created Service Templates of WebHosting Plesk and rerun the task. This should complete successfully.

5356b422f65bdad1c3e9edca5d74a1ae caea8340e2d186a540518d08602aa065 e12cea1d47a3125d335d68e6d4e15e07 dd79f16c76b9dca75205ab5e9f5465ea 1941880841f714e458ae4dc3d9f3062d

Email subscription for changes to this article
Save as PDF