Resolved eWay - Cards not being processed in Cron

slim · January 11, 2020

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 · January 11, 2020

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

slim · January 11, 2020

eWAY or other gateways?

jclarke · January 11, 2020

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

slim · January 11, 2020

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

jclarke · January 11, 2020

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 · January 11, 2020

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 · January 11, 2020

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

slim · January 11, 2020

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 · January 11, 2020

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 · January 12, 2020

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 · January 12, 2020

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 · January 12, 2020

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 · January 12, 2020

8 hours ago, WHMCS John said:

嗨@slim和@jclarke，

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

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

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

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

@ Po1son，

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

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

Jerry1 · January 12, 2020

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 · January 12, 2020

Lets hope they release a hotfix soon.

WHMCS John · January 13, 2020

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 · January 14, 2020

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 · January 14, 2020

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

Resolved eWay - Cards not being processed in Cron

Recommended Posts

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Join the conversation

Similar Content

Recently Browsing 0 members

Important Information