If you have a product in an order that doesn't have any rates configured, then rates will fail and no rate will show.
For instance, in the below screenshot, the product group Fruit has no rates configured.
If a product from the Fruit group is in an order, no rate will show.
In order to get rates to show.
- Add rates to the group
- Re-assign the product to a group that does have rates configured
Read more on how to figure out which group a product is assigned to.