topic Re: System hangs at INSERT REPORT in Application Development and Automation Discussions

System hangs at INSERT REPORT

Former Member — Fri, 04 Jun 2010 05:32:29 GMT

Hi gurus,

I have copied a standard program from sap to make it as Z program.In the standard program there is an INSERT REPORT statement which generate the report dynamically.Now in my copied Z program also the same statement is there.The report generated is of same name but the code inserted is different.I ran both the programs together.Now if i am trying to run any of these two, the system is hanging at the insert statement and time out is happening.Please help me because this problem is also causing the stadard report not to run.

Regards,

Sarath.

Re: System hangs at INSERT REPORT

Former Member — Fri, 04 Jun 2010 05:38:04 GMT

HI,

which is the standard program ? it might be writing the genarating source code / program from the standard & the Z

Re: System hangs at INSERT REPORT

vallamuthu_madheswaran2 — Fri, 04 Jun 2010 05:39:18 GMT

Hi,

In that Dump has many details. kindly provide " WHAT HAPPEND " and "ERROR ANALYSIS".

Thanks & reagrds,

Vallamuthu.M

Re: System hangs at INSERT REPORT

Former Member — Fri, 04 Jun 2010 06:29:45 GMT

Thanks for the repies.

System actually hangs at that point and a time out is occuring.The standard program name is RPSDEV00.In that there is a check box for making it as a pivot tabel while downloading excel.During this action this problem is happening.

Regards,

Sarath.

Re: System hangs at INSERT REPORT

Former Member — Fri, 04 Jun 2010 06:35:26 GMT

Hi ,

Please specify the standard program name and also elaborate the error you are getting.

Regards,

Uma

Re: System hangs at INSERT REPORT

Former Member — Fri, 04 Jun 2010 06:41:14 GMT

Standerd program name is RPSDEV00

I am pasting the piece of code where issue is happening

FORM GEN_REPORT.

DATA: FELD(7) TYPE C.

DATA: IND TYPE I.

DATA: MSGNR(178) TYPE C.

DATA: LINNR(6) TYPE C.

DATA: WORD(30) TYPE C.

FELD(4) = 'FELD'.

new data-definition in report

READ REPORT 'RPSDEV01' INTO REP_TAB.

IF SY-SUBRC = 0.

IND = 9.

DO COUNT TIMES.

UNPACK SY-INDEX TO FELD+4(3).

CLEAR REP_TAB.

REP_TAB-TEXT = FELD.

REP_TAB-TEXT+8 = 'LIKE DATA-NUMBER,'.

INSERT REP_TAB INDEX IND.

ADD 1 TO IND.

ENDDO.

ELSE.

MESSAGE E016 WITH TEXT-X12.

ENDIF.

syntax-check

SYNTAX-CHECK FOR REP_TAB

MESSAGE MSGNR LINE LINNR WORD WORD.

IF SY-SUBRC NE 0.

MESSAGE E016 WITH TEXT-X13 MSGNR LINNR WORD.

ENDIF.

INSERT REPORT 'RPSDEV02' FROM REP_TAB. "At this point of time system is hanging.

text-elements

READ TEXTPOOL 'RPSDEV01' INTO REP_TXT LANGUAGE SY-LANGU.

INSERT TEXTPOOL 'RPSDEV02' FROM REP_TXT LANGUAGE SY-LANGU.

Re: System hangs at INSERT REPORT

Former Member — Fri, 04 Jun 2010 06:47:51 GMT

Sarath,

check the tcode st22 for error analysis

Thanks

Bala Duvvuri

Re: System hangs at INSERT REPORT

Former Member — Fri, 04 Jun 2010 07:17:07 GMT

I checked this already.It is giving descriptions about y this time out has occured.No other information.

Re: System hangs at INSERT REPORT

Former Member — Fri, 04 Jun 2010 07:19:49 GMT

That means system has a problem in creation process of this report RPSDEV02 , can you please check out the details in table REP_TAB, See what source code it contains or if you can let us know the contents.

Regards,

Uma

Re: System hangs at INSERT REPORT

Former Member — Fri, 04 Jun 2010 07:41:49 GMT

Hi ,

I wrote one zprogram as below . it generates report RPSDEV02 , it worked successfully.

DATA: BEGIN OF REP_TAB OCCURS 100,

TEXT(72) TYPE C,

END OF REP_TAB.

INSERT REPORT 'RPSDEV02' FROM REP_TAB.

Can you do one thing , please create 1 zprogram and write this above code and see if you get this program run successfully. So that we can at least see the area of error. Might be something regarding Buffer.

Regards,

Uma

Re: System hangs at INSERT REPORT

Former Member — Fri, 04 Jun 2010 08:08:48 GMT

The code was working earlier witouut giving this time out error.When i ran both the standard and Z program together is started hanging.Now the both programs are hanging at this INSERT REPORT statement.

Re: System hangs at INSERT REPORT

Former Member — Fri, 04 Jun 2010 09:07:16 GMT

Try running in the back ground.

Regards,

Sai Prasad

Re: System hangs at INSERT REPORT

Former Member — Fri, 04 Jun 2010 09:20:14 GMT

I think if you can try writing a zprogram which i have sent you , and if that program does not work then the problem something with buffers and if that zprogram works then the problem is with the internal table that you are paasing to INSERT statement. You must try writing that zprogram and see what happens...

Regards,

Uma

Re: System hangs at INSERT REPORT

Former Member — Fri, 04 Jun 2010 09:40:35 GMT

There is a report already generated with the name 'RPSDEV02'.This is suppose to be generated in the run time and get deleted by the statement delete report.The problem happening is both insert and delete is not happening.If i can delete this generated program the issue may get resolved.

Re: System hangs at INSERT REPORT

Former Member — Fri, 04 Jun 2010 09:55:56 GMT

Hi ,

this does not behave the way you are assuming it.

Even if the program 'RPSDEV02 already exists , the INSERT should work.

Please have a look to the documentation of INSETR.

INSERT will create a new report named eg abc if it does not exist , and if abc is already existing then also INSERT will work fine. It puts the internal table (passed in FROM parameter of INSERT )data as a source code in this abc report in both the cases.

So dont assume that , you are getting the error because this reports is already exist. This is not correct.

Regards,

Uma

Re: System hangs at INSERT REPORT

Former Member — Fri, 04 Jun 2010 10:24:09 GMT

Thanks uma.

I already have went through the documentaion.I also expected the program to behave like that only.Now what i did is in the copied Zprogram i changed the name of the program generated dynamically.Now the Z program is working fine.Since the standard program is stil using the same program name for dynamic generation it is hanging there.If i use any other program name instead of "RPSDEV02" this will work.In standard i can not do that.So what i am thinking is like if i can delete this program from SAP and try to regenerate it throught the standard program it will work as it was working earlier.

Regards,

Sarath.