Upload rpd from OBIEE 12.2.1.2 to 12.2.1.1

3068122

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

[Deleted User]

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

FTisiot

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

@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]

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

Hi,

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

3068122

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.

Gianni Ceresa

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]

biserverxmlgen

biserverxmlexec