Question Re: Excel Export exception raised: java.lang.Exception schedule in Technology Q&A

Excel Export exception raised: java.lang.Exception schedule

former_member198540 — Tue, 13 Sep 2016 13:53:35 GMT

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

Re: Excel Export exception raised: java.lang.Exception schedule

Former Member — Tue, 13 Sep 2016 14:50:16 GMT

Have a look at this SAP note:

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

Re: Excel Export exception raised: java.lang.Exception schedule

former_member198540 — Tue, 13 Sep 2016 14:55:19 GMT

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.

Re: Excel Export exception raised: java.lang.Exception schedule

Former Member — Tue, 13 Sep 2016 16:17:45 GMT

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?

Re: Excel Export exception raised: java.lang.Exception schedule

Former Member — Wed, 14 Sep 2016 09:34:47 GMT

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.

Re: Excel Export exception raised: java.lang.Exception schedule

Former Member — Wed, 14 Sep 2016 09:40:23 GMT

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

Re: Excel Export exception raised: java.lang.Exception schedule

Former Member — Wed, 14 Sep 2016 11:51:02 GMT

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

Re: Excel Export exception raised: java.lang.Exception schedule

Former Member — Wed, 14 Sep 2016 12:32:47 GMT

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.

Re: Excel Export exception raised: java.lang.Exception schedule

former_member198540 — Wed, 14 Sep 2016 14:51:45 GMT

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

Re: Excel Export exception raised: java.lang.Exception schedule

Former Member — Fri, 16 Sep 2016 04:04:22 GMT

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