Large Data export from Report

asktam1410

08-03-2019

Hi ,

Is there anyway to export large data from report page. I enabled 'large export' within reports page however when we hit export - it only exports only 200 rows.

Report_page.jpg

Accepted Solutions (1)

Accepted Solutions (1)

naveenk57279863

11-03-2019

ashok.sankar

Thank you for the response Ashok. Can you please get a support ticket opened and we will check the report. And we will also check the maxMB value as well, to confirm if this is related to this or not?

Open a support ticket and share all the required details. And someone from the team would reach out to you accordingly.

-Naveen Kumar

Answers (7)

Answers (7)

naveenk57279863

11-03-2019

Hi ashok.sankar​,

Can you please confirm the number of columns you are trying to export and if it is possible to try with less number of columns and see if this works or not? If this doesn't, please open a ticket with support with details like:

1. Report (name and location) you are trying to export.

2. Instance URL.

3. Has this worked previously for any other report?

Regards,

Naveen Kumar

naveenk57279863

08-03-2019

Thank you for the response and as far as only 200 records getting displayed. This is working as designed. There is a section in the documentation on how to change the default limit that is put on the query.

Please see the link below, the section you want to review is Limiting the amount of data collected: Collecting data to analyze

Take a look at the screen shot below for more information:

1707929_pastedImage_2.png

Once you have made the above change, there could be a possibility that the number of records you are trying to export may increase in future, which may result in error related to Memory (Out of Memory). To avoid this from happening, please do raise a ticket and get the JS maxMB value confirmed and updated accordingly.

Plese let us know if this works for you or not?

Naveen Kumar

naveenk57279863

08-03-2019

Hello Ashok,

Thank you for reaching out to Forum. And per your request, can you please confirm if this is an issue with Exporting data from an Out of the box Report or a Custom Report?

In this situation, you would need to open a request with Adobe Campaign Support. As this could be an issue with the JS allotted size. Support team would get this checked and will help you get it upgraded. And hopefully, this shall resolve the issue.

If this is related to a custom report, there could be many reason and custom report needs to be checked with PS/Consultant. For more information on this, please refer to this documentation (check section Memory allocation): Actions on reports

Hope this helps.

Naveen Kumar

asktam1410

11-03-2019

trying to export less than 10,000 records. This is a custom report which we built to export Campaign Email opens & Clicks ( All possible opens and Clicks ).

asktam1410

08-03-2019

Thanks for sending this info.

I am facing this issue in the custom report where output query contains 10,000 rows but only 200 got displayed in Console.

When i try to export only 200 rows are exported not all 10,000 rows.

How to increase export records size from 200 to as many.