Webi schedule to large CSV-file result Success but 0kB

scheduling XI Scheduler
1

I want to use my universe-logic to create a large datadump. About 7,5M rows and I expect the CVS-file to be about 4GB.

When I schedule it, it runs for about 1 hour, status = Success but the file is empty: 0kB.

When I schedule it to standard webi-format, it works fine. I can open it and see the data. When I do an export to CSV in webi, the server works for about 30 minutes and … the resulting file is empty as well. 0Kb.

If I run a schedule with an extra filter to limit the rows, than it works fine and the data appears in the CSV.

I guess there is a problem with the spooling of the file. Does anybody knows what goes wrong, or knows where and for what to look in the logging of the server?

Thank you
Wim

BO4.1 SP6 P1

wwim (BOB member since 2008-04-22)

2

What version of BO is it?

ABILtd :uk: (BOB member since 2006-02-08)

3

BO4.1 SP6 P1.

thanks for helping out

wwim (BOB member since 2008-04-22)

4

Hmmm. Im thinking theres possibly a file size limit somewhere that could be kicking in. Im not working on 4.1 at the moment though so I cant check!

Reason I asked about the version is because Id have expected issues in 3.1 or lower as its 32bit (files 4GB and above a no no).

ABILtd :uk: (BOB member since 2006-02-08)