Exception from a shapefile whose .dbf contains a "Date" field

WlodzimierzSzafran

Hi,

I just encountered strange behaviour when trying to use a ShapefileTable from a shapefile that has at least one field of type "Date" among the attributes in its .dbf file. Any attempt to either get a count of the features or to iterate over the features ends in an exception:

"The added or subtracted value results in an un-representable DateTime. Parameter name: t"

Steps to reproduce:

Use any shapefile with at least one attribute of type "Date", with actual dates in the data, and then:

var shapefileTable = await ShapefileTable.OpenAsync(fileName);

var features = await shapefileTable.QueryAsync(new QueryFilter() { WhereClause = "1=1" });

if (features == null || features.Count() == 0)

{

    // e.g. throw an exception

}

The relevant stack trace:

   at System.DateTime.op_Addition(DateTime d, TimeSpan t)

   at Esri.ArcGISRuntime.Internal.DateUtils.FromMillisecondsSinceEpoch(Int64 milliSeconds)

   at Esri.ArcGISRuntime.Data.ArcGISFeatureTable.RowEnumerator.<System.Collections.Generic.IEnumerable<Esri.ArcGISRuntime.Data.GeodatabaseFeature>.GetEnumerator>d__48.MoveNext()

   at Esri.ArcGISRuntime.Data.ArcGISFeatureTable.RowEnumerator.<System.Collections.Generic.IEnumerable<Esri.ArcGISRuntime.Data.Feature>.GetEnumerator>d__4e.MoveNext()

   at System.Linq.Enumerable.Count[TSource](IEnumerable`1 source)

I would appreciate if this was acknowledged as an issue and fixed as soon as possible.

Thanks, regards.

MichaelBranscomb

Hi,

Good news: we have recently addressed this issue and I have verified against the latest build of the forthcoming 10.2.6 SDK. The problem was apparently null date values in the Shapefile.

Your example code now successfully reports the feature count (I added the MessageBox):

var shapefileTable = await ShapefileTable.OpenAsync(fileName);
var features = await shapefileTable.QueryAsync(new QueryFilter() { WhereClause = "1=1" });
if (features == null || features.Count() == 0)
{                                                             
                // e.g. throw an exception
}
else
                MessageBox.Show(features.Count().ToString());

Cheers

Mike