SAP Knowledge Base Article - Preview

2503863 - Spid hangs in 'prepprev' after rollback due to Error 2601 (duplicate key) - SAP ASE for Business Suite

Symptom

  • Spid in rollback for a (very) long time
  • System table master..syslogshold shows long running spid
  • The master..sysprocesses table shows that spid with :
    • 'status' =  'running and
    • 'cmd' = 'ROLLBACK'
  • Running dbcc stacktrace (spid#) command on the affected spid shows a stack including calls :
    upyield
    prepprev
    gnext__curpage_qualbounds
    apl_getnext
    xsc__syslogs_getnext
    rec_undo_session
    abortcmd
  • In the output from command dbcc pss (suid#, spid#), last error is shown to be 2601 (duplicate key error): plasterror=2601

Read more...

Environment

  • SAP Adaptive Enterprise (ASE) 16.0 SP02 PL05 for Business Suite
  • SAP Business Warehouse - All versions 
  • SAP Adaptive Server Enterprise (ASE) 15.7
  • SAP Adaptive Server Enterprise (ASE) 16.0

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; SAP NetWeaver 7.4

Keywords

prepprev, 2601, rollback, CR#809442, CR809442, 809442, ins_by_bulk, SYBASE_INS_BY_BULK , KBA , BW-SYS-DB-SYB , BW on Sybase ASE Database Platform , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed

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.