Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

dump analysis (ST22)

Former Member
0 Kudos
138

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

6 REPLIES 6

Former Member
0 Kudos
93

Hi ,

Check the Select statement (VBFA) .

Thanks

Jagadeesh.G

0 Kudos
93

hi ,

actullay i want see that SQL error 60.

where can i see SQL error 60 .

thanks for your response

Former Member
0 Kudos
93

Hi,

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

0 Kudos
93

hi ,

actullay i want see that SQL error 60.

where can i see SQL error 60 .

thanks for your response

Former Member
0 Kudos
93

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
0 Kudos
93

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