Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Work Process Restarted. Sybase DDLOG not found

Hi there ,

Im facing this issue where i cannot login to SAP System.

this the message i get when i try to login:

Work Process Restarted; Session terminated

Per check i found the followin message on dev_w* :

B  ***LOG BY4=> sql error 587    performing INS on table DDLOG [dbsynseq     587]

B  ***LOG BY0=> [ASE Error SQL587][SAP][ASE ODBC Driver][Adaptive Server Enterprise]Identity value overflow for field 'SEQNUMBER' in table 'DDLOG'.

[dbsynseq     587]

B  ***LOG BZY=> unexpected return code 2 calling ins_ddlog [dbsync       1399]

B  db_syflush (TRUE) failed

B  db_con_commit received error 1024 in before-commit action (con_hdl = 0, th_commit = 1, returning 8

M  ***LOG R38=> ThICommit, db_commit98 ( 001024) [thDatabase.c 432]

M  ***LOG R18=> ThISendRequest, ThICommit () [thRequest.c  3708]

When i try the command as instructed on sapnote 1939932 , somehow the DDLOG table doesnt showing.

1> use SID

2> go

1> select next_identity ('DDLOG')

2> go



Kindly help. hanks

(1 row affected)

Former Member
Former Member replied

Hi Alamsyah,

Please put table owner name beside the DDLOG shown below:

1. select next_identity ('SAPSR3.DDLOG')

2. go

Then truncate table *Owner*.DDLOG

1. truncate table SAPSR3.DDLOG

2. go

As for sp_chgattribute you need to setup the user 'SAPSR3'

1> setuser 'SAPSR3'

2> go

And then run the sp command

1> sp_chgattribute DDLOG, 'identity_burn_max', 0, '0'

2> go

Let me know if your problem solve


3 View this answer in context
Not what you were looking for? View more on this topic or Ask a question