解决在创建进程流位置是遇到的问题：连接成功，无法检索工作流版本

错误：

连接成功，无法检索工作流版本

The connection was successful, but failed toretrieve workflow version

问题：

I created a Workflowlocation. But it prompt "The connection was successful, but failed toretrieve workflow version.", when test theconnection.
Does this problem affect execution of process flows? How to fix it? 

回答：

You need to connect with the OWF_MGR user. To do that youneed to run the Workflow Configuration Assistant. It is located in:

<oracle_home>\owb\wf\install\(call)  wfinstall.bat

在出现的界面，填写如下类似的信息：

After completing the assistant you have to give the appropiate privileges tothe user:

GRANT EXECUTE ANY PROCEDURE TO owf_mgr;

当然，只有上面这一个措施，还不够完全解决该错误，因为会在部署进程流包时，提示RPE-02260: Database User OWF_MGR must be a Control Center User. Please use the OWB Design Client against the Control Center repository to grant the Control Center User role。故而还要进行以下一步操作：

注释：Control Center User（控制中心用户）是OWB用户的另一种说法，两者指的是同一个概念。

Register the Oracle Workflow User（即使用OWB安全UI使owf_mgr称为OWB用户。）

You need to grant specific roles to the Oracle Workflow(OWF) user,owf_mgr, for it to have the privileges to execute a process flow in the Control Center.

You do not have to embed the password for the Control Center in database-links owned by the OWF user. The Control Center user is highly privileged and its password is tightly controlled.

To register the OWF user, you use the Register Warehouse Builder Users wizard from the Security > Users node in Global Explorer panel. To get access to the security node, ensure you log in to the design center asthe repository owner（确切说是，工作区所有者用户，非owbsys这个用户，这个用户不能登录设计中心的）.

1.

If not already logged in, log in to the Design Center with username/password asrep_owner/rep_owner.

In the Global Explorer panel, expand the Security node. Right-click theUsers node and selectNew.

Note: You must save or revert your changes before creating a new user. To save previous changes, selectSave All from the Design menu or click on the toolbar.

The Create User dialog appears.

 

2.

On the Create User dialog, you can select from the available list of database users or create a new one that will be automatically registered as Warehouse Builder user.

Earlier in this lesson, where you were instructed to install Oracle Workflow Server, you were instructed to use the Oracle Workflow Configuration Assistant and specify owf_mgr as the Workflow Account. This resulted in the creation of owf_mgr as a database user. Select owf_mgr from the Available DB Users list and click> to move it to Selected Users list. ClickOK.

Notice that owf_mgr user is added to the Security > Users node in the Global Explorer panel.

参考：Designing ETL Data Flow Mappings【OWB 11g Release 1】

解决问题RPE-02260：数据库用户owf_mgr必须是控制中心用户。

附加：

have you installed workflowand created a workflow schema successfully?
Connect to the schema using SQL*Plus and execute

select TEXT from WF_RESOURCES where NAME='WF_VERSION';

用于查看oracle workflow的版本

参考：

Failed to retrieve Workflow version       谷歌

https://community.oracle.com/thread/1066784?start=0&tstart=0

============================================================

Prerequisites

3.

Download Oracle Workflow Server 2.6.4 from here and install it in your Oracledatabase home. (Download the Oracle Database 10g Companion CD Release 2, which contains Workflow Server. This installation uses Oracle Universal Installer.)

Note: You can also use Oracle Workflow Server 2.6.3 with Oracle Warehouse Builder 10g Release 2.

 

 

4.

After installing Oracle Workflow Server in your Oracle database home, run theWorkflow Configuration Assistant to create theowf_mgr Workflow schema.

From the Start menu clickPrograms >Oracle<Database HOME> >Configuration and Migration Tools>Workflow Configuration Assistant. The Assistant is started.

Note for Oracle Workflow 2.6.3: Enter the following values:

Workflow Account: (Accept the default ) owf_mgr
Workflow Password: owf_mgr
SYS Password : <Enter the SYS account password>
Accept the default for
Install Option
Language Selection
Connect Method
Connect String: orcl OR <Enter the database name that you are using for this OBE>
Hostname: localhost
JDBC Connection: localhost:1521:orcl
Click Submit

The Workflow Configuration Assistant window disappears and the command window displays theowf_mgr schema creation progress details. Do not close this command window. On successful completion, the command window will close automatically. The schema creation takes several minutes. A dialog box appears saying that Workflow Configuration has successfully completed.

