2369653 - Deadlocks REPOSRC, SQL30046 errors during imports - SAP ASE for Business Suite | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2369653 - Deadlocks REPOSRC, SQL30046 errors during imports - SAP ASE for Business Suite

Symptom

You are installing or upgrading your SAP system on SAP ASE database. You are using SWPM or SUM.

IMPORT phases of SUM upgrades and SPAM updates, stop, go slow and/or fail:  due to deadlock errors on the REPOSRC table.

DELETE processes deadlock against each other. The offending sql, as seen in the developer work process traces and/or ASE errorlog is:

DELETE FROM REPOSRC WHERE R3STATE = 'A' AND PROGNAME IN (SELECT PROGNAME  FROM REPOSRC WHERE R3STATE = 'P' AND PROGNAME BETWEEN ? AND ? ) /* R3::0 T:REPOSRC */

You may also find downstream access to various SAP tables failing due to disconnect errors like SQL30046 and SQL30102 (in developer work process traces) --
TRACE-INFO: 56: [ dbtrtab ,00000] ***LOG BY0=>[ASE Error SQL30102:HY010][SAP][ASE ODBC Driver]Function sequence error[ASE Error SQL30046:08S01][SAP][ASE ODBC Driver]Connection to the server has been lost.


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7 for Business Suite
  • SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
  • SAP NetWeaver (NW) - All versions 

Product

SAP ERP 6.0

Keywords

REPOSRC, deadlocks, SUM, SPAM, import, SQL30046, SQL30102, recompile, MAIN_NEWBAS/XPRAS_AIMMRG, MAIN_TRANSEXEC/TABIM_TRANS, MAIN_POSTCLEAN/RUN_RSAIMMERGE_TRANSFER , KBA , BC-DB-SYB , SAP Business Suite on Sybase ASE Database Platform , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.