SQLITE files being created
Have noticed in our Enterprise setup a large number of .sqlite files being created and causing downtime on our portal and apps. We have a script running to clear these down every night but some files being created during the day are over 8gb and a number of these cause issues before the script runs.
Is there a way to pinpoint the generation of these sqlite files and reduce their impact?
Hi from Australia.
We have similar challenges with these large files that only seem to be created for a single feature class best we can tell by looking at a sample of the files containing objectid and what appear to be the definition for a sql where clause.
1. We're on Arcgis enterprise 10.9.1 and was unaware of these files with earlier versions although it may relate to something added since version upgrade
2. Files are C:\Users\{arcgis service account}\AppData\Local\Temp on each arcgis server operating system drive.
3. I can't share a file as the 'where clause' values are sensitive data. Screenshot shows snip with objectid and primarykeyclause columns and values
Our local distributor support indicates theMakeQueryLayer Python function generates these but we can't identify use of this in our code so it remains a mystery.
We do use MakeFeatureLayer in ArcGIS Pro python code but not for this feature class and we're told that it doesn't apply for that function.
So any clues as to what scenario causes arcgis server to generate these would be appreciated as we're trying to identify cause and possible options to prevent their generation and probable performance impacts of this happening. Are we missing an attribute index for a join operation or similar perhaps? How else could a web application trigger their generation.
Thanks for any insights.
