Solved

Quickbooks 2008/2009 verification errors upon backups

Posted on 2009-05-14
2
1,618 Views
Last Modified: 2012-08-14
Hi,
Everytime one of our clients backs up one of their 2 quickbooks company files an error always appears upon verification of the company file forcing a rebuild.

Below is the respective quickbooks log containing log data during a verification. I can not find any description of the message errors and am hoping someone else has come accross this problem before.
The quickbooks company file seems to work fine and my client says this has been occuring for the last 6-8months. They have printed full reports of the company and found no errors in the accounting section so they had just been ignoring the error.


==============================* BEGIN VERIFY LOG *=========================


verify.c (382) :  CHECKPOINT: Thu May 14 22:00:51 Verifying data, file name: E:\Quickbooks\Quickbook Data 08-09\<company name> 2006 07.QBW

DBSQLFileManager.cpp (4292) :  CHECKPOINT: Thu May 14 22:05:26 Database validation completed. No error detected
verify.c (11675) :  CHECKPOINT: Thu May 14 22:05:26 Testing for duplicate IDs
DMTXNSQLVerifyIDs.cpp (409) :  MESSAGE: Thu May 14 22:05:26 LVL_ERROR--Unable to create a table in support of verify/rebuild.  DB error code -110, Msg: Item 'vi_dups_recs_only' already exists
DMTXNSQLVerifyIDs.cpp (409) :  MESSAGE: Thu May 14 22:05:26 LVL_ERROR--Unable to create a table in support of verify/rebuild.  DB error code -110, Msg: Item 'vi_duplicates' already exists
DMTXNSQLVerifyIDs.cpp (409) :  MESSAGE: Thu May 14 22:05:26 LVL_ERROR--Unable to create a table in support of verify/rebuild.  DB error code -110, Msg: Item 'vi_inv_all_recnums' already exists
DMTXNSQLVerifyIDs.cpp (409) :  MESSAGE: Thu May 14 22:05:26 LVL_ERROR--Unable to create a table in support of verify/rebuild.  DB error code -110, Msg: Item 'vi_inv_dups_recs_only' already exists
DMTXNSQLVerifyIDs.cpp (409) :  MESSAGE: Thu May 14 22:05:26 LVL_ERROR--Unable to create a table in support of verify/rebuild.  DB error code -110, Msg: Item 'vi_inv_duplicates' already exists
DMTXNVerifyIDs.cpp (432) :  CHECKPOINT: Thu May 14 22:05:26 Could not create temporary tables.  Attempting to recover by dropping old temporary tables.  Ignore 'Table Not Found' errors...
DMTXNVerifyIDs.cpp (434) :  CHECKPOINT: Thu May 14 22:05:27 Old temporary tables dropped.  Retrying creation of temporary tables...
DMTXNVerifyIDs.cpp (439) :  CHECKPOINT: Thu May 14 22:05:27 Temporary tables created successfully after deletion.  Proceeding with verify IDs.
verify.c (11765) :  CHECKPOINT: Thu May 14 22:06:49 Duplicate ID test completed
verify.c (499) :  CHECKPOINT: Thu May 14 22:07:23 Beginning Transaction Verify/Rebuild

verify.c (12097) :  CHECKPOINT: Thu May 14 22:07:23 Check for inventory targets on targets with no inventory item
verify.c (12134) :  CHECKPOINT: Thu May 14 22:07:23 COMPLETED check for inventory targets on targets with no inventory item
verify.c (569) :  CHECKPOINT: Thu May 14 22:42:20 Ending Transaction Verify/Rebuild

verify.c (7704) :  CHECKPOINT: Thu May 14 22:43:11 Error: Verify Name Balance failed. Name = Australian Tax Office. Ref = <num>. Calc bal = 0.00. List bal = <number>

prefuser.c (18051) :  CHECKPOINT: Thu May 14 22:43:13 Permissions Analysis Starting...
prefuser.c (18085) :  CHECKPOINT: Thu May 14 22:43:16 Permissions Analysis Finished.
verify.c (697) :  CHECKPOINT: Thu May 14 22:43:16
==============================* END VERIFY LOG *===========================


