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.