Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

QuickBooks Pro 2016, DB error -185

Posted on 2016-11-10
5
Medium Priority
?
199 Views
Last Modified: 2016-11-15
ErrorMessage:'SELECT returns more than one row' from file:'src\dmedlsqlcontacteditelement.cpp' at line 2686 from function:'DMEDLContactEditElement::LoadAdditional'

That error started about a month ago whenever we run balance sheet. We were able to figure out that it's an entry from 2008 in the amount of $20.74. Intuit techs say they need the file for 5 days to diagnose and maybe fix... we can't do that, way too long to be without QB.

I need to know:

Is it possible that this error will grow and corrupt the whole file? It doesn't bother us except when we run the balance sheet, no big deal.

If yes, then where do I find an onsite QB data repair tech?
0
Comment
Question by:QMBB
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 44

Accepted Solution

by:
Davis McCarn earned 2000 total points
ID: 41883708
That error ought to be preventing QuickBooks from doing any of its internal, automatic backups so I would say you need to have it addressed!
With everyone out of QuickBooks, copy the entire data folder to someplace else for safekeeping.
Then, try the built in File Doctor:
http://support.quickbooks.intuit.com/support/articles/HOW21534
0
 

Author Comment

by:QMBB
ID: 41886912
I do have a question on this... the docs say:

For data damage issues only, only run the QuickBooks File Doctor if you cannot open the file. If you can open the file and work inside it, do not run QuickBooks File Dr.

Since I CAN open it and work in it, does that mean I shouldn't run the file doctor?
0
 
LVL 44

Expert Comment

by:Davis McCarn
ID: 41886969
I would hope that the file doctor would catch and fix the problem; but, as I said, make a backup copy first.
0
 

Author Comment

by:QMBB
ID: 41887009
So you're saying that it is safe to use the file doctor, regardless of what I posted says? I read that as do not use the file doctor unless you cannot even open QuickBooks and that company file. No?
0
 
LVL 44

Expert Comment

by:Davis McCarn
ID: 41887744
If you make a backup copy first, you can always copy it back if it does hurt things!
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

First I will try to share a design of a Veeam Backup Infrastructure without Direct NFS Access backup. Note: Direct NFS Access backup transport mechanism is only available in Veeam v9 In above I try to design the Veeam Backup flow between i…
Here in this article, you will get a step by step guidance on how to restore an Exchange database to a recovery database. Get a brief on Recovery Database and how it can be used to restore Exchange database in this section!
In this Micro Tutorial viewers will learn how to use Boot Corrector from Paragon Rescue Kit Free to identify and fix the boot problems of Windows 7/8/2012R2 etc. As an example is used Windows 2012R2 which lost its active partition flag (often happen…
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…

596 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question