Topic Options
#27457 - 05/30/11 11:19 AM Data Integrtiy check Errors
Henry Offline
Adagio Scholar

Registered: 03/28/08
Posts: 86
Loc: Burnaby, BC. Canada
Hi there,

Please see the following log for the erros I received. is there any way that I could find out the detail of this error ?

thanks

henry


Purchase Orders for Adagio: File Integrity

Comments ... Checked OK
Contract Pricing ... Checked OK
Competitive pricing ... Checked OK
Event Budgets ... Checked OK
User Group Access Levels ... Checked OK
User Groups Form Rights ... Checked OK
Header ... Checked OK
Header History ... Checked OK
Item History ... 2 error(s) found .............................................. FAILED
Header Req ... Checked OK
Header Template ... Checked OK
Import Export File Details ... Checked OK
Import Export File Header ... Checked OK
Import Defaults Field Values ... Checked OK
Sundry Items ... Checked OK
Details History Additional ... Checked OK
Details History ... Checked OK
Details Master ... 2 error(s) found ............................................ FAILED
Details Additional ... Checked OK
Details Req Additional ... Checked OK
Details Req 1 ... Checked OK
Details Template ... Checked OK
Miscellaneous Charges ... Checked OK
Item Pictures ... Checked OK
Pick-up Addresses ... Checked OK
Screen Defaults ... Checked OK
Shipto Addresses ... Checked OK
Totals History ... Checked OK
Totals Req ... Checked OK
Totals Template ... Checked OK
Totals ... Checked OK
Tax Groups ... Checked OK
Tax Group Jurisdictions ... Checked OK
Audit ... Checked OK
User Groups ... Checked OK
Sundry Vendors ... Checked OK

Summary

File Integrity ... 4 error(s) found ............................................ FAILED

Finished at: 2011.05.28 10:06

Data Repair Phase

Rebuild not requested in job.

Top
#27458 - 05/30/11 11:21 AM Re: Data Integrtiy check Errors [Re: Henry]
Henry Offline
Adagio Scholar

Registered: 03/28/08
Posts: 86
Loc: Burnaby, BC. Canada
FYI, here is the log file from Datacare

Data Integrity of:
Located on: Y:\ADDATA\ with extension: CNF
Started at: 2011.05.28 09:59 by Henry Wang
Job: CHECK

Backup of:
Backup file: Y:\ADDATA\DATABACK\DCB3.ZIP
Backing up data at: Y:\ADDATA\ with extension: CNF
Backing up data with prefix: IR SD
Backup started at: 2011.05.28 09:59 by Henry Wang
Backup completed ... OK
Backup finished at: 2011.05.28 10:00

Adagio BankRec: File Integrity

Bank Notes Header ... Checked OK
Banks ... Checked OK
Bank Notes Detail ... Checked OK
Batch (Active) Status Control ... Checked OK
Reconciliation Detail ... Checked OK
Reconciliation Header ... Checked OK
Reconciliation Sub Detail ... Checked OK
Distribution Codes ... Checked OK
Distribution Sets Detail ... Checked OK
Distribution Sets Header ... Checked OK
Email Cover Detail ... Checked OK
Email Cover Header ... Checked OK
Smart Finder Control ... Checked OK
Filter Matches ... Checked OK
Filter Master ... Checked OK
Import Recon Matching ... Checked OK
Receipt History Detail ... Checked OK
Receipt History Header ... Checked OK
Statement Info ... Checked OK
Tax Descriptions ... Checked OK
Import Default Field Values ... Checked OK
Import Export File Header ... Checked OK
Import Export File Details ... Checked OK
Security Groups ... Checked OK

Adagio Common Files: File Integrity

Fax Queue ... Checked OK
Grid Settings ... Checked OK
Optional Field Det Options ... Checked OK
Optional Field Hdr Options ... Checked OK
Optional Field Values ... Checked OK
Report Options ... Checked OK
User Preferences ... Checked OK

Adagio Contacts: File Integrity

Callback Codes ... Checked OK
Customer Callback Dates ... Checked OK
Smart Finder Control ... Checked OK
Import Export File Details ... Checked OK
Import Export File Header ... Checked OK
Import Defaults Field Values ... Checked OK
Notes Detail ... Checked OK
Notes Header ... Checked OK
Prospect Callback Dates ... Checked OK
Profiles ... Checked OK
Prospects ... Checked OK

Adagio DataCare: File Integrity

Applications ... Checked OK
Email Body ... Checked OK
Email Options ... Checked OK
Smart Finder Control ... Checked OK
Backup Folders ... Checked OK
History Detail ... Checked OK
History Header ... Checked OK
Job Detail ... Checked OK
Job Header ... Checked OK
Profiles ... Checked OK

Adagio Inventory: File Integrity

