Skip to Content
author's profile photo Former Member
Former Member

Crystal Reports Hangs due to Requesting Tuples

I am doing a cross tab report in Crystal with two fields on the rows and one field on the column. The query is based on a SAP BW - BEx Query.

When I have a single field on the rows, the report runs fine. but when I add a second field, it just hangs. When I look at the log file, it has multiple rows for "requesting tuples". Why does this happen? Please Help.

Please note that the the two fields that I am using are based on two hierarchies.

We are on SAP XI 3.1 SP4 on the client and the Server

Sun Aug 21 13:10:10 2011] 2948 4520 Requesting tuples 0 to 9999 for session 0013.F696504EFEAB4720E10000000A121E14

[Sun Aug 21 13:10:35 2011] 2948 4520 Requesting tuples 10000 to 19999 for session 0013.F696504EFEAB4720E10000000A121E14

[Sun Aug 21 13:11:35 2011] 2948 4520 Requesting tuples 20000 to 29999 for session 0013.F696504EFEAB4720E10000000A121E14

[Sun Aug 21 13:12:18 2011] 2948 4520 Requesting tuples 30000 to 39999 for session 0013.F696504EFEAB4720E10000000A121E14

[Sun Aug 21 13:13:28 2011] 2948 4520 Requesting tuples 40000 to 49999 for session 0013.F696504EFEAB4720E10000000A121E14

[Sun Aug 21 13:13:59 2011] 2948 4520 Requesting tuples 50000 to 59999 for session 0013.F696504EFEAB4720E10000000A121E14

[Sun Aug 21 13:14:32 2011] 2948 4520 Requesting tuples 60000 to 69999 for session 0013.F696504EFEAB4720E10000000A121E14

[Sun Aug 21 13:15:15 2011] 2948 4520 Requesting tuples 70000 to 79999 for session 0013.F696504EFEAB4720E10000000A121E14

[Sun Aug 21 13:15:59 2011] 2948 4520 Requesting tuples 80000 to 89999 for session 0013.F696504EFEAB4720E10000000A121E14

[Sun Aug 21 13:16:17 2011] 2948 4520 Requesting tuples 90000 to 99999 for session 0013.F696504EFEAB4720E10000000A121E14

Edited by: Ashok Bhuvanagiri on Aug 21, 2011 10:10 PM

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Aug 25, 2011 at 07:31 AM

    Hi Ashok,

    I had trouble with big BW hierarchies in the past - please check transaction ST22 in you BW for any errors.

    You can also try to do some RFC tracing. It can be enabled via the registry on your client machine. (http://wiki.sdn.sap.com/wiki/display/BOBJ/TroubleshootingCrystalReportsoffBW#TroubleshootingCrystalReportsoffBW-SAPintegrationtracing)

    Regards,

    Thorsten

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.