Solved

Quickbooks 2008/2009 verification errors upon backups

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

ScreenConnect 6.0 Free Trial

Check out the updates in one game-changing release, ScreenConnect 6.0, based on partner feedback. New features include a redesigned UI that improves session organization and overall user experience. See the enhancements for yourself!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
QBpos and QB pro 6 123
Trigger to push data from a table in one database to another 13 33
The History of "The Balance Sheet" 5 103
URL address to download QuickBooks 23 3 89
Hi, I've just fixed a problem with Sage 50 Accounts 2010 crashing when creating a new Company.  I've spent nearly 4 hours on it including three calls to the Sage helpdesk (they didn't work it out in the end - I did!) ... so I thought I'd share th…
You may need to view past transactions from previous QuickBooks files or other QuickBooks company files when:       1. you are working in another QuickBooks file       2. QuickBooks is closed QuickBooks users who would benefit from this artic…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
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…

770 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