topic Re: ExcelToSQLite64 won't die (it's back) in ArcGIS Pro Questions

ExcelToSQLite64 won't die (it's back)

PaulSchrum1 — Wed, 29 Jun 2022 14:31:21 GMT

I noticed my computer's fan is running nearly all the time after running ArcGIS Pro 3.0. After investigating, I found that ExcelToSQLite64 keeps running even after closing ArgGIS Pro. When it does, it uses one of my virtual processors at 100% utilization until I kill the process in Task Manager. This is what is making the fan turn on.

While trying to figure out what was going on, I found that this was also a problem with 2.6.

Since this has been a bug acknowledged by ESRI for over two years and three releases, I am wondering if staff know what I can do about it beyond just killing the process whenever I hear my fan turn on.

Also, is this something you guys might fix some day?

Re: ExcelToSQLite64 won't die (it's back)

PaulSchrum1 — Wed, 29 Jun 2022 14:55:54 GMT

Follow up. I just noticed ExcelToSQLite64 stills activates itself. All that is required is for Pro to have been opened some time since the last restart.

Re: ExcelToSQLite64 won't die (it's back)

Remmert — Wed, 29 Jun 2022 20:45:52 GMT

We resolved a variety of the ExceltoSQL64 gremlins today by applying the AccessDB update referenced in this permalink: Solved: Re: DO NOT update to 3.0, Update to ArcPro 3.0 is ... - Esri Community

Re: ExcelToSQLite64 won't die (it's back)

PaulSchrum1 — Thu, 30 Jun 2022 17:52:22 GMT

I don't consider this a solution as you don't seem to have tested for the zombie process case (of this thread). You don't mention it, anyway. It seems to be, "we made a change and we hope it will fix your problem. Good luck with that."

Further, when I look at the "solutions" found at the link you post, I see a lot of "if you have this" and "if you do that". We are not computer scientists, and it should not be the user's responsibility to update a Microsoft app because an ESRI app is misbehaving.

In the mean time, I have written my own C# program which checks for ExcelToSQLite every so often, and if the process is running but ArcGIS Pro is not running, the program kills the process. This is not the solution either, but it keeps my fan from running just because I have opened ArcGIS Pro 3.0 at some time in the past.

Re: ExcelToSQLite64 won't die (it's back)

Remmert — Thu, 30 Jun 2022 18:12:25 GMT

You are correct I havent tested the zombie-thread condition. I dont have that gremlin, so I cant. Best I can do is offer you a driver update that has resolved a number of other reported problems with ExceltoSQL64. Its a logical jump that it appears to improve outcomes in the use of ExceltoSQL64. You can install it, or not.

Re: ExcelToSQLite64 won't die (it's back)

PaulSchrum1 — Thu, 30 Jun 2022 19:17:16 GMT

"I dont have that gremlin, so I cant."

You never asked me for steps to reproduce, so maybe you have it and don't realize it.

1. Open ArcGIS Pro.

2. Close it. Wait five minutes (to make sure every process that is going to close closes).

3. Open Windows Task Manager (Processes Tab). Look for ExcelToSQLite64. The problem is noticed here. If you see it is a running task, this is the zombie process. Kill it.

4. An hour and a half after you kill the zombie, check Task Manager again. If you have the same problem I am having, another ExcelToSQLite64 process has been spawned by some other process.

Note about step 4. I don't know how to figure out which process is spawning ExcelToSQLite64 every hour. But whichever process is doing that, that is where the bug actually is.

Note about Step 3. I understand it is inconvenient to wait an hour for a bug to manifest. So perhaps you have access to another computer with AP 3 on it that you can leave to the side while you work on other things.

My apologies for taking a "mansplaining" tone. I am a man, and when I splain things, unfortunately that's how it comes out. I would fix it if I knew how.

Re: ExcelToSQLite64 won't die (it's back)

PaulSchrum1 — Thu, 30 Jun 2022 23:44:34 GMT

@Remmert for other reasons, I had to uninstall 3.0 and reinstall 2.9. (The other reason was the .Net runtime change.) After doing that I noticed that the zombie process does not get restarted, not even after two hours. So this seems to have fixed the problem.

Re: ExcelToSQLite64 won't die (it's back)

Remmert — Fri, 01 Jul 2022 14:15:21 GMT

We have not been able to reproduce the behavior in steps 3 or 4 above. Our machines, unpatched with the AccessDB update, hang in step 1 if ExceltoSQL64 is invoked and the entire ArcPro process has to be terminated from taskmanager.

Re: ExcelToSQLite64 won't die (it's back)

PaulSchrum1 — Sun, 03 Jul 2022 21:20:05 GMT

Thank you for your reply.

I am abandoning this issue because I have gone back to ArcGIS Pro 2.9. I have confirmed that my issue does not happen with 2.9.

I am supposing that for some reason I already had the AccessDB patch, which would explain why I was able to use ArcGIS Pro 3.0 to begin with though you could not. In your response, you did not mention whether or not you attempted to to exit Pro and look at Task Manager after it closed, so it sounds like you never executed my steps to reproduce.

You should mark this issue as "Abandoned by User" if you have that category as it is a moot point for me now that I am on 2.9. In no case should you mark it as Resolved, Fixed, or Answered. It is none of those, and getting credit for a resolved issue is not indicated for this case.

