Observation search failing for a specific patient

[Michele Mottini]

Hi,

  seeing this failure when searching Observation for a specific patient at EAMC:

• When :  11/11/2021 2:02:49 PM -05:00
• Resource :  Observation
• Request :  GET https://fhir-myrecord.cerner.com/dstu2/c5013bf3-ebba-4bda-8574-ed83da9e1633/Observation?patient=1561871&_lastUpdated=ge2021-11-10T16%3A52%3A44.193%2B00%3A00
• Response status code :  500
•  Response headers
  • Transfer-Encoding :  chunked
  • Connection :  keep-alive
  • Vary :  Origin, User-Agent
  • Server-Response-Time :  951.6805019999999
  • X-Request-Id :  df17c2ca-368d-4279-bda7-54ecc4fcfb45
  • Status :  500 Internal Server Error
  • X-Cache :  Error from cloudfront
  • X-Amz-Cf-Pop :  IAD89-C1
  • X-Amz-Cf-Id :  -8fwxsBvKGN52S0U2xAVOu0js38Wn68_1Xr5EWO4u3eK9O38L0KkqA==
  • Cache-Control :  no-cache
  • Content-Type :  application/json+fhir; charset=utf-8
  • Date :  Thu, 11 Nov 2021 19:02:49 GMT
  • Via :  1.1 417c242b19212928b079740e6dd8f54c.cloudfront.net (CloudFront)
• Response : 

  {
      "resourceType": "OperationOutcome",
      "issue": [
          {
              "severity": "fatal",
              "code": "required",
              "location": [
                  "/f:Observation/f:code"
              ]
          }
      ]
  }

Thanks

- Michele

CareEvolution

[Esmeralda Bolanos (Cerner)]

Greetings,

The Observation that is causing issues has a SHX_ACTIVITY.SHX_CATEGORY_REF_ID of 2661, which when looking in the SHX_CATEGORY_REF table, has a CATEGORY_CD of 0. 

Since the CATEGORY_CD is 0, mappings can't be determined for the code, hence the failure.

To resolve this, the SHX_CATEGORY_REF table would need to be fixed to populate the CATEGORY_CD of the rows that have it set to 0 to an appropriate code value.

Thank you,

   Esme (Cerner)