Alternative Price List ... Checked OK
Item Alerts ... Checked OK
Bill of Material List Detail ... Checked OK
Bill of Material List Header ... Checked OK
Category ... Checked OK
Smart Finder Control ... Checked OK
Filter Matches ... Checked OK
Filter Master ... Checked OK
Transaction History ... Checked OK
Item Locations ... Checked OK
Item Locations Reorder ... Checked OK
Item Notes Header ... Checked OK
Item Notes Detail ... Checked OK
Import Export file Details ... Checked OK
Import Export File header ... Checked OK
Import Defaults Field Values ... Checked OK
Items (2) Additional ... Checked OK
Item (3) Extension ... Checked OK
Items (1) ... Checked OK
Locations ... Checked OK
Multiple Smart Finder Control ... Checked OK
Price List Codes ... Checked OK
P/O Receipt Detail ... Checked OK
P/O Receipt Header ... Checked OK
Report Set Details ... Checked OK
Report Groups ... Checked OK
Report Header ... Checked OK
Tax File ... Checked OK
Tax Groups ... Checked OK
Units of Measure ... Checked OK
Import Default Field Values ... Checked OK
Import Export File Header ... Checked OK
Import Export File Details ... Checked OK
Security Groups ... Checked OK

Adagio Ledger: File Integrity

Account Information (Old) ... Checked OK
Account Reallocation ... Checked OK
Account Notes Header ... Checked OK
Account Notes Detail ... Checked OK
Batch Control File ... Checked OK
Tr Batch Detail A ... Checked OK
Tr Batch Detail C ... Checked OK
Tr Batch Header A ... Checked OK
Tr Batch Header C ... Checked OK
Account Net Changes ... Checked OK
Account Budgets ... Checked OK
Account Net Changes 90C ... Checked OK
Department Information ... Checked OK
Account MC Buckets ... Checked OK
Fiscal Periods ... Checked OK
Import Export Details ... Checked OK
Import Export Header ... Checked OK
Import Defaults ... Checked OK
Account Master ... Checked OK
Retrieval Batches Info ... Checked OK
Revaluation Codes ... Checked OK
Ledger Source Code ... Checked OK
Account Groups ... Checked OK
Source Journal Information ... Checked OK
Import Default Field Values ... Checked OK
Import Export File Header ... Checked OK
Import Export File Details ... Checked OK
Security Groups ... Checked OK

Adagio OrderEntry: File Integrity

Order Action Template Details ... Checked OK
Order Action Template Header ... Checked OK
Email Cover Detail ... Checked OK
Email Cover Header ... Checked OK
Email Queue ... Checked OK
Smart Finder Control ... Checked OK
Filter History Master ... Checked OK
Filter Matches ... Checked OK
Filter Master ... Checked OK
Filter History Matches ... Checked OK
Sales Order Header ... Checked OK
Sales Order Header Extension ... Checked OK
History Header ... Checked OK
History Header Extension ... Checked OK
History Detail ... Checked OK
Import Export file Details ... Checked OK
Import Export File header ... Checked OK
Sales Order Detail ... Checked OK
Miscellaneous Charges ... Checked OK
Profiles ... Checked OK
Profiles Extension ... Checked OK
Report Set Details ... Checked OK
Report Set Header ... Checked OK
Shipto Addresses Alerts ... Checked OK
Shipto Addresses Extension ... Checked OK
Shipto Addresses ... Checked OK
Salespersons ... Checked OK
Special Prices ... Checked OK
Summary Statistics ... Checked OK
Tax Tables ... Checked OK
Text ... Checked OK
Tax Groups ... Checked OK
Import Default Field Values ... Checked OK
Import Export File Header ... Checked OK
Import Export File Details ... Checked OK

Adagio Payables: File Integrity

