Excel Export exception raised: java.lang.Exception schedule

[former_member198540]

Hi Guys,

We actually facing the next error when a report schedule execute and try to send Excel file via mail. we already incresed the limit of the SMTP attached files  to 15MB but its not the thing, because the final excel file size its 8MB

This the log of schedule:

When we try to schedule the report with less data, the schedules run succes.

Any parameter or configuration that i need to incresed. ?

Details of BI Platform:

SAP BI 4.0 SP7

[Former Member · Accepted solution]

Hi Carlos,

Try the following:

1. Change format to PDF.

2. Send an e-mail of size 10-15 MB outside BO and check(If it fails then it is a SMTP issue and not a BO Issue).

3. Increase the Maximum Binary Stream Size parameter values in the properties of all the Webi Processing Server.

4. Are you able to export the report in Excel from BI Launchpad?

Regards,

Adil

[former_member198540 · Accepted solution]

in launchpad the report export success, we test with PDF format but faild with same error in schedule time.

[Former Member · Accepted solution]

Hi Carlos,

Try a different destination other than e-mail, for example default enterprise location and test. If it works fine then the issue is with SMTP server and not BO.

Regards,

Adil

[Former Member]

Can you run the report by itself without scheduling? Does it run?

And also you are using old version of BO. It may have also some issues.

[Former Member]

Hello Carlos,

To confirm if the issue is with SMTP server, you can use SurgeMail .

http://netwinsite.com/cgi-bin/keycgi.exe?cmd=download&product=surgemail

Regards,

Kapil

[Former Member]

Stop disable current Adaptive Job server

Try creating a new Adaptive Job server with default services.

Configure Email Destination again and schedule the report again.

for SMTP test try sending any doc more than 8MB to yourself and see if you able to recive it.

[Former Member]

Have a look at this SAP note:

1806980 - Error: "Exception raised: java.lang.Exception" when scheduling large report to E-mail destination

[former_member198540]

In fact, already have a look in these KBA but we actually increased the SMTP restriction size to 15MB and the final Excel file have just 8MB.

Also, we really need send it via email. btw, we increased the size of Binary Stream in AdaptativeJobServer to 300MB but the issue still appear.

[Former Member]

Check the logs see if WIPS has sufficient memory to process the report or not? Or is it getting out of memory and that is why the schedule is failing?