SAP System Message Workprocess restarted;session terminated while login to sap

SAP System Message Workprocess restarted;session terminated while login to sap



message SAP System Message Work process restarted;session terminated while login to sap and not able to login to SAP

please find the screen shot attached below.




  1. Stop the system. Because the concerned table is used for buffer synchronization, you must shut down all application server ABAP instances, only database should be up and running.
     
  2. Log on the host as "syb" user, then run isql :
isql -Usapsa -S -X(the -X is added if using ASE password net encryption, which is normally required on SAP application environments)
  1. Check the next identity value for DDLOG, this should be higher than 2147483647.
    (If this isn't the case and you still get the identity value overflow for table DDLOG , please contact SAP Product Support for assistance.)
use
go
select next_identity ("SAPSR3.DDLOG")
go
  1. Remove all DDLOG entries:
use
go
truncate table SAPSR3.DDLOG
go
  1. Reset the DDLOG identity counter:
setuser 'SAPSR3'
go
sp_chgattribute DDLOG, 'identity_burn_max', 0, '0'
go
  1. Now restart the system.