Can't download Social Buzz report

Social Buzz Download Solution

When you try to export data from the Social Buzz report using the download option, the Excel reports download but the files are corrupted.

Steps to reproduce

  1. Log in to Adobe Social
  2. Go to Analytics > Social Buzz report > Select Date range > Select Download report icon to pull down report.

Note:

File downloads, but if you open the file it could give the following error.

Windows OS system error is:

"Excel cannot open the file 'Social Buzz.xlsx' because the file format or filename extension is not valid. Verify that the file has not been corrupted and that the filename extension matches the format of the file."

cebble

Or, on a Mac, the error is:

"Excel cannot open this file. The file or filename extension is not valid. Verify that the file has not been corrupted and the filename extension matches the format of the file."

bebble

Solution

There is workaround while a permanent solution is put into place to fully address the issue. The permanent solution is scheduled for release in the June MR. (3.3.1)

  1. First, try clearing the cache on the Internet browser that you are using, log back in to Social, and try to download the report again.
  2. If you still receive the error message, try to open the file with a text editor.

Within the text editor, you could see the following:

{"result":false,"error_message":"mb_parse_str(): Input variables exceeded 1000. To increase the limit change max_input_vars in php.ini."}

The error means that you have exceeded the variable Social is using to pull reporting for the given date range.

File a support incident or ticket with the Adobe Social support team including the problematic attachment file that you received. To work around the error as a temporary fix, try exporting smaller requests for the date range.