SAP Knowledge Base Article - Preview

2337140 - Sequential Read / Select hangs on tables with SQL Server

Symptom

During the update of SPAM, after MOVE NAMETABS phase, the process hangs during the execution of the job RDDGEN0L with the program SAPMS38L, with a Sequential Read on TFDIR.

It has also been observed that SUM (Software Update Manager) hangs in MAIN_SHDIMP/SUBMOD_SHD2_RUN/TABIM_POST_SHD also running a SELECT statement against TFDIR.


Read more...

Environment

  • SAP NetWeaver based systems with ABAP Stack or Dual-Stack;
  • MS SQL Server 2014 SP1 CU6 (12.0.4449.0)

Product

SAP NetWeaver all versions

Keywords

sum, SUM, spam, SPAM, upgrade, upgradation, update, updatation, deprecate, removed, update hangs, upgrade hanging, upgradation hanging, mssql, mssqlserver, ms_sql, msql, performance, TFDIR~, Software Update Manager, MAIN_SHDIMP, SUBMOD_SHD2_RUN, TABIM_POST_SHD, shadow instance, shd, submod, shdimp, main, tabim, Solution Manager, RDDGEN0L, IMPORT_PROPER, SAPKD , KBA , BC-DB-MSS-UPG , SQL Server Upgrades in SAP NetWeaver Products , BC-UPG-TLS-TLA , Upgrade tools for ABAP , BC-UPG-OCS , Online Corr. Support (Tools:Supp.-Pack., Addon Install/Upgr) , BC-UPG-OCS-SPA , Support package tools for ABAP , BC-DB-MSS , SQL Server in SAP NetWeaver Products , Problem

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.