QuickBooks Enterprise unlinked data, corrupted file, request recovery options

Lionel MM
Lionel MM used Ask the Experts™
on
QuickBooks Enterprise data file issues--when we run Verify and Rebuild data we are getting errors; errors range anywhere from 4 or 5 (may 20018) to 1000's (June/Jule/2018). The last time I was able to run a Verify and a Rebuild without any errors was on 5/29/2018. I saved that file and put it in a backup folder with other backup files that also passed both rebuild and verify. Since that date all files that I try to run Verify and Rebuild error out at some point in the process, some in the verify and other in the Rebuild. Each time these have failed I have sent a the requested report to QuickBooks yet they have never responded to those reports nor acknowledged receiving them when we have called to try to get these errors resolved.  We are now to the point where their support is telling us we have to start a new file because the fixes they have been trying to make over the past 2 months are not working. So before I agree to this I wanted to check with EE to see if I have other options because they are also saying our corrupted file with all our history cannot be saved even though they say that all the unlinked transaction causing these problems are from data created in 1998/99 and 2000 and 2001 and 2002. So my question is this this--can the file be saved by exporting/saving all data from the last 10 years only? Can the last 10 years be removed from the existing "corrupted file" and then see if removing 10 years of data can then allow for repairs to what is left? Ideally we would like to end up with 2 files that have no unlinked or corrupted data, but in talking to QB support they say this is impossible as they have no way to export transactions only lists. Any suggestions or guidance will be helpful. Thank you.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
If you can identify the transactions causing the problems, try deleting them.

It IS possible to export and import transactions, though it is not supported by QB.  You can find details at:
https://qbsupportblog.wordpress.com/2014/09/02/the-trick-to-downgrade-quickbooks-files/

The process is:
Help
About QuickBooks
Ctrl-9 three times
Esc
Help
Tech Support

You'll find new options there that will allow exporting and importing transactions.

To repeat, this is NOT supported by Intuit!  I've successfully used it before, but your results may be quite different.
JohnBusiness Consultant (Owner)
Most Valuable Expert 2012
Expert of the Year 2018

Commented:
Intuit use to offer a repair service where you would send them the file and they have tools to repair it. This is a paid service and may take 48 hours.

Have you asked them? This is a step I would take in your situation
Lionel MMSmall Business IT Consultant

Author

Commented:
CompProbSolv I will try that by doing it on a backup file and get back to you--thanks. There are 100's of unlinked transactions and QuickBooks say if they delete them all then all our data and reports will become meaningless.

John--we have been working with Intuit and that is my main complaint; that are simply telling us to strat over even though we pay them $5000 a year for support, verified backups, and software assurance.
Starting with Angular 5

Learn the essential features and functions of the popular JavaScript framework for building mobile, desktop and web applications.

JohnBusiness Consultant (Owner)
Most Valuable Expert 2012
Expert of the Year 2018

Commented:
I am not sure of any other way, having worked through this on a couple of occasion. Clients and myself. pay for support as well.
How old are the unlinked transactions?  Yes, if you delete them then reports that included them will be inaccurate.  If they are older than you care about, then this shouldn't be a problem.
Small Business IT Consultant
Commented:
I spoke to Intuit Data Recovery on Friday and in that I pressed him quite hard and admitted that there are 1000's of people that are having similar issues and that they cannot fix 1 to 2 percent of these. That made me think back to when these problems stared at the start of June so I checked my work notes on this client and there were updates that I installed on the server and some of the PCs. That made me think if 1000's of others are having problems and ours only started after their latest update that maybe it is their software and not our data. So I did a fresh install on another server, copied the data file over and ran Verify and Rebuild several times and had no issues at all. I also did a fresh install on another PC and ran the same tests on the file and again no issues reported. So I seem to have solved the problem and have uninstalled Enterprise 2016 from the host server and all PCs and then reinstalled it but without any updates. I had 1 of the daily users of Enterprise to check the file yesterday and try to replicate some of the issues and errors that they were encountering last week and now there seems to be no further errors, program crashes, or reports of unlinked transactions. Optimistic but not convinced 100% that this has "fixed" the problem. Will update as needed--thanks for your time and help.
To be clear (as this could be very useful), the error is only present on a version of QB with a recent update?  The same data file can have Verify and Rebuild run on it with a non-updated QB and it passes without error.  When that data file is accessed with an updated QB, it fails the Verify and Rebuild process?

If this is the case, be sure to let Intuit know what you found.  They may act upon it.  Let's hope a future update fixes the one causing the problems.
Lionel MMSmall Business IT Consultant

Author

Commented:
yes that is exactly what is happening and yesterday the users of QBE ran multiple reports and transactions without any of the errors or crashes they were seeing before. further they reported that the had none of the issues they were having on Friday doing simple like entering certain types of transaction or running reconciliation reports--all of those errors seem to have stopped by using non-updated version. as far as Intuit goes we have been working with them very closely through this process and have found them very difficult to get hold of, to work with and to cooperate. we have been with them for over 15 years and on Enterprise since very early 2000's and have gone from paying $1995 per year to more than $4000 per year for software and support and in the end all the seem to want to blame is the size of our file, which is less than 1GB, really this is supposed to be an "Enterprise" solution and they want to put the blame on a file size of 900MB? Come on Intuit.
JohnBusiness Consultant (Owner)
Most Valuable Expert 2012
Expert of the Year 2018

Commented:
I would escalate the case higher. QBE should handle a < 1GB data base file fine. QB Pro handles over 1/2 GB just fine.
Lionel MMSmall Business IT Consultant

Author

Commented:
We have escalated it--they have had a team of their senior techs on it for close to 7 weeks now
JohnBusiness Consultant (Owner)
Most Valuable Expert 2012
Expert of the Year 2018

Commented:
Please see what they say and keep us posted. Many thanks.
Lionel MMSmall Business IT Consultant

Author

Commented:
I have already posted what they said -- they say they cannot help us -- they want us to start a new file -- they are blaming the size of our file
JohnBusiness Consultant (Owner)
Most Valuable Expert 2012
Expert of the Year 2018

Commented:
Ask the senior people here if send them the file, whether they can fix the error with their tools. They do have tools we do not to fix files.
" they are blaming the size of our file": the file works pre-update and not post-update.... and they want to blame the file size?
Lionel MMSmall Business IT Consultant

Author

Commented:
This workaround worked -- none of the other suggestions helped with this particular issue but thanks for your time and efforts.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial