SAP Knowledge Base Article - Preview

2558319 - Migration via Sybmigrate fails due error "RemoteServer....already exists" - SAP ASE

Symptom

  • The migration of SAP ASE 15.7 (page 2k) to SAP ASE 16.0 (4k) via Sybmigrate fails.
  • A box with the following message is displayed:

Error while fetching available tasks of type 'Default'
Could not create proxy table 'mtpdb$1$1..mtpt$mtrs$sysusers' for the system 'mtrs$1.xxxxxxxx.yy.dbo.sysusers'.
Msg 911, Level 11, State 2
Server server01, Line 1, Status 2, TranState 1
Attempt to locate entry in sysdatabases 'mtpdb$1$1' by name failed - no entry found under that name. Make sure that name is entered properly.
Msg 2702, Level 16, State 3
Server server01, Line 1, Status 3, TranState 1
Database 'mtpdb$1$1' does not exist.

  • The sybmigrate log inclused log:

    2017/10/18 18:22:37.079|EXEC_SETUP_TASKS||Save session info to the repository database.
    2017/10/18 18:22:37.104|EXEC_SETUP_TASKS|DEBUG|sAse.setupRemoteServer to XXXXXX
    2017/10/18 18:22:37.312|EXEC_SETUP_TASKS||Completed setup.
    2017/10/18 18:22:40.103|RESTART_SESSION1|DEBUG|getMigrationSession: Auto_Model
    2017/10/18 18:22:40.105|RESTART_SESSION1|DEBUG|isDevEdition 1
    2017/10/18 18:22:40.124|RESTART_SESSION1|DEBUG|using PUSH: Source Version 15.7.0.101
    2017/10/18 18:22:40.213|RESTART_SESSION1|DEBUG|session exists migrateServerInfo 2server InfoMigrationStatus -1
    2017/10/18 18:22:40.213|RESTART_SESSION1|DEBUG|2: setupModeNeeded false
    2017/10/18 18:22:40.252|RESTART_SESSION1|DEBUG|RemoteServer mtrs$0 already exists
    2017/10/18 18:22:40.284|RESTART_SESSION1|DEBUG|3: Status == FAIL
    2017/10/18 18:22:40.293|RESTART_SESSION1||Validated source and target for migration


Read more...

Environment

  • SAP Adaptive Server 15.7
  • SAP Adaptive Server 16.0

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

911 2702 Could not create proxy table Attempt locate entry sysdatabases RemoteServer already exists sybmigrate failed fails sybmigrate , 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.