Crystal Reports Fails to load while trying to view from CMC and Infoview

[Former Member]

Hi ,

I am trying to simply view a crystal report from CMC, the reports takes too long time and finally fails to view.

The report has dynamic params and it has to load millions of records.

Following info may help to undersatand the problem:

Environment Details: BOXI 3.1 sp2

Report : Crystal reports 2008

Report Type: ODBC Report , Repoting Database: DB2

- I am able to view otther reports of similiar kind.

- Problem only with this particulr reports.

- Able to view the reports from the Crystal reports 2008 Designer.

I tried increasing the timout for RAS Server in the registry but it didnt helped.

An any SAP Person watching this thread help finding out a solution ? Handful request !!

Regards,

Jon

[former_member142702 · Accepted solution]

DO you need to display millions of rows in a single report?

Regards,

Stratos

[Former Member · Accepted solution]

Hi,

Thanks for replying !!

Yes, actually we have drill down report so for one level drill we will have around 50 thousand records.

While running report , parameters window opens and the after required param passed , the reports display message to wait ... and then it waits for around 10 mins and then crashes with following errors:

1. Timeout. [RCIRAS0244]

and some time we get this error also and its intermittent:

Error in File STATUS DETAILS Report: The table could not be found.

for the error "1" i increased the RAS time but didnt helped.

Regards,

Jon

[former_member142702 · Accepted solution]

You may want to conider using hyperlinks (openDocument) and multiple reports. For sure it is not a best practice to pull millions of rows in a single CR report and work with it. Even if you make it work the performance will be poor (and that's a rather optimistic statement).

Regards,

Stratos

[former_member142702 · Accepted solution]

Which viewer do you use? Normally the CR processing server is doing the processing of the reports here and not the RAS.

Regards,

Stratos

[Former Member · Accepted solution]

Thanks a lot !!

In th preferences (CMC ) I can see the Crystal View as "web ( no downloading Required) "

Regards,

Jon

[former_member136842 · Accepted solution]

Hi,

maybe SAP Note - 1536503 helps you.

Regards

-Seb.

[Former Member · Accepted solution]

Hello Sebastian,

Many Thanks for Replying !!

Can you please tell me where can I find this note, I searched it here but... hard luck.

Can you please share? what actually this note says !!

I will be really thankful.

Regards,

Jon

[Former Member · Accepted solution]

You can get the SAP Notes details using the following link:

https://websmp104.sap-ag.de/support

You can also check the following possibilities:

1. If the report is created on top of universe, probably you could check the timeout limit setting in universe parameters.

2. If any report getting huge data may fail due to cache or memory issues.