Large Data export from Report

[asktam1410]

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.

[naveenk57279863]

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]

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.

[naveenk57279863]

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:

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

[asktam1410]

I enabled this option however still report is exporting only 200 rows

[naveenk57279863]

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

[asktam1410]

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 ).

[naveenk57279863 · Accepted solution]

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

[pablo_rosero1]

Moved to Adobe Campaign Classic​.

Please post there directly in the future