View Incident Report

Serious

Reported By: Ole Willy Tuv
Reported On: 6/22/2007
For: Version 1.04 Build 2

# 2389 #601 Error Can Occur When Querying a View Based Upon a Grouped SELECT Statement

When executing the following query on the following view, I'm getting the error:

ElevateDB Error #601 The temporary table OWTT4258045088UserTests1 is corrupt (Cannot find row during retrieval from cache)

The query works as expected without the WHERE clause.

View:

create view bt as
select *,
cast((max(einde) - min(aanvang)) hour to minute as varchar(20)) as 
BestedeTijd
from Registraties
group by
 Id_Medewerker,
 Datum,
 Id_Campagne,
 Id_Arbeidscode,
 Id_Team,
 Geaccordeerd

Query:

select *
from bt
where Id_Medewerker = '20020'

Resolution

Fixed Problem on 6/23/2007 in version 1.04 build 3

Products Affected

ElevateDB Additional Software and Utilities
ElevateDB VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap