[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 410
  • Last Modified:

Details for earlier post: "URGENT PLEASE_can't ID screen-flash SQL window..."

Note:  this is a detailed follow-up to an abbreviated description of this problem which was posted earlier:

          URGENT PLEASE_can't ID screen-flash SQL window which may be interfering with QuickBooks

Hello,

The following sequence of events has happened twice with a few slight variations.  The first time was 2-3 days ago.  The second time was earlier this evening (the 14th).

1) Power Outage
The power went out for not more than 5-10 seconds then came back on.  It seemed as though the outage was in my entire house as it was night and I cannot see a thing.  All the lights in my office and an adjoining hall were out and all of my computer and associated equipment went off.  As a result, I had to press the power button on my tower to restart my computer.  I didn't think much of it so I have not asked neighbors if they had a short power outage as well.

2) QuickBooks (QB) won't run
I did not make a connection the first time between the power outage and problems with QB (Pro 2010) since it was a day or two after the outage before I tried to use QB.  (Indeed, there is may be no connection at all but the timing this evening brought the possibility to mind.)  Yesterday was the first time I tried to use QB after the first outage.  I have had no problems with it previously but it had been quite a few days since I had it running.  However yesterday, when I ran it, it could not find the data file (.qbw).  As I was doing some searches to try to get that resolved, QB went down and I got the typical Windows pop-up message when an app fails: "QuickBooks has stopped working."  When I tried to run it again, that same pop up appeared within a couple of seconds.  I tried restarting my computer and a couple of other things (which I don't remember now) but finally concluded that I would just have to reinstall the software.  I found a backup file but realized that I had worked on QB since creating that.  As a result I started looking for the current working file in hopes that I could reinsert that once the software was running again.  To learn if that was OK, I posted a question on the Intuit Community forum:

          Is it OK to grab current data file before re-install, then reinsert it after -- so no data is loss?


One part of the response suggested that I attempt to repair the application through the Control Panel before totally reinstalling it.  I did that and voilà, it worked!  I spent quite a bit of time working on QB after that (because I have tax returns due tomorrow).  :p

Tonight I had worked on QB a bit and although it was open, it was not the active window when the power outage occurred.  It was virtually identical to the earlier outage, lasting just a few seconds.  I had to restart my computer again but this time I could not launch QB.  Each time I would immediately get the "stopped working" pop-up.  Thinking that I could get it running again in a short time, I went back to the Control Panel and went through the repair.  However, this time it would still not launch.  I went back and repaired it a second time but got the same result.  The second time around, I noticed that a small box flashed on the screen just an instant before the repair process was completed.  The flash had been far too short in duration to determine anything about what it was.  Since I had not been watching closely during the first repair, I went through the process of third time and again, there was a brief flash.

I have the Camtasia Studio app installed so I used it to begin recording my screen and went thru the repair process again.  The flash occurred exactly as it had previously so I was able to frame through that point on the recording and capture the image:
 a
I have no idea whether or not the power outage has anything to do with this issue but this flashed window seems like it may.  As closely as I can tell, the window says:

          C:\Users\Steve\AppData\Local\Temp\dofhide.exe

and the screen says:

          SQL Anywhere Command File Hiding Utility Version 11.0.1.2550

I googled both but did not find anything -- at least not anything I understand.  Also, searching that directory (with hidden files and extensions viewable) produced nothing.

It's very late where I live so I've got to call it a night but hopefully some kind and well-SQL-versed person will see this and be able to post a solution before I rise -- that would be a very welcome (and appreciated) relief.

Thanks

PS  Can I refer to the 2nd time around as the SQL Sequel??   :)
0
Steve_Brady
Asked:
Steve_Brady
  • 3
  • 2
3 Solutions
 
chandrasekar1Commented:
As far i checked in net, due to some spyware the “dbfhide.exe” got corrupted, so you need to repair or replace the file with right one. I hope it will resolve this issue.

I am checking for any free tools or file download options and let you know.
0
 
chandrasekar1Commented:
0
 
lbushbyCommented:
Quickbooks uses Sybase's 'SQL Anywhere' as its database engine.

dbfhide.exe is a utility that comes with SQL Anyhwhere that is used to encrypt configuration files used by the engine (see here)

I doubt that the fact that dbfhide is running is the cause of any problem.  My guess would be that the power outage is causing the database used by Quickbooks to become corrupted in some way.

I think you're more likely to find something useful on the Quickbooks support site unless there are any Quickbooks experts on Experts Exchange?

e.g. searching for 'corrupt' on the quickbooks site brings up quite a few results
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
Steve_BradyAuthor Commented:
Thanks for the comments and suggestions.  I will post any new information I come up with.
0
 
Steve_BradyAuthor Commented:
Thanks for all the help!

I eventually ended up calling QuickBooks tech support.  The tech ended up going through a number of different steps including doing a clean install (i.e. removing every Intuit folder on my computer).  In the end the problem turned out to be related to having the working .qbw file in a folder with older conflicting QuickBooks files.  Once the .qbw was moved to where it belongs, everything worked fine.

By the way, that correct location is:

C:\Users\Public\Documents\Intuit\QuickBooks\Company Files
0
 
Steve_BradyAuthor Commented:
Thanks
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now