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
Dear Gurus.,             There is a requirement from my client that is similar to this report s_alr_87012277 . They want all G/L Account opening balances,Issue value,Reciept value and Closing balance for a particular period . I debugged the report to [More]
Hi all, I am new to Java programming and trying to figure out some issues with a class This is the problem I am trying to solve 1. I am trying to parse a xml and represent it in a JTable 2. I have parsed the xml and stored it in vector of vector form [More]
''locking this thread as duplicate, please continue at [https://support.mozilla.org/en-US/questions/1051908 /questions/1051908]'' one of my 2 address books can no longer be viewed, how do I access it? It disappeared within the last few days. I can st [More]
I am getting this error when I try to install iTunes: "iTunes could not be installed because Visual Basic Script (VBScript) is not installed or has been disabled. Make sure VBScript is installed, turn off script blocking in anti-virus and personal fi [More]
BB newbie and have new Tour - how do I dial # at the end of phone number or within a call? I have tried alt Q and finding a show-keyboard option - and have not had success - Thanks! Solved! Go to Solution.Cool! I'm glad you have it fixed. Please reso [More]
I would like to create an epub from a pages document for viewing on the iPod Touch, iPhone, and iPad. Here is my problem. I have made a whole book, and the whole thing has floating objects, and the epub format doesn't support floating objects, so how [More]
Hi,   I have a sequence of 4 operations among which last operation is milestone and all other three operations are confirmed automatically when 4 th operation is confirmed. But I have removed the default proposal of activity hours in the confirmation [More]
I have a table like this desc work_table2 WORK_TABLE2_ID NOT NULL NUMBER APPLICATION_ID NUMBER APPLICATION_VERSION NUMBER JOB_ID NUMBER CUSTOMER_ID NUMBER ATTRIBUTE_ID NUMBER TEMPLATE_ID NUMBER DISTRICT_ID NUMBER SCHOOL_OID VARCHAR2(32) PERSON_OID VA [More]
hi, i have installed the webas ABAP 6.40 system now when i am going for the transaction se80 i am getting the error : "C:\perforce\bas\620_COR\src\fes\few\sapfewin\guifunctionality.xml  contains an invalid path " can you please suggest me how to [More]
I have no visable open cards, I have no access to apps because I have too many open cards, I have nothing but 5 icons on my phone front screen,  the green phone the envelope the contacts calendar and a black arrow that opens applications, there is no [More]