Upload rpd from OBIEE 12.2.1.2 to 12.2.1.1 — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Upload rpd from OBIEE 12.2.1.2 to 12.2.1.1

Received Response
61
Views
8
Comments
3068122
3068122 Rank 4 - Community Specialist

Hi ,

I downloaded rpd from OBIEE 12.2.1.2.0. I opened rpd in offline mode and checked global consistency , I got no error.

Then , I uploaded rpd (which downloaded from 12.2.1.2) to 12.2.1.1 system. RPD upload completed succesfully without any error.

After uploaded rpd to 12.2.1.1 , I opened rpd in online mode.  Checked Global Consistency ,I got tons of same error like below.

-----------[38207] Logical column "Test"."Test Table."Column1" has no physical data source mapping.

-----------[38014] Logical tables "Test"."Test Table" and "Test"."Test Table 2" have multiple joins. Delete join object(s) so that repository doesn't contain duplicate(s) of existing joins.

I opened rpd in offline mode that i uploaded  , everyting is fine. All columns has physical data source mapping. However , in online mode , some column's physical data sources is empty.

Is there anyone who met issue like mine or who have any idea ?

Regards

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Basic question: Why would you go back a version? They aren't exactly the same you know...

  • FTisiot
    FTisiot Rank 6 - Analytics Lead

    If you upload an RPD generated on a newer system (12.2.1.2) to an older one (12.2.1.1) there is no guarantee that it will work.

    There was in 11g an utility to downgrade RPD version, worth checking if it still exists in 12c

    https://www.jamescoyle.net/how-to/1824-downgrade-an-obiee-rpd-version

  • 3068122
    3068122 Rank 4 - Community Specialist

    @Christian Berg , Basic answer Had a chronic crash problem in 12.2.1.2 and can't get solution from support for 4 months.That's why we decided to try 12.2.1.1

    @FTisiot , I downgraded rpd from version 356 to 354 then uploaded to 12.2.1.1 but no luck.

    By the way , when I opened rpd in online mode after uploading version 354 , ask me to upgrade rpd version to 356 while closing Administration. Also , the same situtation when upload rpd in version 355.

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Try this: mds-xml the whole rpd and recompile into binary rpd using the 12.2.1.1 commands (and hence 12.2.1.1 binaries)

  • 3310714
    3310714 Rank 6 - Analytics Lead

    Hi,

    Just curious, can you describe your crash problems?  What issues were you having? 

  • 3068122
    3068122 Rank 4 - Community Specialist

    Sorry for delay @Christian Berg,

    is there any document at MOS about how to recompile rpd ? I didn't find anything.

    @3310714 , Unfortunately sawserver.exe crashes periodically.

  • MDS-XML is an alternative format for the RPD, where the RPD is saved as a ton of XML files instead of a single binary file.

    So to go from the MDS XML back to a RPD file you can just open with the Admin tool the MDS XML version and then save it back as .rpd .

    There is also a command line way to make the job, but doing it with the Admin tool is probably just easier as it's a one shot thing to try.

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    biserverxmlgen

    biserverxmlexec