Article ID: 118472, created on Nov 6, 2013, last review on Aug 18, 2015

  • Applies to:
  • Business Automation

Symptoms

Cancellation order fails in PBA with the following error message:

Removing of Service of Subscription #ID is failed. Stop service of Order Item #ID failed.

The exception appears in the BM.log file or generic_worker.log file on the PBA Application server after selecting reason code #13 from the database:

[...] Exclusively locking a row (ReasonID=13) in table SubscrReasonCode
[...] Prepare [023D08E0]: SELECT "T65871192"."ReasonID", "T65871192"."OperType", "T65871192"."Reason", "T65871192"."UserArc", "T65871192"."DateArc" FROM "SubscrReasonCode" "T65871192" (UPDLOCK)  WHERE ("T65871192"."ReasonID") = (?)
[...] Rows fetched: 0, internal storage capacity: 0 bytes.
...
[...]   ...[2] *** INTERRUPTED BY EXCEPTION *** class ErrorMessage *__thiscall BM::StopSubscription(class STLRT::Type::Numeric<int>,class STLRT::Type::Numeric<int>,class Str)

Cause

The subscription cancellation reason code #13 is absent in the POA database. It was probably deleted manually.

Resolution

Check if the reason code with ID #13 exists in the PBA Provider Control Panel at Configuration Director > Miscellaneous Settings > Reason Codes. If it does not exist contact the Parallels Support team, reason code must be added manually in the PBA database.

Search Words

cancellation order failing

Other

Removing of Service of Subscription #1094132 is failed. Stop service of Order Item #1436816 failed.

198398b282069eaf2d94a6af87dcb3ff caea8340e2d186a540518d08602aa065 e12cea1d47a3125d335d68e6d4e15e07

Email subscription for changes to this article
Save as PDF