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 everyone, I'm new to this community, my name is Flavio, from Argentina. I'm on a Mac Book Pro Intel Core Duo 2, using Final Cut 7 and I'm using a customized keyboard layout (1 for zoom in, 2 for zoom out), but everytime I launch the application I [More]
This is probably to do with my enviroment having a problem but when I try to compilee ShowMethods.java from Chapter 10 of thinking in Jave (code below after error messages) I get the following error:- ShowMethods.java:23: cannot access Class bad clas [More]
I have a 32bit Oracle client installed on Solarus 8 server. Have DSN defined to passthrough to backend oracle database. When I try to select from the backend database I get the following 5102 error 5102: Cannot load backend library 'libclntsh.so' for [More]
I programmed an application, using QMH template in LV and made a build out of it. The build has the "main.vi" and it is always included. But, after build is complete, the application starts by clicking on my apllication.exe and immediately termi [More]
so i checked my online banking and i have charges from 'APPLE/ITUNES PURCHASES LU' however i havnt purchased anything and it dont show up in purchase history? any ideas about this until i can contact apple protection on mondayHello Jamieh89, Payment [More]
I just upgraded to Lion on my MacBook Pro. I burned a dvd from a torrent through the Mac's own disk utility. I didn't see anywhere that it finalized it. It did say it verified it. Is this the same thing? I am trying to play this dvd with is DVD+R on [More]
Hi, After ORACLE 11G software installation i tried to change the ORACLE_HOME directory. OS : RHEL 4.5 DB : 11.2.0 Previous Home Location : [[email protected] ~]$ echo $ORACLE_HOME /u01/oracle/prod/tech_st/product/11.2.0/db_1 Current Home Loc: [[email protected] [More]
I am looking for a way of linking two JScrollBar types together. So that if one JScrollBar is moved the corresponding movement in the other follows suit. Example: There is a JFrame with two JScrollPanes side by side acting as a viewport to their resp [More]
I'm looking a thumbnail preview of a .psd file in Bridge. When I try to open it in Photoshop, it says that it can't open because "it is not a valid photoshop file." What's the problem?The preview may be readable, but the full file not readable. [More]
Dear all first all thank you for your attention, I' ve to build a procedure to manage automatic back up cause actually in my company there is no back up policy or tool..and utility i've lot of laptop user..that travel..and lotus notes (mean local rep [More]