Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Merge two different RPD
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?
Answers
-
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
\OBIEE11119\RPDPatching\OracleBIApps_BI0003.rpd -W Admin123 -G \OBIEE11119\RPDPatching\OracleBIApps.rpd -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
\OBIEE11119\RPDPatching\OracleBIApps_BI0005.rpd -Q Admin123 -G \OBIEE11119\RPDPatching\OracleBIApps_BI0003.rpd -S Admin123 -I \OBIEE11119\RPDPatching\Release.xml -O \OBIEE11119\RPDPatching\OracleBIApps_BI0006_Patched.rpd -V \OBIEE11119\RPDPatching\Outputfile1.csv0 -
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=""Procurement and Spend - Purchase Orders".."Fact_BENCH_NEW"."SAVINGS [EUR] DETAILS""/>
<PresentationColumn name="SAVINGS [EUR] DETAILS" parentName=""Procurement and Spend - Purchase Orders".."Fact_BENCH_NEW"" 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=""Core"."Fact_XX_W_BENCH_A"."SAVINGS [EUR] DETAILS""/>
</PresentationColumn>
What wrong with my operation?
0 -
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.
0 -
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...
0 -
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
0 -
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?
0 -
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.
0 -
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?
0 -
Have you an appropriate Oracle InstantClient install on your machine?
0 -
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.
0