OBE flow fails when running Data Explore node
888047Mar 8 2012 — edited Apr 7 2012I 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?