Current Position:Home > Error While Importing Process Flow in OWB Repository.

Error While Importing Process Flow in OWB Repository.

Update:10-11Source: network consolidation
Advertisement
Hi All,
OWB Config Details is as follows:
Oracle 9i Warehouse Builder Client: 9.2.0.2.8
Oracle 9i Warehouse Builder Repository: 9.2.0.2.0
Following Error Message is displayed when i tried to import process flow from one OWB Repositoty to another OWB Repository.
Warning at line 23: MDL1312: Referenced logical location with name <PF_STG_INC_LOC> and UOID <F3940F1D5EB84985E0340003BA0AF737> not found for PROCESSMODULE <SALES_INC>. Logical location not set for this module.
Warning at line 28: MDL1320: PROCESS PF_C_C_CALLS_INC in STG_INC.SALES_INC.SAL_INC cannot be imported because referenced STANDALONEPROCEDURE
FLSTG.PROC_GET_ETL_DATA_DATE does not exist.
Warning at line 28: MDL1320: PROCESS PF_STG_CALL_CENTER_CALLS_INC in FLSTG_INC.SALES_INC.SAL_INC cannot be imported because referenced STANDALONEPROCEDURE
FL_TRG_FLSTG.PROC_UPDATE_RECO_CTL does not exist.
Informational: MDL1134: COMMIT issued at end of import data file.

The Best Answer

Advertisement
Hello, all the errors you've been given are related to missing objects.
You should re-create/import the location for you process flows before importing the process flows themselves.
Also verify that you have imported the procedures FLSTG.PROC_GET_ETL_DATA_DATE and FL_TRG_FLSTG.PROC_UPDATE_RECO_CTL because you use them in your process flows so you need them: OWB refuses to import a process flows if some objects are missing because it would break some links.
In general process flows should be imported where you have all the other objects in the repository because they are the final step and they reference many other objects.
Hope this helps - Antonio
  • Error While Importing Process Flow in OWB Repository. Update:10-11

    Hi All, OWB Config Details is as follows: Oracle 9i Warehouse Builder Client: 9.2.0.2.8 Oracle 9i Warehouse Builder Repository: 9.2.0.2.0 Following Error Message is displayed when i tried to import process flow from one OWB Repositoty to another OWB

  • Error While Improting Process Flow in OWB Repository. Update:10-11

    Hi All, OWB Config Details is as follows: Oracle 9i Warehouse Builder Client: 9.2.0.2.8 Oracle 9i Warehouse Builder Repository: 9.2.0.2.0 Following Error Message is displayed when i tried to import process flow from one OWB Repositoty to another OWB

  • Error while importing process flow mdls in OWB 11.2.0.3 Update:10-11

    Hi All, I am facing below error while importing process flow mdls in OWB 11.2.0.3:   ERROR   Informational: MDL1328: PROJECT MTH not imported since the object in MDL file   is the same as the object in the workspace.   Error at line 11: MDL1261: Erro

  • Error in deploying Process flow in OWB 10.2 Update:10-11

    I have migrated process flow from OWB 9.2 to OWB 10.2,but when i try to deploy the process flow i get the following error. oracle.wh.service.sdk.runtime.QueryException: null - Internal Error Unknown System Parameter MODULE_NAME for executionAdapterId

  • Error while creating Process flows in OWB 11gR2 Update:10-11

    Hi I have never faced this before and thats why it baffles me. I am trying to create a new process flow module which has already been configured to the OWF_LOCATION(Oracle workflow location). I get Java exception error window with long list of detail

  • Error while deploying process flow Update:10-11

    hi All, i am getting below error while deploying 1 process flow. Description : Runtime User : OWBPC Started : 2011-06-02 19:18:06.0 Name Action Status Log None Error ORA-00942: table or view does not exist None Error RPE-02053: The Oracle Workflow ve