Skip to Main Content
  • Questions

  • Limit to size of csv file download from Interactive Report

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Sam.

Asked: May 31, 2017 - 5:40 pm UTC

Last updated: June 09, 2017 - 2:21 am UTC

Version: Application Express 4.1.1.00.23

Viewed 1000+ times

You Asked

Hello Tom,

Firstly, I tried to google it a lot to check on if there is a limit to number of rows that can be exported to csv file from APEX Interactive Report but couldn't find one.

So here is my issue. I have an interactive report with around 35 columns and 500k rows. When I tried to download to a csv file, it only gave me around 150k rows. I then did hit and trial to see if it is an issue with number or rows. I tried with 4/5 columns and it downloaded all the rows. As I keep on increasing the number of columns in the report and download the file, the number of rows in the started decreasing.

So my question - is there a size limit to csv file in interactive report. I would really appreciate if you can point to any Oracle documentation on this limitation, if it exists?

Thanks,
Sam

and Connor said...

Hi, I spoke to the Apex PM and there is no internal limit on the size of a download.

If you can setup a demo on apex.oracle.com, and paste the URL to it in here as a review, we'll take a look.

Easy way to generate 500k rows is to have your report run of a query like:

select
rownum c1,
rownum c2,
rownum c3,
rownum c4,
..
from dual connect by level <= 500000;

Rating

  (2 ratings)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Thanks

Samip Musyaju, June 05, 2017 - 12:53 am UTC

I am trying to replicate the issue in apex.oracle.com but got stuck on the memory issue.

ORA-30009: Not enough memory for CONNECT BY operation

and just an FYI, my apex version is 4.1.X.X. I will try to see if it is an issue on excel side.

But thanks for the response.
Connor McDonald
June 06, 2017 - 1:50 am UTC

Ah...my bad. Do this as a workaround

select
rownum c1,
rownum c2,
rownum c3,
rownum c4,
..
from
( select 1 from dual connect by level <= 5000 ),
( select 1 from dual connect by level <= 1000 );


Thanks

Sam, June 08, 2017 - 2:06 pm UTC

I changed the query and the report is now displaying up. I have 20 columns with 500k rows. URL below

https://apex.oracle.com/pls/apex/f?p=44037:3

The download to csv works for 4 or 5 columns but it errors out when I tried with 20 columns.

Error: 500 Internal Server Error.

I suppose it has to do something with timing out.

Anyway I had one of my friend create the report in apex version 4.2.X.X and it worked fine. I could download all 500k rows.

Is it something with the apex version 4.1.1.00.23 that this limitation is applied.
Connor McDonald
June 09, 2017 - 2:21 am UTC

OK, I'll pass it on to the PM and see what he comes back with
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.