Sitemap

Amicuk Programming Answers

How do we migrate the OWB mapping from one server to another server?

2015-10-11   Views:3

Advertisement

Here is my situation. Source server ================ Project name : SOURCEOWB Under this project, we have two module(MBTSOURCE, MBTTARGET). In connection explorer, the locations are DW_MBT_SR, DW_MBT_TR. We have 15 mappings on this project. Source sc

Here is my situation.
Source server
================
Project name : SOURCEOWB
Under this project, we have two module(MBTSOURCE, MBTTARGET).
In connection explorer, the locations are DW_MBT_SR, DW_MBT_TR.
We have 15 mappings on this project.
Source schema name is TXMBT_DW.
Target schema name is MBTTX_DW.
I want to migrate the whole thing to new server.
Here are the info about target location. After migrating to new server, i need to rename
as below.
Project name : CA_SOURCEOWB
Under this project, we have two module(CA_MBTSOURCE, CA_MBTTARGET).
In connection explorer, the locations are CA_DW_MBT_SR, CA_DW_MBT_TR.
Source schema name is CA_TXMBT_DW
Target schema name is CA_MBTTX_DW
Here are my steps i followed.
===============================
1. Created the source and target schemas in new machine.
2. Create a new workspace
3. Export the mapping with dependent objects from source server and imported in new server.
4. changed the source and target location successfully.
5. Renamed the project namd, module names as i needed successfully.
But only issue is, i am not table to change the location name.
Again, i tried the below steps.
1. uninstall the workspace and create the workspace
2. create source and target locations as i needed(CA_DW_MBT_SR,CA_DW_MBT_TR).
3. import only mapping
4. Able to register the mapping
Here i am not able to configure the module for newly created locations.
I right clicked on module and click Configure, go to Stream Administrator and not able to find
the source and target locations over there.....
How do we resolve this?
My data warehouse is runing for each state. I want to copy one state mapping and import into
another state and customize the mapping. I have hard time to change the location name. Because,
location name has state code. I can not use the same location name for all other state.
Any help is highly appreciated.

The replay answer
Advertisement
Hello Oleg, Thanks for your input.. It helps... but the problem is not completly solved.
let me explain my whole steps. Plesae review and let me know if i missed anything.
1. Created new workspace. the workspace is successfully created.
2. Login to new workspace.
3. Go to Locations, create source location(entered host name,username, password etc)
4. Created target location(entered host name,username, password etc), go to db connector on target location, created new db connector and linked the source location here.
5. Exported mapping and import into new workspace.(I can not use the location name in the exported workspace).
6. Renamed the project name, module name as i needed.
7. Double click the module name under Oracle and changed the meta data location and data locations.
8. Right click on soure and target module and click configure, change the the location and streams administrator.
9. Right click on mapping and go to configure, go to table operators and change the location as i need.
10.Right click on target module(under oracle), click generate. On this step, i get the below error
VLD-1141: Internal error during mapping generation.
Java.lang.ArrayIndexOutOfBoundsExeception
11. Go to control center, register the source and targert and followed the step 10. I get the same error.
I am almost close to complete this task. But i got stuck in the last step.

Go to See the other 6 answers

How do we migrate the OWB mapping from one server to another server?

Category:DefaultRelease time:2015-10-11Views:130

Here is my situation. Source server ================ Project name : SOURCEOWB Under this project, we have two module(MBTSOURCE, MBTTARGET). In connection explorer, the locations are DW_MBT_SR, DW_MBT_TR. We have 15 mappings on this project. Source sc[More]

Migrating CMP EJB mapped to SQL Server table with identity column from WL

Category:DefaultRelease time:-0001-11-30Views:130

Hi,     I want to migrate an application from Weblogic to SAP Netweaver 2004s (7.0). We had successfully migrated this application to an earlier version of Netweaver. I have a number of CMP EJBs which are mapped to SQL Server tables with the PK as id[More]

How to use OMB to change filter conditions in OWB maps

Category:DefaultRelease time:-0001-11-30Views:130

Hi, I want to know how we can use OMB to change filter conditions in an OWB map. As per my scenario i have a filter operator FLTR_1 in my maps and i have to change its filter condition from INOUTGRP1.ID IN (1,2) AND INOUTGRP1.VALUE > CONST_0_MAX_VAL[More]

OWB 9.0.3 migration to OWB 10G R2

Category:DefaultRelease time:-0001-11-30Views:130

Hi All, I am in the process of doing the Migration of OWB 9.0.3 migration to OWB 10G R2, I am doing it for the first time. is there any manual or can any one help me with the steps to achieve the migration. thanks.Hi there. I am currently going from[More]

Problem in OWB map for source change capture

Category:DefaultRelease time:2015-10-11Views:130

