3021869 - OData GET Call on SurveyResponseCollection Running For Too Long or Timing Out

You are trying to execute a GET in the SurveyResponseCollection of c4codataapi, but the process runs for too long without completing or eventually times out.

SAP Cloud for Customer

1. Go to the Administrator work center.
2. Access the OData Service Explorer view.
3. Select the row for c4codataapi and click Test.
4. In the OData Service Explorer, locate and select SurveyResponseCollection.
5. Navigate to the Test tab.
6. Click Execute.
7. Process will run for a long time or time out.

By accessing the GET URL (https://myXXXXXX.crm.ondemand.com/sap/c4c/odata/v1/c4codataapi/SurveyResponseCollection) in a browser, you might see the following message:

Internal Server Error - Read
The server encountered an internal error or misconfiguration and was unable to complete your request.

GET calls to SurveyResponseCollection are process-intensive because of property RepresentationBinaryObject in the collection: entire survey data is collected and organized in a certain way and then converted into Binary format before it is sent through this property. As there are around 1001 records for SurveyResponseCollection, the OData times out because of this.

There are two workarounds for this, depending on whether you need RepresentationBinaryObject in the response:

• If binaryObject is required, please use filters in the GET URL to restrict the call to a smaller set of data;
• If this binaryObject is not required, please use Data Workbench for the data download. In DWB, the column XML_Base64 (the binaryObject column) can be unchecked, which will speed up the download.

SurveyResponseCollection, GET, Time Out, The server encountered an internal error , KBA , LOD-LE-SUR-DEF , Survey definition = design time , AP-RC-ODF , OData framework (C4C Only) , How To

SAP Cloud for Customer add-ins all versions ; SAP Cloud for Customer core applications all versions