Skip to main content
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

  • Sep 29, 2023 9:14 AM UTC
  • 4 replies
  • 85 views

nitinshahane
Contributor
Forum|alt.badge.img+7

If this is a bug in 2022, then I can think of upgrading my FME version to 2023. Please confirm.

4 replies

david_r
Celebrity
  • Sep 29, 2023 9:24 AM UTC

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)

 


nitinshahane
Contributor
Forum|alt.badge.img+7
  • Author
  • Contributor
  • Sep 29, 2023 9:28 AM UTC

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?


david_r
Celebrity
  • Sep 29, 2023 9:40 AM UTC

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?


nitinshahane
Contributor
Forum|alt.badge.img+7
  • Author
  • Contributor
  • Sep 29, 2023 10:03 AM UTC

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.