Click OK. The command window closes automatically.

Note for Oracle Workflow 2.6.4:When you run theWorkflow Configuration Assistant, you need to specify the database connect string in the TNS Connect Descriptor box.

Enter the following values:

Accept the default for Install Option

Workflow Account: (Accept the default ) owf_mgr
Workflow Password: owf_mgr

SYS Password : <Enter the SYS account password>

TNS Connect Descriptor: localhost:1521:orcl

Click Submit.

Register the Oracle Workflow User

You need to grant specific roles to the Oracle Workflow(OWF) user, owf_mgr, for it to have the privileges to execute a process flow in the Control Center.

The step of registering the Oracle Workflow user, owf_mgr, is because of the new security model. This new security model means that you do not have to embed the password for the Control Center in database-links owned by the OWF user. The Control Center user is highly privileged and its password is tightly controlled.

To register the OWF user, you use the Register Warehouse Builder Users wizard from the Security > Users node in Global Explorer panel. To get access to the security node, ensure you log in to the design center as the repository owner.

1.

If not already logged in, log in to the Design Center with username/password asrep_owner/rep_owner.

In the Global Explorer panel, expand the Security node. Right-click theUsers node and selectNew.

Note: You must save or revert your changes before creating a new user. To save previous changes, selectSave All from the Design menu or click on the toolbar.

The Register Warehouse Builder Users Wizard is launched. Click Next on the Welcome page.

 

2.

On the Select DB user to register page, you can select from the available list of database users or create a new one that will be automatically registered as Warehouse Builder target user.

Select owf_mgr from the Available DB Users list and click > to move it to Selected Users list.

 

3.

On the Check user as target schema page, de-select the Used as target schemaoption. You need not make OWF user, a target user. ClickNext.

On the Summary page, examine the details and click Finish. The Fix Database Default Role for Users dialog box diaplays.

 

4.

In the Fix Database Default Role for Users dialog box, enter sys or<your SYS password> in SYSDBA Password field in the Fix Now section.

Click OK. Notice that owf_mgr user gets added inside theSecurity > Users node, in the Global Explorer panel.

参考：

DesigningETL Data Flow Mappings

Designing ETL Data Flow Mappings【 OWB 10g Releases 1 and 2】

==================================================================

1 环境配置

建议直接安装Oracle 11g（如Oracle 11.2.0.1.0），其安装包中直接包含了OWB和依赖的组件。若使用Oracle 10g（如Oracle 10.2.0.1）则需要下载Oracle数据库安装包和Oracle Database 10g Companion CD Release 2 (10.2.0.1.0)，后者包含OWB所必须的Oracle Workflow Server和Oracle HTTP Server。

安装Oracle Workflow（针对Oracle 10g）

注意：不要通过执行companion目录下的setup.exe文件来安装，而是通过选择你本机上已经安装好的oracle 10g R2的Universal Installer来安装，在Oracle Universal Installer: 指定源位置界面中，点击“浏览”按钮，定位companion\stage\products.xml文件，然后点击“下一步”按钮，选择“Oracle Database 10g Products 10.2.0.1.0”即可正常安装这些组件。步骤如下：

安装了oracle10g，在D:\oracle\product\10.2.0下。
安装了OWB10g2，在D:\oracle\product\10.2.0\OWB下。
下载了Oracle Workflow 2.6.4。安装时候，指定主目录详细信息如下：
名称：OraDb10g_home1
路径：D:\oracle\product\10.2.0\db_1
安装Oracle Workflow 2.6.4的过程，在“选择要安装的产品”窗口，选择了第二项，即“Oracle Database 10g Products 10.2.0.1.0”。此时已包括了HTTP Server的安装。

Oracle Workflow 2.6.4安装后，配置 Workflow Configuration Assistant。

最后，你需要赋予owf_mgr “EXECUTE ANY PROCEDURE” 的权限，用sys 账号连到SQL Plus，并赋予owf_mgr 如下权限. 
grant execute any procedure to owf_mgr; 

（*）若要单独安装Oracle Workflow，则选择Oracle Database10g Companion Product；若要安装HTTP Server则选择Oracle HTML DB 10.2.0.1.0。

参考：http://blog.csdn.net/kingzone_2008/article/details/8921970