All data is available in the database. Than why data is not in sales grid?
Anyone has idea about this problem?
Disable Async Grid Indexing
As mentioned in the other answer, you can disable it by going to
Store > Configuration > Advance > Developer > Grid Settings > Asynchronous indexing
You can do the same from the command line:
View the settings value:
bin/magento config:show dev/grid/async_indexing
bin/magento config:set dev/grid/async_indexing 1
bin/magento config:set dev/grid/async_indexing 0
Run Cron Job
It is not recommended to disable async grid indexing as it might degrade the performance.
The grid updates are done by the scheduled cron job.
The best solution would be to run the cron job at regular intervals.
Or, you can also run cron job manually via the following command:
After that, refresh cache:
Try to use this tool https://github.com/trunglv/mage2_dev
sudo bin/magento beta_dev:build_order_grid --missing-orders true
sudo bin/magento beta_dev:build_order_grid --missing-orders [order_id]