Icon View Incident Report

Minor Minor
Reported By: Tiago Ameller
Reported On: 4/1/2009
For: Version 2.02 Build 10
# 2970 Trying to Create a Temporary Table in the Configuration Database Causes AV

The following script raises:

ElevateDB Error #900 An error occurred with the statement at line 7 and column 1 (Access violation at address 00000000. Write of address 00000000)

/*
 Export today's server log to csv
*/               
SCRIPT ()
BEGIN
 EXECUTE IMMEDIATE 
' CREATE TEMPORARY TABLE TODAYS_LOG AS
 SELECT
 "LOGTIMESTAMP",
 "USER",
 "CATEGORY",
 "FUNCTION",
 "DESCRIPTION"
 FROM
 CONFIGURATION.LOGEVENTS
 WHERE
 LOGTIMESTAMP BETWEEN CURRENT_DATE AND
 CURRENT_DATE + INTERVAL "1" DAY
 WITH DATA';
 
 EXECUTE IMMEDIATE 
   'EXPORT TEMPORARY TABLE TODAYS_LOG TO "TODAYS_LOG.CSV"
   IN STORE CLIENTS
   DELIMITER CHAR '';''
   DATE FORMAT ''DD/MM/YYYY''
   TIME FORMAT ''HH:MM:SS''
   DECIMAL CHAR '',''
   INCLUDE HEADERS';
END



Comments Comments and Workarounds
The AV is caused when you try to create a temporary table (not a normal table) in the Configuration database.


Resolution Resolution
Fixed Problem on 4/2/2009 in version 2.02 build 11


Products Affected Products Affected
ElevateDB Additional Software and Utilities
ElevateDB DAC Client-Server
ElevateDB DAC Client-Server with Source
ElevateDB DAC Standard
ElevateDB DAC Standard with Source
ElevateDB DAC Trial
ElevateDB LCL Standard with Source
ElevateDB VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial

Image