Infoset Error at Reading and furtherloading

[erdem_sephanelioglu]

Hello everybody,

I used 5 infoobject under infoset. If I would activate it, it works fine. The issue arises if i want to display the data or load the data into infocube.

I get a dump with name TIME_OUT, and with terminated program CL_SQL_STATEMENT==============CP

Is there a way I can fix this problem.

Thanks a lot

Regards

Eddy

[KodandaPani_KV]

HI,

where are you facing the issue while loading the data or displaying the data?

after loading the form source to target then go with the display data.

with loading data it is ot possible to display the data.

issue got because for paraments issue.

Report CL_SQL_RESULT_SET=============CP

ABAP Keyword Documentation

Runtime Errors : TIME_OUT (The program "CL_SQL_STATEMENT==============CP" has exceeded the maximum p...

Thanks,

Phani.

[sander_vanwilligen]

Hi Eddy,

It will be difficult to understand the issue w/o a bit more details. Please describe the situation, e.g. what is the InfoSet doing (which InfoProviders, type of join, how much data to process).

I suggest to analyze the generated SQL behind the BEx Query. Please run t/code RSRT for the respective BEx Query, execute the function Performance Info and select Display SQL. This might give you a better understanding why you get a time out.

Best regards,

Sander

[erdem_sephanelioglu]

Hi Sander,

I have 5 masterdata under Infoset

Top of it is info Cube. Unfortunately dtp loading got stuck.

The join type is inner join(standard).

Number of data on each Provider

1. InfoProvider: 179228

2. InfoProvider: 61102

3. InfoProvider: 119193

4. InfoProvider: 63938

5. InfoProvider: 72980

There could not be any query and data with cube. The current issue is displaying data on Infoset and running dtp for cube from infoset.

I really can not say what the problem might be and the way i can analyze it.

Thank you for any comments, insight

Regards

Eddy

[sander_vanwilligen]

Hi Eddy,

Still I have questions re. the issue you are facing. Do you use the InfoSet as an InfoProvider on which you define a BEx Query? Or do you use the InfoSet in data staging?

Please share screenshots where we can see all details, e.g. the real InfoProviders, fields, joins, etc. It is for me too abstract at the moment to give you any advice.

Best regards,
Sander