Looking for Developer for finding technical issues

[dirk_meid]

Hi,

we need a Pro to find out why we're missing orders in Magento 2. Some orders are not listed in the backend although we get the paypal payment.
We have log files with error messages but we don't know, where the error is.

Please pm.

Thanks,

Daniel

[Sunil Patel]

Hello @dirk_meid 

does this order showing into sales_order table?

[PankajS_Magento]

Hi @dirk_meid 

We will definitely help you. Can you please share the scenario of the issue and the some more details of error you are facing?

Thanks

[dirk_meid]

Hi,

no, it does not show up in the sales_order table!

[dirk_meid]

This ist the error message found in the log file:

[2020-02-19 18:14:54] main.CRITICAL: The "000000104" order ID is incorrect. Verify the ID and try again. {"exception":"[object] (Exception(code: 0): The \"000000104\" order ID is incorrect. Verify the ID and try again. at /html/magento/vendor/magento/module-paypal/Model/Ipn.php:143)"} []

[David Duong]

In my case, I found the issue is

`Numeric value out of range: 167 Out of range value for column 'sequence_value' at row 1, query was: INSERT INTO `sequence_invoice_1` () VALUES ()`

Then I go to table sequence_invoice_1 and have changed type of "sequence_value" from int(10) to bigint(20). Now, it works fine.

Our customer have a lot order migration from Magento 1 to Magento 2. That is an issue. Hope it can help someone.

Alothemes - Happy Coding!