SAP Knowledge Base Article - Preview

3218200 - Getting error 2601 while running sp_addserver - SAP ASE

Symptom

  • sysservers has 1000 rows, maximum value of column "srvid" on sysservers table is 999.
  • Received error 2601 when trying to add 1 more server:
        
    sp_addserver isyb094, ASEnterprise, isyb094
    go
    Adding server 'isyb094', physical name 'isyb094'
    Msg 2601, Level 16, State 6:
    Server 'ASE16', Procedure 'sp_addserver', Line 630:
    Attempt to insert duplicate key row in object 'sysservers' with unique index 'csysservers'
    Command has been aborted.
    (return status = 1)


Read more...

Environment

SAP Adaptive Server Enterprise

Product

SAP Adaptive Server Enterprise 16.0

Keywords

826790, CR#826790, CR 826790, sp_addserver, Msg 2601, Level 16, State 6:, error 2601, 2601, duplicate key row, duplicate row, sysservers, unique index 'csysservers', csysservers, srvid , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Known Error

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.