Trcing down to JOB or program level from Short dump or system log in APO.

[Former Member]

Hi Guru's

Can anyone please guide me how to trace down to JOB or program level from ST22 and SM21 logs.

I have SQL errors and lock entries in APO system, I want to find which program or job writing them.

Thanks in advance,

Sreerama.

[Former Member · Accepted solution]

Hi Sreerama,

In ST22 you should get information in "USER and Transaction" Also it gives in program at what step error has occurred and that program line should have ">>>>" instead of line no. Just click on that it will open the actual program.

ST22 also gives list of ABAP program affected in the left.

Regards,

Harshil Desai

[Former Member · Accepted solution]

Hi,

Thanks for the replay,

I have checked same way as you suggested >>>> in ST22 dump, but it is taking me to Include "LARFCF06" which is trying to delete ARFCSTATE table.

and I have error message :

Database error text........: "[1205] Transaction (Process ID 291

deadlocked on lock resources with another process and has been

deadlock victim. Rerun the transaction."

Internal call code.........: "[RSQL/DELE/ARFCRSTATE ]"

Please check the entries in the system log (Transaction SM21).

User and Transaction

Client.............. 100

User................ "APORFC"

Language Key........ "E"

Transaction......... " "

Transactions ID..... "002FE8DE2A71F1B182E80019BB345F90"

Program............. "SAPLARFC"

Screen.............. "SAPMSSY1 3004"

Screen Line......... 2

Information on caller of Remote Function Call (RFC):

System.............. "P48"

Database Release.... 700

Kernel Release...... 700

Connection Type..... 3 (2=R/2, 3=ABAP System, E=Ext., R=Reg. Ext.)

Call Type........... "synchron and non-transactional (emode 0, imode 0)"

Inbound TID.........." "

Inbound Queue Name..." "

Outbound TID........." "

Outbound Queue Name.." "

Client.............. 100

User................ "APORFC"

Transaction......... " "

Call Program........."SAPLERFC"

Function Module..... "ARFC_DEST_CONFIRM"

Call Destination.... "NONE"

Source Server....... "debosap172_P48_21"

Source IP Address... "10.132.184.172"

Additional information on RFC logon:

Trusted Relationship " "

Logon Return Code... 0

Trusted Return Code. 0

Note: For releases < 4.0, information on the RFC caller are often

only partially available.

Information on where terminated

Termination occurred in the ABAP program "SAPLARFC" - in

"DELETE_ARFC_ORPHANS_WO_COMMIT".

The main program was "SAPMSSY1 ".

In the source code you have the termination point in line 508

of the (Include) program "LARFCF06".

The termination is caused because exception "CX_SY_OPEN_SQL_DB" occurred in

procedure "DELETE_ARFC_ORPHANS_WO_COMMIT" "(FORM)", but it was neither handled

locally nor declared

in the RAISING clause of its signature.

The procedure is in program "SAPLARFC "; its source code begins in line

489 of the (Include program "LARFCF06 ".

Now I want to find how this dead lock is created and which two (programs or JOB's) causing this dead lock.

And program "APLARFC" is not a exicutable program and even I try to where used list I am not able to find exicutable program.

now I need to find which are the two programs or jobs causing this loack.

Thanks in Advance,

Sreerama.

[Former Member]

Hi Sreerama,

Could you please let us know how you resolved this issue. I am also facing same kind of issue.

Please advise.

Thanks

Venkat