Skip to Content
author's profile photo Former Member
Former Member

System Refresh fails Recovery phase

Hello,

I'm trying to do a system refresh from PRD to QUA with the Homogeneous system copy with Backup/Restore method.

I've made the recovery of PRD on QUA after that I've executed the System Rename but I'm getting and error during the process on create sap stored procedures step.

[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name MSSSOURCE

What did I do incorrect?

Regards

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on May 09, 2016 at 03:20 PM

    Any suggestion?

    Many thanks

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 04, 2016 at 01:32 PM

    Hi Ruben,

    Can you kindly check what is the Default Database for Login and the connection String settings.

    Also what is the Owner of the Object. Is it the DBO user ?

    Thanks and Regards

    Anurag

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 04, 2016 at 03:57 PM

    Hi Ruben,

    As I understood from you, you are doing the Homogeneous system copy with Backup/Restore method.

    System rename i.e. change of <sid> from PRD to QUA is done by controlfile.sql script.

    Which command are you using.

    what is your Database, oracle ?

    Regards,

    Deepa.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 04, 2016 at 08:16 PM

    Hi Ruben,

    Did you use DB utility to restore the backup or SWPM (with option homogeneous system copy )


    I guess the problem is with the schema owner for the DB objects in your target DB. Can you see if the schema is correct for QA DB.


    If the schema is not correct you can use the SWPM --> System Copy option to fix this.

    Thanks,

    Manas

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 15, 2016 at 01:05 PM

    Hello,

    Has anybody a suggestion about this error??

    Please let me know.

    Regards

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.