14 Replies Latest reply: Apr 7, 2012 2:17 AM by 888047 RSS

    OBE flow fails when running Data Explore node

    888047
      I am running into what is probably a simple ODM setup issue and was hoping that someone may be able to help.

      I used an existing 11gR2 DB and followed steps in Setting Up Oracle Data Miner 11g Release 2 OBE (http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/11g/r2/prod/bidw/datamining/ODM11gR2-SetUp.htm).

      I then followed steps in OBE Using Oracle Data Miner 11g Release 2 (http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/11g/r2/prod/bidw/datamining/ODM11gR2.htm). Created a project, a workflow, used existing table, added Explore Data node. Tried to run the Explore Node and failed with the following error:

      oracle.ide.dialogs.ProgressException: java.sql.SQLException: ORA-20999: ORA-20003: Workflow Run failed due to ORA-27451: PROGRAM_NAME cannot be NULL
      .
      ORA-06512: at "ODMRSYS.ODMR_WORKFLOW", line 1230
      ORA-06512: at line 1
           at oracle.ide.dialogs.ProgressRunnable.start(ProgressRunnable.java:136)
      .... (more Java messages)

      Dropped repository, repeated the setup steps with both 3.0 and 3.1 versions of SQL Developer - same error. Also tried to create a new workflow with other tables - same error. Verified install on backend following steps in ODM Admin Guide - everything checks out fine. Tried google searches, Oracle support site - no obvious hits.

      Any ideas / pointers?
        • 1. Re: OBE flow fails when running Data Explore node
          Mark Kelly-Oracle
          Hi,
          No quick answer as I have not seen this type of installation issue before.
          What version of the db are you using : 11.2.0.1 , 11.2.0.2 or 11.2.0.3?
          When you tried SQL Dev 3.1 did you use the production version or one of the Early Release versions?
          Go to Help->About and click on the extension tab and let us know what the data miner version.

          When you create a workflow can you add a ds node and save it without any failure?
          Can you run just a DS node?

          Can you paste in the installation log or provide a link to it so we can review.
          The installation log is saved, you can see the location when you click view log.
          It is going to be long, so a link would be best although I think OTN will probably accept a posting of that size.

          Thanks, Mark
          • 2. Re: OBE flow fails when running Data Explore node
            888047
            Mark,

            Thank you very much for the quick response and sorry about the delay on my side -
            I was out on vacation and also wanted to play with diff versions as well as
            install / uninstall ODM.

            Answers:

            Running 11.2.0.3 on DB, and running SQL Dev production version.
            Help -> About produces
            Data Miner     oracle.dmt.dataminer     11.2.1.1.07.42     Loaded

            Yes, I can create, save and run a DS node by itself.
            The DE node produces the same error after dropping and recreating repository.

            Also, if I drop repository and install the 3.0 version, the DS node by itself runs for a very long time (hours) and does not complete. I am guessing this (ie 2 diff SQL Dev version having diff problems) points to something being wrong with the DB.

            Install log is as follows -

            anonymous block completed


            anonymous block completed
            Drop public synonyms created by ODMRSYS.

            anonymous block completed


            anonymous block completed
            Total Number of Objects: 0
            Total Number of Objects Dropped: 0
            Total Number of Objects Failed to Drop: 0

            anonymous block completed
            drop role ODMRUSER: failed as ODMRUSER role does not exist

            anonymous block completed


            anonymous block completed
            Create ODMRSYS account.

            anonymous block completed


            user ODMRSYS created.
            user ODMRSYS altered.
            user ODMRSYS altered.
            commited.
            anonymous block completed


            anonymous block completed
            Grant required privileges to ODMRSYS account.

            anonymous block completed


            grant succeeded.
            grant succeeded.
            grant succeeded.
            grant succeeded.
            grant succeeded.
            grant succeeded.
            grant succeeded.
            grant succeeded.
            grant succeeded.
            grant succeeded.
            grant succeeded.
            grant succeeded.
            grant succeeded.
            anonymous block completed


            anonymous block completed
            Create ODMRUSER role.

            anonymous block completed


            role ODMRUSER created.
            anonymous block completed


            anonymous block completed
            Grant required privileges to ODMRUSER role.

            anonymous block completed


            grant succeeded.
            grant succeeded.
            grant succeeded.
            grant succeeded.
            grant succeeded.
            grant succeeded.
            grant succeeded.
            grant succeeded.
            grant succeeded.
            grant succeeded.
            grant succeeded.
            grant succeeded.
            grant succeeded.
            anonymous block completed


            anonymous block completed
            Revoke ODMRUSER role from sys account to avoid locks with dropping repository.

            anonymous block completed


            revoke succeeded.
            session SET altered.
            anonymous block completed
            session SET altered.
            anonymous block completed
            anonymous block completed


            anonymous block completed
            Create db objects (tables,views,types) in ODMRSYS

            anonymous block completed


            table ODMRSYS.ODMR$DEFAULT_STOPLISTS created.
            table ODMRSYS.ODMR$DEBUG_LOG created.
            table ODMRSYS.ODMR$WORKFLOW_JOBS created.
            table ODMRSYS.ODMR$WORKFLOWS created.
            table ODMRSYS.ODMR$WF_LOG created.
            table ODMRSYS.ODMR$WF_JOB_ARGS created.
            table ODMRSYS.ODMR$REPOSITORY_PROPERTIES created.
            1 rows inserted.
            1 rows inserted.
            1 rows inserted.
            1 rows inserted.
            1 rows inserted.
            1 rows inserted.
            1 rows inserted.
            1 rows inserted.
            1 rows inserted.
            1 rows inserted.
            1 rows inserted.
            1 rows inserted.
            1 rows inserted.
            1 rows inserted.
            1 rows inserted.
            1 rows inserted.
            1 rows inserted.
            table ODMRSYS.ODMR$MESSAGES created.
            index ODMR$MESSAGES_MSG_ID_INDEX created.
            index ODMR$MESSAGES_LANG_ID_INDEX created.
            table ODMRSYS.ODMR$PROJECTS created.
            table ODMRSYS.ODMR$WORKFLOW_JOBS altered.
            table ODMRSYS.ODMR$WORKFLOWS altered.
            table ODMRSYS.ODMR$PROJECTS altered.
            table ODMRSYS.ODMR$WORKFLOW_JOBS altered.
            table ODMRSYS.ODMR$WORKFLOWS altered.
            table ODMRSYS.ODMR$WF_JOB_ARGS altered.
            view ODMRSYS.ODMR_USER_DEFAULT_STOPLISTS created.
            view ODMRSYS.ODMR_USER_PROJECT_WORKFLOW created.
            view ODMRSYS.ODMR_USER_WORKFLOW_JOBS created.
            view ODMRSYS.ODMR_USER_WORKFLOW_LOG created.
            view ODMRSYS.ODMR_MESSAGES created.
            view ODMRSYS.ODMR_REPOSITORY_PROPERTIES created.
            view ODMRSYS.ODMR_USER_WORKFLOW_RUNNING created.
            view ODMRSYS.ODMR_USER_WORKFLOW_COMPLETE created.
            view ODMRSYS.ODMR_USER_WORKFLOW_ALL created.
            view ODMRSYS.ODMR_ALL_WORKFLOW_MODELS created.
            COMMENT on column odmrsys.odmr$workflows.run_mode 'RUN, RERUN' succeeded.
            COMMENT on column odmrsys.odmr$workflows.status 'ACTIVE, INACTIVE, QUEUED' succeeded.
            index ODMR$WORKFLOWS_INDEX created.
            index ODMR$WF_LOG_PROJ_NAME_INDEX created.
            index ODMR$WF_LOG_WF_NAME_INDEX created.
            index ODMR$WF_LOG_JOB_NAME_INDEX created.
            index ODMR$WF_LOG_TYPE_INDEX created.
            index ODMR$WF_LOG_STYPE_INDEX created.
            index ODMR$WF_LOG_TASK_INDEX created.
            index ODMR$WF_LOG_NODE_ID_INDEX created.
            index ODMR$WF_LOG_WF_ID_INDEX created.
            index ODMR$WF_LOG_TIMESTMP_INDEX created.
            sequence ODMRSYS.ODMR$WORKFLOW_OBJECT_NAME_SEQ created.
            sequence ODMRSYS.ODMR$WORKFLOW_ID_SEQ created.
            sequence ODMRSYS.ODMR$PROJECT_ID_SEQ created.
            sequence ODMRSYS.ODMR$LOG_ID_SEQ created.
            TYPE ODMR_PREDICTION_NUM_COST compiled
            TYPE ODMR_PREDICTION_NUM compiled
            TYPE ODMR_PREDICTION_CAT_COST compiled
            TYPE ODMR_PREDICTION_CAT compiled
            TYPE ODMR_PREDICTION_SET_NUM_COST compiled
            TYPE ODMR_PREDICTION_SET_NUM compiled
            TYPE ODMR_PREDICTION_SET_CAT_COST compiled
            TYPE ODMR_PREDICTION_SET_CAT compiled
            TYPE ODMR_FEATURE_NUM compiled
            TYPE ODMR_FEATURE_SET_NUM compiled
            TYPE ODMR_FEATURE_CAT compiled
            TYPE ODMR_FEATURE_SET_CAT compiled
            TYPE ODMR_CLUSTER_NUM compiled
            TYPE ODMR_CLUSTER_SET_NUM compiled
            TYPE ODMR_CLUSTER_CAT compiled
            TYPE ODMR_CLUSTER_SET_CAT compiled
            TYPE ODMR_PREDICTION_NUM_COSTF compiled
            TYPE ODMR_PREDICTION_NUM_COSTD compiled
            TYPE ODMR_PREDICTION_NUM_COSTN compiled
            TYPE ODMR_PREDICTION_NUM_F compiled
            TYPE ODMR_PREDICTION_NUM_D compiled
            TYPE ODMR_PREDICTION_NUM_N compiled
            TYPE ODMR_PREDICTION_CAT_COSTPD compiled
            TYPE ODMR_PREDICTION_CATPD compiled
            TYPE ODMR_PREDICTION_SET_NUM_COSTF compiled
            TYPE ODMR_PREDICTION_SET_NUM_COSTD compiled
            TYPE ODMR_PREDICTION_SET_NUM_COSTN compiled
            TYPE ODMR_PREDICTION_SET_NUM_F compiled
            TYPE ODMR_PREDICTION_SET_NUM_D compiled
            TYPE ODMR_PREDICTION_SET_NUM_N compiled
            TYPE ODMR_PREDICTION_SET_CAT_COSTPD compiled
            TYPE ODMR_PREDICTION_SET_CATPD compiled
            TYPE ODMR_FEATURE_NUMVD compiled
            TYPE ODMR_FEATURE_SET_NUMVD compiled
            TYPE ODMR_FEATURE_CATVD compiled
            TYPE ODMR_FEATURE_SET_CATVD compiled
            TYPE ODMR_CLUSTER_NUMPD compiled
            TYPE ODMR_CLUSTER_SET_NUMPD compiled
            TYPE ODMR_CLUSTER_CATPD compiled
            TYPE ODMR_CLUSTER_SET_CATPD compiled
            TYPE ODMR_HISTOGRAM_POINT compiled
            TYPE ODMR_HISTOGRAMS compiled
            TYPE ODMR_TRANSFORM_SETTING compiled
            TYPE ODMR_TRANSFORM_SETTINGS compiled
            TYPE ODMR_OBJECT_VALUES compiled
            TYPE ODMR_OBJECT_NAMES compiled
            TYPE ODMR_OBJECT_IDS compiled
            TYPE ODMR_NODE_REFERENCE compiled
            TYPE ODMR_NODE_REFERENCE_SET compiled
            index "ODMRSYS"."CLASSIFICATION_BUILD_N_ID_IDX" created.
            index "ODMRSYS"."DATA_PROFILE_N_ID_IDX" created.
            index "ODMRSYS"."DATA_SOURCE_N_ID_IDX" created.
            index "ODMRSYS"."CREATE_TABLE_N_ID_IDX" created.
            index "ODMRSYS"."UPDATE_TABLE_N_ID_IDX" created.
            index "ODMRSYS"."AGGREGATION_N_ID_IDX" created.
            index "ODMRSYS"."TRANSFORMATION_N_ID_IDX" created.
            index "ODMRSYS"."JOIN_N_ID_IDX" created.
            index "ODMRSYS"."BUILD_TEXT_REF_N_ID_IDX" created.
            index "ODMRSYS"."APPLY_TEXT_N_ID_IDX" created.
            index "ODMRSYS"."BUILD_TEXT_N_ID_IDX" created.
            index "ODMRSYS"."SAMPLE_N_ID_IDX" created.
            index "ODMRSYS"."COLUMN_FILTER_N_ID_IDX" created.
            index "ODMRSYS"."ROW_FILTER_N_ID_IDX" created.
            index "ODMRSYS"."REGRESSION_BUILD_N_ID_IDX" created.
            index "ODMRSYS"."CLUSTERING_BUILD_N_ID_IDX" created.
            index "ODMRSYS"."ASSOCIATION_BUILD_N_ID_IDX" created.
            index "ODMRSYS"."FEATURE_EXT_BUILD_N_ID_IDX" created.
            index "ODMRSYS"."ANOMALY_DET_BUILD_N_ID_IDX" created.
            index "ODMRSYS"."MODEL_N_ID_IDX" created.
            index "ODMRSYS"."APPLY_N_ID_IDX" created.
            index "ODMRSYS"."TEST_N_ID_IDX" created.
            index "ODMRSYS"."MODEL_DETAILS_N_ID_IDX" created.
            index "ODMRSYS"."TEST_DETAILS_N_ID_IDX" created.
            index "ODMRSYS"."FILTER_DETAILS_N_ID_IDX" created.
            index "ODMRSYS"."DECISION_TREE_M_ID_IDX" created.
            index "ODMRSYS"."NAIVE_BAYES_M_ID_IDX" created.
            index "ODMRSYS"."SUPT_VECTOR_MACH_C_M_ID_IDX" created.
            index "ODMRSYS"."GEN_LINEAR_C_M_ID_IDX" created.
            index "ODMRSYS"."KMEANS_M_ID_IDX" created.
            index "ODMRSYS"."OCLUSTER_M_ID_IDX" created.
            index "ODMRSYS"."NON_NEG_MATRIX_M_ID_IDX" created.
            index "ODMRSYS"."SUPT_VECTOR_MACH_R_M_ID_IDX" created.
            index "ODMRSYS"."GEN_LINEAR_R_M_ID_IDX" created.
            index "ODMRSYS"."ANOM_DETECT_M_ID_IDX" created.
            index "ODMRSYS"."APRIORI_M_ID_IDX" created.
            index "ODMRSYS"."MINING_ATTRIBUTE_NM_IDX" created.
            index "ODMRSYS"."LINKS_TAB_FROM_IDX" created.
            index "ODMRSYS"."LINKS_TAB_TO_IDX" created.
            anonymous block completed
            anonymous block completed


            anonymous block completed
            Load stopword entries into repository.

            anonymous block completed


            0 rows deleted.
            1 rows inserted.
            (another 1620 identical statements of "1 rows inserted.")
            1 rows inserted.
            1 rows inserted.
            1 rows inserted.
            1 rows inserted.
            1 rows inserted.
            1 rows inserted.
            anonymous block completed
            commited.
            anonymous block completed


            anonymous block completed
            Load translated messages.

            anonymous block completed


            0 rows deleted.
            1 rows inserted.
            (another 705 identical statements of "1 rows inserted.")
            1 rows inserted.
            1 rows inserted.
            anonymous block completed
            anonymous block completed
            anonymous block completed
            anonymous block completed
            PACKAGE ODMR_CONSTANT compiled
            PACKAGE ODMR_MSG compiled
            PACKAGE ODMR_ENGINE_SEC compiled
            Warning: execution completed with warning
            PACKAGE ODMR_INTERNAL_UTIL compiled
            PACKAGE ODMR_PROJECT_SEC compiled
            PACKAGE ODMR_ENGINE_TRANSFORMS_SEC compiled
            Warning: execution completed with warning
            PACKAGE ODMR_INTERNAL_UTIL_SEC compiled
            PACKAGE ODMR_ENGINE_TEXT_SEC compiled
            PACKAGE ODMR_ENGINE_OUTPUT_SEC compiled
            PACKAGE ODMR_ENGINE_MINING_SEC compiled
            Warning: execution completed with warning
            PACKAGE ODMR_ENGINE_DATA_SEC compiled
            PACKAGE ODMR_WORKFLOW_SEC compiled
            Warning: execution completed with warning
            PACKAGE ODMR_ENGINE compiled
            PACKAGE ODMR_PROJECT compiled
            PACKAGE ODMR_ENGINE_TRANSFORMS compiled
            PACKAGE ODMR_UTIL compiled
            PACKAGE ODMR_ENGINE_TEXT compiled
            PACKAGE ODMR_ENGINE_OUTPUT compiled
            PACKAGE ODMR_ENGINE_MINING compiled
            PACKAGE ODMR_ENGINE_DATA compiled
            PACKAGE ODMR_WORKFLOW compiled
            PACKAGE BODY ODMR_MSG compiled
            PACKAGE BODY ODMR_ENGINE_SEC compiled
            PACKAGE BODY ODMR_INTERNAL_UTIL compiled
            PACKAGE BODY ODMR_PROJECT_SEC compiled
            PACKAGE BODY ODMR_ENGINE_TRANSFORMS_SEC compiled
            PACKAGE BODY ODMR_INTERNAL_UTIL_SEC compiled
            PACKAGE BODY ODMR_ENGINE_TEXT_SEC compiled
            PACKAGE BODY ODMR_ENGINE_OUTPUT_SEC compiled
            PACKAGE BODY ODMR_ENGINE_MINING_SEC compiled
            PACKAGE BODY ODMR_ENGINE_DATA_SEC compiled
            PACKAGE BODY ODMR_WORKFLOW_SEC compiled
            PACKAGE BODY ODMR_ENGINE compiled
            PACKAGE BODY ODMR_PROJECT compiled
            PACKAGE BODY ODMR_ENGINE_TRANSFORMS compiled
            PACKAGE BODY ODMR_UTIL compiled
            PACKAGE BODY ODMR_ENGINE_TEXT compiled
            PACKAGE BODY ODMR_ENGINE_OUTPUT compiled
            PACKAGE BODY ODMR_ENGINE_MINING compiled
            PACKAGE BODY ODMR_ENGINE_DATA compiled
            PACKAGE BODY ODMR_WORKFLOW compiled
            anonymous block completed


            anonymous block completed
            Create public synonyms on views, packages and types and grant to access to public.

            anonymous block completed


            public synonym ODMR_TRANSFORM_SETTING created.
            GRANT succeeded.
            public synonym ODMR_TRANSFORM_SETTINGS created.
            GRANT succeeded.
            public synonym ODMR_OBJECT_IDS created.
            GRANT succeeded.
            public synonym ODMR_OBJECT_NAMES created.
            GRANT succeeded.
            public synonym ODMR_OBJECT_VALUES created.
            GRANT succeeded.
            public synonym ODMR_WORKFLOW_OBJECT_NAME_SEQ created.
            GRANT succeeded.
            public synonym ODMR_HISTOGRAM_POINT created.
            GRANT succeeded.
            public synonym ODMR_HISTOGRAMS created.
            GRANT succeeded.
            public synonym ODMR_PREDICTION_CAT created.
            GRANT succeeded.
            public synonym ODMR_PREDICTION_SET_CAT created.
            GRANT succeeded.
            public synonym ODMR_PREDICTION_CAT_COST created.
            GRANT succeeded.
            public synonym ODMR_PREDICTION_SET_CAT_COST created.
            GRANT succeeded.
            public synonym ODMR_PREDICTION_NUM created.
            GRANT succeeded.
            public synonym ODMR_PREDICTION_SET_NUM created.
            GRANT succeeded.
            public synonym ODMR_PREDICTION_NUM_COST created.
            GRANT succeeded.
            public synonym ODMR_PREDICTION_SET_NUM_COST created.
            GRANT succeeded.
            public synonym ODMR_FEATURE_CAT created.
            GRANT succeeded.
            public synonym ODMR_FEATURE_SET_CAT created.
            GRANT succeeded.
            public synonym ODMR_FEATURE_NUM created.
            GRANT succeeded.
            public synonym ODMR_FEATURE_SET_NUM created.
            GRANT succeeded.
            public synonym ODMR_CLUSTER_CAT created.
            GRANT succeeded.
            public synonym ODMR_CLUSTER_SET_CAT created.
            GRANT succeeded.
            public synonym ODMR_CLUSTER_NUM created.
            GRANT succeeded.
            public synonym ODMR_CLUSTER_SET_NUM created.
            GRANT succeeded.
            public synonym ODMR_PREDICTION_NUM_COSTF created.
            GRANT succeeded.
            public synonym ODMR_PREDICTION_NUM_COSTD created.
            GRANT succeeded.
            public synonym ODMR_PREDICTION_NUM_COSTN created.
            GRANT succeeded.
            public synonym ODMR_PREDICTION_NUM_F created.
            GRANT succeeded.
            public synonym ODMR_PREDICTION_NUM_D created.
            GRANT succeeded.
            public synonym ODMR_PREDICTION_NUM_N created.
            GRANT succeeded.
            public synonym ODMR_PREDICTION_SET_NUM_COSTF created.
            GRANT succeeded.
            public synonym ODMR_PREDICTION_SET_NUM_COSTD created.
            GRANT succeeded.
            public synonym ODMR_PREDICTION_SET_NUM_COSTN created.
            GRANT succeeded.
            public synonym ODMR_PREDICTION_SET_NUM_F created.
            GRANT succeeded.
            public synonym ODMR_PREDICTION_SET_NUM_D created.
            GRANT succeeded.
            public synonym ODMR_PREDICTION_SET_NUM_N created.
            GRANT succeeded.
            public synonym ODMR_PREDICTION_CAT_COSTPD created.
            GRANT succeeded.
            public synonym ODMR_PREDICTION_CATPD created.
            GRANT succeeded.
            public synonym ODMR_PREDICTION_SET_CAT_COSTPD created.
            GRANT succeeded.
            public synonym ODMR_PREDICTION_SET_CATPD created.
            GRANT succeeded.
            public synonym ODMR_FEATURE_NUMVD created.
            GRANT succeeded.
            public synonym ODMR_FEATURE_SET_NUMVD created.
            GRANT succeeded.
            public synonym ODMR_FEATURE_CATVD created.
            GRANT succeeded.
            public synonym ODMR_FEATURE_SET_CATVD created.
            GRANT succeeded.
            public synonym ODMR_CLUSTER_NUMPD created.
            GRANT succeeded.
            public synonym ODMR_CLUSTER_SET_NUMPD created.
            GRANT succeeded.
            public synonym ODMR_CLUSTER_CATPD created.
            GRANT succeeded.
            public synonym ODMR_CLUSTER_SET_CATPD created.
            GRANT succeeded.
            public synonym ODMR_NODE_REFERENCE created.
            GRANT succeeded.
            public synonym ODMR_NODE_REFERENCE_SET created.
            GRANT succeeded.
            public synonym ODMR_USER_DEFAULT_STOPLISTS created.
            GRANT succeeded.
            public synonym ODMR_USER_PROJECT_WORKFLOW created.
            GRANT succeeded.
            public synonym ODMR_USER_WORKFLOW_JOBS created.
            GRANT succeeded.
            public synonym ODMR_USER_WORKFLOW_LOG created.
            GRANT succeeded.
            public synonym ODMR_REPOSITORY_PROPERTIES created.
            GRANT succeeded.
            public synonym ODMR_USER_WORKFLOW_RUNNING created.
            GRANT succeeded.
            public synonym ODMR_USER_WORKFLOW_COMPLETE created.
            GRANT succeeded.
            public synonym ODMR_USER_WORKFLOW_ALL created.
            GRANT succeeded.
            public synonym ODMR_ALL_WORKFLOW_MODELS created.
            GRANT succeeded.
            public synonym ODMR_CONSTANT created.
            GRANT succeeded.
            public synonym ODMR_PROJECT created.
            GRANT succeeded.
            public synonym ODMR_WORKFLOW created.
            GRANT succeeded.
            public synonym ODMR_UTIL created.
            GRANT succeeded.
            public synonym ODMR_ENGINE created.
            GRANT succeeded.
            public synonym ODMR_ENGINE_DATA created.
            GRANT succeeded.
            public synonym ODMR_ENGINE_MINING created.
            GRANT succeeded.
            public synonym ODMR_ENGINE_OUTPUT created.
            GRANT succeeded.
            public synonym ODMR_ENGINE_TRANSFORMS created.
            GRANT succeeded.
            public synonym ODMR_ENGINE_TEXT created.
            GRANT succeeded.
            public synonym ODMR_MESSAGES created.
            GRANT succeeded.
            anonymous block completed


            anonymous block completed
            Create Scheduler Job definitions.

            anonymous block completed


            anonymous block completed
            anonymous block completed


            anonymous block completed
            Validate ODMRSYS to insure all objects are valid.

            anonymous block completed


            anonymous block completed

            Invalid ODMRSYS Objects Report


            Total Number of Invalid Objects: 0

            anonymous block completed


            anonymous block completed
            Grant access to Data Miner repository objects to specified user.

            anonymous block completed


            grant succeeded.
            GRANT succeeded.
            GRANT succeeded.
            GRANT succeeded.
            GRANT succeeded.
            GRANT succeeded.
            GRANT succeeded.
            GRANT succeeded.
            GRANT succeeded.
            GRANT succeeded.
            GRANT succeeded.
            GRANT succeeded.
            GRANT succeeded.
            GRANT succeeded.
            GRANT succeeded.
            GRANT succeeded.
            GRANT succeeded.
            GRANT succeeded.
            GRANT succeeded.
            GRANT succeeded.
            GRANT succeeded.
            GRANT succeeded.
            GRANT succeeded.
            GRANT succeeded.
            GRANT succeeded.
            GRANT succeeded.
            GRANT succeeded.
            GRANT succeeded.
            GRANT succeeded.
            GRANT succeeded.
            GRANT succeeded.
            GRANT succeeded.
            anonymous block completed


            anonymous block completed
            Add ODMRUSER as one of the user default roles.

            anonymous block completed


            anonymous block completed
            Validated ODMRUSER is a default role of user

            Commit
            • 3. Re: OBE flow fails when running Data Explore node
              Mark Kelly-Oracle
              Hi,
              The install log looks clean.
              So far, I just have more questions, no answers, but lets see where it goes.

              You noted that you can run the Data Source node ok. Can you run any other nodes?
              Is your only failure with the Explore data node?

              The error that you included, is that from running the SQL Dev 3.1 Install?

              What is the locale on the client side?

              Thanks, Mark
              • 4. Re: OBE flow fails when running Data Explore node
                888047
                No, so far I have not found any other nodes that I could run except for the Data Source node. Explore Data, Anomaly Build, Build Text all fail with the same error above (ie oracle.ide.dialogs.ProgressException: java.sql.SQLException: ORA-20999: ORA-20003: Workflow Run failed due to ORA-27451: PROGRAM_NAME cannot be NULL).

                Yes, the error is when running SQL Dev 3.1.

                Locale on client is English (United States).
                • 5. Re: OBE flow fails when running Data Explore node
                  Mark Kelly-Oracle
                  Hi,
                  Here are several investigate steps that you can take that will provide information for us to understand what is wrong with the installation.
                  The failure is coming during the construction of the oracle scheduler objects generated to run the workflow.
                  The scripts focus on this process.
                  Thanks, Mark

                  Here are some tests (run in SYS account) to try for the problem:

                  1. Test the XML query is working to get the node types (which is used by the workflow chain construction):

                  SELECT WORKFLOW_ID, xtab.*
                  FROM odmrsys.ODMR$WORKFLOWS x,
                  XMLTable(XMLNAMESPACES(DEFAULT 'http://xmlns.oracle.com/odmr11'),
                  'for $i in (
                  /WorkflowProcess/Nodes/DataSource,
                  /WorkflowProcess/Nodes/CreateTable,
                  /WorkflowProcess/Nodes/UpdateTable,
                  /WorkflowProcess/Nodes/DataProfile,
                  /WorkflowProcess/Nodes/Transformation,
                  /WorkflowProcess/Nodes/Aggregation,
                  /WorkflowProcess/Nodes/Join,
                  /WorkflowProcess/Nodes/BuildTextRef,
                  /WorkflowProcess/Nodes/BuildText,
                  /WorkflowProcess/Nodes/ApplyText,
                  /WorkflowProcess/Nodes/Sample,
                  /WorkflowProcess/Nodes/ColumnFilter,
                  /WorkflowProcess/Nodes/RowFilter,
                  /WorkflowProcess/Nodes/ClassificationBuild,
                  /WorkflowProcess/Nodes/RegressionBuild,
                  /WorkflowProcess/Nodes/ClusteringBuild,
                  /WorkflowProcess/Nodes/AssociationBuild,
                  /WorkflowProcess/Nodes/FeatureExtractionBuild,
                  /WorkflowProcess/Nodes/AnomalyDetectionBuild,
                  /WorkflowProcess/Nodes/Model,
                  /WorkflowProcess/Nodes/Apply,
                  /WorkflowProcess/Nodes/Test,
                  /WorkflowProcess/Nodes/ModelDetails,
                  /WorkflowProcess/Nodes/TestDetails,
                  /WorkflowProcess/Nodes/FilterDetails
                  )
                  return $i'
                  PASSING x.WORKFLOW_DATA
                  COLUMNS Type VARCHAR2(30) PATH 'name()',
                  Id VARCHAR2(30) PATH '@Id',
                  Name VARCHAR2(30) PATH '@Name',
                  Status VARCHAR2(30) PATH '@Status') xtab

                  2. Make sure our scheduler programs are installed properly:

                  select * from DBA_SCHEDULER_PROGRAMS where owner = 'ODMRSYS'

                  3. Update the ODMRSYS repository to turn ON the debug_log trace:

                  --update repository status completion
                  UPDATE ODMRSYS.ODMR$REPOSITORY_PROPERTIES SET PROPERTY_STR_VALUE = 'TRUE' WHERE PROPERTY_NAME = 'DEBUG_LOG';
                  COMMIT;

                  4. Run just the Explore Data Node (which will also include the Data Source node that it is connected to). Keep it to just 2 nodes.


                  5. Look at the debug log to see the scheduler chain construction calls are issued properly:

                  select * from odmrsys.odmr$debug_log where output_msg like 'DBMS_SCHEDULER%' order by log_timestamp;

                  6. Update the the ODMRSYS repository to turn OFF the debug_log trace:
                  UPDATE ODMRSYS.ODMR$REPOSITORY_PROPERTIES SET PROPERTY_STR_VALUE = 'FALSE' WHERE PROPERTY_NAME = 'DEBUG_LOG';
                  COMMIT;


                  7. Post the results to the forum.
                  • 6. Re: OBE flow fails when running Data Explore node
                    888047
                    Thank you for the quick responses, Mark.

                    1. Returns
                    WORKFLOW_ID TYPE ID NAME STATUS
                    ----------- ------------------------------ ------------------------------ ------------------------------ ------------------------------
                    1 DataSource 10001 INSUR_CUST_LTV_SAMPLE Complete



                    2. Returns 29 rows. I omitted the large text column values but can post them if needed.

                    OWNER PROGRAM_NAME PROGRAM_TYPE NUMBER_OF_ARGUMENTS ENABLED DETACHED SCHEDULE_LIMIT PRIORITY WEIGHT MAX_RUNS MAX_FAILURES MAX_RUN_DURATION
                    ------------------------------ ------------------------------ ---------------- ------------------- ------- -------- -------------- -------- ------ -------- ------------ ----------------
                    ODMRSYS START_PROG STORED_PROCEDURE 2 TRUE FALSE 3 1
                    ODMRSYS CLEANUP_PROG STORED_PROCEDURE 2 TRUE FALSE 3 1
                    ODMRSYS SUBFLOW_START_PROG STORED_PROCEDURE 2 TRUE FALSE 3 1
                    ODMRSYS SUBFLOW_CLEANUP_PROG STORED_PROCEDURE 2 TRUE FALSE 3 1
                    ODMRSYS DATASOURCE_PROG STORED_PROCEDURE 2 TRUE FALSE 3 1
                    ODMRSYS DATAPROFILE_PROG STORED_PROCEDURE 2 TRUE FALSE 3 1
                    ODMRSYS CREATETABLE_PROG STORED_PROCEDURE 2 TRUE FALSE 3 1
                    ODMRSYS UPDATETABLE_PROG STORED_PROCEDURE 2 TRUE FALSE 3 1
                    ODMRSYS AGGREGATION_PROG STORED_PROCEDURE 2 TRUE FALSE 3 1
                    ODMRSYS CLASS_BUILD_PROG STORED_PROCEDURE 2 TRUE FALSE 3 1
                    ODMRSYS REGRESS_BUILD_PROG STORED_PROCEDURE 2 TRUE FALSE 3 1
                    ODMRSYS CLUST_BUILD_PROG STORED_PROCEDURE 2 TRUE FALSE 3 1
                    ODMRSYS ASSOC_BUILD_PROG STORED_PROCEDURE 2 TRUE FALSE 3 1
                    ODMRSYS ANOMALY_BUILD_PROG STORED_PROCEDURE 2 TRUE FALSE 3 1
                    ODMRSYS MODEL_PROG STORED_PROCEDURE 2 TRUE FALSE 3 1
                    ODMRSYS TEST_PROG STORED_PROCEDURE 2 TRUE FALSE 3 1
                    ODMRSYS APPLY_PROG STORED_PROCEDURE 2 TRUE FALSE 3 1
                    ODMRSYS MODELDETAILS_PROG STORED_PROCEDURE 2 TRUE FALSE 3 1
                    ODMRSYS JOIN_PROG STORED_PROCEDURE 2 TRUE FALSE 3 1
                    ODMRSYS TRANSFORMATIONS_PROG STORED_PROCEDURE 2 TRUE FALSE 3 1
                    ODMRSYS COLUMNFILTER_PROG STORED_PROCEDURE 2 TRUE FALSE 3 1
                    ODMRSYS SAMPLE_PROG STORED_PROCEDURE 2 TRUE FALSE 3 1
                    ODMRSYS FILTERDETAILS_PROG STORED_PROCEDURE 2 TRUE FALSE 3 1
                    ODMRSYS ROWFILTER_PROG STORED_PROCEDURE 2 TRUE FALSE 3 1
                    ODMRSYS FEATURE_BUILD_PROG STORED_PROCEDURE 2 TRUE FALSE 3 1
                    ODMRSYS TEXT_PROG STORED_PROCEDURE 2 TRUE FALSE 3 1
                    ODMRSYS BUILDTEXT_PROG STORED_PROCEDURE 2 TRUE FALSE 3 1
                    ODMRSYS APPLYTEXT_PROG STORED_PROCEDURE 2 TRUE FALSE 3 1
                    ODMRSYS BUILDTEXT_REF_PROG STORED_PROCEDURE 2 TRUE FALSE 3 1

                    29 rows selected



                    5. Returns 13 rows. I omitted the CLOB columns as they did not appear to contain any data. Session_user and session_id columns had the same DMREP and 67 values respectively for all rows.

                    WORKFLOW_JOB_ID PROJECT_NAME PROJECT_ID WORKFLOW_NAME WORKFLOW_ID NODE_ID NODE_NAME SUB_NODE_ID SUB_NODE_NAME LOG_TIMESTAMP
                    ------------------------------ ------------------------------ ---------- ------------------------------ ----------- ------------------------------ ------------------------------ ------------------------------ ------------------------------ -------------------------------
                    GK1 1 GKWF1 1 03-APR-12 12.00.18.537484000 AM
                    GK1 1 GKWF1 1 03-APR-12 12.00.18.630471000 AM
                    GK1 1 GKWF1 1 03-APR-12 12.00.18.980468000 AM
                    GK1 1 GKWF1 1 03-APR-12 12.00.18.981098000 AM
                    GK1 1 GKWF1 1 03-APR-12 12.00.19.258396000 AM
                    GK1 1 GKWF1 1 03-APR-12 12.00.19.303358000 AM
                    GK1 1 GKWF1 1 03-APR-12 12.00.19.307274000 AM
                    GK1 1 GKWF1 1 03-APR-12 12.00.19.311549000 AM
                    GK1 1 GKWF1 1 03-APR-12 12.00.19.314097000 AM
                    GK1 1 GKWF1 1 03-APR-12 12.00.19.317393000 AM
                    GK1 1 GKWF1 1 03-APR-12 12.00.19.319078000 AM
                    GK1 1 GKWF1 1 03-APR-12 12.00.19.321411000 AM
                    GK1 1 GKWF1 1 03-APR-12 12.00.19.322938000 AM

                    13 rows selected


                    Selecting just the OUTPUT_MSG (same where clause and order by) gives

                    ------------------------------------------------------------------------------------------------------------------------------------------------------
                    DBMS_SCHEDULER.DROP_CHAIN(chain_name => 'ODMR$WFCHAIN4138', force => TRUE)
                    DBMS_SCHEDULER.GENERATE_JOB_NAME('ODMR$WFCHAIN')
                    DBMS_SCHEDULER.GENERATE_JOB_NAME('ODMR$WFJOB')
                    DBMS_SCHEDULER.CREATE_CHAIN(chain_name => 'ODMR$WFCHAIN4338')
                    DBMS_SCHEDULER.DEFINE_CHAIN_STEP(chain_name => 'ODMR$WFCHAIN4338', step_name => '"WF_START"', program_name => 'ODMRSYS.START_PROG')
                    DBMS_SCHEDULER.ALTER_CHAIN(chain_name => 'ODMR$WFCHAIN4338', step_name => '"WF_START"', attribute => 'RESTART_ON_RECOVERY', value => TRUE)
                    DBMS_SCHEDULER.DEFINE_CHAIN_STEP(chain_name => 'ODMR$WFCHAIN4338', step_name => '"WF_END"', program_name => 'ODMRSYS.CLEANUP_PROG')
                    DBMS_SCHEDULER.ALTER_CHAIN(chain_name => 'ODMR$WFCHAIN4338', step_name => '"WF_END"', attribute => 'RESTART_ON_RECOVERY', value => TRUE)
                    DBMS_SCHEDULER.DEFINE_CHAIN_STEP(chain_name => 'ODMR$WFCHAIN4338', step_name => '"10001"', program_name => 'ODMRSYS.DATASOURCE_PROG')
                    DBMS_SCHEDULER.ALTER_CHAIN(chain_name => 'ODMR$WFCHAIN4338', step_name => '"10001"', attribute => 'RESTART_ON_RECOVERY', value => TRUE)
                    DBMS_SCHEDULER.DEFINE_CHAIN_STEP(chain_name => 'ODMR$WFCHAIN4338', step_name => '"10015"', program_name => '')
                    DBMS_SCHEDULER.DROP_JOB(job_name => 'ODMR$WFJOB4339', force => TRUE)
                    DBMS_SCHEDULER.DROP_CHAIN(chain_name => 'ODMR$WFCHAIN4338', force => TRUE)

                    Ie it appears that result row 11 has a null program_name. And it does not seem to have a corresponding ALTER_CHAIN step.

                    From looking at WORKFLOW_DATA in odmrsys.ODMR$WORKFLOWS, ID 10015 corresponds to the Dataprofile / Explore Data node.
                    • 7. Re: OBE flow fails when running Data Explore node
                      Mark Kelly-Oracle
                      Ok, we know the reason for the specific failure, but we don't understand yet why the internal query is not returning a program_name.
                      More digging...

                      1) Same query as before but this time with a where clause specifying the workflow_id which is = 1. (I think that is the correct workflow_id for your workflow).
                      The workflow prior to this query should have been saved and have the DS node and Explore node.
                      Run as odmrsys

                      SELECT WORKFLOW_ID, xtab.*
                      FROM odmrsys.ODMR$WORKFLOWS x,
                      XMLTable(XMLNAMESPACES(DEFAULT 'http://xmlns.oracle.com/odmr11'),
                      'for $i in (
                      /WorkflowProcess/Nodes/DataSource,
                      /WorkflowProcess/Nodes/CreateTable,
                      /WorkflowProcess/Nodes/UpdateTable,
                      /WorkflowProcess/Nodes/DataProfile,
                      /WorkflowProcess/Nodes/Transformation,
                      /WorkflowProcess/Nodes/Aggregation,
                      /WorkflowProcess/Nodes/Join,
                      /WorkflowProcess/Nodes/BuildTextRef,
                      /WorkflowProcess/Nodes/BuildText,
                      /WorkflowProcess/Nodes/ApplyText,
                      /WorkflowProcess/Nodes/Sample,
                      /WorkflowProcess/Nodes/ColumnFilter,
                      /WorkflowProcess/Nodes/RowFilter,
                      /WorkflowProcess/Nodes/ClassificationBuild,
                      /WorkflowProcess/Nodes/RegressionBuild,
                      /WorkflowProcess/Nodes/ClusteringBuild,
                      /WorkflowProcess/Nodes/AssociationBuild,
                      /WorkflowProcess/Nodes/FeatureExtractionBuild,
                      /WorkflowProcess/Nodes/AnomalyDetectionBuild,
                      /WorkflowProcess/Nodes/Model,
                      /WorkflowProcess/Nodes/Apply,
                      /WorkflowProcess/Nodes/Test,
                      /WorkflowProcess/Nodes/ModelDetails,
                      /WorkflowProcess/Nodes/TestDetails,
                      /WorkflowProcess/Nodes/FilterDetails
                      )
                      return $i'
                      PASSING x.WORKFLOW_DATA
                      COLUMNS Type VARCHAR2(30) PATH 'name()',
                      Id VARCHAR2(30) PATH '@Id',
                      Name VARCHAR2(30) PATH '@Name',
                      Status VARCHAR2(30) PATH '@Status') xtab
                      where WORKFLOW_ID = 1;

                      2) Manually export the workflow and then include the results in the posting.
                      You can do this by right clicking the workflow in the navigator and selecting Export Workflow...

                      3)Run query to extract workflow data directly from workflow table (looks like you had already done this):
                      run as sys

                      SELECT XMLSerialize(CONTENT WORKFLOW_DATA)
                      FROM ODMRSYS.ODMR$WORKFLOWS x WHERE WORKFLOW_ID = 1;

                      4) What operating system is your 11.2.0.3 db running on?

                      5) What type of sql dev connection have you defined.
                      For example:
                      connection type - basic or some other type?
                      special authentication - proxy etc.

                      6) Is the client and db on same system?
                      Is it a standard db installation?

                      Thanks, Mark
                      • 8. Re: OBE flow fails when running Data Explore node
                        888047
                        Thank you, Mark. My response will span several posts.

                        1)
                        WORKFLOW_ID TYPE ID NAME STATUS
                        ----------- ------------------------------ ------------------------------ ------------------------------ ------------------------------
                        1 DataSource 10001 INSUR_CUST_LTV_SAMPLE Complete

                        And yes, that's the right WORKFLOW_ID.

                        2)

                        <?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
                        - <WorkflowProcess Version="11.2.1.1.1" xmlns="http://xmlns.oracle.com/odmr11">
                        - <Nodes>
                        - <DataSource Status="Complete" Name="INSUR_CUST_LTV_SAMPLE" Id="10001">
                        <Icon YCOORD="87" XCOORD="374" />
                        <Messages />
                        - <CacheSettings GenerateCache="false" UseFullData="false">
                        <NumberOfRows>2000</NumberOfRows>
                        - <Method>
                        <TopN />
                        </Method>
                        </CacheSettings>
                        <SQLExpression>"N$10001" as (select /*+ inline */ "INSUR_CUST_LTV_SAMPLE"."MARITAL_STATUS", "INSUR_CUST_LTV_SAMPLE"."STATE", "INSUR_CUST_LTV_SAMPLE"."CREDIT_BALANCE", "INSUR_CUST_LTV_SAMPLE"."TIME_AS_CUSTOMER", "INSUR_CUST_LTV_SAMPLE"."CUSTOMER_ID", "INSUR_CUST_LTV_SAMPLE"."MORTGAGE_AMOUNT", "INSUR_CUST_LTV_SAMPLE"."BANK_FUNDS", "INSUR_CUST_LTV_SAMPLE"."N_OF_DEPENDENTS", "INSUR_CUST_LTV_SAMPLE"."HAS_CHILDREN", "INSUR_CUST_LTV_SAMPLE"."SALARY", "INSUR_CUST_LTV_SAMPLE"."SEX", "INSUR_CUST_LTV_SAMPLE"."PROFESSION", "INSUR_CUST_LTV_SAMPLE"."CREDIT_CARD_LIMITS", "INSUR_CUST_LTV_SAMPLE"."REGION", "INSUR_CUST_LTV_SAMPLE"."HOUSE_OWNERSHIP", "INSUR_CUST_LTV_SAMPLE"."N_TRANS_WEB_BANK", "INSUR_CUST_LTV_SAMPLE"."BUY_INSURANCE", "INSUR_CUST_LTV_SAMPLE"."MONTHLY_CHECKS_WRITTEN", "INSUR_CUST_LTV_SAMPLE"."N_TRANS_KIOSK", "INSUR_CUST_LTV_SAMPLE"."AGE", "INSUR_CUST_LTV_SAMPLE"."MONEY_MONTLY_OVERDRAWN", "INSUR_CUST_LTV_SAMPLE"."LTV", "INSUR_CUST_LTV_SAMPLE"."T_AMOUNT_AUTOM_PAYMENTS", "INSUR_CUST_LTV_SAMPLE"."N_TRANS_TELLER", "INSUR_CUST_LTV_SAMPLE"."CHECKING_AMOUNT", "INSUR_CUST_LTV_SAMPLE"."N_TRANS_ATM", "INSUR_CUST_LTV_SAMPLE"."LTV_BIN", "INSUR_CUST_LTV_SAMPLE"."LAST", "INSUR_CUST_LTV_SAMPLE"."N_MORTGAGES", "INSUR_CUST_LTV_SAMPLE"."CAR_OWNERSHIP", "INSUR_CUST_LTV_SAMPLE"."FIRST" from "DMREP"."INSUR_CUST_LTV_SAMPLE" )</SQLExpression>
                        - <Attributes>
                        <Attribute Status="Valid" DataType="VARCHAR2" Name="MARITAL_STATUS" />
                        <Attribute Status="Valid" DataType="VARCHAR2" Name="STATE" />
                        <Attribute Status="Valid" DataType="NUMBER" Name="CREDIT_BALANCE" />
                        <Attribute Status="Valid" DataType="NUMBER" Name="TIME_AS_CUSTOMER" />
                        <Attribute Status="Valid" DataType="VARCHAR2" Name="CUSTOMER_ID" />
                        <Attribute Status="Valid" DataType="NUMBER" Name="MORTGAGE_AMOUNT" />
                        <Attribute Status="Valid" DataType="NUMBER" Name="BANK_FUNDS" />
                        <Attribute Status="Valid" DataType="NUMBER" Name="N_OF_DEPENDENTS" />
                        <Attribute Status="Valid" DataType="NUMBER" Name="HAS_CHILDREN" />
                        <Attribute Status="Valid" DataType="NUMBER" Name="SALARY" />
                        <Attribute Status="Valid" DataType="VARCHAR2" Name="SEX" />
                        <Attribute Status="Valid" DataType="VARCHAR2" Name="PROFESSION" />
                        <Attribute Status="Valid" DataType="NUMBER" Name="CREDIT_CARD_LIMITS" />
                        <Attribute Status="Valid" DataType="VARCHAR2" Name="REGION" />
                        <Attribute Status="Valid" DataType="NUMBER" Name="HOUSE_OWNERSHIP" />
                        <Attribute Status="Valid" DataType="NUMBER" Name="N_TRANS_WEB_BANK" />
                        <Attribute Status="Valid" DataType="VARCHAR2" Name="BUY_INSURANCE" />
                        <Attribute Status="Valid" DataType="NUMBER" Name="MONTHLY_CHECKS_WRITTEN" />
                        <Attribute Status="Valid" DataType="NUMBER" Name="N_TRANS_KIOSK" />
                        <Attribute Status="Valid" DataType="NUMBER" Name="AGE" />
                        <Attribute Status="Valid" DataType="NUMBER" Name="MONEY_MONTLY_OVERDRAWN" />
                        <Attribute Status="Valid" DataType="NUMBER" Name="LTV" />
                        <Attribute Status="Valid" DataType="NUMBER" Name="T_AMOUNT_AUTOM_PAYMENTS" />
                        <Attribute Status="Valid" DataType="NUMBER" Name="N_TRANS_TELLER" />
                        <Attribute Status="Valid" DataType="NUMBER" Name="CHECKING_AMOUNT" />
                        <Attribute Status="Valid" DataType="NUMBER" Name="N_TRANS_ATM" />
                        <Attribute Status="Valid" DataType="VARCHAR2" Name="LTV_BIN" />
                        <Attribute Status="Valid" DataType="VARCHAR2" Name="LAST" />
                        <Attribute Status="Valid" DataType="NUMBER" Name="N_MORTGAGES" />
                        <Attribute Status="Valid" DataType="NUMBER" Name="CAR_OWNERSHIP" />
                        <Attribute Status="Valid" DataType="VARCHAR2" Name="FIRST" />
                        </Attributes>
                        <SourceTable Name="INSUR_CUST_LTV_SAMPLE" Schema="" />
                        </DataSource>
                        - <DataProfile Status="Ready" Name="Explore Data" Id="10015">
                        <Icon YCOORD="190" XCOORD="197" />
                        <Messages />
                        - <CacheSettings GenerateCache="false" UseFullData="false">
                        <NumberOfRows>2000</NumberOfRows>
                        - <Method>
                        <TopN />
                        </Method>
                        </CacheSettings>
                        <SQLExpression>"N$10015" as (SELECT /*+ inline */ "ATTR", "DATA_TYPE", "NULL_PERCENT", "DISTINCT_CNT", "DISTINCT_PERCENT", "MODE_VALUE", "AVG", "MIN", "MAX", "STD", "VAR", "SKEWNESS", "KURTOSIS", "HISTOGRAMS" FROM {STATS_TABLE} )</SQLExpression>
                        - <DataProfileInput>
                        - <Attributes>
                        <Attribute Status="Valid" DataType="VARCHAR2" Name="MARITAL_STATUS" />
                        <Attribute Status="Valid" DataType="VARCHAR2" Name="STATE" />
                        <Attribute Status="Valid" DataType="NUMBER" Name="CREDIT_BALANCE" />
                        <Attribute Status="Valid" DataType="NUMBER" Name="TIME_AS_CUSTOMER" />
                        <Attribute Status="Valid" DataType="VARCHAR2" Name="CUSTOMER_ID" />
                        <Attribute Status="Valid" DataType="NUMBER" Name="MORTGAGE_AMOUNT" />
                        <Attribute Status="Valid" DataType="NUMBER" Name="BANK_FUNDS" />
                        <Attribute Status="Valid" DataType="NUMBER" Name="N_OF_DEPENDENTS" />
                        <Attribute Status="Valid" DataType="NUMBER" Name="HAS_CHILDREN" />
                        <Attribute Status="Valid" DataType="NUMBER" Name="SALARY" />
                        <Attribute Status="Valid" DataType="VARCHAR2" Name="SEX" />
                        <Attribute Status="Valid" DataType="VARCHAR2" Name="PROFESSION" />
                        <Attribute Status="Valid" DataType="NUMBER" Name="CREDIT_CARD_LIMITS" />
                        <Attribute Status="Valid" DataType="VARCHAR2" Name="REGION" />
                        <Attribute Status="Valid" DataType="NUMBER" Name="HOUSE_OWNERSHIP" />
                        <Attribute Status="Valid" DataType="NUMBER" Name="N_TRANS_WEB_BANK" />
                        <Attribute Status="Valid" DataType="VARCHAR2" Name="BUY_INSURANCE" />
                        <Attribute Status="Valid" DataType="NUMBER" Name="MONTHLY_CHECKS_WRITTEN" />
                        <Attribute Status="Valid" DataType="NUMBER" Name="N_TRANS_KIOSK" />
                        <Attribute Status="Valid" DataType="NUMBER" Name="AGE" />
                        <Attribute Status="Valid" DataType="NUMBER" Name="MONEY_MONTLY_OVERDRAWN" />
                        <Attribute Status="Valid" DataType="NUMBER" Name="LTV" />
                        <Attribute Status="Valid" DataType="NUMBER" Name="T_AMOUNT_AUTOM_PAYMENTS" />
                        <Attribute Status="Valid" DataType="NUMBER" Name="N_TRANS_TELLER" />
                        <Attribute Status="Valid" DataType="NUMBER" Name="CHECKING_AMOUNT" />
                        <Attribute Status="Valid" DataType="NUMBER" Name="N_TRANS_ATM" />
                        <Attribute Status="Valid" DataType="VARCHAR2" Name="LTV_BIN" />
                        <Attribute Status="Valid" DataType="VARCHAR2" Name="LAST" />
                        <Attribute Status="Valid" DataType="NUMBER" Name="N_MORTGAGES" />
                        <Attribute Status="Valid" DataType="NUMBER" Name="CAR_OWNERSHIP" />
                        <Attribute Status="Valid" DataType="VARCHAR2" Name="FIRST" />
                        </Attributes>
                        </DataProfileInput>
                        - <DataProfileOutput>
                        - <Attributes>
                        <Attribute Status="Valid" DataType="VARCHAR2" Name="ATTR" />
                        <Attribute Status="Valid" DataType="VARCHAR2" Name="DATA_TYPE" />
                        <Attribute Status="Valid" DataType="NUMBER" Name="NULL_PERCENT" />
                        <Attribute Status="Valid" DataType="NUMBER" Name="DISTINCT_CNT" />
                        <Attribute Status="Valid" DataType="NUMBER" Name="DISTINCT_PERCENT" />
                        <Attribute Status="Valid" DataType="NVARCHAR2" Name="MODE_VALUE" />
                        <Attribute Status="Valid" DataType="NUMBER" Name="AVG" />
                        <Attribute Status="Valid" DataType="NVARCHAR2" Name="MIN" />
                        <Attribute Status="Valid" DataType="NVARCHAR2" Name="MAX" />
                        <Attribute Status="Valid" DataType="NUMBER" Name="STD" />
                        <Attribute Status="Valid" DataType="NUMBER" Name="VAR" />
                        <Attribute Status="Valid" DataType="NUMBER" Name="SKEWNESS" />
                        <Attribute Status="Valid" DataType="NUMBER" Name="KURTOSIS" />
                        <Attribute Status="Valid" DataType="ODMR_HISTOGRAMS" Name="HISTOGRAMS" />
                        </Attributes>
                        </DataProfileOutput>
                        - <DataProfileSettings>
                        <NumericalBins>10</NumericalBins>
                        <CategoricalBins>10</CategoricalBins>
                        <DateBins>10</DateBins>
                        </DataProfileSettings>
                        <StatisticTable Name="OUTPUT_2_1" />
                        - <SampleSettings GenerateCache="true" UseFullData="false">
                        <NumberOfRows>2000</NumberOfRows>
                        - <Method>
                        <Random Seed="12345" />
                        </Method>
                        </SampleSettings>
                        </DataProfile>
                        </Nodes>
                        - <Links>
                        - <Link Label="From "INSUR_CUST_LTV_SAMPLE" to "Explore Data"" Name="Link" To="10015" From="10001" Id="10016">
                        - <ConnectorGraphicsInfo>
                        <Coordinates YCoordinate="0.0" XCoordinate="0.0" />
                        </ConnectorGraphicsInfo>
                        </Link>
                        </Links>
                        </WorkflowProcess>
                        • 9. Re: OBE flow fails when running Data Explore node
                          888047
                          3)

                          <?xml version="1.0" encoding="UTF-8"?>
                          <WorkflowProcess Version="11.2.1.1.1" xmlns="http://xmlns.oracle.com/odmr11">
                          <Nodes>
                          <DataSource Status="Complete" Name="INSUR_CUST_LTV_SAMPLE" Id="10001">
                          <Icon YCOORD="87" XCOORD="374"/>
                          <Messages/>
                          <CacheSettings GenerateCache="false" UseFullData="false">
                          <NumberOfRows>2000</NumberOfRows>
                          <Method>
                          <TopN/>
                          </Method>
                          </CacheSettings>
                          <SQLExpression>&quot;N$10001&quot; as (select /*+ inline */ &quot;INSUR_CUST_LTV_SAMPLE&quot;.&quot;MARITAL_STATUS&quot;,
                          &quot;INSUR_CUST_LTV_SAMPLE&quot;.&quot;STATE&quot;,
                          &quot;INSUR_CUST_LTV_SAMPLE&quot;.&quot;CREDIT_BALANCE&quot;,
                          &quot;INSUR_CUST_LTV_SAMPLE&quot;.&quot;TIME_AS_CUSTOMER&quot;,
                          &quot;INSUR_CUST_LTV_SAMPLE&quot;.&quot;CUSTOMER_ID&quot;,
                          &quot;INSUR_CUST_LTV_SAMPLE&quot;.&quot;MORTGAGE_AMOUNT&quot;,
                          &quot;INSUR_CUST_LTV_SAMPLE&quot;.&quot;BANK_FUNDS&quot;,
                          &quot;INSUR_CUST_LTV_SAMPLE&quot;.&quot;N_OF_DEPENDENTS&quot;,
                          &quot;INSUR_CUST_LTV_SAMPLE&quot;.&quot;HAS_CHILDREN&quot;,
                          &quot;INSUR_CUST_LTV_SAMPLE&quot;.&quot;SALARY&quot;,
                          &quot;INSUR_CUST_LTV_SAMPLE&quot;.&quot;SEX&quot;,
                          &quot;INSUR_CUST_LTV_SAMPLE&quot;.&quot;PROFESSION&quot;,
                          &quot;INSUR_CUST_LTV_SAMPLE&quot;.&quot;CREDIT_CARD_LIMITS&quot;,
                          &quot;INSUR_CUST_LTV_SAMPLE&quot;.&quot;REGION&quot;,
                          &quot;INSUR_CUST_LTV_SAMPLE&quot;.&quot;HOUSE_OWNERSHIP&quot;,
                          &quot;INSUR_CUST_LTV_SAMPLE&quot;.&quot;N_TRANS_WEB_BANK&quot;,
                          &quot;INSUR_CUST_LTV_SAMPLE&quot;.&quot;BUY_INSURANCE&quot;,
                          &quot;INSUR_CUST_LTV_SAMPLE&quot;.&quot;MONTHLY_CHECKS_WRITTEN&quot;,
                          &quot;INSUR_CUST_LTV_SAMPLE&quot;.&quot;N_TRANS_KIOSK&quot;,
                          &quot;INSUR_CUST_LTV_SAMPLE&quot;.&quot;AGE&quot;,
                          &quot;INSUR_CUST_LTV_SAMPLE&quot;.&quot;MONEY_MONTLY_OVERDRAWN&quot;,
                          &quot;INSUR_CUST_LTV_SAMPLE&quot;.&quot;LTV&quot;,
                          &quot;INSUR_CUST_LTV_SAMPLE&quot;.&quot;T_AMOUNT_AUTOM_PAYMENTS&quot;,
                          &quot;INSUR_CUST_LTV_SAMPLE&quot;.&quot;N_TRANS_TELLER&quot;,
                          &quot;INSUR_CUST_LTV_SAMPLE&quot;.&quot;CHECKING_AMOUNT&quot;,
                          &quot;INSUR_CUST_LTV_SAMPLE&quot;.&quot;N_TRANS_ATM&quot;,
                          &quot;INSUR_CUST_LTV_SAMPLE&quot;.&quot;LTV_BIN&quot;,
                          &quot;INSUR_CUST_LTV_SAMPLE&quot;.&quot;LAST&quot;,
                          &quot;INSUR_CUST_LTV_SAMPLE&quot;.&quot;N_MORTGAGES&quot;,
                          &quot;INSUR_CUST_LTV_SAMPLE&quot;.&quot;CAR_OWNERSHIP&quot;,
                          &quot;INSUR_CUST_LTV_SAMPLE&quot;.&quot;FIRST&quot;
                          from &quot;DMREP&quot;.&quot;INSUR_CUST_LTV_SAMPLE&quot; )</SQLExpression>
                          <Attributes>
                          <Attribute Status="Valid" DataType="VARCHAR2" Name="MARITAL_STATUS"/>
                          <Attribute Status="Valid" DataType="VARCHAR2" Name="STATE"/>
                          <Attribute Status="Valid" DataType="NUMBER" Name="CREDIT_BALANCE"/>
                          <Attribute Status="Valid" DataType="NUMBER" Name="TIME_AS_CUSTOMER"/>
                          <Attribute Status="Valid" DataType="VARCHAR2" Name="CUSTOMER_ID"/>
                          <Attribute Status="Valid" DataType="NUMBER" Name="MORTGAGE_AMOUNT"/>
                          <Attribute Status="Valid" DataType="NUMBER" Name="BANK_FUNDS"/>
                          <Attribute Status="Valid" DataType="NUMBER" Name="N_OF_DEPENDENTS"/>
                          <Attribute Status="Valid" DataType="NUMBER" Name="HAS_CHILDREN"/>
                          <Attribute Status="Valid" DataType="NUMBER" Name="SALARY"/>
                          <Attribute Status="Valid" DataType="VARCHAR2" Name="SEX"/>
                          <Attribute Status="Valid" DataType="VARCHAR2" Name="PROFESSION"/>
                          <Attribute Status="Valid" DataType="NUMBER" Name="CREDIT_CARD_LIMITS"/>
                          <Attribute Status="Valid" DataType="VARCHAR2" Name="REGION"/>
                          <Attribute Status="Valid" DataType="NUMBER" Name="HOUSE_OWNERSHIP"/>
                          <Attribute Status="Valid" DataType="NUMBER" Name="N_TRANS_WEB_BANK"/>
                          <Attribute Status="Valid" DataType="VARCHAR2" Name="BUY_INSURANCE"/>
                          <Attribute Status="Valid" DataType="NUMBER" Name="MONTHLY_CHECKS_WRITTEN"/>
                          <Attribute Status="Valid" DataType="NUMBER" Name="N_TRANS_KIOSK"/>
                          <Attribute Status="Valid" DataType="NUMBER" Name="AGE"/>
                          <Attribute Status="Valid" DataType="NUMBER" Name="MONEY_MONTLY_OVERDRAWN"/>
                          <Attribute Status="Valid" DataType="NUMBER" Name="LTV"/>
                          <Attribute Status="Valid" DataType="NUMBER" Name="T_AMOUNT_AUTOM_PAYMENTS"/>
                          <Attribute Status="Valid" DataType="NUMBER" Name="N_TRANS_TELLER"/>
                          <Attribute Status="Valid" DataType="NUMBER" Name="CHECKING_AMOUNT"/>
                          <Attribute Status="Valid" DataType="NUMBER" Name="N_TRANS_ATM"/>
                          <Attribute Status="Valid" DataType="VARCHAR2" Name="LTV_BIN"/>
                          <Attribute Status="Valid" DataType="VARCHAR2" Name="LAST"/>
                          <Attribute Status="Valid" DataType="NUMBER" Name="N_MORTGAGES"/>
                          <Attribute Status="Valid" DataType="NUMBER" Name="CAR_OWNERSHIP"/>
                          <Attribute Status="Valid" DataType="VARCHAR2" Name="FIRST"/>
                          </Attributes>
                          <SourceTable Name="INSUR_CUST_LTV_SAMPLE" Schema="DMREP"/>
                          </DataSource>
                          <DataProfile Status="Ready" Name="Explore Data" Id="10015">
                          <Icon YCOORD="190" XCOORD="197"/>
                          <Messages/>
                          <CacheSettings GenerateCache="false" UseFullData="false">
                          <NumberOfRows>2000</NumberOfRows>
                          <Method>
                          <TopN/>
                          </Method>
                          </CacheSettings>
                          <SQLExpression>&quot;N$10015&quot; as (SELECT
                          /*+ inline */ &quot;ATTR&quot;,
                          &quot;DATA_TYPE&quot;,
                          &quot;NULL_PERCENT&quot;,
                          &quot;DISTINCT_CNT&quot;,
                          &quot;DISTINCT_PERCENT&quot;,
                          &quot;MODE_VALUE&quot;,
                          &quot;AVG&quot;,
                          &quot;MIN&quot;,
                          &quot;MAX&quot;,
                          &quot;STD&quot;,
                          &quot;VAR&quot;,
                          &quot;SKEWNESS&quot;,
                          &quot;KURTOSIS&quot;,
                          &quot;HISTOGRAMS&quot;
                          FROM {STATS_TABLE} )</SQLExpression>
                          <DataProfileInput>
                          <Attributes>
                          <Attribute Status="Valid" DataType="VARCHAR2" Name="MARITAL_STATUS"/>
                          <Attribute Status="Valid" DataType="VARCHAR2" Name="STATE"/>
                          <Attribute Status="Valid" DataType="NUMBER" Name="CREDIT_BALANCE"/>
                          <Attribute Status="Valid" DataType="NUMBER" Name="TIME_AS_CUSTOMER"/>
                          <Attribute Status="Valid" DataType="VARCHAR2" Name="CUSTOMER_ID"/>
                          <Attribute Status="Valid" DataType="NUMBER" Name="MORTGAGE_AMOUNT"/>
                          <Attribute Status="Valid" DataType="NUMBER" Name="BANK_FUNDS"/>
                          <Attribute Status="Valid" DataType="NUMBER" Name="N_OF_DEPENDENTS"/>
                          <Attribute Status="Valid" DataType="NUMBER" Name="HAS_CHILDREN"/>
                          <Attribute Status="Valid" DataType="NUMBER" Name="SALARY"/>
                          <Attribute Status="Valid" DataType="VARCHAR2" Name="SEX"/>
                          <Attribute Status="Valid" DataType="VARCHAR2" Name="PROFESSION"/>
                          <Attribute Status="Valid" DataType="NUMBER" Name="CREDIT_CARD_LIMITS"/>
                          <Attribute Status="Valid" DataType="VARCHAR2" Name="REGION"/>
                          <Attribute Status="Valid" DataType="NUMBER" Name="HOUSE_OWNERSHIP"/>
                          <Attribute Status="Valid" DataType="NUMBER" Name="N_TRANS_WEB_BANK"/>
                          <Attribute Status="Valid" DataType="VARCHAR2" Name="BUY_INSURANCE"/>
                          <Attribute Status="Valid" DataType="NUMBER" Name="MONTHLY_CHECKS_WRITTEN"/>
                          <Attribute Status="Valid" DataType="NUMBER" Name="N_TRANS_KIOSK"/>
                          <Attribute Status="Valid" DataType="NUMBER" Name="AGE"/>
                          <Attribute Status="Valid" DataType="NUMBER" Name="MONEY_MONTLY_OVERDRAWN"/>
                          <Attribute Status="Valid" DataType="NUMBER" Name="LTV"/>
                          <Attribute Status="Valid" DataType="NUMBER" Name="T_AMOUNT_AUTOM_PAYMENTS"/>
                          <Attribute Status="Valid" DataType="NUMBER" Name="N_TRANS_TELLER"/>
                          <Attribute Status="Valid" DataType="NUMBER" Name="CHECKING_AMOUNT"/>
                          <Attribute Status="Valid" DataType="NUMBER" Name="N_TRANS_ATM"/>
                          <Attribute Status="Valid" DataType="VARCHAR2" Name="LTV_BIN"/>
                          <Attribute Status="Valid" DataType="VARCHAR2" Name="LAST"/>
                          <Attribute Status="Valid" DataType="NUMBER" Name="N_MORTGAGES"/>
                          <Attribute Status="Valid" DataType="NUMBER" Name="CAR_OWNERSHIP"/>
                          <Attribute Status="Valid" DataType="VARCHAR2" Name="FIRST"/>
                          </Attributes>
                          </DataProfileInput>
                          <DataProfileOutput>
                          <Attributes>
                          <Attribute Status="Valid" DataType="VARCHAR2" Name="ATTR"/>
                          <Attribute Status="Valid" DataType="VARCHAR2" Name="DATA_TYPE"/>
                          <Attribute Status="Valid" DataType="NUMBER" Name="NULL_PERCENT"/>
                          <Attribute Status="Valid" DataType="NUMBER" Name="DISTINCT_CNT"/>
                          <Attribute Status="Valid" DataType="NUMBER" Name="DISTINCT_PERCENT"/>
                          <Attribute Status="Valid" DataType="NVARCHAR2" Name="MODE_VALUE"/>
                          <Attribute Status="Valid" DataType="NUMBER" Name="AVG"/>
                          <Attribute Status="Valid" DataType="NVARCHAR2" Name="MIN"/>
                          <Attribute Status="Valid" DataType="NVARCHAR2" Name="MAX"/>
                          <Attribute Status="Valid" DataType="NUMBER" Name="STD"/>
                          <Attribute Status="Valid" DataType="NUMBER" Name="VAR"/>
                          <Attribute Status="Valid" DataType="NUMBER" Name="SKEWNESS"/>
                          <Attribute Status="Valid" DataType="NUMBER" Name="KURTOSIS"/>
                          <Attribute Status="Valid" DataType="ODMR_HISTOGRAMS" Name="HISTOGRAMS"/>
                          </Attributes>
                          </DataProfileOutput>
                          <DataProfileSettings>
                          <NumericalBins>10</NumericalBins>
                          <CategoricalBins>10</CategoricalBins>
                          <DateBins>10</DateBins>
                          </DataProfileSettings>
                          <StatisticTable Name="OUTPUT_2_1"/>
                          <SampleSettings GenerateCache="true" UseFullData="false">
                          <NumberOfRows>2000</NumberOfRows>
                          <Method>
                          <Random Seed="12345"/>
                          </Method>
                          </SampleSettings>
                          </DataProfile>
                          </Nodes>
                          <Links>
                          <Link Label="From &quot;INSUR_CUST_LTV_SAMPLE&quot; to &quot;Explore Data&quot;" Name="Link" To="10015" From="10001" Id="10016">
                          <ConnectorGraphicsInfo>
                          <Coordinates YCoordinate="0" XCoordinate="0"/>
                          </ConnectorGraphicsInfo>
                          </Link>
                          </Links>
                          </WorkflowProcess>
                          • 10. Re: OBE flow fails when running Data Explore node
                            888047
                            Diffs between 2 and 3 above that I am seeing:

                            <?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
                            <SourceTable Name="INSUR_CUST_LTV_SAMPLE" Schema="" />

                            Continuing with the responses..

                            4. select dbms_utility.port_string from dual returns

                            x86_64/Linux 2.4.xx

                            5. Connections are basic, using SID, no special authentication (OS authentication unchecked, Kerberos authentication unchecked, Proxy Connection unchecked).

                            6. No. Client is a desktop that is running VPN to connect to company network. DB is inside firewall. DB is a copy of a production DW environment and I don't have entire history of its creation. I could try to dig up more info if needed.
                            • 11. Re: OBE flow fails when running Data Explore node
                              Mark Kelly-Oracle
                              As best we can tell, there is something odd going on with the Oracle XML DB query used to extract out the workflow.
                              It could be some install issue, not sure.
                              We are querying the xml db team to see if they can provide any insight on how to diagnose this.

                              Couple of other ideas:

                              1) Check for db compatibility level. This can be a gotcha, and we do not test for yet in the installation process:

                              COLUMN name FORMAT A20
                              COLUMN value FORMAT A15
                              COLUMN description FORMAT A40
                              SELECT name, value, description FROM v$parameter
                              WHERE name = 'compatible';

                              2)I expect if you run the following query you will probably see the Explore data node, because the element is the first one in the query.

                              SELECT WORKFLOW_ID, xtab.*
                              FROM odmrsys.ODMR$WORKFLOWS x,
                              XMLTable(XMLNAMESPACES(DEFAULT 'http://xmlns.oracle.com/odmr11'),
                              'for $i in (
                              /WorkflowProcess/Nodes/DataProfile,
                              /WorkflowProcess/Nodes/DataSource,
                              /WorkflowProcess/Nodes/CreateTable,
                              /WorkflowProcess/Nodes/UpdateTable,
                              /WorkflowProcess/Nodes/Transformation,
                              /WorkflowProcess/Nodes/Aggregation,
                              /WorkflowProcess/Nodes/Join,
                              /WorkflowProcess/Nodes/BuildTextRef,
                              /WorkflowProcess/Nodes/BuildText,
                              /WorkflowProcess/Nodes/ApplyText,
                              /WorkflowProcess/Nodes/Sample,
                              /WorkflowProcess/Nodes/ColumnFilter,
                              /WorkflowProcess/Nodes/RowFilter,
                              /WorkflowProcess/Nodes/ClassificationBuild,
                              /WorkflowProcess/Nodes/RegressionBuild,
                              /WorkflowProcess/Nodes/ClusteringBuild,
                              /WorkflowProcess/Nodes/AssociationBuild,
                              /WorkflowProcess/Nodes/FeatureExtractionBuild,
                              /WorkflowProcess/Nodes/AnomalyDetectionBuild,
                              /WorkflowProcess/Nodes/Model,
                              /WorkflowProcess/Nodes/Apply,
                              /WorkflowProcess/Nodes/Test,
                              /WorkflowProcess/Nodes/ModelDetails,
                              /WorkflowProcess/Nodes/TestDetails,
                              /WorkflowProcess/Nodes/FilterDetails
                              )
                              return $i'
                              PASSING x.WORKFLOW_DATA
                              COLUMNS Type VARCHAR2(30) PATH 'name()',
                              Id VARCHAR2(30) PATH '@Id',
                              Name VARCHAR2(30) PATH '@Name',
                              Status VARCHAR2(30) PATH '@Status') xtab
                              where WORKFLOW_ID = 1;

                              Thanks, Mark
                              • 12. Re: OBE flow fails when running Data Explore node
                                888047
                                OK - thanks, Mark.

                                1) Compatibility level:

                                NAME VALUE DESCRIPTION
                                -------------------- --------------- ----------------------------------------
                                compatible 11.2.0.3.0 Database will be completely compatible w
                                ith this software version

                                I know that this has been changed on the DB side from 10g to 11g at some point, though I am pretty sure my last install of ODM was done after the change.

                                2) Yes, this SQL does return the Explore Data node:

                                WORKFLOW_ID TYPE ID NAME STATUS
                                ----------- ------------------------------ ------------------------------ -------------------- ------------------------------
                                1 DataProfile 10015 Explore Data Ready
                                • 13. Re: OBE flow fails when running Data Explore node
                                  Mark Kelly-Oracle
                                  Well, the only thing that has come out of further discussions with the xml db folks, is that this most likely a db configuration issue. Maybe there was some patch applied that has affected the behavior.
                                  There was a suggestion that you could possibly try reinstalling xdb (install script is "catqm.sql", uninstall script is "catnoqm.sql") but it is doubtful that is the source of the problem.
                                  So it may not be easy to resolve.
                                  If you have a Oracle Support license, you could open up a ticket.
                                  Another option would be to create a new clean db from scratch.
                                  Sorry that is all I can come up with right now, Mark
                                  • 14. Re: OBE flow fails when running Data Explore node
                                    888047
                                    Allright - no worries and thanks for all the help, Mark. I will likely try the ODM install on another DB. It was very nice to see the quick responses, and I certainly learned from the exchange, which was great. Thank you again, Mark.