SAP Knowledge Base Article - Preview

2578340 - Using sp_thresholdaction for Dump database/dump tran hangs if using net password encryption - SAP ASE

Symptom

  • The sp_thresholdaction with Dump database or dump tran hangs if enabling "net password encryption" option for the backup server.

  • When this happens, in sp_who or select * from sysprocesses, we can notice the $dmpxact or DUMP command which is hung for long time. select * from master..sysprocesses ouput shows

    spid kpid enginenum status suid hostname program_name hostprocess cmd cpu physical_io memusage blocked dbid uid gid tran_name time_blocked network_pktsz fid execlass priority affinity id stmtnum linenum origsuid block_xloid clientname clienthostname clientapplname sys_id ses_id loggedindatetime ipaddr nodeid spare2 execution_time
      86 5832749 0 background 1 NULL <threshold> NULL DUMP TRANSACTION 0 0 19 0 7 1 0 $dmpxact NULL 2048 0 NULL MEDIUM NULL 251144909 10 54 0 0 0 0 Dec 12 2017 11:01AM NULL NULL NULL 131601


Read more...

Environment

SAP Adaptive Server Enterprise 16.0.x

Product

SAP Adaptive Server Enterprise 16.0

Keywords

sp_thresholdaction, hang, dump database, dump tran, #812354, 812354, "net password encryption", backup server , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , SAP Business Suite on Sybase ASE Database Platform , 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.