Link to home
Start Free TrialLog in
Avatar of bnoyzy
bnoyzy

asked on

Quickbooks 2008/2009 verification errors upon backups

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 *==========================

ASKER CERTIFIED SOLUTION
Avatar of stlinae
stlinae
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of bnoyzy
bnoyzy

ASKER

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.