View Incident Report

Serious

Reported By: Terry Swiers
Reported On: 12/21/2020
For: Version 2.33 Build 2

# 4800 Failed Table Opens in SQL Statements Can Cause an Access Violation

This is a pretty unique scenario and hopefully I have all the steps required for you to reproduce it.

1. Using EDB Manager on a locally hosted Remote Session to create a remote file store that points to a store on a DIFFERENT EDB server instance. It doesn't matter what the name is or what it points to on the remote server. I just used "ABC" for the name to make it simple.

2. After verifying that you can see the files in the remote store, close it and turn the server engine off on the remote server.

3. Run the following script.

You should see AVs in the LogEvents table for the Prepare Statement, Free Statement, and Execute Script steps.

SCRIPT
BEGIN
DECLARE StoreName VarChar;
DECLARE TempCursor CURSOR FOR stmt;

SET StoreName = 'ABC';

EXECUTE IMMEDIATE 'SET FILES STORE TO "' + StoreName + '"';
PREPARE stmt FROM 'select * from configuration.Files where name like ''%.EDBBKP'' order by CreatedOn';
OPEN TempCursor;
UNPREPARE stmt;
END

Resolution

Fixed Problem on 1/2/2021 in version 2.34 build 1

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 PHP Standard
ElevateDB PHP Standard with Source
ElevateDB PHP Trial
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