PRODUCT API ERROR

Url Key: big-boss-pool-noodle-21-per-case
Id: -1
SKU: UNKNOWN
Name: Product Lookup Failed
Error Message: Product lookup by failed: SELECT a.entity_id, a.sku FROM `catalog_product_entity` AS a LEFT JOIN catalog_product_entity_varchar AS b ON a.entity_id = b.entity_id WHERE b.value = "big-boss-pool-noodle-21-per-case"
Debug Info:

Product lookup by failed: SELECT a.entity_id, a.sku FROM `catalog_product_entity` AS a LEFT JOIN catalog_product_entity_varchar AS b ON a.entity_id = b.entity_id WHERE b.value = "big-boss-pool-noodle-21-per-case"