topic Re: CalculateStatistics does not work on Query Table in ArcGIS Pro SDK Questions

CalculateStatistics does not work on Query Table

GKmieliauskas — Thu, 03 Jun 2021 13:59:06 GMT

Hi,

I have "QueryTable" type table on enterprise database. I would like to calculate some statistics on it. CalculateStatistics method throws exeception "A geodatabase-related exception has occurred".

The same code with exported to gdb table works fine.

Does anyone have experience in working with statistics on QueryTable type tables?

Re: CalculateStatistics does not work on Query Table

Wolf — Thu, 03 Jun 2021 14:40:44 GMT

Which Enterprise database are you using and what type of statistics are you trying to get?

Re: CalculateStatistics does not work on Query Table

Aashis — Thu, 03 Jun 2021 17:38:44 GMT

Thank you for bringing the issue to our attention @GKmieliauskas. We logged it as a bug, and our dev team will investigate the cause, and then we will let you know the solution or any workaround to the issue.

Re: CalculateStatistics does not work on Query Table

GKmieliauskas — Fri, 04 Jun 2021 13:22:06 GMT

Thank you for the information.

I have another one issue related to "QueryTable" type table. GetCount from table takes about 40s on 3600 records when on the same structure of regular table it takes a moment to count rows. There is no difference to call GetCount or walk thru Search cursor and count records by myself. Is it specific to "QueryTable" or something wrong in implementation?

P.s. I have found that my "QueryTable" isn't registered with the geodatabase. Could registration help me with performance issue?

Re: CalculateStatistics does not work on Query Table

GKmieliauskas — Mon, 07 Jun 2021 09:05:10 GMT

We have solved issue with GetCount by indexing primary table field.

Re: CalculateStatistics does not work on Query Table

Aashis — Fri, 11 Jun 2021 16:52:30 GMT

@GKmieliauskas What enterprise geodatabase are you using? Is it SQL Sever?

Re: CalculateStatistics does not work on Query Table

GKmieliauskas — Fri, 11 Jun 2021 19:35:58 GMT

Yes, it is SQL Server