Resolved eWay - Cards not being processed in Cron

[slim]

I was beta testing the new eWay secure fields in the RC, and it was working mostly OK.

However, after updating to the full release, it appears my cron job is no longer attempting to process cards. The cron appears to complete OK - But in the cron email, it says '0' Credit Card Charges..  I can see lots of overdue invoices for the last two days - none have been attempted. I was able to process them manually via the admin area in WHMCS, but obviously somthing has gone wrong.

Anyone else have same issue?

[jclarke]

I'm having the same issue with multiple WHMCS instances. I opened a ticket and haven't gotten anywhere with support yet.

[slim]

eWAY or other gateways?

[jclarke]

I'm using a different gateway, for some reason WHMCS isn't attempting to capture any due payments.

[slim]

Good... 🙂 it should get fixed faster if it effects everyone.

[jclarke]

You might want to open a ticket, support told me they couldn't replicate the issue but it has happened now two days in a row on multiple WHMCS instances on multiple servers for me.

[WHMCS Lawrence]

5 hours ago, jclarke said:

You might want to open a ticket, support told me they couldn't replicate the issue but it has happened now two days in a row on multiple WHMCS instances on multiple servers for me.

Hello,

Looking over your ticket, I can see that we requested additional details to perform further investigation. Please follow up with them so we can do so.

We've attempted to reproduce this locally, but cannot at this time. This would normally suggest that the underlying cause is a cron-related issue (for example: the crons folder wasn't updated during the update, an unexpected issue with cron on the server itself, etc) that is either causing the cron job to fail to complete or preventing the credit card task itself from completing. The first thing to do would be to debug the cron using our instructions at https://help.whmcs.com/m/automation/l/683269-advanced-cron-troubleshooting

At the very least, that should reveal any errors that are occurring and those can be investigated further. I'd recommend opening a ticket with the findings from the above and we can assist further.

[Po1son]

All of my WHMCS instance can not run daily Cron, I check the log, the daily Cron can start,but can't complete.

[slim]

Ok, I have followed the WHMCS tutorial for troubleshooting the cron.. 

[xxx@xxx~]$ php -q /home/xxxx/xxxxx/crons/cron.php all -F -vvv

WHMCS Automation Task Utility: all
==================================

 Daily Cron Automation Mode

Queuing Tasks
-------------

 Force run any tasks: ignore "in progress" and "is due"
 Task queues ready

