MDuppong

Table export with postfix clause failing with FGDB in 10.1 SP1

Discussion created by MDuppong on Jan 9, 2013
Latest reply on Dec 5, 2013 by lshipman-esristaff
Hello,

Anyone else having an issue with exporting data from a table in a file geodatabase using an IQueryFilterDefinition postfix clause in ArcGIS Desktop 10.1?

Essentially:

IQueryFilter queryFilter = new QueryFilterClass();
queryFilter.WhereClause = "InspDate >= CURRENT_DATE - 365";
queryFilter.SubFields = "*";
IQueryFilterDefinition queryFilterDef = (IQueryFilterDefinition)queryFilter;
queryFilterDef.PostfixClause = "order by SiteID asc, InspDate desc";
ICursor cursor = table.Search(queryFilter, false);
IExportOperation exporter = new ExportOperationClass();
exporter.ExportTable(datasetName, queryFilter, cursor as ISelectionSet, outputName, 0);


This works in 10.0.  In 10.1 it results in an exception:

"Error: The owner SID on a per-user subscription doesn't exist (Exception from HRESULT: 0x80040207)"

With the proper change of the query filter's WhereClause to "InspDate >= DATEADD(day, -365, GETDATE())", this same code works on both 10.0 and 10.1 systems using SDE.  So, only file geodatabases in 10.1 seem to be giving the problem.

Any ideas?

Outcomes