ERROR: relation already exists. Appears in ArcGIS Server log when using predefined filter

930
1
Jump to solution
06-30-2021 08:30 PM
GeorgieCassar1
New Contributor III

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)

Tags (3)
0 Kudos
1 Solution

Accepted Solutions
HeikoHeijenga
Esri Contributor

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). 

View solution in original post

0 Kudos
1 Reply
HeikoHeijenga
Esri Contributor

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). 

0 Kudos