Executing Application Queue
---------------------------

  0/31 [░░░░░░░░░░░░░░░░░░░░░░░░░░░░]   0% < 1 sec/< 1 sec 20.0 MiB
 Currency Exchange Rates
  1/31 [░░░░░░░░░░░░░░░░░░░░░░░░░░░░]   3% < 1 sec/< 1 sec 20.0 MiB
 Product Pricing Updates
  2/31 [▓░░░░░░░░░░░░░░░░░░░░░░░░░░░]   6% < 1 sec/< 1 sec 22.0 MiB
 Tenant Usage Metrics
  3/31 [▓▓░░░░░░░░░░░░░░░░░░░░░░░░░░]   9% 2 mins/20 mins 24.0 MiB
 Invoices
  4/31 [▓▓▓░░░░░░░░░░░░░░░░░░░░░░░░░]  12% 2 mins/20 mins 48.0 MiB
 Late Fees
  5/31 [▓▓▓▓░░░░░░░░░░░░░░░░░░░░░░░░]  16% 2 mins/16 mins 48.0 MiB
 Credit Card Charges
  6/31 [▓▓▓▓▓░░░░░░░░░░░░░░░░░░░░░░░]  19% 2 mins/13 mins 48.0 MiB
 Invoice & Overdue Reminders
  7/31 [▓▓▓▓▓▓░░░░░░░░░░░░░░░░░░░░░░]  22% 3 mins/14 mins 48.0 MiB
 Domain Renewal Notices
  8/31 [▓▓▓▓▓▓▓░░░░░░░░░░░░░░░░░░░░░]  25% 3 mins/13 mins 50.5 MiB
 Cancellation Requests
  9/31 [▓▓▓▓▓▓▓▓░░░░░░░░░░░░░░░░░░░░]  29% 3 mins/12 mins 50.5 MiB
 Overdue Suspensions
 10/31 [▓▓▓▓▓▓▓▓▓░░░░░░░░░░░░░░░░░░░]  32% 3 mins/10 mins 50.5 MiB
 Overdue Terminations
 11/31 [▓▓▓▓▓▓▓▓▓░░░░░░░░░░░░░░░░░░░]  35% 3 mins/9 mins 50.5 MiB
 Fixed Term Terminations
 12/31 [▓▓▓▓▓▓▓▓▓▓░░░░░░░░░░░░░░░░░░]  38% 3 mins/9 mins 50.5 MiB
 Inactive Tickets
 13/31 [▓▓▓▓▓▓▓▓▓▓▓░░░░░░░░░░░░░░░░░]  41% 3 mins/8 mins 50.5 MiB
 Prune Ticket Attachments
 14/31 [▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░░░░░░░░░░]  45% 3 mins/7 mins 50.5 MiB
 Delayed Affiliate Commissions
 15/31 [▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░░░░░░░░░]  48% 3 mins/7 mins 50.5 MiB
 Affiliate Reports
 16/31 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░░░░░░░░]  51% 3 mins/6 mins 50.5 MiB
 Email Marketer Rules
 17/31 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░░░░░░░]  54% 3 mins/6 mins 50.5 MiB
 SSL Sync
 18/31 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░░░░░░]  58% 5 mins/8 mins 50.5 MiB
 Credit Card Expiry Notices
 19/31 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░░░░░]  61% 5 mins/8 mins 50.5 MiB
 Server Usage Stats
 20/31 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░░░░]  64% 5 mins/8 mins 50.5 MiB
 Overage Billing Charges
 21/31 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░░░░]  67% 5 mins/7 mins 50.5 MiB
 Client Status Update
 22/31 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░░░]  70% 5 mins/7 mins 50.5 MiB
 Domain Expiry
 23/31 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░░]  74% 5 mins/6 mins 50.5 MiB
 Ticket Escalation Rules
 24/31 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░]  77% 5 mins/6 mins 50.5 MiB
 Data Retention Pruning
 25/31 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░]  80% 5 mins/6 mins 50.5 MiB
 Update Server Usage
 26/31 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░]  83% 5 mins/6 mins 50.5 MiB
 Update Server Meta Data
 27/31 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░]  87% 5 mins/5 mins 50.5 MiB
 Run Jobs Queue
 28/31 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░]  90% 5 mins/5 mins 50.5 MiB
 WHMCS Updates
 29/31 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░]  93% 5 mins/5 mins 56.5 MiB
 Domain Transfer Status Synchronisation
 30/31 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░]  96% 5 mins/5 mins 56.5 MiB
 Domain Status Syncronisation
 31/31 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓] 100% 5 mins/5 mins 58.5 MiB

 Sending Daily Cron Digest email

Executing System Queue
----------------------

 4/4 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓] 100% < 1 sec/< 1 sec 58.5 MiB

 [OK] Completed
 

However, When I look at the overdue invoice list I can see a bunch of invoices that are due that should have processed but didn't. I also checked my eWay logs and there were ZERO attempts at any card transactions. (see the attached image showing the invoices due yesterday.. its the 12th here today at about 9:30am)

 

I can also confirm the CRON folder was updated.. All files except the config.php file have a file date of 8th Jan 2020, which is the date I updated to 7.9 from the RC. The contents of cron.php are:

 

// * WHMCS - The Complete Client Management, Billing & Support Solution    *
// * Copyright (c) WHMCS Ltd. All Rights Reserved,                         *
// * Version: 7.9.0 (7.9.0-release.1)                                      *
// * BuildId: 2fe3943.452                                                  *
// * Build Date: 08 Jan 2020  

To make matters even worse, WHMCS is sending overdue invoices to customers whos invoice wasn't paid during yesterdays cron.. resulting in a customer service nightmare.

Edited January 11, 2020 by slim
add info about cron folder

[jclarke]

There is a bug in the code, I provided with support more details so hopefully they will have a fix soon. If you check "Attempt Only Once" in automation settings it will fix it for now. 

[Po1son]

here is mytroubleshooting

WHMCS Automation Task Utility: all
==================================

Daily Cron Automation Mode

Queuing Tasks
-------------

Force run any tasks: ignore "in progress" and "is due"
Task queues ready

Executing Application Queue
---------------------------


Currency Exchange Rates

Product Pricing Updates

Tenant Usage Metrics

Invoices

Late Fees

Credit Card Charges

Invoice & Overdue Reminders

Domain Renewal Notices

Cancellation Requests

Overdue Suspensions

Overdue Terminations


