Timeout Issue in CRM WEB UI when exporting to excel

[Former Member]

Hi All,

I am exporting a search result to excel from the account search page,but i am getting a  timeout error when the maximum hit count is above 40k.

When i decrease the maximum hit count to 30k,it is working fine with huge delay (almost 10 mins).

Is there any restrictions on the file size we are exporting or any steps to improve this file size?

FYI: I am using CRM 7.0 EHP2

[Former Member · Accepted solution]

Hi All,

Raising an OSS message is fine,may i know changing parameter 'icm/server_port_<XX>' makes any sense with this issue?

Thanks

Mukesh.L

[ashik_k2 · Accepted solution]

Hello Mukesh,

Even raising an OSS message will not be helpful.

Check Note 1553152.

Regards,

Ashik

[Former Member · Accepted solution]

Hi Ashik,

Yes you are right,thanks for your inputs.

Cheers!

[former_member182421 · Accepted solution]

Interesting, I wonder what will hapend with SAP CRM Web UI Analytics

[Former Member]

Hi All,

Thanks for all of your inputs.

Here is the SAP response after raising an OSS message:

The export to XLS functionality was designed and meant for typical use

cases of exporting adequately small amounts of data in result list,

which in the majority of use cases is around tens or hundreds of result

lines. The typical use cases where this XLS export is offered is not the export of mass-data,

but the exploration and review of data via e.g.searching, sorting or filtering of information.

This is also documented in Note 1553152.

Cheers!

Mukesh.L

[former_member182421]

As I said is a very interesting answer, SAP CRM has a component tu run BI Reports and export them via flat xls file or a pivot table. I'm guessing if those "tens or hundrerds" capacity will be enoguh to justify using CRM Analytics

[kumar5]

Basically we need to change value of Parameter 'rdisp/max_wprun_time' in TC 'RZ11'.

Have you gone through below link:

http://sap.ittoolbox.com/groups/technical-functional/sap-basis/time_out-error-when-exporting-to-exce...

It might be helpful.

Thanks

Kumar Gaurav

[Former Member]

It's already set to 30 minutes,but i got the timeout runtime error before the mentioned time span.

Do i need to check any other parameter like this?

[former_member182421]

Hi Mukesh,

In this case I would raise an OSS message, I guess you are exporting a result of a standard search right?

Cheers!

Luis

[kumar5]

If its still not working then I would also recommend to raise an OSS message.

I do not think there would be any other variable for this.

Thanks

Kumar.