DUMP ERROR FOR REPORT TO ASSIGN TCODE TO ABAP QUERY

[Former Member]

hi friends ..

i did this smallreport by difernet type but its the

error says dump_--report not found or status errror says

maximum session reached ..i think there something wrong in my submit stmt .pls let me know ...

also assign tcode to the report.

DATA:QUERYREPORT LIKE AQADEF-PGNAME,

QUERY LIKE AQADEF-QUNAME,

USERGROUP LIKE AQADEF-BGNAME,

WORKSPACE LIKE AQADEF-WSID.

query = 'zskview'.

usergroup = 'zskgrp'.

workspace = ''.

• get name of queryreport

CALL FUNCTION 'RSAQ_REPORT_NAME'

EXPORTING

WORKSPACE = workspace

USERGROUP = usergroup

QUERY = query

IMPORTING

REPORTNAME = QUERYREPORT

EXCEPTIONS

OTHERS = 0.

SUBMIT (QUERYREPORT)

• VIA SELECTION-SCREEN

• USING SELECTION-SETS OF PROGRAM QUERYREPORT

AND RETURN.

[Former Member]

hi friends ..

i did this smallreport by difernet type but its the

error says dump_--report not found or status errror says

maximum session reached ..i think there something wrong in my submit stmt .pls let me know ...

also assign tcode to the report.

DATA:QUERYREPORT LIKE AQADEF-PGNAME,

QUERY LIKE AQADEF-QUNAME,

USERGROUP LIKE AQADEF-BGNAME,

WORKSPACE LIKE AQADEF-WSID.

query = 'zskview'.

usergroup = 'zskgrp'.

workspace = ''.

• get name of queryreport

CALL FUNCTION 'RSAQ_REPORT_NAME'

EXPORTING

WORKSPACE = workspace

USERGROUP = usergroup

QUERY = query

IMPORTING

REPORTNAME = QUERYREPORT

EXCEPTIONS

OTHERS = 0.

SUBMIT (QUERYREPORT)

• VIA SELECTION-SCREEN

• USING SELECTION-SETS OF PROGRAM QUERYREPORT

AND RETURN.

[Former Member]

Since you are calling the same report within the same program you are getting the error. Since the order of execution is :

Start -> REPORT zprog.
         ....
         SUBMIT zprog and return. 
              This calls the same program again and again in an infinite loop.
Back to  -> REPORT zprog.
         ....
         SUBMIT zprog and return.

Ps: Reward points if helpful.

[Former Member]

Hi,

<b>report not found</b> : such a error comes when ur report is not available on client on which u r working.

<b>maximum session reached</b> : Such a error comes when u execute report at a time when already 6 sessions are

opened.and u try to open new session by execution of ur report.

Regards,

Digesh Panchal

[Former Member]

Hi,

you are submitting the same report again and again .

so maximum no of sessions reached, and that is the reason you got the dump.

regards

vijay

[andreas_mann3]

Hi,

check return code of your fm

check what is in QUERYREPORT

is it like

AQCSZSKGRP========ZSKVIEW======

check wheter query is activated

Andreas

[Former Member]

Hello,

Very important, check the program name of the Query in SQ01.

If it is AQZZZSKGRP========ZSKVIEW====== then pass some value in workspace else if the name is

AQxxZSKGRP========ZSKVIEW====== then pass blank in workspace field where xx is not ZZ.

pass query = 'ZSKVIEW' instead 'zskview'.

usergroup = 'ZSKGRP' 'zskgrp'.

[Former Member]

HI farukh,

1. The program u have written

is for running DYNAMIC query,

(given the query name)

2. In debugging,

chck the value of the variable

queryreport

after the FM is executed.

3. It will contain the program name (of the corersponding query)

in the following format (eg)

AQFKzskgrp======ZAMQ01========

4. Open another se38,

and CHECK whether this program exists or not!

5. If it does not,

a)either the QUERY NAME is not correct,

b) either the user group is not correct,

c) either the query is deleted / not generated .

regards,

amit m.