Article ID: 117298, created on Sep 16, 2013, last review on May 3, 2014

  • Applies to:
  • Business Automation 5.5
  • Business Automation 5.4

Symptoms

An attempt to delete a resource rate from PBA Service Plan fails with the following error message:

PBA for Windows:

ODBC error #23000: [Microsoft][ODBC SQL Server Driver][SQL Server]The DELETE statement conflicted with the REFERENCE constraint "TermConditionForPlanRate_PlanRateID". The conflict occurred in database "pba", table "dbo.TermConditionForPlanRate", column 'PlanRateID'.ODBC error #01000: [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.ODBC error #01000: 

PBA for Linux:

ODBC error #23503: ERROR: update or delete on table "PlanRate" violates foreign key constraint "TermConditionForPlanRate_P_073" on table "TermConditionForPlanRate" Key (PlanRateID)=(X) is still referenced from table "TermConditionForPlanRate".; Error while executing the query

Cause

Resource rate you are trying to delete is being used in one or more 'Terms and Conditions' defined in PBA.

Resolution

Remove resource rate from 'Terms and Condition' that have it attached:

  1. Log into PBA Provider Control Panel
  2. Go to Configuration Director > Sales & Financial Settings > Terms and Conditions
  3. Select the needed Terms and Conditions
  4. Switch to the 'Resource Rates' tab
  5. Select and delete the resource rate you need to delete from Service Plan

Search Words

resource rate

TermConditionForPlanRate

Terms and Conditions

198398b282069eaf2d94a6af87dcb3ff caea8340e2d186a540518d08602aa065 801221f8cd76fba7300d1e6817c8e08b 92711db0799e8aefe8e51f12dace0496 210d017ddc3a076d22f0f865b1cf0730 e12cea1d47a3125d335d68e6d4e15e07

Email subscription for changes to this article
Save as PDF