I am using the DateTimeConverter in a workbench to convert date and time from an Oracle database to an ArcGIS Online feature service. The autodetect feature works in the workbench and the translation is successful. However, when I upload the workbench to the server, the DateTimeConverter is unable to autodetect the date/time value from the input and the translation fails. Has anyone faced and resolved this situation?
Solved
DateTimeConverter - FME Server
+1- Contributor
Best answer by takashi
Hi @surbhi, I think datetime values read from an Oracle database table can be treated fine with the auto-detect mode usually, but exceptionally, if the datetime field stored <null>, the DateTimeConverter would reject it and cause translation failure. Firstly check if there could be null datetime.
+15- Contributor
There are many situations where autodetect fails.
Just enter the input format is advised.
+19- Contributor
- Best Answer
Hi @surbhi, I think datetime values read from an Oracle database table can be treated fine with the auto-detect mode usually, but exceptionally, if the datetime field stored <null>, the DateTimeConverter would reject it and cause translation failure. Firstly check if there could be null datetime.
+1- Contributor
takashi wrote:
Hi @surbhi, I think datetime values read from an Oracle database table can be treated fine with the auto-detect mode usually, but exceptionally, if the datetime field stored <null>, the DateTimeConverter would reject it and cause translation failure. Firstly check if there could be null datetime.
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.