Work Process Restarted. Sybase DDLOG not found

[Former Member]

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)

[victoria_normand · Accepted solution]

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.

[Former Member · Accepted solution]

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

Thanks
AP

[victoria_normand · Accepted solution]

Hi Andre,

Thanks for the correction about table owner, it should be corrected/added on the SAP Note 1939932 - SYB: Identity value overflow for field 'SEQNUMBER' in table 'DDLOG'

Regards,
Victoria.

[Former Member · Accepted solution]

Hi Andre,

Full points for you.. Problem solved. Thank you very much.

R,

AM

[victoria_normand · Accepted solution]

Hi,
Just for anyone that might read this thread: the solution was documented on SAP Note 1939932 - SYB: Identity value overflow for field 'SEQNUMBER' in table 'DDLOG' which had a missing information Andre noticed: the table owner SAPSR3 was not correctly mentioned. The SAP Note has been now updated.

Best regards,

Victoria.

[Johan_sapbasis]

Hi,

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

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

Johan

[Former Member]

Hi Nicolaas,

I used sapsa as the isql login user.