[ECP-9538] Orders Stuck in Pending Status Due to Empty adyenOrderPayments Parameter

[jvrodriguesgranado]

Describe the bug
Hello,

I'm encountering an issue where some orders in my Magento 2 e-commerce store remain stuck in the "pending" status. After investigation, I identified the problem within the compareAdyenOrderPaymentsAmount function, located in the adyen/module-payment/Helper/AdyenOrderPayment.php file.

To Reproduce
I was unable to reproduce this issue in a local environment, but I added a log in the production environment to gather evidence. I encounter around 5 orders daily with this problem. Even though the payment is approved in the Adyen dashboard, the order status remains "pending" in Magento.

Magento version
2.4.6-p4

Plugin version
9.8.1

Screenshots

[candemiralp]

Hello @jvrodriguesgranado,

Thank you for raising this issue. The issue that you have described sounds very similar to a known issue due to having synchronous database replication of Adobe Commerce enabled.

Could you please try disabling synchronous database replication and observe the system?

Best Regards,
Can

[jvrodriguesgranado]

I spoke with our architecture team at Granado, and we are unable to implement the suggested solution. Since this is a recommendation from Adobe, we cannot risk losing the benefits defined by Adobe for this functionality, particularly scalability:

Provides data backup
Enables data analysis without affecting the master database
Scalability

[jvrodriguesgranado]

Hello, is there any update regarding this issue? It is still occurring in our production environment.

[candemiralp]

Hello @jvrodriguesgranado,

Thank you for sharing your insights. Currently, there is no solution to concrete solution to this issue. Adobe proposed the solution to disable the synchronous replication.

The reason behind the issue is that Adobe Commerce instance writes the data to DB instance A and tries to fetch the data on the next line immediately from DB instance B. IMO, this is related to synchronisation performance of Adobe Commerce.

You can check this line where the issue occurs. I will keep this issue open for further internal discussions and external recommendations.

Best Regards,
Can