nc.zip

注：本文适用于仅适用于Windows。

症状

在Windows任务调度报告创建的任务成功运行，但FME工作台日志表明该翻译是失败的。有可能是在工作空间日志文件中的错误类似下面：

2016-10-05 10:00:58| 1.8| 0.0|INFORM|Microsoft SQL Server Non-Spatial Reader: Read 1 DEF line(s). Found 0 attribute(s) 2016-10-05 10:00:58| 1.8| 0.0|INFORM|Microsoft SQL Server Non-Spatial Reader: Opening `TABLE' for read operation 2016-10-05 10:00:58| 1.8| 0.0|INFORM|Microsoft SQL Server Non-Spatial Reader: Trying to connect using SQL Server 2012 Native Client... 2016-10-05 10:00:58| 1.9| 0.1|ERROR |Microsoft SQL Server Non-Spatial Reader: Failed to connect using SQL Server 2012 Native Client. Provider error '(-2147217843) Invalid authorization specification'. Connection string 'Provider=DB_NAME;DataTypeCompatibility=80;Data Source=;Initial Catalog=TABLE_NAME;User ID=;Password=********' 2016-10-05 10:00:58| 1.9| 0.0|INFORM|Microsoft SQL Server Non-Spatial Reader: Trying to connect using SQL Server 2008 Native Client... 2016-10-05 10:00:58| 1.9| 0.0|ERROR |Microsoft SQL Server Non-Spatial Reader: Failed to connect using SQL Server 2008 Native Client. Provider error '(-2146824582) Provider cannot be found. It may not be properly installed.'. Connection string 'Provider=DB_NAME;DataTypeCompatibility=80;Data Source=;Initial Catalog=TABLE_NAME;User ID=;Password=********' 2016-10-05 10:00:58| 1.9| 0.0|ERROR |Failed to open reader 2016-10-05 10:00:58| 1.9| 0.0|INFORM|FME Session Duration: 1.8 seconds. (CPU: 0.6s user, 0.2s system) 2016-10-05 10:00:58| 1.9| 0.0|INFORM|END - ProcessID: 9440, peak process memory usage: 272396 kB, current process memory usage: 272396 kB

Cause

如果Windows任务计划用于部署FME工作空间和运行它们为“默认用户”，然后FME工作台将不能够正确的路径设置为数据库或网络连接文件。This will prevent passing any credentials into Readers or Transformers connecting to a database and the workspace translation will fail.

解析度

For this situation, the registry must be set manually to indicate to FME.exe where the named connection file is located. The information is set in the HKLM hive where FME.exe looks if the keys are not present in the HKLU hive.The steps below assume the connection files have already been made public as outlined in制作数据库和Web连接公共.

管理员权限需要配置使用以下步骤的默认用户。

Edit the attached .reg file

Unzip the attached file nc.zip file. Open the nc.reg file in a text editor and modify the line "Named Connection Directory"="c:\\dbtest" to replace it with the path to the connection file on the shared directory. When editing the path, be sure to escape the \ character in the paths by entering \\. (ie: c:\\stellar\\test)

执行.reg文件

双击.reg文件将其导入到HKLM（HKEY_LOCAL_MACHINE注册表项）。

HKEY_LOCAL_MACHINE \ SOFTWARE \ WOW6432N亚搏在线ode \安全软件公司\功能操纵引擎\设置或

HKEY_LOCAL_MACHINE\SOFTWARE\Safe Software Inc.\Feature Manipulation Engine\Settings should now exist in the registry on the machine