If this is a bug in 2022, then I can think of upgrading my FME version to 2023. Please confirm.
Question
I am trying to read data from ArcSDE geodatabase where the value stored in Date field is 12/30/1899. However, SDE Reader reading it as '0000'. Please suggest the workaround. Can anyone from Safe Software confirm if this is a bug in FME 2022 version
- 8392 replies
A possible workaround would be to read the date directly from the underlying database, e.g. using a DatabaseJoiner, SQLExecutor, etc. Example SQL:
SELECT myDateField
FROM mySchema.myFeatureClass
WHERE objectid = @Value(OBJECTID)
+7- Contributor
- 6 replies
A possible workaround would be to read the date directly from the underlying database, e.g. using a DatabaseJoiner, SQLExecutor, etc. Example SQL:
SELECT myDateField
FROM mySchema.myFeatureClass
WHERE objectid = @Value(OBJECTID)
Is it a bug in SDE Reader?
As we do not have direct access to the database, therefore, I am unable to go with suggested options. We can access the data using SDE reader only.
Can you please suggest the other way around?
- 8392 replies
Is it a bug in SDE Reader?
As we do not have direct access to the database, therefore, I am unable to go with suggested options. We can access the data using SDE reader only.
Can you please suggest the other way around?
I've no idea where such a limit could occur.
Perhaps try using arcpy from FME?
+7- Contributor
- 6 replies
Is it a bug in SDE Reader?
As we do not have direct access to the database, therefore, I am unable to go with suggested options. We can access the data using SDE reader only.
Can you please suggest the other way around?
I have exported the data to FGDB and tried to read it with 2023 version and it is reading it successfully. However, it's not reading correctly on 2022 version. I am looking into it by changing Python compatibility as well.