Dear Ramakrishnan,
Your Deadlock is coming for ARFCSSTATE & ARFCSDATA tables.
Current SQL Statement:
DELETE FROM "ARFCSSTATE" WHERE "ARFCIPID" = :A0 AND "ARFCPID" = :A1 AND "ARFCTIME" = :A2 AND "ARFCTIDCNT" = :A3 AND "ARFCDEST" = :A4 AND "ARFCLUWCNT" = :A5
End of information on OTHER waiting sessions.
Current SQL statement for this session:
DELETE FROM "ARFCSDATA" WHERE "ARFCIPID" = :A0 AND "ARFCPID" = :A1 AND "ARFCTIME" = :A2 AND "ARFCTIDCNT" = :A3
Please check if Note 1445107 can be implemented for your system.
Note 1445107 - Deadlocks occur in the DB tables ARFCSSTATE and ARFCSDATA
Regards
Ashish
Hi Ashish,
Thanks for your urgent help and additionally i have taken note that i mentioned in the first reply and found the decimal value.Below is the output too.
hexa value 0004EA6E ----->decimal value is 322158
hexa value 0004EA66------>decimal value is 322150
SQL> SELECT owner, object_name, object_id FROM DBA_OBJECTS
WHERE object_id=322158;
SQL> SELECT owner, object_name, object_id FROM DBA_OBJECTS
WHERE object_id=322150;
SQL> SELECT owner, object_name, object_id FROM DBA_OBJECTS
WHERE object_id=322158 2 ;
OWNER
--------------------------------------------------------------------------------
OBJECT_NAME
--------------------------------------------------------------------------------
OBJECT_ID
----------
SAPR3
ARFCSSTATE
322158
SQL> SELECT owner, object_name, object_id FROM DBA_OBJECTS
WHERE object_id=322150 2 ;
OWNER
--------------------------------------------------------------------------------
OBJECT_NAME
--------------------------------------------------------------------------------
OBJECT_ID
----------
SAPR3
ARFCSDATA
322150
Let me know anything further has to be done from my end and i will go through the note suggested by you and will provide you the update later.
Many thanks ashish
Regards
Ram
Here also you found same tables : ARFCSSTATE & ARFCSDATA.
I will suggest you first check if this note is applicable for your System Release or not and if this can be implemented. If not, may be we can find another relevant SAP Note for this problem. Let us know your SAP Release in that case.
Regards
Ashish
Dude,
i have SAPKB64021 which is far below the SAP note suggested,Anyhow we are going for support pack activity on coming friday and i will implement the SAPKB64029
Thanks for your valuable solution and pinpointed one answer
If you basis SP is far below the Basis SP in which the corrections of OSS note have been included then what is the issue in applying the OSS note. You can't apply the note if Basis SP was equal to hgher than the one specified in the note.
Regards.
Ruchit
Hi Ruchit,
Yes you are absolutly right,,,,Anyhow issue is resolved
Regards
Ram
