dump analysis (ST22)

[Former Member]

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

[Former Member]

Hi ,

Check the Select statement (VBFA) .

Thanks

Jagadeesh.G

[Former Member]

hi ,

actullay i want see that SQL error 60.

where can i see SQL error 60 .

thanks for your response

[Former Member]

Hi,

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

[Former Member]

hi ,

actullay i want see that SQL error 60.

where can i see SQL error 60 .

thanks for your response

[Former Member]

Hi

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

[Former Member]

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