There is not enough memory on the device running SQL Server Compact to complete this operation.
We have unattended set ups that are running in a windows service using SQL Server Compact Private deployment (No runtime installed on client computer for SQL CE) and we are running into an issue. After an indeterminate amount of time, usually a couple days, some of our installations will start giving us this error after every call to create a new Entity Framework context and the application will not work until we restart the windows service. The machine is not restarted. The machine never seems to recover, and the most important part of course is that not only does the machine have a lot of memory left, our windows service only consumes between 50-100 MB when this exception occurs.
Upvotes: 1<=-=Mar 2 2017 1:53PM=-=>
Please close this, upon further inspection, it appears as the process was using between 1 and 1.5 gb of memory. This process is 32 bit.