Several Azure CSP provisioning tasks fail with the following error message:
500 Internal Server Error [unknown] Error while committing the transaction.
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".
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 'https://192.168.1.1:10443/azure/aps/resellers/d77632b2-...-13f77b44693e' 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.