function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Ankit Singh 6Ankit Singh 6 

Getting error -1474772396 while fetching report data through REST api call

Hi All

We are trying to fetch reports data from salesforce using REST api call. We are using below api call :
https://cs15.salesforce.com/services/data/v29.0/analytics/reports/00O40000003XxXCEA0?export=1&enc=UTF-8&xf=CSV&data=2&includeDetails=true

The above call works for some of our client but not for others. On fetching data users are facing below error :
Salesforce Reponse: [{"message":"An unexpected error occurred. Please include this ErrorId if you contact support: 1950640632-71631 (-1474772396)","errorCode":"UNKNOWN_EXCEPTION"}]

Please let me know resolution for this as it is creating problem for many users.

Regards
Ankit
Daniel BallingerDaniel Ballinger

That is a GACK response code. See What Is A Gack? (https://developer.salesforce.com/blogs/engineering/2015/02/gack.htmlAre you able to raise this as a support case?

Can you make a distinction between the clients it works for and those it doesn't? I.e.

  • Does the report work when run through the standard Salesforce UI
  • Is there something in the report data that might be causing problems? Think characters that have significance in the CSV format. Commas, double quotes, carriage returns.
Ankit Singh 6Ankit Singh 6
Yes report works when they run through standard Sallesforce UI.
Yes, we have already raised this as a support case.
Daniel BallingerDaniel Ballinger
OK. I suspect the problem will be in the encoding of the report data into the CSV report format. 
The Salesforce support case will be the best way to get the actual underlying cause without a lot of trial and error.