Error when using UPPER together with statistical functions.

FabianoScardua

REST returns an error when using the statistical functions in conjunction with the UPPER function in where clausure in a published service from a filegeodatabase. When used with a published service from an enterprise geodatabase the problem does not happen.
Also the problem does not happen when the upper it is used without the statistics functions.

Arcgis Server 10.11

Someone confirms the problem?

IngRF

Here is my code:

/********************************************************************************************/

var queryPCTask = new QueryTask(this.layers[0].queryParameters.url);

            var queryPC = new Query();

            queryPC.where = "UPPER(MUNICIPALITE) LIKE '%MONTRÉAL%'";

            queryPC.outFields = ["*"];

            var statisticDefinition = new esri.tasks.StatisticDefinition();

            statisticDefinition.statisticType = "count";

            statisticDefinition.onStatisticField = "TYPE_SITE_DESC";

            statisticDefinition.outStatisticFieldName = "TYPE_SITE_DESC_COUNT";

            queryPC.outStatistics = [statisticDefinition];

            queryPC.groupByFieldsForStatistics = ["TYPE_SITE_DESC"];

            queryPCTask.execute(queryPC, lang.hitch(this, 'updatePCDashboard'), lang.hitch(this, 'updatePCDashboardError'));

/********************************************************************************************/

When Executed, I get this error: Error: Unable to complete operation. at Error (native) at Object.h.load

If I modify my query to:

queryPC.where = "MUNICIPALITE LIKE '%MONTRÉAL%'"

The query task is successful.

As stated initially in this post, the problem seems to be related to the statisticDefinition because without that, I can use Upper/Lower without any problems

/********************************************************************************************/

var queryPC = new Query();

            queryPC.where = "UPPER(MUNICIPALITE) LIKE '%MONTRÉAL%'";

            queryPC.outFields = ["*"];

            queryPCTask.execute(queryPC, lang.hitch(this, 'updatePCDashboard'), lang.hitch(this, 'updatePCDashboardError'));

/********************************************************************************************/

Regards,