Search Engine: Elastic

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.

198398b282069eaf2d94a6af87dcb3ff caea8340e2d186a540518d08602aa065 e12cea1d47a3125d335d68e6d4e15e07 c0f836394088a28cc30dd0e5fe8b600e b2c3b33425dfc50c7d41a2efaa7f84f3

Email subscription for changes to this article
Save as PDF