Checkout getting No such entity with orderId =

Question

I'm using 2.3

But I don't know why when I place an Order I am getting No such entity with orderId=

How can I fix it?

look like this issue

update:

I check in chrome when i place an Order will showing

POST http://XXXX/rest/en/V1/carts/mine/payment-information 400 (Bad Request)

<response>
<message>
The consumer isn't authorized to access %resources.
</message>
<parameters>
<resources>self</resources>
</parameters>
<trace>
#0 public_html/vendor/magento/module-webapi/Controller/Rest/RequestValidator.php(68): Magento\Webapi\Controller\Rest\RequestValidator->checkPermissions() #1 public_html/vendor/magento/module-webapi/Controller/Rest/InputParamsResolver.php(80): Magento\Webapi\Controller\Rest\RequestValidator->validate() #2 public_html/vendor/magento/module-webapi/Controller/Rest/SynchronousRequestProcessor.php(85): Magento\Webapi\Controller\Rest\InputParamsResolver->resolve() #3 public_html/vendor/magento/module-webapi/Controller/Rest.php(188): Magento\Webapi\Controller\Rest\SynchronousRequestProcessor->process(Object(Magento\Framework\Webapi\Rest\Request\Proxy)) #4 public_html/vendor/magento/framework/Interception/Interceptor.php(58): Magento\Webapi\Controller\Rest->dispatch(Object(Magento\Framework\App\Request\Http)) #5 public_html/vendor/magento/framework/Interception/Interceptor.php(138): Magento\Webapi\Controller\Rest\Interceptor->___callParent('dispatch', Array) #6 public_html/vendor/magento/framework/Interception/Interceptor.php(153): Magento\Webapi\Controller\Rest\Interceptor->Magento\Framework\Interception\{closure}(Object(Magento\Framework\App\Request\Http)) #7 public_html/generated/code/Magento/Webapi/Controller/Rest/Interceptor.php(26): Magento\Webapi\Controller\Rest\Interceptor->___callPlugins('dispatch', Array, Array) #8 public_html/vendor/magento/framework/App/Http.php(135): Magento\Webapi\Controller\Rest\Interceptor->dispatch(Object(Magento\Framework\App\Request\Http)) #9 public_html/generated/code/Magento/Framework/App/Http/Interceptor.php(24): Magento\Framework\App\Http->launch() #10 public_html/vendor/magento/framework/App/Bootstrap.php(258): Magento\Framework\App\Http\Interceptor->launch() #11 public_html/index.php(39): Magento\Framework\App\Bootstrap->run(Object(Magento\Framework\App\Http\Interceptor)) #12 {main}
</trace>
</response>

Answer 1

I had the same error before.But on Magento 2.2.8 For my case the problem was only if you did a checkout as logged in customer and not as quest. The errors was coming from that file:

vendor/magento/module-sales/Model/ResourceModel/Order/Plugin/Authorization.php

function: after load

which is checking if the order is allowed for current customer. For my occasion again I was getting that error because of a custom Module which was doing something with the invoice before the moment it should. So I would start debugging my code to see when this function is called and which action is calling it.

I hope it helps someone.

Answer 2

If you receive the error message "No such entity.", "No such entity with" or "No such entity with customerId,OrderId" in Magento 2, the issue usually occurred when you try to load not existing object via Magento 2 Repository Class.

To debug this issue, please open the file

vendor/magento/framework/Exception/NoSuchEntityException.php

and at the beginning of the __construct method temporary add debug backtrace code:

foreach (debug_backtrace() as $_stack) {
    echo ($_stack["file"] ? $_stack["file"] : '') . ':' .
        ($_stack["line"] ? $_stack["line"] : '') . ' - ' .
        ($_stack["function"] ? $_stack["function"] : '');
}
exit();

example:

public function __construct(Phrase $phrase = null, \Exception $cause = null, $code = 0)
 {

    foreach (debug_backtrace() as $_stack) {
        echo ($_stack["file"] ? $_stack["file"] : '') . ':' .
            ($_stack["line"] ? $_stack["line"] : '') . ' - ' .
            ($_stack["function"] ? $_stack["function"] : '');
     }
    exit();


    if ($phrase === null) {
        $phrase = new Phrase('No such entity.');
    }
    parent::__construct($phrase, $cause, $code);
 }

save the file and refresh the page.

You will see the debug backtrace that will allow you to define the issue source and you will get an idea how to fix it.

Usually third party Magento 2 extensions lead up to this problem, so you can override their code and add try-catch exception.

Don't forget to revert changes in NoSuchEntityException.php file after you're finished.

Answer 3

Check url_rewrite table in your database, perform this SQL query

select * from url_rewrite where target_path like '%/category/orderId(in your error)%'
delete from url_rewrite where target_path like '%/category/orderId(in your error)%';

select * from url_rewrite where entity_type='category' and entity_id=orderId(in your error);
delete from url_rewrite where entity_type='category' and entity_id=orderId(in your error);