formmgr.c (604) :  CHECKPOINT: Thu May 14 22:43:16 Creating a MODAL form: formID=0, itID=6
formmgr.c (604) :  CHECKPOINT: Thu May 14 22:44:33 Creating a MODAL form: formID=0, itID=7
DBManager.cpp (3863) :  CHECKPOINT: Thu May 14 22:44:48 Database Server cache size = 64M
DBManager.cpp (3865) :  CHECKPOINT: Thu May 14 22:44:48 Database Server initial cache size = 32M
DBManager.cpp (3659) :  CHECKPOINT: Thu May 14 22:44:48 Database Server starting. Startup String = C:\PROGRA~1\Intuit\QUICKB~2\QBDBMgr.exe -n QB_ReadOnly_engine_17 -qs -gd ALL -gk all -gp 4096 -gu all -ch 16M -ti 0 -c 4M -x none -ct- -qi -qw  -tl 120 -oe "C:\Documents and Settings\Administrator\Local Settings\Application Data\Intuit\QuickBooks\Log\DBStartup.log" -r
formmgr.c (604) :  CHECKPOINT: Thu May 14 22:52:16 Creating a MODAL form: formID=0, itID=8
load.c (1997) :  CHECKPOINT: Thu May 14 23:03:10 InitSystem
load.c (9915) :  CHECKPOINT: Thu May 14 23:03:11 In hosting local files only mode, opening local file - no hosting change needed.
load.c (2212) :  CHECKPOINT: Thu May 14 23:03:11 InitSystem Open DB Session[5]
DBManager.cpp (3375) :  CHECKPOINT: Thu May 14 23:03:18 Current Database Server version = 9.0.2.3267
FileMgr.cpp (274) :  CHECKPOINT: Thu May 14 23:03:18 Company file E:\Quickbooks\Quickbook Data 08-09\<company name> 2006 07.QBW is open using database server:QB_SERVER_17.
load.c (2218) :  CHECKPOINT: Thu May 14 23:03:18 InitSystem Open DB Session[5] Succeeded
QBPRINT.c (2449) :  CHECKPOINT: Thu May 14 23:03:19 Detecting if Terminal Service is running.
QBPRINT.c (2460) :  CHECKPOINT: Thu May 14 23:03:19 Terminal Service is running
PermissionManager.cpp (4221) :  CHECKPOINT: Thu May 14 23:03:21 A new permission context is added for QuickBooks
load.c (3535) :  CHECKPOINT: Thu May 14 23:03:24 InitSystem: Open System
load.c (3543) :  CHECKPOINT: Thu May 14 23:03:24 InitSystem: Open System succeeded
load.c (3882) :  CHECKPOINT: Thu May 14 23:03:27 InitSystem: successful completion
verify.c (378) :  CHECKPOINT: Thu May 14 23:03:28

==============================* BEGIN REBUILD LOG *========================


verify.c (379) :  CHECKPOINT: Thu May 14 23:03:28 Rebuilding data, file name: E:\Quickbooks\Quickbook Data 08-09\<company name> 2006 07.QBW

DBSQLFileManager.cpp (4292) :  CHECKPOINT: Thu May 14 23:16:45 Database validation completed. No error detected
verify.c (11675) :  CHECKPOINT: Thu May 14 23:16:45 Testing for duplicate IDs
verify.c (11765) :  CHECKPOINT: Thu May 14 23:18:20 Duplicate ID test completed
verify.c (499) :  CHECKPOINT: Thu May 14 23:18:52 Beginning Transaction Verify/Rebuild

verify.c (12097) :  CHECKPOINT: Thu May 14 23:18:52 Check for inventory targets on targets with no inventory item
verify.c (12134) :  CHECKPOINT: Thu May 14 23:18:52 COMPLETED check for inventory targets on targets with no inventory item
verify.c (569) :  CHECKPOINT: Thu May 14 23:53:46 Ending Transaction Verify/Rebuild

verify.c (7704) :  CHECKPOINT: Thu May 14 23:54:20 Error: Verify Name Balance failed. Name = Australian Tax Office. Ref = <num>. Calc bal = 0.00. List bal = <number>

verify.c (7663) :  CHECKPOINT: Thu May 14 23:54:21 ** Corrected **

prefuser.c (18051) :  CHECKPOINT: Thu May 14 23:54:22 Permissions Analysis Starting...
prefuser.c (18085) :  CHECKPOINT: Thu May 14 23:54:25 Permissions Analysis Finished.
verify.c (695) :  CHECKPOINT: Thu May 14 23:54:25
==============================* END REBUILD LOG *==========================

0
Comment
Question by:bnoyzy
2 Comments
 
LVL 11

Accepted Solution

by:
stlinae earned 500 total points
ID: 24470382
Other than removing the file name from the log, what other changes did you or your client make? What version of QB is the file in? U.S.? (While it doesn't appear to be a US version, I will give advise as if it is. Most information should be the same, but I have not work in all other versions.)

Depending on what you and your clients want will depend on what steps you need to take. To simply get rid of the message when creating a backup, you can turn off the option to do a Complete Verification. Click the Option button that should come up on the 2nd screen when creating a backup. I would first try selecting 'Quicker verification' before no verification, but that may still trigger the rebuild message. This will take care of the message, but not the root cause.

Resort the lists. (COS, Item and Names) Run a verify on the file, then, regardless of it passing or failing, run back to back rebuilds on the file. After that, try the verify again. Hopefully it will pass. If not, check the QBWin.log again. If it there is any damage that can be corrected be an end user, it will tell you. If not, you will have three main options. Try to get Intuit's Data Service department to fix the file (typically at a fee.) Start a new data file, or just ignore it.

While starting a new data file is never fun, there are 3rd party apps and companies that can help you with it. As far as ignoring the issue, remember this is someones finicials you're dealing with.



0
 

Author Comment

by:bnoyzy
ID: 24865029
I have spoken to Rekon in regards to this issue and from their advice and stlinae's advice I have decided to start a new company file and archive the current company to reduce the company files size; starting a new file for this financial year. Currently the size of the company file is over 2GB which could be half the issue not to mention is does not help in troubleshooting as each verify takes about an hour.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

By Linda Saltz Customized item descriptions from bills DO import into a customer invoice!   This is a wonderful tip for companies that want to use generic items like Hardware, Software, Mileage, Travel in their item list which helps keep the i…
If you need to import sales transactions from another system into Microsoft Dynamics GP as Sales Order Invoices, you may need to store some additional data related to the customer, the transaction, or the line items.  Even if your company is manuall…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

759 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now