When I upgrade to 3.x (x >=1), I will check for this again and hopefully it will be fixed by then.

Please close any issue you have opened on my behalf.

Re: ExcelToSQLite64 won't die (it's back)

LyleMariam — Mon, 08 Aug 2022 13:39:58 GMT

I've just discovered the same problem. ExcelToSQLite automatically launches on reboot. If I kill it with Task Manager, it's back within a minute. I can't see where it is loaded. The program is taking 12% of my CPU and turning my Xeon machine into a dog. A three-legged dog at that.

Re: ExcelToSQLite64 won't die (it's back)

PaulSchrum1 — Mon, 08 Aug 2022 14:36:38 GMT

Glad to know about it. If you tell the ESRI support people in this forum, as you can see they will tell you they can't reproduce it so it must be your problem. The best option is to skip Pro 3.0 and check again to see if it is fixed when 3.1 comes out.

Re: ExcelToSQLite64 won't die (it's back)

LyleMariam — Mon, 08 Aug 2022 16:10:52 GMT

Thanks for your response. Unfortunately, I am but a simple minion and at the mercy of my corporation's IT group. My issue has been reported to our section but I'll just have to live with it until 3.1 comes out or someone hopefully fixes it. Searching through the posts, some users have reported similar issues for the past several years on previous versions and while there may not be a lot of people with this issue, apparently I am not the only one. I just noticed this issue in the last week but have been using 3.0 for a little while.

I can't figure out where ExcelToSQLite is launched on boot as I only have local Admin rights but killing it doesn't help as it immediately restarts within a minute and rebooting the system doesn't make a difference.

Re: ExcelToSQLite64 won't die (it's back)

LyleMariam — Mon, 15 Aug 2022 19:42:36 GMT

"We have not been able to reproduce the behavior in steps 3 or 4 above."

My testing indicates that ExcelToSQLite is loaded during adding a layer from our server to a local ArcGIS project. I used ArcGIS 3.0.0 locally without ExcelToSQLite being loaded. Then after connecting to our server and adding a layer to a project on my PC, ExcelToSQLite reared its ugly head. To be honest, I also exported a layer to a local shape file but forgot to check in-between adding a layer from the server and exporting to local shape file to see which one invoked the program.

Re: ExcelToSQLite64 won't die (it's back)

LyleMariam — Mon, 15 Aug 2022 20:01:06 GMT

So far I've discovered that ExcelToSQLite gets loaded when you add a layer from our server onto a local project. It could also be when you export a layer to a shape file. I forgot to check between the two steps but will see if I can isolate which one triggered it.

P.S. I just updated to 3.0.1 and that seems to have killed ExcelToSQLite. Possibly the update fixes the problem.

Re: ExcelToSQLite64 won't die (it's back)

LyleMariam — Mon, 15 Aug 2022 23:22:35 GMT

After updating to 3.0.1, the problem still exists.

Re: ExcelToSQLite64 won't die (it's back)

CECNorthAmericanAtlas — Mon, 22 Aug 2022 23:31:59 GMT

I had this problem today and the worse thing is that I did NOT use ArcGIS Pro 3.0.1 at all today!

I was wondering why my fan was running at max speed for a while when I wasn't doing anything and Task Explorer showed me the culprit: ExcelToSQLite64.exe!

See image.

NOTE: I'm on a laptop and this seem to have started when I plugged in my laptop but can't confirm it was exactly at that moment that it started.

ExcelToSQLite64.exe using 46% of my CPU without using ArcGIS Pro 3.0.1

Re: ExcelToSQLite64 won't die (it's back)

CECNorthAmericanAtlas — Tue, 23 Aug 2022 20:07:47 GMT

I confirm: After working on battery power, when I plug in my laptop, for no reason whatsoever ExcelToSQLite64.exe starts running like crazy.

NOTE: I am not even running nor started ArcGIS Pro 3.0.1 during the day and my computer was completely off when I turned it on this morning. This process should not start at all.

Re: ExcelToSQLite64 won't die (it's back)

AdrienneJohnson — Wed, 24 Aug 2022 15:45:16 GMT

Same issue for me. I can't use Excel conversion tools at all, as my machine just locks up. I've been using 3.0 and can't go back to 2.9x. Can't find a way to export the projects as older versions.

Re: ExcelToSQLite64 won't die (it's back)

LyleMariam — Wed, 24 Aug 2022 16:55:02 GMT

Unfortunately, support says they can't duplicate the problem so I assume are not working on the issue. If I could just figure out how to kill ExcelToSQLite after using ArcGIS, I'd be happy. If you kill the process, it automatically starts up almost immediately. I have a halfway decent Xeon machine and it takes 12% of my CPU time slices. What's strange is I'm not doing anything with Excel and ArcGIS Pro together so don't understand why it fires up. I'm assuming from the file name that the routine converts Excel spreadsheets to SQLlite databases and if I'm not doing that, why is the app loading?

Re: ExcelToSQLite64 won't die (it's back)

CECNorthAmericanAtlas — Wed, 24 Aug 2022 17:45:28 GMT

They should try on a laptop. Going from Battery power to Plugged-in power is what starts ExcelToSQLite for me. What bugs me the most is that these days I'm not even opening ArcGIS at all and yet, this process is automatically starting.