We have a predefined filter in our Insights project based on a TEXT field called thefinancialyear. The values look like eg. 2020-2021
When we use the predefined filter, it does work but we are noticing that the ArcGIS Server log displays an error that says
(
Query [-1] failed "ERROR: relation "insights_a319a7fdd67024d0708bcf29a9735655" already exists": CREATE INDEX "insights_a319a7fdd67024d0708bcf29a9735655" ON "water_consumption_data_dashboard_water_meter_reading" ((lower(trim("thefinancialyear"::TEXT))))
)
I am unsure what this error is telling me. Does Insights try to index the field on the fly ?.
We have not indexed it in our SQL table. Should we try doing this ?
The field type in SQL Server is Varchar(80)
Solved! Go to Solution.
Insights indeed tries to create an index on the fly. The error can safely be ignored (and it should really be a debug/verbose level log message, we will correct that in a future release).
Insights indeed tries to create an index on the fly. The error can safely be ignored (and it should really be a debug/verbose level log message, we will correct that in a future release).