Expand my Community achievements bar.

SOLVED

Large Data export from Report

Avatar

Level 4

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

1 Accepted Solution

Avatar

Correct answer by
Level 2

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

View solution in original post

8 Replies

Avatar

Level 2

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

Avatar

Level 4

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.

Avatar

Level 2

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

Avatar

Level 4

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

Avatar

Level 2

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

Avatar

Level 4

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

Avatar

Correct answer by
Level 2

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

Avatar

Level 10

Moved to Adobe Campaign Classic​.

Please post there directly in the future