topic Re: dump analysis (ST22) in Application Development and Automation Discussions

dump analysis (ST22)

Former Member — Tue, 11 Mar 2008 11:17:35 GMT

hi all ,

i am analysisng the dump for some program ,

for analyzing that dump i went to ST22 ,

in that i have seen ,the first line is the given below.

SQL error 60 occurred when accessing table "VBFA ".

i have unserstood the problem is while accesing the table VBFA.

can please suggest what is the SQL error 60.

and how to see that SQL error 60.

please kindly give me the suggestions on it.

thanks in afdvancve

Re: dump analysis (ST22)

Former Member — Tue, 11 Mar 2008 11:18:55 GMT

Hi ,

Check the Select statement (VBFA) .

Thanks

Jagadeesh.G

Re: dump analysis (ST22)

Former Member — Tue, 11 Mar 2008 11:27:05 GMT

Hi,

Set the break-point where u r accessing the VBFA in ur program and chk the parameters ur passing in where condition..

Re: dump analysis (ST22)

Former Member — Tue, 11 Mar 2008 12:21:30 GMT

hi ,

actullay i want see that SQL error 60.

where can i see SQL error 60 .

thanks for your response

Re: dump analysis (ST22)

Former Member — Tue, 11 Mar 2008 12:23:30 GMT

hi ,

actullay i want see that SQL error 60.

where can i see SQL error 60 .

thanks for your response

Re: dump analysis (ST22)

Former Member — Tue, 11 Mar 2008 12:27:39 GMT

The error is DBIF_RSQL_SQL_ERROR, this is because of sequence of the fields in select of the ttable VBFA into itab

the itab sequence should match with select from

check the same and re arragange the same according to the table occurance

Regards

Shiva

Re: dump analysis (ST22)

Former Member — Tue, 11 Mar 2008 12:34:19 GMT

Cause for the error:

Look at SAP note : 363085 -- this can throw some light on your

problem

SQL error 60 occurs because of deadlock

The problem is caused by a program error. The update to the pegkey table for writing the planning file entry must be made with a sorted table so that no *deadlock problem (SQL error

60) occurs.*