Article ID: 125491, created on May 13, 2015, last review on May 13, 2015

  • Applies to:
  • Business Automation 6.0

Symptoms

The task to synchronize the reseller(s) fails. The log shows an exception on processing one the delegated service plans:

[15-04-28 08:35:48.935 TaskRunner_ RQ00169 TH05832 TRC]         +++[8] Process plan  {2 => 6}
[15-04-28 08:35:48.936 scheduler   RQ00169 TH05832 DBG] Skipping update for a row (PlanID=6) in table Plan. No fields changed.
[15-04-28 08:35:48.936 TaskRunner_ RQ00169 TH05832 TRC]          +++[9] Int bPlanDelegated::checkIfPlanCanBePublished(Int)(6)
[15-04-28 08:35:48.937 RDBMS       RQ00169 TH05832 INF] Prepare [0x7f29f81ed360]: SELECT "PD"."serviceTemplateID" FROM "Subscription" "S" CROSS JOIN "PlanDelegated" "PD" WHERE ((("S"."AccountID"= $1) AND ("S"."Status" <> $2)) AND ("S"."serviceTemplateID" = "PD"."serviceTemplateID")) AND ("PD"."PlanID" = $3) LIMIT $4 OFFSET $5
[15-04-28 08:35:48.937 RDBMS       RQ00169 TH05832 INF] Execute [0x7f29f81ed360]: 1000003, 60, 2, 1, 0
[15-04-28 08:35:48.938 RDBMS       RQ00169 TH05832 DBG] Fetch [0x7f29f81ed360]: 1000004
[15-04-28 08:35:48.939 TaskRunner_ RQ00169 TH05832 TRC] => [2] YES
[15-04-28 08:35:48.939 TaskRunner_ RQ00169 TH05832 TRC]          ---[9] Int bPlanDelegated::checkIfPlanCanBePublished(Int)
[15-04-28 08:35:48.939 TaskRunner_ RQ00169 TH05832 TRC]          +++[9] void bPlan::allowToPublish(Int, Int, Int)(6, 4, 1)
[15-04-28 08:35:48.940 scheduler   RQ00169 TH05832 DBG] Skipping update for a row (PlanID=6) in table Plan. No fields changed.
[15-04-28 08:35:48.941 TaskRunner_ RQ00169 TH05832 TRC]          ---[9] void bPlan::allowToPublish(Int, Int, Int)
[15-04-28 08:35:48.941 RDBMS       RQ00169 TH05832 INF] Prepare [0x7f29f811dfb0]: DELETE FROM "TermConditionForPlan" WHERE "TermConditionForPlan"."PlanID" = $1
[15-04-28 08:35:48.941 RDBMS       RQ00169 TH05832 INF] Execute [0x7f29f811dfb0]: 6
[15-04-28 08:35:48.942 RDBMS       RQ00169 TH05832 INF] Prepare [0x7f29f811f7e0]: SELECT "TermConditionForPlan"."TermID" FROM "TermConditionForPlan" WHERE "TermConditionForPlan"."PlanID" = $1
[15-04-28 08:35:48.943 RDBMS       RQ00169 TH05832 INF] Execute [0x7f29f811f7e0]: 2
[15-04-28 08:35:48.943 RDBMS       RQ00169 TH05832 DBG] Fetch [0x7f29f811f7e0]: 1
[15-04-28 08:35:48.944 TaskRunner_ RQ00169 TH05832 TRC]         ...[8] *** INTERRUPTED BY EXCEPTION *** Process plan

There are terms and conditions assigned to the delegated plan (in the log above plan with id 2).

Cause

The issue is caused by the bug with id #PBA-63488 ("Reseller sync fails if delegated plan has Terms and Conditions assigned").

Resolution

The issue is to be fixed in one of the upcoming BA updates. Until a fix is available, sync the reseller without option to sync Terms and Conditions. As a workaround create copy of T&C manually on the reseller side.

Search Words

Failed to synchronize 2 out of 2 resellers.

198398b282069eaf2d94a6af87dcb3ff caea8340e2d186a540518d08602aa065 e12cea1d47a3125d335d68e6d4e15e07 3627d36199b8ff577605df76e2fa222b bb7e9177fb03488961a3ea554120f328

Email subscription for changes to this article
Save as PDF