The problem is as follows:- Our OWB map between two different databases, captures change in data at source and populates them in target. It is a one to one map. The map is failing to process some rows from source database though it gives no:of errors[More]

Case statement in OWB mapping

Category:DefaultRelease time:2015-10-11Views:130

I am trying to use a case statement in an OWB mapping. I am attempting to use it in expression builder within a filter object. Each time I try to validate the expression in the expression builder I get an error: Line 4, Col 6: PL/SQL: ORA-00920: inva[More]

Array of Parameters in OWB mapping

Category:DefaultRelease time:2015-10-11Views:130

How do i pass an array of parameters to an OWB mapping.Try this and similarly you can get all operator. OMBRETRIEVE MAPPING 'MAP_NAME' GET TABLE OPERATORS OMBRETRIEVE MAPPING 'MAP_NAME' GET VIEW OPERATORS OMBRETRIEVE MAPPING 'MAP_NAME' GET TRANSFORMA[More]

Call a shell script from a OWB Mapping or Process Flow

Category:DefaultRelease time:2015-10-11Views:130

Hi, is it possible to call a shell script from a owb mapping or Process Flow and how can i do this? GreetingsCheck this :- http://blogs.oracle.com/warehousebuilder/2010/05/how_to_use_user_defined_activity_in_owb_process_flow.html Cheers NawneetRead o[More]

How to Execute a OWB Mapping or a Process from SQLPLUS editor?

Category:DefaultRelease time:2015-10-11Views:130

I need to know how can we execute a OWB mapping from SQLPLUS editor or from a Stored Procedure.Hi, You can use the MDL export/import utility for this, but as you are importing into the same repository you will end up with importing into the same proj[More]

Transformations not occuring properly using PIVOT operator in OWB mapping.

Category:DefaultRelease time:2015-10-11Views:130

Hi , In our project we have a OWB Map UII_D_MAP_SPC_CUST_FAULT_NATTR which is used to populate UII_CUSTOMER_FAULT table in our target side. The source table which populate UII_CUSTOMER_FAULT is SR_S_TABLE_N_ATTRIBUTEVALUE (a materialized view in anot[More]

SQL Query of an OWB map (row based)

Category:DefaultRelease time:-0001-11-30Views:130

If I trace a session, execute an OWB map (row based), will the trace file contain the actual SQL query ? The problem with me is that when I am executing this row -based OWB map, it is throwing me an error CursorFetchMapTerminationRTV20007 BUT ( plus[More]

Hot
Hi, When I use Vbo3 t-code and enter a rebate number and drill down to Sales volume of rebate management and hit SCOPE button and emty the content I get a list with Invoice numbers. I looked in KONA table it is header and how do we retriev data of th [More]
Same problem with hp envy laptop and no success with repaird laptop, all the time same problem motherboard melt up. I use all the time notebook cooler and laptop breaths more than it needs but it doest work normaly. Temps are wiht cooler bad normally [More]
hi, first of all thanks to everybody for providing solns at time. i went thru the doc it is not clear for me as i am very beginner to oracle. so oracle experts & professionals plz guide me. i am trying to install oracle 9i, std edition, general purpo [More]
My computer is Macbook pro mid 2010, i can use the airplay only from iTunes, is there any chance i can use airplay from my screen to apple TV by adding parts or driver? ThanksI believe you have to have the 2012 model or newer.Read other 2 answers [More]
iPhoNettie wrote:Apple Genius-tried syncing thru ethernet cable I need to know if this is possible with ethernet cable only between ATV/MacPro vs Airport wireless. I've spent hours with this 32gb ATV to just load and it's been nothing but long hours. [More]
The W530 speakers are the worst speakers I've ever seen in any laptop.  I purchased the W530, and although everything else is great, the speakers are absolutely worthless. And no, calling it a business laptop doesn't justify not installing good speak [More]
what is the difference  between PO's and invoices. pls help me. thanks in advance.here is info from help.sap glossary.. purchase order (MM-PUR)  Purchasing (MM-PUR) A request or instruction from a purchasing organization to a vendor (external supplie [More]
Dear All, I would be grateful if you wouldhelp me answer for my issue. I use AFD for investment and equity. Goodwill only has extraamortization method in the setting for Consolidation of Investment. When I perform task balance forward in a new year, [More]
Hi, I am new to UPK, when I am in UPK Developer and I select a topic, the preview menu item (under File) and in the tool bar is disabled. Any ideas on how I can preview a topic. ThanksHi, In order to preview, you will need to open the hierarchial vie [More]
Hi everyone, First of all, this is my first time writing here. Nevertheless, my knowledge about Java is not vast but still it helps me somehow. My problem is, I am writing a program that has a JFrame with a JPanel added to it and I need to draw a vis [More]