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
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
david_r wrote:
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?
ni3 wrote:
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
ni3 wrote:
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.
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.