Recently we are having troubles copying data from the majority of our published services to our workbooks within Insights (Enterprise 10.9.1 Portal version/Insights 2021.3.1.4259). Historically this has worked fine, however we are now frequently not able to do so.
This process appears to work for services on the Living Atlas, data from connected SQL DBs, and some simplified services, but for the majority of the time we get a notice stating that the Layer cannot be copied.
I have increased the "javaHeapSize" settings to 2,048. I have also increased the "maxRecordCount" to exceed the number of counties in the US data.
The current data I am testing on is a county layer for the US.
When I look at the server logs I get the following response:
Tool [copy-dataset] execution in connector arcgis-relational-datastore failed. Params: CopyParameters{params=Params{dataset='Country_e86eb13'}} ToolParameters{outDataset='Country_08b2704', connectorId='arcgis-relational-datastore'} com.esri.insights.api.http.RequestException: Error performing query operation
Thanks for any assistance in advance.
George