Skip to Content
Author's profile photo Eduardo Rezende

Wondering why your transport tools …

…does not work after a system copy?

Check note 1886616! 🙂

SAP Netweaver based systems uses two different variables sets, environment and profile variables.

During a system copy those variables should be updated.

If only the profile variables (<Unit>:\usr\sap\<SID>\SYS\profile\DEFAULT.PFL) are updated, you will be able to start your SAP system but some tools (e.g. tp) which uses the environment variables of your <sid>adm user will not work.

To exemplify:

You have a SAP system ERM located on host VM-MSS-OLD with default database instance, the database variables should be:

  • C:\usr\sap\ERM\SYS\profile\DEFAULT.PFL
    • dbms/type = mss
    • dbs/mss/dbname = ERM
    • dbs/mss/schema = erm
    • dbs/mss/server = VM-MSS-OLD
  • Environment variables of user ermadm:
    • DBMS_TYPE=mss
    • MSSQL_DBNAME=ERM
    • MSSQL_SCHEMA=erm
    • MSSQL_SERVER=VM-MSS-OLD

After a system copy of system ERM to host VM-MSS with default database instance, the database variables should be:

  • C:\usr\sap\ERM\SYS\profile\DEFAULT.PFL
    • dbms/type = mss
    • dbs/mss/dbname = ERM
    • dbs/mss/schema = erm
    • dbs/mss/server = VM-MSS
  • Environment variables of user ermadm:
    • DBMS_TYPE=mss
    • MSSQL_DBNAME=ERM
    • MSSQL_SCHEMA=erm
    • MSSQL_SERVER=VM-MSS

If a mismatch in the server variable is observed, this could be the cause of the issue:

  • C:\usr\sap\ERM\SYS\profile\DEFAULT.PFL
    • dbms/type = mss
    • dbs/mss/dbname = ERM
    • dbs/mss/schema = erm
    • dbs/mss/server = VM-MSS
  • Environment variables of user ermadm:
    • DBMS_TYPE=mss
    • MSSQL_DBNAME=ERM
    • MSSQL_SCHEMA=erm
    • MSSQL_SERVER=VM-MSS-OLD

If the system <SID> is changed during the system copy, all database variables must be updated.


This variables mismatch might affect other SAP procedures, as other tools (e.g. R3trans) also uses the <sid>adm user variables.

Hope you like this blog and any comments/suggestions are welcome!

Regards,

Eduardo Rezende

Assigned tags

      8 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Carlos Machado
      Carlos Machado

      Hi Eduardo

      Have you identified this behavior only in MSS Databases ?

      Author's profile photo Eduardo Rezende
      Eduardo Rezende
      Blog Post Author

      Hi Carlos,

      So far yes, because other databases uses other connection mechanisms.

      Regards,

      Eduardo

      Author's profile photo Cristiano Hansen
      Cristiano Hansen

      Hi Eduardo,

      Nice post. Thanks for sharing,

      Cris

      Author's profile photo Eduardo Rezende
      Eduardo Rezende
      Blog Post Author

      Thanks Cris!

      Author's profile photo Vagner Andrade
      Vagner Andrade

      Hi Eduardo,

      Thanks for this posting this. It is helpful.

      Author's profile photo Eduardo Rezende
      Eduardo Rezende
      Blog Post Author

      Thanks Vagner!

      Author's profile photo Daniel Grings
      Daniel Grings

      Hello Eduardo,

      Very nice blog and KBA!

      Author's profile photo Eduardo Rezende
      Eduardo Rezende
      Blog Post Author

      Thanks Daniel!