Article ID: 130468, created on Mar 20, 2017, last review on Mar 20, 2017

  • Applies to:
  • Business Automation 7.0

Symptoms

Reseller sync fails with an exception seen in the logs:

[17-02-10 05:42:10.926 RDBMS       RQ87225 TH20837 NTE] Code: 1003. ERROR:  duplicate key value violates unique constraint "StoreCategoryPlan_PK"

DETAIL: Key ("PlanID", "CategoryID")=(3168, 161958) already exists. [17-02-10 05:42:10.926 RDBMS RQ87225 TH20837 INF] can't retry. Transaction is in progress [17-02-10 05:42:10.927 TaskRunner_ RQ87225 TH20837 TRC] ...[7] * INTERRUPTED BY EXCEPTION * void bStoreCategory::updateDelegatedStoreCategoryPlans(Int, const std::set, std::less >, std::allocator > >&)

or

[17-02-10 17:57:52.501 RDBMS       RQ00055 TH29311 NTE] Code: 1003. ERROR:  duplicate key value violates unique constraint "UpsellCategory_PK"
DETAIL:  Key ("PlanID", "CategoryID")=(15518, 172477) already exists.
[17-02-10 17:57:52.501 RDBMS       RQ00055 TH29311 INF] can't retry. Transaction is in progress
[17-02-10 17:57:52.502 TaskRunner_ RQ00055 TH29311 TRC]        ...[7] *** INTERRUPTED BY EXCEPTION *** void bStoreCategory::updateDelegatedUpsellCategories(Int, const std::set<STLRT::Type::Numeric<int>, std::less<STLRT::Type::Numeric<int> >, std::allocator<STLRT::Type::Numeric<int> > >&)    

Cause

The issue is caused by the bug "Synchronize Reseller task is failed if Upsell Category is assigned to Service Plan", it is hotfixed in #PBA-78532, hotfix #130284.

Resolution

Install the hotfix as soon as possible.

Search Words

Plans are not added to Sales Category under resellers

198398b282069eaf2d94a6af87dcb3ff caea8340e2d186a540518d08602aa065 e12cea1d47a3125d335d68e6d4e15e07 c0f836394088a28cc30dd0e5fe8b600e b2c3b33425dfc50c7d41a2efaa7f84f3

Email subscription for changes to this article
Save as PDF