Symptom
- Running sybmigrate
- Returns errors including duplicate key error 2601:
WARNING|Attention: Failed to copy users from source database 'XXX' to the work database 'mtpdb$1$1' for path 'XXX --> XXX'. This will cause problem in migrating data for tables owned by non-dbo users.
Manually add all users in source database 'XXX' to the work database 'mtpdb$1$1'.
WARNING|Msg 2601, Level 14, State 6
Server <svrname., Line 1, Status 6, TranState 0
Attempt to insert duplicate key row in object 'sysusers' with unique index 'ncsysusers2'
Root Cause:Msg 2601, Level 14, State 6
Server <svrname>, Line 1, Status 6, TranState 0
Attempt to insert duplicate key row in object 'sysusers' with unique index 'ncsysusers2'
Read more...
Environment
-
SAP Adaptive Server Enterprise (ASE)
- Sybmigrate utility
Product
SAP Adaptive Server Enterprise 15.7
Keywords
sybmigrate
resource file , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem
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.