Article ID: 111346, created on May 30, 2011, last review on Aug 12, 2014

  • Applies to:
  • Business Automation 5.0

Symptoms

Any/all of the following bugs takes effect:
PBA-29708 Deadlock between billing of a reseller account and processing of Renewal Order of the reseller's customer
PBA-29920 Long PDF is truncated
PBA-30485 [Tsukaeru] Billing Order is generated both for Statement Cycle Date and for Subscription Expiration Date
PBA-30180 Synchronization of reseller subscription lasts too long and locks reseller Account for update
PBA-30478 synchronize reseller sp with delegated plans: only first object use for update

I. Also includes fixes:
1. PBA-29989 Promotions for delegated Plans are not working in PBA 5.0
Symptoms:
IrishDomains has actively used promotions to control reseller prices but in PBA 5.0 this functionality has gone
https://kb.odin.com/111173
2. PBA-29748 Deadlock in PlaceOrderAndAuthorize_API method on Check/Cash payment method in case of free of charge Sales Order
Symptoms:
Deadlock in PlaceOrderAndAuthorize_API method on Check/Cash payment method in case of free of charge Sales Order
https://kb.odin.com/111169
3. PBA-29710 Deadlock between BM::PlaceOrderAndAuthorize_API and BM::PlanUpdate methods
Symptoms:
PlaceOrderAndAuthorize_API fails with deadlock when a plan is updated in CP
https://kb.odin.com/111121
4. PBA-29612 Deadlock on payment creation from Customer's CP in BM::CDB_AddPaymentAndPaymentOrder method
Symptoms:
database deadlock
https://kb.odin.com/11252
5. BA-28761 Subscription ID is not shown in consolidated invoice for resource overusage details
Symptoms:
It is not possible to find out which subscription refers each line of consolidated invoice
https://kb.odin.com/11215
6. PBA-28440 Deadlock in PlaceOrderAndAuthorize_API method on Check/Cash payment method, PBA-29389 Deadlock in MESSAGE::NotifyDebtAccount on IntUsers and ISOCurrency tables
Symptoms:
database deadlock
https://kb.odin.com/11198
7. PBA-28787, PBA-28789, PBA-28790, PBA-28791, PBA-28793, PBA-28794, PBA-28795 Locks of global objects in BM Container
Symptoms:
Sometimes an operation may fail with 'Canceling statement due to statement timeout' error
https://kb.odin.com/11121
8. PBA 5.0.1-276 HOTFIX 11118 PBA-27491 Expiration date spoiled by generateBill
Symptoms:
Expiration date of subscription doesn't change after successful renewal order's processing
https://kb.odin.com/11118
9. PBA-28787, PBA-28789, PBA-28790, PBA-28791, PBA-28793, PBA-28794, PBA-28795 Locks of global objects in BM Container
Symptoms:
Sometimes an operation may fail with 'Canceling statement due to statement timeout' error
https://kb.odin.com/10057
10. PBA-28655 Incorrect resource usage showing.
Symptoms:
All changes of resource usage during day will be ignored until new day.
https://kb.odin.com/10038
11. Cumulative fix for PBA core components (I)
Symptoms:
Cumulative fix for PBA core components
https://kb.odin.com/10032
12. PBA-28350 RESELLERGATE::IsResellerLimitExceeded and CDB_AddPaymentAndPaymentOrder deadlock
Symptoms:
Sometimes attempt to add payment failed because of deadlock in DB caused by simultaneous calls of RESELLERGATE::IsResellerLimitExceeded and  BM::CDB_AddPaymentAndPaymentOrder methods.
https://kb.odin.com/9740
13. PBA-28117 Consolidated invoices not correctly created with billing orders.
Symptoms:
Incorrect consolidated invoice generation. If the account statement day and the billing day is set to one date, consolidated invoice is created once in two statement cycles.
https://kb.odin.com/9726
14. PBA-28186 Rounding of discount and extended prices are incorrect.
Symptoms:
Rounding of discounts and extended prices are calculated incorrect in case currency does not allow decimal part in prices.
https://kb.odin.com/9723
15. PBA-28184 No placeholder for precise unit price
Symptoms:
There is no placeholder for precise unit price.
https://kb.odin.com/9723
16. PBA-27439 DB lock during DailyBilling processing
Symptoms:
Renewal orders stay in "Provisioning" status if DailyBilling processing is running. Status becomes updated only after manual pressing of 'Check order provisioning status' button. Duration is counted incorrectly for the resource purchased somewhere in the middle of the billing period.
https://kb.odin.com/9636
17. PBA-28084 Fix for customization of payments redirect from Customers CP
Symptoms:
Customer specific. "Add payment" customization doesn't attach new payment to invoice automatically.
https://kb.odin.com/9625
18. PBA-27040 IncrementResourceUsage_API works incorrectly
Symptoms:
Measurable resources for some subscriptions have enormous usage values. That happens if resource has some multiplier (say 1024).
https://kb.odin.com/9619
19. PBA-27591 Two Billing Orders are created in one Month
Symptoms:
Two Billing Orders are created in one Month for charged After Billing Period subscriptions.
https://kb.odin.com/9615
20. PBA-27277 'Freeze prices' is not ignored during billing of reseller by provider
Symptoms:
If a subscription of reseller's customer has 'Freeze prices' option enabled and the subscription is created on delegated plan then prices from the subscription is used for the reseller account billing.
https://kb.odin.com/9517
21. PBA-26996 Incorrect diskspace resource amount.
Symptoms:
PBA incorrectly calculates non-additive resource usage on statistics based on POA data: PBA summarizes statistics entries for each day several times.
https://kb.odin.com/9505
22. PBA-27043 ASCII fields for Domain contacts work incorrectly
Symptoms:
User attributes is updated on account attribute update from CCP.
https://kb.odin.com/9504
23. PBA-27311 Cancel orders on a subscription should prevent renewal processing
Symptoms:
Subscription is renewed automatically even if Cancelation Order placed for it.
24. PBA-29322 Deadlock between ResellerOrderCompleted and IsResellerLimitExceeded methods, PBA-29238 Lock of ServiceGate and Service Template in ResellerOrderCompleted method
Symptoms:
Sometimes provisioning of AR Document of reseller's customer fails because of deadlock.
https://kb.odin.com/11171
25. PBA-29232 Redundant lock of AccountInheritance table in RESELLERGATE
Symptoms:
Sometimes provisioning of AR Document of reseller's customer fails because of deadlock.
https://kb.odin.com/11146
26. PBA-29179 of global objects in ResellerOrderCompleted method
Symptoms:
Sometimes call of ResellerOrderCompleted method fails with an error 'Canceling statement due to statement timeout'.
https://kb.odin.com/11130
27. PBA-28832, PBA-28833, PBA-28835, PBA-28837 Locks of global objects in IsResellerLimitExceeded method
Symptoms:
Sometimes call of IsResellerLimitExceeded method fails with an error "Canceling statement due to statement timeout".
https://kb.odin.com/10037
28. PBA-29785 Maximum number of container clones cannot be changed without re-build of the container
Symptoms:
Maximum number of clones of TASKMAN container remains 10, even if MAX_SERVERS variable is increased in TASKMAN.conf to some higher value.
https://kb.odin.com/111166
29. PBA-30053 Deadlock in TASKMAN container on GetTaskToRun and SetTransID methods
Symptoms:
Deadlock in TASKMAN container on GetTaskToRun and SetTransID methods
https://kb.odin.com/111263

