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