Symptom
- The performance of SLT initial load is slow in production system
- There were many deadlock issues and it happened on the table which were being imported by SLT initial load.
server Deadlock Id 452 detected
Deadlock Id 452 detected. 1 deadlock chain(s) involved.
Deadlock Id 452: Process (Familyid 0, Spid 1546, Suid 13) was executing a INSERT command at line 1.
SQL Text:
SQL Text: INSERT INTO "/1LT/10000004538"
(omit)
Deadlock Id 452: Process (Familyid 0, Spid 2778) was waiting for a 'exclusive page' lock on page 147275548 of table 'KONV' in database '<DBNAME>' but process (Familyid 0, Spid 1546) already held a 'exclusive page' lock on it.
Deadlock Id 452: Process (Familyid 0, Spid 1546) was waiting for a 'exclusive page' lock on page 133662961 of table 'KONV' , indid 1 in database '<DBNAME>' but process (Familyid 0, Spid 2778) already held a 'exclusive page' lock on it.
Deadlock Id 452: Process (Familyid 0, Spid 1546) was chosen as the victim.
Victim process host = `<hostname>', user = `<DBNAME>' program name = `R3 039 01 [1]comm rd ODBC' host processes = `1473685' .
End of deadlock information. - The deadlock issue still happened after running update statistics.
Read more...
Environment
- SAP Adaptive Server Enterprise (SAP ASE) 16.0 for Business Suite
- SAP Landscape Transformation Replication Server
Product
SAP Adaptive Server Enterprise 16.0
Keywords
BSAS,ZZSUMMT,BKPF,EQUZ , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , How To
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview