Skip to Content
avatar image
Former Member

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

--------------------------------------

NULL

Kindly help. hanks

(1 row affected)

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Nov 04, 2015 at 07:46 AM

    Hello Alamsyah,
    You may apply instructions from SAP Note 1939932 - SYB: Identity value overflow for field 'SEQNUMBER' in table 'DDLOG'

    Prior of that you may want to check the content of DDLOG (ie to see how many records, oldest transaction datetime), by running ABAP report RSDBBUFF.

    Regards,
    Victoria.

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 03, 2015 at 12:00 PM

    Hi,

    What do you see as SA user if not using sapsa?


    If you dont get value returned open OSS as per note.

    Johan

    Add comment
    10|10000 characters needed characters exceeded