Icon View Incident Report

Serious 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 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:


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 Resolution
Fixed Problem on 5/10/2010 in version 2.03 build 14

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