Reading unversioned SDE table with archiving enabled

Concerning the view, it will depend on your ArcGIS version and how the view was defined. In general, if it is a regular database view you will have to either register it as a layer in SDE to make it visible in ArcGIS (prior to ArcGIS 10.2 I believe), or you will have to define it as a query layer (starting with ArcGIS 10).

David

I think you have forgotten doubles quotes. The following archived clause should work :

"GDB_FROM_DATE > 20070101090000"

Nicolas

Hi all,

I want to reopen this topic as I encountered an unexpected behaviour in FME 2016. When I use an ArcSDE-Reader and insert e. g. "GDB_FROM_DATE > 20070101090000" (with double quotes) for Archive Where Clause, I get the desired results.

When I use a FeatureReader and input the same feature class and Archive Where Clause, however, I get the following error message:

Invalid archive where clause. The archive where clause must be in the format 'GDB_FROM_DATE|GDB_TO_DATE <logical operator> <date> [AND GDB_TO_DATE <logical operator> <date>]' and be space delimited

Does the FeatureReader-Archive Where Clause parameter expect another format and outputs the wrong error message? I have also checked this thread but couldn’t find anything relating to FeatureReader specific adpations.

Best regards,

André

PS: I am using FME 2016.1 (Build 16494).

Hi Folks,

We are looking a new variation of this problem mentioned by @andr_ where the Archive Where Clause is not working when used in the FeatureReader and indeed this is a known issue. In fact the problem is related to original issue posted by @ turid_skedsmo where we noticed you need to use double quotes around the Archive Where Clause. Unfortunately this work-around doesn't work in the FeatureReader. We are looking for a work-around and our developers are looking into this problem but in the meantime apologies for the inconvenience.

Ken

@KenAtSafe : Thanks for the fast response. Do you have, by chance, any information on when this issue may be fixed?