question Particular user cannot able to export data in Developer forum

Particular user cannot able to export data

dharanidd — Wed, 15 Mar 2017 10:55:13 GMT

Particular user cannot able to export data from servicenow.

After giving export>download it opens a blank page and cannot download data.

Attached the screenshots

Re: Particular user cannot able to export data

Chinthuja2 — Wed, 15 Mar 2017 11:19:54 GMT

Hello Dharani,

We have also faced this issue before. I can give you two three options. It might be one of the following issues.

1. This can be browser related. Can you check these two - Browser console/error log and Warning and error log within SN.?

2. You can try to create an ACL on operation 'read' on 'sys_poll' or 'sys_attachment' table.

3. This can also happen because of some CSS issues. Some properties might be having some blank spaces. You may need to find which one is that and fix it.

If none of the baove worked you may have to log a ticket with Servicenow support.

Thanks,

Please mark it as correct, or helpful.

Re: Particular user cannot able to export data

Brian S5 — Mon, 01 May 2017 17:16:50 GMT

Hi Dharani,

I have a user who is having the same difficulty. I impersonated their account and the issue remains on my machine, so i don't think its browser related which is what i though initially. I will investigate setting up an ACL on the table mentioned and see if that fixes anything.

Was just wondering if you were able to get this sorted out, would appreciate any information you have in regards to this. Let me know. Thank you.

Re: Particular user cannot able to export data

Gavin2 — Wed, 03 May 2017 14:14:44 GMT

Hello Dharani,

I have the same/similar issue which seems to be partly caused by a size difference between the user_name field on the User table, and the sys_created_by field on the Attachment [sys_attachment] table. Increasing the field size on the Attachment table has solved some of the issues for me, so it might be worth giving it a look at for yours.

Regards,

Re: Particular user cannot able to export data

Brian S5 — Wed, 03 May 2017 14:27:13 GMT

I was able to solve this with a read ACL on the sys_poll table.

Re: Particular user cannot able to export data

Gavin2 — Wed, 03 May 2017 14:31:37 GMT

I'll agree with what Brian said.

It seems the default ACL wants to match the user name with the value in the created by field, so if there is a size difference it'll not work.

A generic ACL will solve this, or increasing the created by max length.