Trying to use DateTimeConverter to conver Oracle Date to PostgreSQL timestampz. Have tried multiple formats.
Value of attribute 'start_date' could not be converted to type 'timestamptz'. Feature will be logged and skipped
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.
+44- Influencer
- 3427 replies
Are you reading data from Oracle? If it's coming from the date field in Oracle it will already be in an FME format irrespective of how it is displayed in Oracle so you shouldn't need to do this conversion
+7- Contributor
- 35 replies
Are you reading data from Oracle? If it's coming from the date field in Oracle it will already be in an FME format irrespective of how it is displayed in Oracle so you shouldn't need to do this conversion
Correct from Oracle Date to PostgrSQL timestampz. I removed the DateTimeConverter, this is the result:
Value of attribute 'start_date' could not be converted to type 'timestamptz'. Feature will be logged and skipped
+7- Contributor
- 35 replies
Are you reading data from Oracle? If it's coming from the date field in Oracle it will already be in an FME format irrespective of how it is displayed in Oracle so you shouldn't need to do this conversion
I changed the target postgresql table to use timstamp instead of timestamptz. Same error.
Value of attribute 'start_date' could not be converted to type 'timestamp'. Feature will be logged and skipped
@jbradfor as @ebygomm mentions - if your source data is Oracle with a data type timedate, then FME will have converted the Oralce date field into the FME data format. So you shouldn't need the TimeDateConverter at all. To check that FME is reading and interpreting your Oracle date field correctly, add an Inspector after the Oracle reader feature type and check the date field. It should have the standard FME date format.
+7- Contributor
- 35 replies
I modified the postgresql start_date to timestamp.
Then I added this dateconverter logic.
SUCCESS!
