Exporting a list of records in excel/csv/pdf/xml results an empty file

[antonymirza]

Hi,

We have some reports using on CMS portal. Reports are working fine, when click on chart bar, it takes me to the list layout which is ok. But, when exporting that list of records in any format e.g. Excel/CSV/PDF, the file is always empty.

The report is generated from incident_sla table (it's a database view from task_sla and incident) and I have already checked there is no such ACL / Query BR script which is causing it. Since, it is on CMS portal therefore, I cannot see anything when enable System Diagnostics options.

Has anyone experienced it before?

Brgds, AM

[pankaj_puniani]

Hi Antony,

I'm not sure about the CMS part but one reason file after export could be empty is that user triggering export doesn't have permission to access those records.   Try hitting http://<servicenow_instance>/incident_sla_list.do directly and see if you see any records.

Thanks,

Pankaj

[antonymirza]

Hi Pankaj,

I already tested using an example URL you shared to verify if user has access. When I go to respective CMS page, report gauge is loaded ok, when I click on the gauge to drill down further, system takes me to the appropriate list of records. From that list when I try export irrespective of any format, system generate an empty file record.

The problem is I can't even use system diagnostics here to check and verify where exactly it fails. Also, there is nothing appear in logs.

Brgds, AM

[Timothy F1]

Did you ever find a fix for this? I'm experiencing the same thing.