SAP Knowledge Base Article - Preview

1939932 - Error SQL587 "Identity value overflow for field 'SEQNUMBER' in table 'DDLOG'" - SAP ASE for Business Suite

Symptom

  • Transactions or imports terminate with the following error:
    [ASE Error SQL587]: Identity value overflow for field 'SEQNUMBER' in table 'DDLOG'
  • The following lines will appear on a dev_w* trace file:

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


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7 for Business Suite
  • SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; SAP ERP 6.0

Keywords

"buffer synchronization", SEQNUMBER, SQL587, 587

reboot ASE reallly really really frequently with nowait option
, KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-DBI , DB Independent Database Interface , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.