Abap report Error

[Former Member]

Hi

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...

[Former Member]

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

[Former Member]

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-

[Former Member]

Hi,

COPY and paste the DUMP here!

Let us have a look at it!

Regards

Naren

[Former Member]

Hi,

COPY and paste the DUMP here!

Let us have a look at it!

Regards

Naren

[Former Member]

Hi manjula,

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

why ur getting dump.

Regards

Adil

[Former Member]

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

[Former Member]

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?

[Former Member]

hi manjula,

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

reward if helpfull..

[Former Member]

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.

[Former Member]

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

[Former Member]

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