12 Replies Latest reply on Aug 23, 2017 11:49 AM by Syed Hamd Salman

    Merge two different RPD

    choracy69

      Hello,

       

      I have some problem with merge repository. Actually, we are upgrading our BI system.

      At now we have: Oracle Business Intelligence 11.1.1.7.131017 with Oracle Business Intelligence Applications 11g Release 1 (11.1.1.7.1) ---> OracleBIApps_BI0003.rpd (this rpd has many our changes)

      New version: Oracle Business Intelligence 11.1.1.9.6 with Oracle Business Intelligence Applications 11g Release 1 (11.1.1.9) --> OracleBIApps_BI0005.rpd

       

      I must merge this two rpd.

      I open OracleBIApps_BI0003.rpd and merge: Full Repository Merge

      Current Repository for me: OracleBIApps_BI0003.rpd  --> because I want export object from it

      Modified rpd: OracleBIApps_BI0005.rpd

      Original: Blank.rpd

       

      And I click finish. Next I have decision windows but I have a lot of point, around 9000 decision to check. It takes a lot of time, and it is not known if it will end up with a mistake.

       

      Is it possible to improve this process somehow? Or does anyone have any suggestions on how to solve this?

        • 1. Re: Merge two different RPD
          Syed Hamd Salman

          I think correction is needed in your statement as OBIEE 11.1.1.9.6 doesn't come along with OBIA 11.1.1.9.x infact it was not even released when OBIA 11.1.1.9.x was released, 11.1.1.9.6 is the OBIEE version which comes with OBIA 11.1.1.10.2

           

          Regarding your issue try following below steps and test if you are able to achieve your requirement:

           

          **** All below steps need to be followed keeping all the RPD version as same i.e. either 11.1.1.7.x or 11.1.1.9.x

          **** Keep a backup copy of all the RPD's to avoid lossing your changes in case of incorrect steps execution.

           

          a) Create Patch between Current RPD(OracleBIApps_BI0003.rpd) with latest changes and Original BIAPPS out of the box 11.1.1.7.1 RPD(OracleBIApps.rpd) without changes using comparerpd command from       following location <ORA_HOME>\Oracle_BI1\bifoundation\server\bin


          ***You can find Out of the box BIAPPS RPD(OracleBIApps.rpd) without your changes in following location
          <MIDDLE WARE HOME>\Oracle_BI1\biapps\admin\provisioning\OracleBISereverComponent


          Example comparerpd Command Below:

           

          comparerpd -P Admin123 -C D:\OBIEE11119\RPDPatching\OracleBIApps_BI0003.rpd -W Admin123 -G D:\OBIEE11119\RPDPatching\OracleBIApps.rpd -D D:\OBIEE11119\RPDPatching\Release.xml

           

          ***Before running patchrpd, you must first run bi-init.cmd (or bi-init.sh on UNIX) to launch a command prompt or shell window that is initialized to your Oracle instance.

              You can find this utility in: ORACLE_INSTANCE/bifoundation/OracleBIApplication/coreapplication/setup

           

          c) From same location on same command console use generated Patch file Release.xml in above example to generate a new Patched RPD by using patchrpd command.

           

          Example:

           

          patchrpd.exe -P Admin123 -C D:\OBIEE11119\RPDPatching\OracleBIApps_BI0005.rpd -Q Admin123 -G D:\OBIEE11119\RPDPatching\OracleBIApps_BI0003.rpd -S Admin123 -I D:\OBIEE11119\RPDPatching\Release.xml -O D:\OBIEE11119\RPDPatching\OracleBIApps_BI0006_Patched.rpd -V D:\OBIEE11119\RPDPatching\Outputfile1.csv

          1 person found this helpful
          • 2. Re: Merge two different RPD
            choracy69

            About yours steps. Must I do this in console?

             

            I used Oracle BI Administration Tool.

             

            Step 1. Open OracleBIApps_BI0003.rpd and COMPARE with OracleBIApps.rpd --> it looks on windows thats everthing it's. And I Create Path --> release.xml

            Step.2 Open in Administration Tool OracleBIApps_BI0005.rpd and use MERGE -- Path Repository Merge.where:

            Original Master Repository: OracleBIApps_BI0003.rpd

            Modified Repository: OracleBIApps_BI0005.rpd

            Patch File: release.xml

            Save Merged Repository as: OracleBIApps_BI0005_patched.rpd

             

            And I click finish, all process is doing without any problems and error and I get OracleBIApps_BI0005_pathed.rpd but I don't see any change.

            Volumne of my rpd OracleBIApps_BI0005.rpd:

            befor emerge: 17562 KiB

            after merge: 18078 KiB

            It does not have any my object.

            I find some file: OracleBIApps_BI0005_patched_merge_log.csv and there I have some lines for example:

             

            Deleted,Presentation Column,"""Procurement and Spend - Purchase Orders""..""Fact_BENCH_NEW"".""SAVINGS [EUR] DETAILS""",Default decision

             

            Why it deleted? I don't have window with decision.

             

            In release.xml I find lines fot it:

             

            <RefPresentationColumn id="4010:1905020" uid="c0000003-7aaf-1606-ba2a-c0a8259f0000" qualifiedName="&quot;Procurement and Spend - Purchase Orders&quot;..&quot;Fact_BENCH_NEW&quot;.&quot;SAVINGS [EUR] DETAILS&quot;"/>

             

            <PresentationColumn name="SAVINGS [EUR] DETAILS" parentName="&quot;Procurement and Spend - Purchase Orders&quot;..&quot;Fact_BENCH_NEW&quot;" parentId="4008:1857743" parentUid="929b2b70-0d1f-1000-ac17-c0a824b30000" id="4010:1905020" uid="c0000003-7aaf-1606-ba2a-c0a8259f0000" hasDispName="false" hasDispDescription="false" overrideLogicalName="false">

            <RefLogicalColumn id="2006:1904991" uid="4000000d-7a7e-1606-ba2a-c0a8259f0000" qualifiedName="&quot;Core&quot;.&quot;Fact_XX_W_BENCH_A&quot;.&quot;SAVINGS [EUR] DETAILS&quot;"/>

            </PresentationColumn>

             

            What wrong with my operation?

            • 3. Re: Merge two different RPD
              Syed Hamd Salman

              By console , I meant command console like Command Prompt(cmd) in Windows and Putty etc in Unix

               

              Could you redo Step 2 with below settings

               

              Step.2

              Open in Administration Tool OracleBIApps_BI0005.rpd and use MERGE -- Patch Repository Merge.where:

              Original Master Repository: OracleBIApps_BI0005.rpd

              Modified Repository: OracleBIApps_BI0003.rpd

              Patch File: release.xml

              Save Merged Repository as: OracleBIApps_BI0005_patched.rpd

               

              If above steps do not give desired results then could you also compare  OracleBIApps.rpd(11.1.1.7.1 Out Of the Box RPD) and OracleBIApps_BI0005.rpd to see the difference between two different BIAPPS version out of the box RPD.

              • 4. Re: Merge two different RPD
                choracy69

                Ok I done this process in console (cmd).

                 

                Step 1)

                 

                comparerpd.exe -P RPDpass12 -C w:\rpd\OracleBIApps_BI0003.rpd -W RPDpass12 -G w:\rpd\OracleBIApps.rpd -D w:\rpd\rel.xml

                 

                logs:

                 

                C:\Program Files\Oracle Business Intelligence Enterprise Edition Plus Client Too

                ls 11.1.1.9\oraclebi\orahome\bifoundation\server\bin>comparerpd.exe -P RPDpass12

                -C w:\rpd\OracleBIApps_BI0003.rpd -W RPDpass12 -G w:\rpd\OracleBIApps.rpd -D w:

                \rpd\rel.xml

                [94078] Repository equalized successfully

                The following repository is opened: w:\rpd\OracleBIApps.rpd

                The following repository is opened: w:\rpd\OracleBIApps_BI0003_equalized.rpd

                 

                Step 2)

                 

                patchrpd.exe -P RPDpass12 -C w:\rpd\OracleBIApps_BI0005.rpd -Q RPDpass12 -G w:\rpd\OracleBIApps_BI0003.rpd -S RPDpass12 -I w:\rpd\rel.xml -O w:\rpd\OracleBIApps_BI0006_Patched.rpd -V w:\rpd\Outputfile1.csv

                 

                logs:

                 

                C:\Program Files\Oracle Business Intelligence Enterprise Edition Plus Client Too

                ls 11.1.1.9\oraclebi\orahome\bifoundation\server\bin>patchrpd.exe -P RPDpass12 -

                C w:\rpd\OracleBIApps_BI0005.rpd -Q RPDpass12 -G w:\rpd\OracleBIApps_BI0003.rpd

                -S RPDpass12 -I w:\rpd\rel.xml -O w:\rpd\OracleBIApps_BI0006_Patched.rpd -V w:\r

                pd\Outputfile1.csv

                XML execution finished successfully.

                 

                Complete Success of patch application on original repository!!

                The following repository is opened: w:\rpd\OracleBIApps_BI0005.rpd

                 

                 

                Project extract is successful for the repository: w:\rpd\OracleBIApps_BI0003.rpd

                .

                Project extract is successful for the repository: w:\rpd\OracleBIApps_BI0003_pat

                ched.rpd.

                [94078] Repository equalized successfully

                [94078] Repository equalized successfully

                 

                [94017] Complete success of patch application on customer repository.

                Output log files can be found at C:\Users\marcho\AppData\Local\Temp\oracle\insta

                nce\diagnostics\logs\OracleBIServerComponent\coreapplication_obis1.

                 

                 

                Result:

                 

                new rpd does not have any my object --> new databases, new connection pool, new physiscal tabe, new logical table etc...

                • 5. Re: Merge two different RPD
                  choracy69

                  Step 2 with other settings.

                   

                  comand:

                   

                  patchrpd.exe -P RPDpass12 -C w:\rpd\OracleBIApps_BI0003.rpd -Q RPDpass12 -G w:\rpd\OracleBIApps_BI0005.rpd -S RPDpass12 -I w:\rpd\rel.xml -O w:\rpd\OracleBIApps_BI0007_Patched.rpd -V w:\rpd\Outputfile11.csv

                   

                  logs:

                   

                   

                  C:\Program Files\Oracle Business Intelligence Enterprise Edition Plus Client Too

                  ls 11.1.1.9\oraclebi\orahome\bifoundation\server\bin>patchrpd.exe -P RPDpass12 -

                  C w:\rpd\OracleBIApps_BI0003.rpd -Q RPDpass12 -G w:\rpd\OracleBIApps_BI0005.rpd

                  -S RPDpass12 -I w:\rpd\rel.xml -O w:\rpd\OracleBIApps_BI0007_Patched.rpd -V w:\r

                  pd\Outputfile11.csv

                  [94057]

                        Couldn't create the RPD. Error details: [nQSError: 92006] Could not resolv

                  e the object "Fixed Asset Book"."ASSET_BOOK_CODE____FUSION" (UID: 80f69eca-0bd7-

                  0000-714b-e31d00000000)

                  [94037]

                        Couldn't create the RPD! Please check the log file '*BiServerXmlExec.log'

                  under Oracle BI instance directory for error details.

                        For example, path to this log file could be:

                        '<ORACLE_INSTANCE>\instances\instance1\diagnostics\logs\OracleBIServerComp

                  onent\coreapplication_obis1'.

                   

                  [94322] Execution Biserverxmlexec failed on original repository: w:\rpd\OracleBI

                  Apps_BI0005.rpd

                  [94042] Patch cannot be applied on w:\rpd\OracleBIApps_BI0003.rpd. See log file

                  for the details

                  Output log files can be found at C:\Users\marcho\AppData\Local\Temp\oracle\insta

                  nce\diagnostics\logs\OracleBIServerComponent\coreapplication_obis1.

                   

                   

                  In BiServerXmlExec.log:

                   

                  [2017-07-28T12:35:26.917+02:00] [OracleBIServerComponent] [TRACE:1] [] [] [ecid: ] [tid: 1894] Opening RPD. File=w:\rpd\OracleBIApps_BI0005.rpd,ID=14745296896137393482_14574824250792966783, LogicalName:  [[

                  file: server\objectmodel\Src\SOPersistRp.cpp; line: 331

                  ]]

                  [2017-07-28T12:35:35.433+02:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: ] [tid: 1894]  [92016] Executing the XUDML file:  w:\rpd\rel.xml

                  [2017-07-28T12:35:46.416+02:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 1894]  [nQSError: 92006] Could not resolve the object "Fixed Asset Book"."ASSET_BOOK_CODE____FUSION" (UID: 80f69eca-0bd7-0000-714b-e31d00000000) [[

                  file: server\Metadata\XUDML\Src\SMXUDMLUtil.cpp; line: 2882

                  ]]

                  [2017-07-28T12:35:47.192+02:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 1894]  [nQSError: 92006] Could not resolve the object "Fixed Asset Book"."ASSET_BOOK_CODE____FUSION" (UID: 80f69eca-0bd7-0000-714b-e31d00000000)

                  [2017-07-28T12:35:47.241+02:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: ] [tid: 1894]  [94057]  [[

                        Couldn't create the RPD. Error details: [nQSError: 92006] Could not resolve the object "Fixed Asset Book"."ASSET_BOOK_CODE____FUSION" (UID: 80f69eca-0bd7-0000-714b-e31d00000000)

                  ]]

                  [2017-07-28T12:35:47.244+02:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: ] [tid: 1894]  [94037]  [[

                        Couldn't create the RPD! Please check the log file '*BiServerXmlExec.log' under Oracle BI instance directory for error details.

                        For example, path to this log file could be:

                        '<ORACLE_INSTANCE>\instances\instance1\diagnostics\logs\OracleBIServerComponent\coreapplication_obis1'.

                  ]]

                  [2017-07-28T12:35:47.248+02:00] [OracleBIServerComponent] [TRACE:1] [] [] [ecid: ] [tid: 1894] Unloading RPD. File=w:\rpd\OracleBIApps_BI0005.rpd,ID=14745296896137393482_14574824250792966783, LogicalName:  [[

                  file: server\objectmodel\Src\SOPersistRp.cpp; line: 288

                   

                  patchrpd.log:

                   

                   

                  [2017-07-28T12:35:01.877+02:00] [OracleBIServerComponent] [TRACE:1] [] [] [ecid: ] [tid: b4c] Opening RPD. File=w:\rpd\OracleBIApps_BI0005.rpd,ID=14745296896137393482_14574824250792966783, LogicalName:  [[

                  file: server\objectmodel\Src\SOPersistRp.cpp; line: 331

                  ]]

                  [2017-07-28T12:35:21.832+02:00] [OracleBIServerComponent] [TRACE:1] [] [] [ecid: ] [tid: b4c] Unloading RPD. File=w:\rpd\OracleBIApps_BI0005.rpd,ID=14745296896137393482_14574824250792966783, LogicalName:  [[

                  file: server\objectmodel\Src\SOPersistRp.cpp; line: 288

                  ]]

                  [2017-07-28T12:35:52.733+02:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: ] [tid: b4c]  [94322] Execution Biserverxmlexec failed on original repository: w:\rpd\OracleBIApps_BI0005.rpd

                  [2017-07-28T12:35:52.737+02:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: ] [tid: b4c]  [94042] Patch cannot be applied on w:\rpd\OracleBIApps_BI0003.rpd. See log file for the details

                  • 6. Re: Merge two different RPD
                    choracy69

                    Maybe Patch Repository Merge only move original obiect from rpd to rpd, but for my new objects (table, databases, connection pool etc.) nedd I Full Respository Merge?

                    • 7. Re: Merge two different RPD
                      John_K

                      When upgrading an RPD, there are generally two approaches you can take.

                       

                      1) Try to merge your changes into the new RPD.

                      2) Diff the "out of the box" (OOTB) old version and OOTB new version, and patch those changes into your customized RPD and save as the latest version.

                       

                      The second option can often lead to less headache.

                      • 8. Re: Merge two different RPD
                        choracy69

                        Hi,

                         

                        I done migrate only my objects to new repository (exclude my customizations in Bi Apps) but I think it enough and it works.

                        But I have some problem when I save my rpd in new Version: 11.1.1.9.160119 and try to Import metedata my Oracle Bi Administration Tool turn out. In logs i find:

                         

                        [2017-08-23T11:41:35.527+02:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: ] [tid: 1028]  [46158] Admintool is using language PLK.

                        [2017-08-23T11:41:35.532+02:00] [OracleBIServerComponent] [TRACE:1] [] [] [ecid: ] [tid: 1028] Loading javads Metadata

                        [2017-08-23T11:41:45.105+02:00] [OracleBIServerComponent] [TRACE:1] [] [] [ecid: ] [tid: 1028] Opening RPD. File=C:\Program Files\Oracle Business Intelligence Enterprise Edition Plus Client Tools 11.1.1.9\oraclebi\orainst\bifoundation\OracleBIServerComponent\coreapplication\repository\OracleBIApps_BI0003 - Kopia.rpd,ID=5686962589290994507_6744304675375142756, LogicalName: C:\Program Files\Oracle Business Intelligence Enterprise Edition Plus Client Tools 11.1.1.9\oraclebi\orainst\bifoundation\OracleBIServerComponent\coreapplication\repository\OracleBIApps_BI0003 - Kopia.rpd [[

                        file: server\objectmodel\Src\SOPersistRp.cpp; line: 331

                        ]]

                        [2017-08-23T11:42:33.09+02:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: ] [tid: 1028]  [16020] Metadata Database Type:  [[

                        Data Source Name: (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=obiadb.---.com)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=OBIADB)))

                        Data Source Type: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64b

                        ]]

                        [2017-08-23T11:42:41.532+02:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 1028]  [nQSError: 17003] Oracle gateway error: Unsupported data type 10. [[

                        file: server\Query\Execution\DbGateway\Oci10g\..\Oci8\Src\SQXDGOci8Utils.cpp; line: 238

                        ]]

                         

                        _______________

                         

                        [2017-08-23T10:21:17.115+02:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 854]  [nQSError: 17012] Bulk fetch failed. [[

                        file: server\Query\Execution\DbGateway\Oci10g\..\Oci8\Src\SQXDGOci8.cpp; line: 373

                        [nQSError: 17001] Oracle Error code: 3113, message: ORA-03113: end-of-file on communication channel

                        Process ID: 32374

                        Session ID: 48 Serial number: 38547

                        at OCI call OCIStmtFetch.

                        ]]

                        [2017-08-23T10:24:28.688+02:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 854]  [nQSError: 17011] SQL statement execution failed. [[

                        file: server\Query\Execution\DbGateway\Oci10g\..\Oci8\Src\SQXDGOci8.cpp; line: 373

                        [nQSError: 17001] Oracle Error code: 3114, message: ORA-03114: not connected to ORACLE

                        at OCI call OCIStmtExecute: select constraint_name from all_constraints where all_constraints.constraint_type='P' and all_constraints.table_name='XX_BIS_MM_BUSINESS_LINE_DS' and all_constraints.owner='DEV_DW'.

                        ]]

                        [2017-08-23T10:24:36.173+02:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 854]  [nQSError: 17011] SQL statement execution failed. [[

                        file: server\Query\Execution\DbGateway\Oci10g\..\Oci8\Src\SQXDGOci8.cpp; line: 373

                        [nQSError: 17001] Oracle Error code: 3114, message: ORA-03114: not connected to ORACLE

                        at OCI call OCIStmtExecute: select constraint_name from all_constraints where all_constraints.constraint_type='P' and all_constraints.table_name='XX_BIS_MM_IT_FS' and all_constraints.owner='DEV_DW'.

                        ]]

                        Someone can help?

                        • 9. Re: Merge two different RPD
                          John_K

                          Have you an appropriate Oracle InstantClient install on your machine?

                          • 10. Re: Merge two different RPD
                            choracy69

                            What does it mean the appropriate Oracle Instant Client?

                            In past RPD version 11.1.1.7.140527, repository version: 326, MUD version:3 it everything is ok.

                            Next I download new RPD version 11.1.1.9.160119, repository version: 349, MUD version: 6 and try to merge...

                            I open BI0003.rpd in my new rpd version and merge with my new BI Apss (BI0005.rpd). It is ok, but Import MetaData not working.

                            But when I use View Data or Update Row Count it's ok.

                            • 11. Re: Merge two different RPD
                              John_K

                              If you are doing anything other than simple RPD development you should have the Oracle InstantClient software installed on your client machine.

                              • 12. Re: Merge two different RPD
                                Syed Hamd Salman

                                Follow the steps mentioned in below KM document for further diagnosis of your issue.

                                 

                                OBIEE 11g: How to Troubleshoot Administration Tool Client Connectivity Issues (Doc ID 2124416.1)

                                 

                                P.S. Sent you a connection request earlier with a thought of helping you out personally in merging the RPD's but anyways good to know you have achieved the same on your own.