2558319 - Migration via Sybmigrate fails due error "RemoteServer....already exists" - SAP ASE | SAP Knowledge Base Article

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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.