Search Engine: Elastic

Article ID: 132040, created on Jan 9, 2018, last review on Jan 9, 2018

  • Applies to:
  • Operations Automation


Several Azure CSP provisioning tasks fail with the following error message:

500 Internal Server Error
[unknown] Error while committing the transaction.

azure.log error:

Caused by: org.postgresql.util.PSQLException: ERROR: update or delete on table "consumption_records" violates foreign key constraint "fk_reseller_consumption_queue_consumption_record_id" on table "reseller_consumption_queue"
Detail: Key (id)=(12345) is still referenced from table "reseller_consumption_queue".

Also, Synchronize resource usage for APS application instance #123 (Azure Cloud Solution Provider) periodic task fails:

Could not get resource usage for resource with UUID 'd77632b2-...-13f77b44693e': Could not invoke endpoint url '' of application instance with UUID 'ca13b8f0-...-5bb5a9aa7b6c'. An unexpected error has occurred.


Reseller Service Template misconfiguration.
Check that Service Template, affected Reseller's subscription is based on, contains only resources mentioned in the Creating 'Azure Reseller' Service Template section:

  • Azure Application
  • Azure Second Tier Reseller
  • Reseller Total Cost of Azure Services


Add required Azure CSP Resource Types to the Service Template (and all corresponding Reseller's subscriptions) or remove redundant ones.

5356b422f65bdad1c3e9edca5d74a1ae caea8340e2d186a540518d08602aa065 e12cea1d47a3125d335d68e6d4e15e07

Email subscription for changes to this article
Save as PDF