Crystal Reports Hangs due to Requesting Tuples

[Former Member]

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

[Former Member]

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