Solved

Quickbooks 2008/2009 verification errors upon backups

Posted on 2009-05-14
2
1,657 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
[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
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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

A frequent question here in the MAS90 Zone is, How do you get data out of MAS90 for analysis, reporting or using the data on your web pages?   This is an introductory level tutorial to getting data out of MAS90 using ODBC. Data can be accessed by…
Hi, I've just fixed a problem with Sage 50 Accounts 2011 crashing when creating a new Company.  I've wasted several hours on it so I thought I'd share the solution with others.  Remarkably, the same laptop had what appears to be exactly the same …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

738 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