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
I got married, changed my Facebook name and gave my account a new password. Now, under settings and Facebook they have my ITunes/Apple ID and under it says "please sign in using (my old Facebook name) and under that is password. Only that old Faceboo [More]
Hi I have restored(F11) my laptop to out-of-box factory restore, after fresh installation laptop got rebooted . After entering the system name, location, date.. etc. Before the desktop is loading for the first time i got the error, ' To run this appl [More]
Hi, How can I settle the Final Balance of a Vendor in SAP against the Down Payment Made under a PO Based Invoice. For Eg. - I have raised a PO of $10000.00 and made a Down Payment Request and Posted it through the APP for $ 300.00 the final balance u [More]
Hello all, I am not having much luck with our first test upgrade. Already once I have scratched and started again. The first time through, I was able to get past the eu_import1 phase (I think by patching SAPUP). This time it seems futile.  Here is th [More]
Yesterday I was using ITunes just fine on my school computer.  Today when I turned it on and clicked on Itunes it pulled up a apple mini player.  I X it out and tried again from the program list.  It pulled up the apple player again, no itunes.  Wher [More]
Dear experts, For the pipeline management in USA I inserted the tax code U1 on the inforecord. During the automatic consumption from Process order confirmation (Movement 261 P) the system calculates the cost without tax amount. For example Eletricity [More]
Hi All, I extracting the data from ECC table and loading it in ORACLE table SAP BODS tool. While starting the extract itself i am getting the error like below, 6628 8592 SYS-170101 24-Apr-15 9:41:20 PM System Exception <ACCESS_VIOLATION> occurred. P [More]
How to covert final web program to post on adobe exchange program for viewing.  This is for the class.Hi You can publish your website on business catalyst as trial site and then you can share the url with anyone, it will work like your site is online [More]
Using Photoshop CS6 with Camera Raw 8.3 and still can't open NEF from Nikon D600. The files can be opened in Nikon Capture so they are not corrupt. There's no later Camera Raw to update to. Anyone with a solution?Are you downloading images with an ol [More]
Hi, I'm very new with EIS and created a sample meta outline. Everytime I add a member name below a Dimension in the meta outline, EIS does not allow me to check "Move Members" in the "Duplicate Member Name" area from the Outline Build [More]