magento 2.3.2 order not found in staging table

[aliatrista6f22]

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"} []

[amitsamsukha]

@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. 

[aliatrista6f22]

integration with oracle is through REST APIs

[amitsamsukha]

@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. 

[aliatrista6f22]

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.

[amitsamsukha]

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.