How to solve the error 3114 (Checksum mismatch in fetched da

For questions and postings not covered by the other forums
ConvertFromOldNGs
Posts: 5321
Joined: Wed Aug 05, 2009 5:19 pm

How to solve the error 3114 (Checksum mismatch in fetched da

Postby ConvertFromOldNGs » Fri Aug 07, 2009 12:35 pm

by tyc >> Thu, 27 May 2004 6:47:43 GMT

Hi,
I met the error 3114 (Checksum mismatch in fetched data, Database Open failed) using Jade bin310, but when I changed the jade bin310 to jade bin220 which is using for the system, it can work correctly.
I tried to use the jdbutil.exe to Verify Checksums, it gave me following text.

- checksum verification terminated due to error (3036) The database file being opened is required but was not found
Checksum error(s) exist
Refer to checksum.log

How to solve this problem? I'd appreciated if someone can help me solve it.

Thanks
Scott
Bizpoint System Pte Ltd

ConvertFromOldNGs
Posts: 5321
Joined: Wed Aug 05, 2009 5:19 pm

Re: How to solve the error 3114 (Checksum mismatch in fetched da

Postby ConvertFromOldNGs » Fri Aug 07, 2009 12:35 pm

by Jade Support >> Mon, 31 May 2004 22:30:05 GMT

In this instance the error has been caused by running the database against the wrong binaries.

A record-level checksum mechanism has been implemented so that corrupted records are detected when they are read from disk. This mechanism is implemented with hot-fix 5.2.8.192 included in this 5.2.8.220 consolidated release.

The checksum mechanism imposes no space or I/O overheads, and while the checksum calculation incurs a slight CPU burden, sensible use of database cache settings minimises the overhead because the mechanism is implemented at the disk file I/O interface.

When an updated record is flushed from the database cache, a record checksum is calculated and stored with the record; that is, checksums are applied gradually as objects are updated. If you want immediate proliferation of checksums to a file or the entire database, perform file-level operations; for example, compaction or re organization, which update all records.

When a check summed record is read into the database cache, the checksum is recalculated and compared. A mismatch will generate a 3114 exception ("Checksum mismatch in fetched data"). When this exception is raised during normal processing, the affected data is inaccessible. While it is possible for you to continue operations with degraded access to your data, to reinstate data integrity you must restore your database from backup and perform a roll-forward recovery. When a checksum error is detected during recovery processing, the recovery process is terminated.

For further information regarding this check summing, please review the readme.txt file supplied with consolidated patch 220 for JADE release 5.2.08.

The latest help files available are those PDF and Online Help documents shipped with 5.2.08.


Return to “General Discussion”

Who is online

Users browsing this forum: No registered users and 30 guests