3039041 - Error ‘[COE0019]Fail to retrieve snapshot keys’ while using SAP Standard OData API – Cloud Integration

You want to execute an SAP Standard OData API with specific search criteria via ODataV2 Receiver adapter. During the message processing in your Integration Flow you see an error which is occurring in the ODataV2 Receiver adapter.

In the Message Processing Log of the Integration Flow:

ResponseBody        = <?xml version="1.0" encoding="utf-8"?><error xmlns="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata"><code>COE_GENERAL_SERVER_FAILURE</code><message lang="en-US">[COE0019]Failed to retrieve result with given criteria.</message></error>

AND

HTTP 500 Internal Server Error in the Message Processing Log of the Integration Flow:

Message Processing Log:
  StartTime           = Thu Feb 18 13:19:11.977 UTC 2021
  StopTime            = Thu Feb 18 13:19:14.044 UTC 2021
  OverallStatus       = FAILED
  MessageGuid         = AGAuaU80SR2tvd7jQlrHv6K1Fbjb
  ChildCount          = 0
  ChildrenCounter     = 8
  ContextName         = [Integration Flow name]
  CorrelationId       = AGAuaU8H0nDc0UcMoOmjcwBcdIpw
  IntermediateError   = true
  LastError           = com.sap.gateway.core.ip.component.odata.exception.OsciException: Internal Server Error : 500 : HTTP/1.1 
  LastErrorModelStepId= MessageFlow_99402
  Node                = vsa8145006
  OriginComponentName = CPI_[tenant ID]
  PreviousComponentName= CPI_[tenant ID]
  ProcessId           = 26df43ea1aaaf0e515fe1c028d9ab23db892c25e
  TransactionId       = 8c500338e2cf4429bf7c43e51dc576c3

The same call with the same search criteria also fails in SOAP UI/ Postman with following error:

<error xmlns=”http://schemas.microsoft.com/ado/2007/08/dataservices/metadata”>
          <code>COE_GENERAL_SERVER_FAILURE</code>
          <message lang=“en-US“>[COE0019]Failed to retrieve result with given criteria.</message>
</error>

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."

SAP Cloud Integration

HCI, HANA Cloud Integration, SAP Cloud Platform Integration, SAP Cloud Integration, CPI, ODataV2 Receiver Adapter, HTTP 500, Internal Server Error, COE0019, COE_GENERAL_SERVER_FAILURE, Failed to retrieve result with given criteria , KBA , LOD-HCI-PI-CON-OD , OData Adapters , Problem