Search Engine: Elastic

Article ID: 122083, created on Jun 19, 2014, last review on Jun 19, 2014

  • Applies to:
  • Business Automation 5.4


Some subscriptions that had expiration date after 28th were renewed till 28th in February. For example expiration date of the subscription in January was January, 30, but when subscription was renewed in February expiration became March, 28.


Only subscription with 'Auto-Renew' option enabled are affected.

The issue is caused by bug #PBA-42719 which is fixed in PBA-E 5.5.


You can find all affected subscription using the following query:

select * from (SELECT  "subscriptionID", "startDate"::abstime, "ExpirationDate"::abstime, "Status" as Status, "IsAutoRenew" as AutoRen, EXTRACT(DAY FROM  to_timestamp("startDate") ) as startD, EXTRACT(DAY FROM  to_timestamp("ExpirationDate") ) as expD from "Subscription" ) A where startD in (29,30,31) and expD = 28 and AutoRen=1 and Status=30;

Then you can correct expiration date using start date of the subscriptions. For example you can do it in Provider's control panel using 'Change Expiration Date' button on General tab of the subscription.

198398b282069eaf2d94a6af87dcb3ff caea8340e2d186a540518d08602aa065 210d017ddc3a076d22f0f865b1cf0730 92711db0799e8aefe8e51f12dace0496 e12cea1d47a3125d335d68e6d4e15e07

Email subscription for changes to this article
Save as PDF