Skip to Content

Restore UJBR error ORA-00942

Hi BPC experts!

SAP_BW 740, CPMBPC 801 SP-level 10

I have some problem with restoring in UJBR. I'm trying restore from PROD to DEV. UJBR give me error "SQL message: ORA-00942: table or view doesn't exist". I restore in Background mode because my backup about 2Gb(without data). I did not find any sap note.

ujbr.jpg (61.0 kB)
error.png (30.9 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Feb 10 at 08:50 PM

    If you are using "Insert File" instead of "Insert Image" then:

    1. You are not reading forum (I have told many times not to do it).

    2. No answers from me.

    P.S. And version/SP info about BPC and BW is not provided clearly!

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 11 at 08:22 AM

    Do you restore backup over existing environment?

    Do you have the same BW/BPC SP level on PROD and DEV?

    P.S. CPMBPC 801 SP-level 10 is VERY old!

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 11 at 03:12 PM

    You are using the option "use technical names from backup files" to restore the Environment with the same technical names as in your Productive system.

    UJBR does not restore to an already existing environment. If restoring to an existing environment with the same technical names you need to fully delete the existing environment and all references to any technical objects.

    It can happen that deleting an environenment witll not delete all references to tables (due to dependencies, etc). There is a program UJAA_CLEAN_DELETED_APPSET that can be used to remove any orphaned references, but this program does not exist in your SP version which as Vadim has stated is quite old. You would need at minimum SP13 for this program.

    Ad the short dump message clearly states the table name in question, please delete the existing environment you are trying to restore into and ask your BASIS to search for any reference to this table and remove it and try your restore again.

    Regards,

    Peter Kreutlein

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 11 at 06:37 PM

    So BPC experts as I understand the solution is I must upgrade SP level up to minimum SP 13?

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 11 at 10:54 PM

    I would strongly suggest upgrading to the latest SP and keep current with new releases on a fairly frequent basis. keep in mind that code fixes are normally only provided for the latest SP and last three releases, so if any new code related issues were discovered that impacted your system we would not fix it in your SP.

    As this issue has shown, being too far behind means that fixes and features that are released to fix issues will not be available for your SP.

    Add comment
    10|10000 characters needed characters exceeded