https://community.esri.com/t5/arcgis-insights-questions/error-relation-already-exists-appears-in-arcgis/m-p/1074560#M809 <P>We have a predefined filter in our Insights project based on a TEXT field called <EM>thefinancialyear</EM>.&nbsp; The values look like eg.&nbsp; 2020-2021</P><P>When we use the predefined filter, it does work but we are noticing that the ArcGIS Server log displays an error that says</P><P>(<BR />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))))</P><P>)</P><P>I am unsure what this error is telling me.&nbsp;&nbsp; Does Insights try to index the field on the fly ?.</P><P>We have not indexed it in our SQL table.&nbsp; Should we try doing this ?&nbsp;&nbsp;</P><P>The field type in SQL Server is Varchar(80)</P> Thu, 01 Jul 2021 03:30:53 GMT GeorgieCassar1 2021-07-01T03:30:53Z https://community.esri.com/t5/arcgis-insights-questions/error-relation-already-exists-appears-in-arcgis/m-p/1074560#M809 <P>We have a predefined filter in our Insights project based on a TEXT field called <EM>thefinancialyear</EM>.&nbsp; The values look like eg.&nbsp; 2020-2021</P><P>When we use the predefined filter, it does work but we are noticing that the ArcGIS Server log displays an error that says</P><P>(<BR />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))))</P><P>)</P><P>I am unsure what this error is telling me.&nbsp;&nbsp; Does Insights try to index the field on the fly ?.</P><P>We have not indexed it in our SQL table.&nbsp; Should we try doing this ?&nbsp;&nbsp;</P><P>The field type in SQL Server is Varchar(80)</P> Thu, 01 Jul 2021 03:30:53 GMT https://community.esri.com/t5/arcgis-insights-questions/error-relation-already-exists-appears-in-arcgis/m-p/1074560#M809 GeorgieCassar1 2021-07-01T03:30:53Z https://community.esri.com/t5/arcgis-insights-questions/error-relation-already-exists-appears-in-arcgis/m-p/1074565#M810 <P>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).&nbsp;</P> Thu, 01 Jul 2021 04:18:18 GMT https://community.esri.com/t5/arcgis-insights-questions/error-relation-already-exists-appears-in-arcgis/m-p/1074565#M810 HeikoHeijenga 2021-07-01T04:18:18Z