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.
SAP Knowledge Base Article - Preview