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
+2- 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.
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+15- Contributor
There are many situations where autodetect fails.
Just enter the input format is advised.
- 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.
+2- Contributor
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.