View Incident Report

Serious

Reported By: Kick Martens
Reported On: 5/7/2010
For: Version 2.03 Build 13

# 3206 Executing RENAME TABLE on a Newly-Created Table Can Cause File Manager Error

I want to Empty a very large table and DELETE FROM xx takes very long. Its much faster to Drop the table and recreate it. But if I execute these queries after each other, I get an error saying:

ElevateDB Error #600 File manager error (Cannot rename the file E:\ElevateDB DataFiles\Data2Ba\artikelen_tmp.EDBTbl to E:\ElevateDB DataFiles\Data2Ba\artikelen.EDBTbl (OS Error: Het systeem kan het opgegeven bestand niet vinden.
))

The OS Error is saying in Dutch that the system cannot find the file specified!

CREATE TABLE atable_tmp (LIKE atable) 
DROP TABLE atable;
RENAME TABLE atable_tmp atable;

Comments and Workarounds

The problem was that the file wasn't physically created on disk yet since it hadn't been opened. The workaround is to simply execute a dummy:

SELECT * FROM Table

statement in-between the DROP TABLE and RENAME TABLE statements. The table to SELECT from is the table that is going to be renamed.

Resolution

Fixed Problem on 5/10/2010 in version 2.03 build 14

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

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap