topic Re: Abap report Error in Application Development and Automation Discussions

Abap report Error

Former Member — Fri, 09 May 2008 13:42:52 GMT

I generated a report and I found that it is syntactically correct

also execution is successful but when I executed the same

program after 10 minutes a blank screen appears stating that

[Abap Runtime Error Error Code -

SQL error in the database when accessing table.]

I dont understand where is the problem and what I should do in the next step inorder to eliminate this.Any solution plz

answer...

Re: Abap report Error

Former Member — Fri, 09 May 2008 13:46:04 GMT

Did you check st22 for any dumps....the dump will give u more detailed information.

Re: Abap report Error

Former Member — Fri, 09 May 2008 13:46:50 GMT

Hello

Debug the program and check on wich statement is taking the long time....and then correct it, you may have for example an endless loop or something like that...

dont forget to reward

Gabriel P-

Re: Abap report Error

Former Member — Fri, 09 May 2008 13:52:47 GMT

Hi,

COPY and paste the DUMP here!

Let us have a look at it!

Regards

Naren

Re: Abap report Error

Former Member — Fri, 09 May 2008 13:55:31 GMT

Hi,

COPY and paste the DUMP here!

Let us have a look at it!

Regards

Naren

Re: Abap report Error

Former Member — Fri, 09 May 2008 15:14:17 GMT

Hi manjula,

If possible paste the code here or dump also, we are not clear

why ur getting dump.

Regards

Adil

Re: Abap report Error

Former Member — Fri, 09 May 2008 16:18:04 GMT

Hi,

Guess the fields in the internal table order and while fetching data through select may not be in same order just check once.

and

guess the size of the records in the table may be exceeds the limit(huge amount of data).

Manjula its just a guess.

Check once.

also check the length of each field .

Thanks

Naveed

Re: Abap report Error

Former Member — Mon, 12 May 2008 10:19:00 GMT

hi Naveed

do you any thing about performance tuning?also

regarding Dumps,how to decrease or increase

Database usuage or anything which we could do to

a system so that it could work without any errors?

Re: Abap report Error

Former Member — Mon, 12 May 2008 10:42:40 GMT

hi manjula,

i think the prob is with the database installation,ask your basis administrator to check wether it is fine..

reward if helpfull..

Re: Abap report Error

Former Member — Mon, 12 May 2008 10:46:22 GMT

The error is probabaly due to incorrect SQL Statement (Please paste the dump for further analyses ) or it also comes if the memory is insufficient for the user to execute the statement.In that case you need to check this with your basis consultant.

Reward points if usefull.

Re: Abap report Error

Former Member — Mon, 12 May 2008 10:51:13 GMT

Hi,

While using the select statement see the sequence of the selected fields and the field of the internal table

As a safe option use into corresponding fields of table ...........

Try this and do let me know whether it works

Re: Abap report Error

Former Member — Mon, 12 May 2008 10:53:45 GMT

hi check this..

this may be continious loop exist in the programs, or incorrect statement in the select statement, go to the ST22 and choose ...source code analysis...it will show the error source code...

regards,

venkat