SAP Knowledge Base Article - Public

3349418 - Remote table replication via OData fails due returned status 500


When loading a new snapshot for a Remote Table which source is a Generic OData connection, error occurs:

Error: {"timestamp":"20XX-XX-XX XX:XX:XX.XXXXXXX", "origin":"_sys_task", "message":"internal error: connection to ODATA_URL:ODATA_PORT returned status 500 at ptime/query/plan_executor/dml/hex/; Statement: ,INSERT INTO ...


SAP Datasphere

Reproducing the Issue

Replicating data from remote source into SAP Datasphere


Remote query fails due ERROR status 500 SAP Internal Server Error.
This is due to issue in retrieving data from OData service.
This message may occur when the amount of data handled during the query is too high, and may exceed the limit transactional data. 


The best approach will be reducing the total records retrieved in your query, such number of characteristics included in $select or add selections by using $filter.

Furthermore, adjust the remote query like:

  • Increase the parameter $inlinecount=allpages&  in the query before the $skip parameter. This parameter is useful for queries which handle high amounts of data.
  • Not assigned and null values has to be passed as filter condition in the format ‘” “’.

Use filter to limit the amount of data fetched to avoid such out of memory issues. 

See Also

SAP KBA 2806920 - OData Error " 500 SAP Internal Server Error" No more memory available to extend an internal table. (termination: RABAX_STATE)


generic odata, C4C, query, odata, 500 SAP Internal Server Error, no more memory available to extend an internal table. (termination: RABAX_STATE), RABAX_STATE, AP-RC-ANA; gateway timeout; timeout; time out;  , KBA , DS-DI-RT , Remote Tables , Known Error


SAP Datasphere all versions