[Bug]: /ratings/{rating-id} throws error code 500 when that rating spec is not found

Describe the bug

The /ratings/{rating-id} endpoint returns error code 500 where the /ratings/spec/{rating-id} for the same id throws an error code 404.

Expected behavior

Consistency between endpoints so that calling applications can respond accordingly.

To Reproduce

Returns 404:

curl -X 'GET' \
  'https://cwms-data-test.cwbi.us/cwms-data/ratings/spec/EUFA.Stage%3BFlow.Standard.Production?office=SWT' \
  -H 'accept: application/json;version=2' \
  -H 'Cache-Control: no-cache, no-store, max-age=0' \
  -H 'Pragma: no-cache'

Returns 500:

curl -X 'GET' \
  'https://cwms-data-test.cwbi.us/cwms-data/ratings/EUFA.Stage%3BFlow.Standard.Production?office=SWT' \
  -H 'accept: application/json;version=2' \
  -H 'Cache-Control: no-cache, no-store, max-age=0' \
  -H 'Pragma: no-cache'

Priority

Medium

Logs/Incident Identifier

{
  "message": "Failed to process request to retrieve RatingSet",
  "incidentIdentifier": "e3faf90a-33e2-47a7-b1cf-a914c5b3f79d",
  "source": "Unknown",
  "details": {}
}

CURL Commands

CDA Version

CWBI Test - 2026.05.12-testf

Additional context

No response

Start by running the two documented curl requests against the ratings endpoints and compare their responses for the missing rating ID. Trace the /ratings/{rating-id} entry point to where the RatingSet retrieval error is converted into an HTTP response. Done means the missing rating returns 404 consistently with /ratings/spec/{rating-id}, with the relevant API tests passing.