12 Replies Latest reply: Apr 6, 2011 12:43 AM by 775861 RSS

    Process flow does not exist in OCDM_Intra_ETL.mdl ocdm 11.2.3 on lunux x86

    User805674-Oracle
      Hi,

      Process flow does not exist in OCDM_Intra_ETL.mdl file.

      I am trying to install ocdm, and I am stuck with OWB process flow import.
      - I installed and configured OWB workflow into OWF_MGR schema
      - After I want to import process flow from OCDM_Intra_ETL.mdl file, it doesn't exist there.

      Anyone can help!!???

      During the ocdm installation following object were created:

      PROJECT: OCDM_INTRA_ETL

      Object Types Added Replaced Skipped Deleted
      ----------------------------------------- ----- -------- ------- -------
      ATTRIBUTE: 24846 0 0 0
      COLUMN: 4259 0 0 0
      CONFIGURATION: 1 0 0 0
      DEPLOYMENT: 1 0 0 0
      FOREIGN_KEY: 790 0 0 0
      FUNCTION: 3 0 0 0
      GROUP: 1478 0 0 0
      INDEX: 742 0 0 0
      MAPPING: 42 0 0 0
      MATERIALIZED_VIEW: 1 0 0 0
      MODULE: 1 0 0 0
      OPERATOR: 826 0 0 0
      PACKAGE: 2 0 0 0
      PARAMETER: 13 0 0 0
      PARTITION: 6017 0 0 0
      PARTITION_KEY: 75 0 0 0
      PHYSICAL_MAP: 42 0 0 0
      PHYSICAL_OBJECT: 144 0 0 0
      PLATFORM_CONFIGURATION: 1 0 0 0
      PROJECT: 1 0 0 0
      TABLE: 142 0 0 0
      UNIQUE_KEY: 175 0 0 0

      Internal Objects Added Replaced Skipped Deleted
      ----------------------------------------- ----- -------- ------- -------
      DIAGRAM: 98 0 0 0
      DIAGRAMNODE: 2240 0 0 0
      ITEMSETUSAGE: 2068 0 0 0
      LOCATIONUSAGE: 2 0 0 0
      PUREPHYSICALOBJECT: 1416 0 0 0
      REFERENCEPROPERTYVALUE: 128 0 6506 0
      STRINGPROPERTYVALUE: 40979 0 19046 0



      Import ended at 03/09/2011 15:23:47 CET
        • 1. Re: Process flow does not exist in OCDM_Intra_ETL.mdl ocdm 11.2.3 on lunux x86
          750089
          Hi,
          During the ocdm installation, Process flow does not exist in OCDM_Intra_ETL.mdl file.

          Thanks,
          Esther
          • 2. Re: Process flow does not exist in OCDM_Intra_ETL.mdl ocdm 11.2.3 on lunux x86
            User805674-Oracle
            Hi Esther,

            Thank you for your reply. Since ocdm documentation is reffering to INTRA_ETL_FLW OWB workflow, where can I found it?

            Regards,

            Sasa
            • 3. Re: Process flow does not exist in OCDM_Intra_ETL.mdl ocdm 11.2.3 on lunux x86
              750089
              Hi Sasa,
              Actually Process Flow exists in OCDM_Intra_ETL.mdl ocdm 11.2.3.
              You need to follow this steps
              1.configuring the owb workflow.
              2.registering OWF_MGR schema in security in global explorer.

              Thanks
              Esther
              • 4. Re: Process flow does not exist in OCDM_Intra_ETL.mdl ocdm 11.2.3 on lunux x86
                User805674-Oracle
                Hi Esther,

                I am running Oracle DB 11.2 on Oracle Linux 5.4 on 32 bits, and I downloaded ocdm for linux 32 bits.

                1. I instaled and configured OWB workflow as per instruction
                SQL> select count(*) from dba_tables where owner='OWF_MGR';

                COUNT(*)
                ----------
                191
                2. I registerd OWF_MGR using repository assistant

                3. Additionally I upgrade database and OWB repository to 11.2.2 version
                4. Plus, I installed interim patches on top on 11.2.2 database (patches have some conenction with problems with OWB workflow):
                10247079 and 10185523

                5. When I am trying to open OCDM_Intra_ETL.mdl only following object exists:
                - Locations -> Oracle Database Locations -> OCDM_SYS_LOCATION
                - Projects -> OCDM_INTRA_ETL -> Configurations -> DEFAULT_CONFIGURATION
                - Projects -> OCDM_INTRA_ETL -> OCDM_INTRA_ETL -> (Mappings,Materialized Views, Packages, Tables)

                Process flow does not exist.

                6. Also, I am importing some different mdl file, and could import process flow without any problem.

                If you could provide access to your OCDM_Intra_ETL.mdl it will be perfect.

                Regards,

                Sasa
                • 5. Re: Process flow does not exist in OCDM_Intra_ETL.mdl ocdm 11.2.3 on lunux x86
                  750089
                  Hi Sasa,
                  Check whether you have followed the below steps.
                  1.First you need to Configure the WorkFlow.
                  2.Then register the user 'OWF_MGR' in Securities.
                  3.Then import the mdl file by choosing the below options
                  a) Replace the existing object
                  b) MATCH BY NAME
                  4.Then you can see Process Flow.
                  No need of patch upgradation.

                  Regards
                  Esther

                  Edited by: user9071835 on Mar 17, 2011 2:41 AM
                  • 6. Re: Process flow does not exist in OCDM_Intra_ETL.mdl ocdm 11.2.3 on lunux x86
                    User805674-Oracle
                    HI Esther,

                    Still do not have success. Following is the log file.

                    Regards,

                    Sasa



                    Import started at 03/17/2011 12:24:16 CET

                    Importing into workspace OCDMWORKSPACE

                    Project "PUBLIC_PROJECT"
                    Oracle Database Location "OCDM_SYS_LOCATION"
                    Project "OCDM_INTRA_ETL"
                    Configuration "DEFAULT_CONFIGURATION"
                    Location Specific Configuration "DEFAULT_DEPLOYMENT"
                    Platform Configuration "ORACLE"
                    Object Configuration "DEFAULT_CONFIGURATION"
                    PhysicalMap "DEFAULT_CONFIGURATION"
                    PhysicalMap "MAPPING_1"
                    Oracle "OCDM_INTRA_ETL"
                    Table "DWB_ACCS_MTHD_STAT_HIST"
                    Table "DWB_ACCT_BAL_ADJ"
                    Table "DWB_ACCT_BAL_HIST"
                    Table "DWB_ACCT_COST"
                    Table "DWB_ACCT_CRDT_LMT"
                    Table "DWB_ACCT_PYMT"
                    Table "DWB_ACCT_PYMT_MTHD_STAT"
                    Table "DWB_ACCT_RFND"
                    Table "DWB_ACCT_STAT_HIST"
                    Table "DWB_BSNS_UNIT_COST"
                    Table "DWB_CNRT_STAT"
                    Table "DWB_CNRT_TERM_VAL"
                    Table "DWB_CUST_COST"
                    Table "DWB_CUST_ORDR"
                    Table "DWB_CUST_ORDR_LN_ITEM"
                    Table "DWB_CUST_ORDR_PYMT"
                    Table "DWB_DEBT_COLLCTN"
                    Table "DWB_DEBT_COLLCTN_ASGN"
                    Table "DWB_EVT"
                    Table "DWB_EVT_ACCS_MTHD_ACTVTY"
                    Table "DWB_EVT_ACCT"
                    Table "DWB_EVT_ASGN"
                    Table "DWB_EVT_EQPMNT_INSTNC"
                    Table "DWB_EVT_GFT_RDMPTN"
                    Table "DWB_EVT_LYLTY_PROG"
                    Table "DWB_EVT_LYLTY_PROG_ACMLTN"
                    Table "DWB_EVT_LYLTY_PROG_RDMPTN"
                    Table "DWB_EVT_PRTY_ASGN"
                    Table "DWB_EVT_PRTY_INTRACN"
                    Table "DWB_EVT_PRTY_INTRACN_CALL"
                    Table "DWB_EVT_PRTY_INTRACN_VST"
                    Table "DWB_INVC"
                    Table "DWB_INVC_ADJ"
                    Table "DWB_INVC_ITEM"
                    Table "DWB_INVC_PYMT_ASGN"
                    Table "DWB_LYLTY_PROG_PTS_BAL"
                    Table "DWB_MNT_ALLWNC"
                    Table "DWB_NTWK_EVT"
                    Table "DWB_PROD_COST"
                    Table "DWB_PRPD_RCHRG"
                    Table "DWB_PRTY_INTRACN_THRD"
                    Table "DWB_PRTY_ORDR_ASGN"
                    Table "DWB_SL_CMISN_DTL"
                    Table "DWB_WRLS_CALL_EVT"
                    Table "DWC_OLAP_ETL_PARAMETER"
                    Table "DWD_ACCT_DEBT_DAY"
                    Table "DWD_ACCT_PYMT_DAY"
                    Table "DWD_ACCT_PYMT_MTHD_STAT_HIST"
                    Table "DWD_ACCT_RFND_DAY"
                    Table "DWD_ACCT_STAT"
                    Table "DWD_ACCT_STTSTC"
                    Table "DWD_ARPU_BASE"
                    Table "DWD_CALL_CNTR_CALL_DAY"
                    Table "DWD_CALL_CNTR_CASE_DAY"
                    Table "DWD_CANBLZTN_DTL_DAY"
                    Table "DWD_CMISN_DAY"
                    Table "DWD_CNCT_DSCNCT_DAY"
                    Table "DWD_CNRT"
                    Table "DWD_CNRT_CHNG"
                    Table "DWD_COST_CUST"
                    Table "DWD_COST_ORG"
                    Table "DWD_CRDT_CTGRY"
                    Table "DWD_CUST_DEBT_COLLCTN"
                    Table "DWD_EXTRNL_DEBT_COLLCTN_DAY"
                    Table "DWD_GIVE_AWAY_ITEM_DAY"
                    Table "DWD_HNDST_SUBSDY_DAY"
                    Table "DWD_INTRNL_DEBT_COLLCTN_DAY"
                    Table "DWD_INVC"
                    Table "DWD_INVC_ADJ"
                    Table "DWD_LN_ACTVTN_TMNT_DAY"
                    Table "DWD_LYLTY_PROG_DAY"
                    Table "DWD_MKT_SHARE"
                    Table "DWD_PRPD_ACCT_STTSTC"
                    Table "DWD_PRPD_ALWNCE_DAY"
                    Table "DWD_PRPD_CALL_SUMM_DAY"
                    Table "DWD_PYMT_AGNG_DAY"
                    Table "DWD_RDMPTN_DAY"
                    Table "DWD_SBCRBR_CHRN_STTSTC"
                    Table "DWD_SHARED_PKG_USG_STTSTC_DAY"
                    Table "DWD_SHOP_EFFNCY_DAY"
                    Table "DWD_SL_DAY"
                    Table "DWD_SL_RPRSTV_STTSTC"
                    Table "DWD_SPLMNTR_SRVC_USG"
                    Table "DWD_SUBSDY_AMT"
                    Table "DWD_VAS_SBRP_QCK_SUMM"
                    Table "DWL_AGE_BND"
                    Table "DWL_AGE_ON_NET_BND"
                    Table "DWL_ARPU_BND"
                    Table "DWL_CHRN_RSN"
                    Table "DWL_CNRT_ASGN_RSN"
                    Table "DWL_CNRT_ASGN_TYP"
                    Table "DWL_CUST_RVN_BND"
                    Table "DWL_DEBT_AGNG_BND"
                    Table "DWL_EVT_RSLT"
                    Table "DWL_EVT_TYP"
                    Table "DWL_INTRACN_RSN"
                    Table "DWL_PK_OFPK_TIME"
                    Table "DWL_RECHRG_RVN_SLB"
                    Table "DWR_ACCS_MTHD"
                    Table "DWR_ACCS_MTHD_SBRP_ASGN"
                    Table "DWR_ACCT"
                    Table "DWR_ACCT_PREF_PYMT_MTHD"
                    Table "DWR_ADDR_LOC"
                    Table "DWR_BSNS_MO"
                    Table "DWR_CALL_SRC_DSTN"
                    Table "DWR_CHNL"
                    Table "DWR_CLNDR_MO"
                    Table "DWR_CMPGN"
                    Table "DWR_CNRT"
                    Table "DWR_CNRT_ASGN"
                    Table "DWR_CUST"
                    Table "DWR_DAY"
                    Table "DWR_EMP"
                    Table "DWR_EQPMNT_INSTNC"
                    Table "DWR_EVT_LOC"
                    Table "DWR_EVT_PRTY_RL"
                    Table "DWR_HNDST_INSTNC"
                    Table "DWR_HNDST_MDL"
                    Table "DWR_INTRACN_CHNL"
                    Table "DWR_ITEM"
                    Table "DWR_LYLTY_PROG_CHNL"
                    Table "DWR_NTWK"
                    Table "DWR_ORG_BSNS_UNIT"
                    Table "DWR_ORG_ITEM_SLNG_PRICE"
                    Table "DWR_PRMTN"
                    Table "DWR_PROD"
                    Table "DWR_PROD_CAPBLTY"
                    Table "DWR_PROD_CAPBLTY_VAL"
                    Table "DWR_PROD_MKT_PLN"
                    Table "DWR_PROD_MKT_PLN_ASGN"
                    Table "DWR_PROD_RTNG_PLN_DTL"
                    Table "DWR_PRTY"
                    Table "DWR_PRTY_ASGN"
                    Table "DWR_PRTY_LYLTY_PROG_PRTCPTN"
                    Table "DWR_PYMT_CHNL"
                    Table "DWR_SBRP"
                    Table "DWR_SBRP_ASGN"
                    Table "DWR_SL_CHNL"
                    Table "DWR_SL_CHNL_RPRSTV"
                    Table "DWR_SL_CMISN_PLN_DTL"
                    Table "DWR_SPLMNTR_SRVC"
                    Table "DWR_TIME_SLT"
                    Materialized View "DWV_CNRT_ACCT_SBRP_PROD"
                    Package "PKG_INTRA_ETL_UTIL"
                    Function "GET_END_DATE"
                    Function "GET_START_DATE"
                    Package "PKG_OCDM_OLAP_ETL_AW_LOAD"
                    Function "OLAP_ETL_AW_BUILD"
                    Mapping "DWD_ACCT_DEBT_DAY__MAP"

                    Import ended at 03/17/2011 12:26:20 CET

                    Log File output to /u01/app/oracle/product/11.2.0/db_1/ocdm/pdm/relational/intra_etl/owb/OCDM_Intra_ETL_imp5.log

                    Total import time (hh:mm:ss): 00:02:04

                    Error occurred importing from file "/u01/app/oracle/product/11.2.0/db_1/ocdm/pdm/relational/intra_etl/owb/OCDM_Intra_ETL.mdl".
                    Error at line 85,360: MDL1261: Error importing MAPPING OCDM_INTRA_ETL.OCDM_INTRA_ETL.DWD_ACCT_DEBT_DAY__MAP.

                    Detailed Error Message:
                    Matching conflicts on CMPDiagramNode@584be/id=361662/owningFCO=359957/proxyFor=(CMPDiagramNodeGen@17eae1c/id=361662/stname=null/pname=DWR_DAY/lname=DWR_DAY/status=CLEAN/committed=true/persistent=true/propsLoaded=false) on key DWR_DAY
                    • 7. Re: Process flow does not exist in OCDM_Intra_ETL.mdl ocdm 11.2.3 on lunux x86
                      User805674-Oracle
                      HI Esther,

                      Are we talking about the same OCDM_Intra_ETL.mdl file? Information about my file, before I will take any action.
                      Also, there are no object such as:
                      PROCESS_FLOW
                      PROCESS_FLOW_MODULE
                      PROCESS_FLOW_PACKAGE
                      I have in other mdl files!

                      Regards,

                      Sasa

                      ------------------------------------------------
                      File created: 08/19/2010 18:27:28 PDT
                      Exported by: OWB_OWNER
                      Connection: stbde18.us.oracle.com:1524:ocdm
                      OWB client: 11.2.0.1

                      Statistics:
                      Projects - 2
                      PUBLIC_PROJECT: 19
                      LOCATION: 1
                      Internal Objects: 18
                      STRINGPROPERTYVALUE: 18

                      OCDM_INTRA_ETL: 112084
                      ATTRIBUTE: 24846
                      COLUMN: 4259
                      CONFIGURATION: 1
                      DEPLOYMENT: 1
                      FOREIGN_KEY: 790
                      FUNCTION: 3
                      GROUP: 1478
                      INDEX: 742
                      MAPPING: 42
                      MATERIALIZED_VIEW: 1
                      MODULE: 1
                      OPERATOR: 826
                      PACKAGE: 2
                      PARAMETER: 13
                      PARTITION: 6017
                      PARTITION_KEY: 75
                      PHYSICAL_MAP: 42
                      PHYSICAL_OBJECT: 144
                      PLATFORM_CONFIGURATION:1
                      TABLE: 142
                      UNIQUE_KEY: 175
                      Internal objects: 72483
                      • 8. Re: Process flow does not exist in OCDM_Intra_ETL.mdl ocdm 11.2.3 on lunux x86
                        677461
                        Hi Esther and Sasa,

                        i have the same problem. There are no process flows.

                        I have the same file:
                        http://img.ba/svpi

                        I sucessfuly import the file:
                        http://img.ba/gyw9

                        Afther it there are no flows:
                        http://img.ba/9uxs

                        BR,
                        Alen Ruvic

                        Edited by: user10067954 on Mar 18, 2011 2:41 AM

                        Edited by: user10067954 on Mar 18, 2011 2:42 AM
                        • 9. Re: Process flow does not exist in OCDM_Intra_ETL.mdl ocdm 11.2.3 on lunux x86
                          750089
                          Hi Sasa and Alen Ruvic,
                          We have cross checked from our side and Process Flow exists in OCDM_Intra_ETL.mdl ocdm 11.2.3.
                          Below is the log file after importing the mdl file.

                          ********************************************************************************
                          * Oracle Warehouse Builder Import Log File
                          * Created: 03/25/2011 13:56:28 IST
                          *
                          * OWB Release: 11.2.0.1.0 OWB Repository Version: 11.2.0.1.0 MDL Release: 11.2
                          * User: master Connect String: (DESCRIPTION=(ADDRESS=(HOST=localhost)(PROTOCOL=tcp)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=db11g)))
                          *
                          * Data File: C:\Documents and Settings\Genex\Desktop\Intra_ETL_11.2.3\OCDM_Intra_ETL.mdl
                          * Log File: C:\Documents and Settings\Genex\Desktop\Intra_ETL_11.2.3\OCDM_Intra_ETL_imp.log Log Message Level: ALL
                          *
                          * Character Set: UTF8
                          * Mode: CREATE Ignore Universal Identifier: N
                          ********************************************************************************

                          Import started at 03/25/2011 13:56:28 IST


                          Importing into workspace MYSPACE

                          Informational at line 83: MDL1205: LOCATION with Unique Object ID (UOID) <72B9E4E65B33912CE0404498F7C40C23> already exists, so LOCATION with name <OWF_LOCATION> not imported.
                          Informational: MDL1134: COMMIT issued at end of import data file.

                          Statistics
                          ----------

                          Total Projects Imported: 2

                          ***********************************************
                          PROJECT: PUBLIC_PROJECT

                          Object Types Added Replaced Skipped Deleted
                          ----------------------------------------- ----- -------- ------- -------
                          LOCATION: 2 0 1 0
                          PROJECT: 0 0 1 0

                          Internal Objects Added Replaced Skipped Deleted
                          ----------------------------------------- ----- -------- ------- -------
                          STRINGPROPERTYVALUE: 34 0 18 0

                          ***********************************************
                          PROJECT: OCDM_INTRA_ETL

                          Object Types Added Replaced Skipped Deleted
                          ----------------------------------------- ----- -------- ------- -------
                          ACTIVITY: 196 0 0 0
                          ATTRIBUTE: 25922 0 0 0
                          COLUMN: 5283 0 0 0
                          CONFIGURATION: 1 0 0 0
                          DEPLOYMENT: 1 0 0 0
                          FOREIGN_KEY: 1017 0 0 0
                          FUNCTION: 43 0 0 0
                          FUNCTION_PARALLEL: 1 0 0 0
                          GROUP: 1525 0 0 0
                          INDEX: 971 0 0 0
                          MAPPING: 43 0 0 0
                          MATERIALIZED_VIEW: 1 0 0 0
                          MODULE: 2 0 0 0
                          OBJECT_TYPE_ATTRIBUTE: 6 0 0 0
                          OPERATOR: 852 0 0 0
                          PACKAGE: 6 0 0 0
                          PARAMETER: 98 0 0 0
                          PARTITION: 7350 0 0 0
                          PARTITION_KEY: 100 0 0 0
                          PHYSICAL_MAP: 43 0 0 0
                          PHYSICAL_OBJECT: 186 0 0 0
                          PLATFORM_CONFIGURATION: 3 0 0 0
                          PLSQL_RECORD_TYPE: 1 0 0 0
                          PLSQL_TABLE_TYPE: 1 0 0 0
                          PROCESS_FLOW: 6 0 0 0
                          PROCESS_FLOW_MODULE: 1 0 0 0
                          PROCESS_FLOW_PACKAGE: 3 0 0 0
                          PROJECT: 1 0 0 0
                          SEQUENCE: 2 0 0 0
                          SUBPROCESS: 4 0 0 0
                          SYSTEM_PARAMETER: 571 0 0 0
                          SYSTEM_VARIABLE: 5 0 0 0
                          TABLE: 181 0 0 0
                          TRANSITION: 320 0 0 0
                          UNIQUE_KEY: 216 0 0 0
                          VIEW: 2 0 0 0

                          Internal Objects Added Replaced Skipped Deleted
                          ----------------------------------------- ----- -------- ------- -------
                          DIAGRAM: 99 0 0 0
                          DIAGRAMNODE: 2269 0 0 0
                          ITEMSETUSAGE: 2665 0 0 0
                          LOCATIONUSAGE: 5 0 0 0
                          PUREPHYSICALOBJECT: 1497 0 0 0
                          REFERENCEPROPERTYVALUE: 8042 0 0 0
                          STRINGPROPERTYVALUE: 66538 0 0 0
                          TASKFLOWSET: 1 0 0 0



                          Import ended at 03/25/2011 14:19:06 IST

                          Total import time (hh:mm:ss): 00:22:38

                          *****************************************************************************************************************

                          To check whether Process Flow is existing or not,Please follow the below two methods.
                          1.While choosing first option(Import all objects from file) and importing,see whether OWF_LOCATION has been created or not.
                          If OWF_LOCATION exists then Process Flow also exists.
                          2.Otherwise,while choosing 2nd option(Import selected objects from file) and importing,see whether
                          In Project OCDM_INTRA_ETL,the following are existing or not.
                          ->Process Flow Modules
                          ->OLAP_PFLW
                          ->Process Flow Packages
                          ->AGR_PFLW
                          ->DRDV_FLW
                          ->AGGR_FLW
                          ->MNNG_FLW
                          ->INTRA_ETL_FLW

                          From the above two methods,If Process Flow is not existing then i think in OCDM_Intra_ETL.mdl file Process Flow is missing.

                          Regards,
                          Esther

                          Edited by: user9071835 on Mar 25, 2011 2:41 AM
                          • 10. Re: Process flow does not exist in OCDM_Intra_ETL.mdl ocdm 11.2.3 on lunux x86
                            User805674-Oracle
                            Hi Esther,

                            1. Please, provide details about your OCDM_Intra_ETL.mdl file. I could not see details regarding your mdl file (timestamp, which machine generates mdl file, and other details). I am more then sure that we are not talking about the same mdl file.
                            2. Please, download OCDM product from edelivery.oracle.com and try to install process flow.

                            Regards,

                            Sasa
                            • 11. Re: Process flow does not exist in OCDM_Intra_ETL.mdl ocdm 11.2.3 on lunux x86
                              User805674-Oracle
                              Hi Esther,

                              In my mdl file there is only one location exist: OCDM_SYS_LOCATION

                              Regards,

                              Sasa
                              • 12. Re: Process flow does not exist in OCDM_Intra_ETL.mdl ocdm 11.2.3 on lunux x86
                                775861
                                Hi Sasa,

                                The current version(11.2.3) of OCDM_Intra_ETL.mdl does not include Process flow, the process flow will be provided with next release(will be available soon).

                                Regards,
                                Avinash