I upgraded a workspace with a dynamic writer from FME 2022 to FME 2024. When inspecting the schema before writing there is fme_date and fme_datetime time fields. When writing to geodatabase it created dateonly fields from the fme_date fields when using FME 2024. When writing to SDE we get a ORA-210 / ORA-308 (invalid field type). What is the solution to this problem? I posted this before as addition to another forum topic. However someone from FME suggested to make a new topic.
Question
fme_data field converted to dateonly field, problem when writing to SDE
+39- Influencer
What version of SDE are you running?
Are you trying to update an existing feature class or create a new feature class?
1 person upvoted this
+3- Contributor
The version of our ArcGIS geodatabase within Oracle is 10.8.1 according to our system administrator. We are writing data (DROP AND CREATE).
+54
I’m not sure which version SDE accepts date only fields, but I think it is newer than 10.8.1?
As a workaround, if you use a dynamic workflow, I would try to edit the schema feature to search and replace fme_date with fme_datetime.
+3- Contributor
Thanks for your responses. I'll try the workaround. I am directly writing into a lokal GDB using FME (which I do not get the warning, correct version) and then try to copy manually using ArcGIS Pro to the Oracle database on the older version.
+3- Contributor
11.2.0 is indeed required for the enterprise geodatabase version. Found out after contact with ESRI. Still working on the workaround. I'll update the topic when I got it to work. See Client and geodatabase compatibility—ArcGIS Pro | Documentation
Reply
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.