Installation instructions

1. Login to PBA APP CT via ssh;

2. Install all previous hotfixes:
perl ~bm/tools/pba-hotfixes.pl install

3. Enter some internal directory, e.g. /root/parallels/:
cd /root/parallels/

4. Download the update installer:
wget --no-cache http://download.pa.parallels.com/pba/5.0/5.0.1-sp1/hotfixes/hf-111346-BM/as4/pba-5.0.1-276-hf111346.sh

5. Stop PBA:
/etc/init.d/pba stop

6. Install the update:
sh pba-5.0.1-276-hf111346.sh

7. Connect to PBA DB server via ssh

8. Become superuser:
sudo su -

9. Drop old pba_verify database
# dropdb pba_verify -U pba

10. Run the configure_db.pl script:
/usr/local/bm/tools-db/configure_db.pl

NOTE: In case PBA APP and PBA DB are installed on one server, use:
/usr/local/bm/tools/configure_db.pl

11. Return to PBA APP CT.

12. Run the configure.pl script:
/usr/local/bm/tools/configure.pl

13. Start PBA:
/etc/init.d/pba start

Additional information

1. The update requires:
- PBA 5.0.1-276 for Linux installed.
- Hotfix 111173 (https://kb.odin.com/111173) installed.

2. BM, RESELLERGATE, AMAIL, MESSAGE, LICENSE, TASKMAN, TASKRUNNER Containers will be restarted automatically during the hotfix installation.

198398b282069eaf2d94a6af87dcb3ff d863a37023d0fbc15b909ef836e29214 92711db0799e8aefe8e51f12dace0496 caea8340e2d186a540518d08602aa065 e12cea1d47a3125d335d68e6d4e15e07

Email subscription for changes to this article
Save as PDF