View Incident Report

Serious

Reported By: Shawn Van Riper
Reported On: 1/29/2004
For: Version 4.02 Build 1

# 1536 Certain Live SELECT Queries and Filters Cause #8965 "Page Buffers Corrupt" Errors

After upgrading a previously working project from 4.01 to 4.02, an index page buffers corrupt exception started to occur when the application ran a particular query. The error could be duplicated in dbsys.exe. However, in dbsys.exe, if the query was run a second time, no error would occur. If the query was unprepared and the query was re-run the error would occur again. Further investigation showed that the problem could be solved by changing the query so that "(PROCESSED=0 OR PROCESSED IS NULL)" was "PROCESSED<>1".

SELECT 
RECID,USERID,TIMETAG,LATITUDE,PROCESSED,LONGITUDE,SPEED,DISTANCE,
HEADING,DIRECTION,STOPRECID,STOPSTATUS,STOPTIME
FROM GPSDATA WHERE (PROCESSED=0 OR PROCESSED IS NULL) AND 
POSSRC='G' ORDER BY USERID,TIMETAG
TOP 100000

Comments and Workarounds

The problem only occurred when selecting a very small portion of records from a fairly large table.

Resolution

Fixed Problem on 2/1/2004 in version 4.03 build 1

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap