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.