Control Account Sets ... Checked OK
Vendor Alerts ... Checked OK
Archived Inv Batch Detail 15A ... Checked OK
Archived Inv Batch Detail 354A ... Checked OK
Archived Inv Batch Detail 356A ... Checked OK
Archived Inv Batch Detail 357A ... Checked OK
Archived Inv Batch Detail 358A ... Checked OK
Archived Inv Batch Detail 359A ... Checked OK
Archived Inv Batch Detail 360A ... Checked OK
Archived Inv Batch Detail 362A ... Checked OK
Archived Inv Batch Detail 366A ... Checked OK
Archived Inv Batch Detail 367A ... Checked OK
Archived Inv Batch Detail 368 ... Checked OK
Archived Inv Batch Detail 369 ... Checked OK
Archived Inv Batch Detail 371 ... Checked OK
Archived Inv Batch Detail 372 ... Checked OK
Archived Inv Batch Detail 374 ... Checked OK
Archived Inv Batch Detail 375 ... Checked OK
Archived Inv Batch Detail 376 ... Checked OK
Archived Inv Batch Detail 378 ... Checked OK
Archived Inv Batch Detail 379 ... Checked OK
Archived Inv Batch Detail 382 ... Checked OK
Bank Account Options ... Checked OK
Bank Account Sets ... Checked OK
Batch Status Control ... Checked OK
Check Reconciliation Detail ... Checked OK
Check Reconciliation Header ... Checked OK
Check Reconciliation Pending ... Checked OK
Distribution Sets Detail 65 ... Checked OK
Distribution Codes ... Checked OK
Distribution Sets Detail ... Checked OK
Distribution Sets Header ... Checked OK
Email Cover Detail ... Checked OK
Email Cover Header ... Checked OK
Email Queue ... Checked OK
Smart Finder Control ... Checked OK
Filter Matches ... Checked OK
Filter Master ... Checked OK
1099 Forms ... Checked OK
G/L Disbursements ... Checked OK
Transaction History ... Checked OK
Invoice Batch Detail 0247 ... Checked OK
Invoice Batch Detail 0249 ... Checked OK
Invoice Batch Detail 0252 ... Checked OK
Invoice Batch Detail 0253 ... Checked OK
Invoice Batch Detail 0255 ... Checked OK
Invoice Batch Detail 0257 ... Checked OK
Invoice Batch Detail 0258 ... Checked OK
Invoice Batch Detail 0259 ... Checked OK
Invoice Batch Detail 0260 ... Checked OK
Invoice Batch Detail 0261 ... Checked OK
Invoice Batch Detail 0266 ... Checked OK
Invoice Batch Header 0247 ... Checked OK
Invoice Batch Header 0249 ... Checked OK
Invoice Batch Header 0252 ... Checked OK
Invoice Batch Header 0253 ... Checked OK
Invoice Batch Header 0255 ... Checked OK
Invoice Batch Header 0257 ... Checked OK
Invoice Batch Header 0258 ... Checked OK
Invoice Batch Header 0259 ... Checked OK
Invoice Batch Header 0260 ... Checked OK
Invoice Batch Header 0261 ... Checked OK
Invoice Batch Header 0266 ... Checked OK
Import Export file Details ... Checked OK
Import Export File header ... Checked OK
Import Defaults Field Values ... Checked OK
Manual Check Batch Detail 0114 ... Checked OK
Manual Check Batch Detail 0117 ... Checked OK
Manual Check Batch Detail 0118 ... Checked OK
Manual Check Batch Detail 0120 ... Checked OK
Manual Check Batch Detail 0121 ... Checked OK
Manual Check Batch Header 0114 ... Checked OK
Manual Check Batch Header 0117 ... Checked OK
Manual Check Batch Header 0118 ... Checked OK
Manual Check Batch Header 0120 ... Checked OK
Manual Check Batch Header 0121 ... Checked OK
Transaction Matching ... Checked OK
Vendor Payee ... Checked OK
System Check Paylist ... Checked OK
Profiles ... Checked OK
Recurring Batch Detail 15A ... Checked OK
Recurring Batch Detail 354A ... Checked OK
Recurring Batch Detail 356A ... Checked OK
Recurring Batch Detail 357A ... Checked OK
Recurring Batch Detail 358A ... Checked OK
Recurring Batch Detail 359A ... Checked OK
Recurring Batch Detail 360A ... Checked OK
Recurring Batch Detail 362A ... Checked OK
Recurring Batch Detail 366A ... Checked OK
Recurring Batch Detail 367A ... Checked OK
Recurring Batch Detail 368 ... Checked OK
Recurring Batch Detail 369 ... Checked OK
Recurring Batch Detail 371 ... Checked OK
Recurring Batch Detail 372 ... Checked OK
Recurring Batch Detail 374 ... Checked OK
Recurring Batch Detail 375 ... Checked OK
Recurring Batch Detail 376 ... Checked OK
Recurring Batch Detail 378 ... Checked OK
Recurring Batch Detail 379 ... Checked OK
Recurring Batch Detail 382 ... Checked OK
Retainage File AJ ... Checked OK
Retainage File ... Checked OK
Revaluation Criteria ... Checked OK
Terms ... Checked OK
Transactions ... Checked OK
Tax Descriptions ... Checked OK
Vendor ... Checked OK
Vendor Notes Header ... Checked OK
Vendor Notes Detail ... Checked OK
Vendor Extension ... Checked OK
Import Default Field Values ... Checked OK
Import Export File Header ... Checked OK
Import Export File Details ... Checked OK

Adagio Receivables: File Integrity

