cancel
Showing results for 
Search instead for 
Did you mean: 

magento 2.3.2 order not found in staging table

magento 2.3.2 order not found in staging table

i am getting below error on some of the orders

 

main.CRITICAL: Oracle Order Error {"exception":"[object] (stdClass: {\"code\":500,\"message\":\"Order not found in staging table.\"})","order_number":"3000000729_882"} []

5 REPLIES 5

Re: magento 2.3.2 order not found in staging table

@aliatrista6f22 

seems like you have 3rd party integration with Oracle 

kindly check with that extension or backend at oracle 

the issue should be for the order which does not exist in your oracle database. 

 

Re: magento 2.3.2 order not found in staging table

integration with oracle is through REST APIs

Re: magento 2.3.2 order not found in staging table

@aliatrista6f22 

you need to check where you are checking in REST API that is communicating with oracle DB 

because it seems like an exception is thrown there when order is not found. 

Re: magento 2.3.2 order not found in staging table

the thing is that for some customers orders are working fine for some customers only orders are not hitting the staging table, i checked the settings and all its same for working customer and non working customer.

Re: magento 2.3.2 order not found in staging table

yes that is the issue.

some orders are not getting into the staging table.

you need to check the connector that is sending the order data to Oracle Rest APIs. 

also implement followings

1. put logs on some steps. that will help you to debug. 

2. implement try-catch while sending data to REST APIs. and log in case of Exception.