span8
span4
span8
span4
你好,
I have an issue when trying to set up a scheduled task to run a workspace with FME Desktop 2018.1.
FME is installed on a windows server.
我创建了以下文件的文件夹:
This folder is setted up in the FME Options (default paths), with the full path "\\servername\path\to\folder" for the fme_connections.data and "\\servername\path\to\folder\fme_publicKey.jceks" for the public key.
连接是公共(选中复选框),如https://knowledge.亚搏在线safe.com/articles/34678/making-database-and-web-connections-public.html
我做这个设置与我的personnal用户帐户。
我和我的同事的管理员用户帐户打开FME和设置好的了默认路径了。
The task was created by my colleague with her admin user account.
Set to daily at a fixed hour.
只有1个行动“启动程序”
程序/脚本=
“C: \程序文件(x86)\FME\fme.exe"
Add arguments (optional) =
“\\服务器\路径\到\工作空间\ workspacename.fmw” - SourceDataset_ORACLE_NONSPATIAL “ORACLE <空格> SIGD” --Excel_file “\\服务器\ paht \到\另一个\文件夹\ FileToUpdate.xlsx”
Note : I changed the paths to put my logs online and changed the 'wrong username' userfolder name to WRONG_USER.
2020年2月4日11:26:12 |0.3 |0.3 |INFORM|FME 2018.1.1.2 (20190121 - Build 18586 - WIN32) 2020-02-04 11:26:12| 0.3| 0.0|INFORM|FME_HOME is 'C:\Program Files (x86)\FME\' 2020-02-04 11:26:12| 0.3| 0.0|INFORM|FME Database Edition (node locked-crc) 2020-02-04 11:26:12| 0.3| 0.0|INFORM|Serial Number: XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX 2020-02-04 11:26:12| 0.3| 0.0|INFORM|Permanent License. 2020-02-04 11:26:12| 0.3| 0.0|INFORM|Machine host name is: xxxxxxxxxx 2020-02-04 11:26:12| 0.3| 0.0|INFORM|START - ProcessID: 16932, peak process memory usage: 29832 kB, current process memory usage: 29732 kB 2020-02-04 11:26:12| 0.3| 0.0|INFORM|FME Configuration: Command line arguments are `C:\Program Files (x86)\FME\fme.exe' `\\servername\path\to\workspace\workspaceName.fmw' `--SourceDataset_ORACLE_NONSPATIAL' `ORACLESIGD' `--ExcelFile' `\\servername\path\to\another\folder\FileToUpdate.xlsx'2020年2月4日11:26:12 |0.3 |0.0 | INFORM | FME配置:连接存储: 'C:\用户\ WRONG_USER \应用程序数据\漫游\安全软件\ FME \'亚搏在线2020年2月4日11:26:12 |0.3 |0.1 | INFORM |为格式共享文件夹是:C:\程序文件(x86)\ FME \数据源; C:\用户\ WRONG_USER \文件\ FME \格式2020年2月4日11:26:12 |0.3 |0.0 | INFORM |变压器共享文件夹为:C:\用户\ WRONG_USER \应用程序数据\漫游\安全软件\ FME \包\ 18586-的Win32 \变压器;亚搏在线 C:\ Program Files文件(x86)的\ FME \变压器; C:\用户\ WRONG_USER \文件\ FME \变形金刚2020年2月4日11:26:12 |0.3 |0.0 | INFORM |共用坐标系统文件夹为:C:\用户\ WRONG_USER \文件\ FME \ CoordinateSystems 2020年2月4日11:26:12 |0.3 |0.0 | INFORM |共用坐标系统异常文件夹为:C:\用户\ WRONG_USER \文件\ FME \ CoordinateSystemExceptions 2020年2月4日11:26:12 |0.3 | 0.0|INFORM|Shared folders for coordinate system grid overrides are : C:\Users\WRONG_USER\Documents\FME\CoordinateSystemGridOverrides 2020-02-04 11:26:12| 0.3| 0.0|INFORM|Shared folders for CS-MAP transformation exceptions are : C:\Users\WRONG_USER\Documents\FME\CsmapTransformationExceptions 2020-02-04 11:26:12| 0.3| 0.0|INFORM|Shared folders for transformer categories are : C:\Users\WRONG_USER\Documents\FME\TransformerCategories 2020-02-04 11:26:12| 0.3| 0.0|INFORM|FME Configuration: Reader Keyword is `MULTI_READER' 2020-02-04 11:26:12| 0.3| 0.0|INFORM|FME Configuration: Writer Keyword is `MULTI_WRITER' 2020-02-04 11:26:12| 0.3| 0.0|INFORM|FME Configuration: Writer Group Definition Keyword is `MULTI_WRITER_DEF' 2020-02-04 11:26:12| 0.3| 0.0|INFORM|FME Configuration: Reader type is `MULTI_READER' 2020-02-04 11:26:12| 0.3| 0.0|INFORM|FME Configuration: Writer type is `MULTI_WRITER' 2020-02-04 11:26:12| 0.3| 0.0|INFORM|FME Configuration: No destination coordinate system set 2020-02-04 11:26:12| 0.3| 0.0|INFORM|FME Configuration: Current working folder is `C:\Windows\System32' 2020-02-04 11:26:12| 0.3| 0.0|INFORM|FME Configuration: Temporary folder is `C:\Users\TEMPSD~1.000\AppData\Local\Temp', set from environment variable `TEMP' 2020-02-04 11:26:12| 0.3| 0.0|INFORM|FME Configuration: FME_HOME is `C:\Program Files (x86)\FME\' 2020-02-04 11:26:12| 0.3| 0.0|INFORM|FME Configuration: FME_BASE is 'no' 2020-02-04 11:26:12| 0.3| 0.0|INFORM|FME Configuration: FME_MF_DIR is '\\servername\path\to\workspace\/' 2020-02-04 11:26:12| 0.3| 0.0|INFORM|FME Configuration: FME_MF_NAME is 'workspaceName.fmw' 2020-02-04 11:26:12| 0.3| 0.0|INFORM|FME Configuration: FME_PRODUCT_NAME is 'FME(R) 2018.1.1.2' 2020-02-04 11:26:12| 0.3| 0.0|INFORM|System Status: 14.58 GB of disk space available in the FME temporary folder (C:\Users\TEMPSD~1.000\AppData\Local\Temp) 2020-02-04 11:26:12| 0.3| 0.0|INFORM|System Status: 4.00 GB of virtual memory available 2020-02-04 11:26:12| 0.3| 0.0|INFORM|Operating System: Microsoft Windows Server 10 Server 4.0 64-bit (Build 14393) 2020-02-04 11:26:12| 0.3| 0.0|INFORM|FME Platform: WIN32 2020-02-04 11:26:12| 0.3| 0.0|INFORM|Locale: fr_FR 2020-02-04 11:26:12| 0.3| 0.0|INFORM|Code Page: 1252 (ANSI - latin I) 2020-02-04 11:26:12| 0.3| 0.0|INFORM|FME Configuration: Process limits are 7.95 GB of physical memory and 4.00 GB of address space 2020-02-04 11:26:12| 0.3| 0.0|INFORM|FME Configuration: Start freeing memory when process usage exceeds 2.83 GB of memory or 3.41 GB of address space 2020-02-04 11:26:12| 0.3| 0.0|INFORM|FME Configuration: Stop freeing memory when process usage is below 2.12 GB of memory and 2.56 GB of address space 2020-02-04 11:26:12| 0.4| 0.0|INFORM|Creating writer for format: 2020-02-04 11:26:12| 0.4| 0.0|INFORM|Creating reader for format: 2020-02-04 11:26:12| 0.4| 0.0|INFORM|MULTI_READER(MULTI_READER): Will fail with first member reader failure 2020-02-04 11:26:12| 0.4| 0.0|INFORM|MULTI_READER(MULTI_READER): Adding ORACLE_NONSPATIAL Reader with keyword ORACLE_NONSPATIAL_1 2020-02-04 11:26:12| 0.4| 0.0|INFORM|Using Multi Reader with keyword `MULTI_READER' to read multiple datasets 2020-02-04 11:26:19| 8.9| 8.6|INFORM|Creating reader for format: Oracle Non-Spatial2020年2月4日11:26:19 |9.0 |0.1 | INFORM | ORACLE阅读器:使用Oracle阅读器读取来自数据库表` '服务器类型`ORACLE8I',服务器名称`ORACLE <空间> SIGD '用户名`',密码`***”2020年2月4日11:26:19 |9.0 |0.0|INFORM|ORACLE Reader: Using Rich geometry. 2020-02-04 11:26:19| 9.1| 0.0|INFORM|Loaded module 'OCI' from file 'OCI.dll' 2020-02-04 11:26:21| 11.3| 2.3|INFORM|Environment variable ORACLE_HOME is not set. 2020-02-04 11:26:21| 11.3| 0.0|INFORM|Connecting to ORACLE database `ORACLE SIGD' with user name of `' and password of `***' 2020-02-04 11:26:21| 11.3| 0.0|WARN |FME_HOME folder contains the following characters: "(", ")". This may cause a connection error with older Oracle clients. FME_HOME is 'C:\Program Files (x86)\FME\' 2020-02-04 11:26:21| 11.3| 0.0|ERROR |Error connecting to Oracle database: message was `ORA-12154: TNS : l'identificateur de connexion indiqué n'a pas pu être résolu'. (serverType=`ORACLE8i', serverName=`ORACLE SIGD', userName=`', password=`***', dbname=`') 2020-02-04 11:26:21| 11.3| 0.0|INFORM|Translation FAILED with 1 error(s) and 1 warning(s) (0 feature(s) output) 2020-02-04 11:26:21| 11.3| 0.0|INFORM|FME Session Duration: 9.8 seconds. (CPU: 10.6s user, 0.5s system) 2020-02-04 11:26:21| 11.3| 0.0|INFORM|END - ProcessID: 16932, peak process memory usage: 180472 kB, current process memory usage: 180468 kB
What can I do to ensure that the connection file will be found when runing the task, so that the connection to oracle will be ok ?
嗨,
显然,问题是在服务器端。
The WRONG_USER folder in Users folders is in reality a temp profile which is used by Windows due to the fact that it can't open a session with the desired profile.
我完全不知道为什么就目前而言,我让我的同事IT调查。
我发现几个环节进行调查,我与大家分享在这里:
而且,关于这对于Windows Server 2012中的修复:https://support.microsoft.com/en-us/help/2896328/fix-you-are-logged-on-with-a-temporary-profile-to-a-remote-desktop-ses
Wait and see...
你好@ p.jeremie...只是抛出一些建议,我的情况下,找到了你还没有尝试过这些:
I hope one of these helps!
© 2020 Safe Software Inc |Legal