Control Accounts ... Checked OK
Adjustment Batch Detail ... Checked OK
Adjustment Batch Header ... Checked OK
Customer Alerts ... Checked OK
Customer Alert Messages ... Checked OK
Batch Control File ... Checked OK
Customer Notes Header ... Checked OK
Customer Notes Detail ... Checked OK
Customer Recurring Charges ... Checked OK
Chart Definitions ... Checked OK
Cash Batch Detail ... Checked OK
Customer Extension 2 ... Checked OK
Cash Batch Header ... Checked OK
Customer Master ... Checked OK
Billing Cycles ... Checked OK
Distribution Codes ... Checked OK
Distribution Sets Detail ... Checked OK
Distribution Sets Header ... Checked OK
Email Cover Detail ... Checked OK
Email Cover Header ... Checked OK
Email Queue ... Checked OK
Filter Matches ... Checked OK
Filter Master ... Checked OK
Transaction G/L Details ... Checked OK
Invoice Batch Detail ... Checked OK
Invoice Batch Header ... Checked OK
Transaction Matching File ... Checked OK
Payment Methods ... Checked OK
Recurring Charges ... Checked OK
Report Groups ... Checked OK
Retainage Transactions ... Checked OK
Contacts ... Checked OK
Contact Alerts ... Checked OK
Salespersons ... Checked OK
Contact Alert Messages ... Checked OK
Tax Tracking ... Checked OK
Territories ... Checked OK
Payment Terms ... Checked OK
Transactions ... Checked OK
Tax Descriptions ... Checked OK
Import Default Field Values ... Checked OK
Import Export File Header ... Checked OK
Import Export File Details ... Checked OK
Security Groups ... Checked OK

Adagio SalesAnalysis: File Integrity

Archive/Purge Template Details ... Checked OK
Archive/Purge Template Header ... Checked OK
Chart Definitions ... Checked OK
Smart Finder Control ... Checked OK
Filter Matches ... Checked OK
Filter Master ... Checked OK
Item Descriptions ... Checked OK
Online Inquiry Template Details ... Checked OK
Online Inquiry Template Header ... Checked OK
Sales Statistics ... Checked OK
Transactions Extension 9.0A ... Checked OK
Transactions 9.0A ... Checked OK
Import Default Field Values ... Checked OK
Import Export File Header ... Checked OK
Import Export File Details ... Checked OK
Security Groups ... Checked OK

Purchase Orders for Adagio: File Integrity

Comments ... Checked OK
Contract Pricing ... Checked OK
Competitive pricing ... Checked OK
Event Budgets ... Checked OK
User Group Access Levels ... Checked OK
User Groups Form Rights ... Checked OK
Header ... Checked OK
Header History ... Checked OK
Item History ... 2 error(s) found .............................................. FAILED
Header Req ... Checked OK
Header Template ... Checked OK
Import Export File Details ... Checked OK
Import Export File Header ... Checked OK
Import Defaults Field Values ... Checked OK
Sundry Items ... Checked OK
Details History Additional ... Checked OK
Details History ... Checked OK
Details Master ... 2 error(s) found ............................................ FAILED
Details Additional ... Checked OK
Details Req Additional ... Checked OK
Details Req 1 ... Checked OK
Details Template ... Checked OK
Miscellaneous Charges ... Checked OK
Item Pictures ... Checked OK
Pick-up Addresses ... Checked OK
Screen Defaults ... Checked OK
Shipto Addresses ... Checked OK
Totals History ... Checked OK
Totals Req ... Checked OK
Totals Template ... Checked OK
Totals ... Checked OK
Tax Groups ... Checked OK
Tax Group Jurisdictions ... Checked OK
Audit ... Checked OK
User Groups ... Checked OK
Sundry Vendors ... Checked OK

Summary

File Integrity ... 4 error(s) found ............................................ FAILED

Finished at: 2011.05.28 10:06

Data Repair Phase

Rebuild not requested in job.

Top
#27460 - 05/30/11 11:25 AM Re: Data Integrtiy check Errors [Re: Henry]
Softrak Support Offline

Adagio Action Team

Registered: 03/09/99
Posts: 11520
Loc: Vancouver, BC Canada
Hi Henry,

This is a File Integrity Error, so the details of the error will typically be something like a missing index. The check process did not attempt to Rebuild the error. You can choose to make a backup of your data and attempt a Rebuild, or restore your data from a good backup, or contact your Adagio consultant to schedule a database repair.

You probably will want to contact your Adagio consultant anyway, whenever data integrity errors occur, even if you are planning on attempting the data Rebuild (found within the integrity check function).
_________________________
Regards,
Softrak Tech Support

Top


Moderator:  Christa_Meissner 
Who's Online
0 registered (), 69 Guests and 1 Spider online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14449 Topics
70594 Posts

Max Online: 432 @ 01/20/25 10:17 PM
April
Su M Tu W Th F Sa
1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30