0/31 [░░░░░░░░░░░░░░░░░░░░░░░░░░░░] 0% < 1 sec/< 1 sec 28.0 MiB
3/31 [▓▓░░░░░░░░░░░░░░░░░░░░░░░░░░] 9% 3 secs/31 secs 32.0 MiB
6/31 [▓▓▓▓▓░░░░░░░░░░░░░░░░░░░░░░░] 19% 4 secs/21 secs 32.0 MiB
9/31 [▓▓▓▓▓▓▓▓░░░░░░░░░░░░░░░░░░░░] 29% 10 secs/34 secs 52.5 MiB

 

and

 

WHMCS Automation Task Utility: all
==================================

Daily Cron Automation Mode

Queuing Tasks
-------------

Force run any tasks: ignore "in progress" and "is due"
Task queues ready

Executing Application Queue
---------------------------


Currency Exchange Rates

Product Pricing Updates

Tenant Usage Metrics

Invoices

Late Fees

Credit Card Charges

Invoice & Overdue Reminders

Domain Renewal Notices

Cancellation Requests


0/31 [░░░░░░░░░░░░░░░░░░░░░░░░░░░░] 0% < 1 sec/< 1 sec 28.0 MiB
3/31 [▓▓░░░░░░░░░░░░░░░░░░░░░░░░░░] 9% 2 secs/21 secs 32.0 MiB
6/31 [▓▓▓▓▓░░░░░░░░░░░░░░░░░░░░░░░] 19% 2 secs/10 secs 32.0 MiB

and I close“ Enable Termination   ” and“Cancellation Requests”, the daily cron is run correctly.

 

but But I have to manually terminate the service and cancel the product with cancellation request.

I think this is a bug, when will it be fixed? I have also submitted a ticket 

[WHMCS John]

Hi @slim and @jclarke,

We have identified an issue which could be the cause of the behaviour you are seeing here.

Please change the Setup > Automation Settings > Retry Every Week For setting to 0,

or tick the "Attempt Only Once" checkbox.

 

We have opened case CORE-14171 internally regarding this for further investigation as a priority.

 

@Po1son,

This situation where the automation tasks are not completing is slightly different to that being discussed here, and wouldn't impact credit card processing.

[Jerry1]

Please note That we are having the same issue with our PayPay gateway since upgrading to 7.9 - Running an invoice through manually and it works. Cron works. Invoices just sit in the queue and don’t get charged.

I have a ticket open and have been trying to resolve this for 3 days. I am being told that whmcs don’t support the PayPal gateway and its not supported even though that Gateway came with the install. Does not seem very professional after reading this,

I will try changing re-billing to 0. Thanks,

jerry

[Po1son]

8 hours ago, WHMCS John said:

嗨@slim和@jclarke，

我们发现了一个问题，可能是您在此处看到的行为的原因。

请更改设置>自动化设置>每周重试设置为0，

或勾选“仅尝试一次”复选框。

 

我们已在内部针对此问题打开了CORE-14171案，以作为进一步调查的重点。

 

@ Po1son，

自动化任务未完成的情况与此处讨论的情况略有不同，并且不会影响信用卡处理。

Thank you ,my problem has been solved by CORE-14170

[Jerry1]

9 hours ago, Jerry1 said:

Please note That we are having the same issue with our PayPay gateway since upgrading to 7.9 - Running an invoice through manually and it works. Cron works. Invoices just sit in the queue and don’t get charged.

I have a ticket open and have been trying to resolve this for 3 days. I am being told that whmcs don’t support the PayPal gateway and its not supported even though that Gateway came with the install. Does not seem very professional after reading this,

I will try changing re-billing to 0. Thanks,

jerry

Turning off auto re-billing after cc fail took care of it.

[slim]

Lets hope they release a hotfix soon.

[WHMCS John]

Hi all,

I'm pleased to advise a hotfix has now been produced to provide an immediate resolution:

My apologies for the inconvenience caused.

[slim]

I can see a new version of WHMCS 7.9.1 includes this fix. I have installed it and run the CRON via the command line as per the troubleshooting guide.

**I can confirm that the cards now process as they are supposed to**

Thanks!

[WHMCS John]

Hi all,

I'm pleased to advise this is addressed the 7.9.1 maintenance update. Please apply this update via Utilities > Update WHMCS:

Quote

CORE-14171 - Prevent error on credit card retries

https://docs.whmcs.com/Changelog:WHMCS_V7.9.1