View Incident Report

Serious

Reported By: James Relyea
Reported On: 10/31/2009
For: Version 2.03 Build 5

# 3095 ALTER TABLE Statements That Encounter Errors Can Cause Error About a Non-Existent Temporary Table

I'm seeing a missing temp table error whenever I add attempt to add a constraint to a table. There's something with the name "tContacts->tCorps_tContacts_XRef" that EDB can't process because the same error keeps coming up. However, creating the same constraint of tCorps_tContacts_XRef.idContactId referenced by tContacts.idContactId and naming it "tCortConXr" gets created successfully.

FAILS:
ALTER TABLE "tCorps_tContacts_XRef"
RENAME CONSTRAINT "tCorps__tCorps_tContacts_XRef" TO
   "tCorps->tCorps_tContacts_XRef",
ALTER CONSTRAINT "tCorps->tCorps_tContacts_XRef" AS
   FOREIGN KEY ("idCorpId") REFERENCES "tCorps" ("idCorpID")
   ON UPDATE RESTRICT ON DELETE RESTRICT

ALTER TABLE "tCorps_tContacts_XRef"
RENAME CONSTRAINT "tCorps__tCorps_tContacts_XRef" TO
   "tCorps:tCorps_tContacts_XRef",
ALTER CONSTRAINT "tCorps:tCorps_tContacts_XRef"
   AS FOREIGN KEY ("idCorpId") REFERENCES "tCorps" ("idCorpID")
   ON UPDATE RESTRICT ON DELETE RESTRICT
 
WORKS:
ALTER TABLE "tCorps_tContacts_XRef"
RENAME CONSTRAINT "tCorps__tCorps_tContacts_XRef" TO
   "tCorps-tCorps_tContacts_XRef",
ALTER CONSTRAINT "tCorps-tCorps_tContacts_XRef"
   AS FOREIGN KEY ("idCorpId") REFERENCES "tCorps"
   ("idCorpID") ON UPDATE RESTRICT ON DELETE RESTRICT
 
ALTER TABLE "tCorps_tContacts_XRef"
RENAME CONSTRAINT "tCorps-tCorps_tContacts_XRef" TO
   "tCorps--tCorps_tContacts_XRef",
ALTER CONSTRAINT "tCorps--tCorps_tContacts_XRef"
   AS FOREIGN KEY ("idCorpId") REFERENCES "tCorps" ("idCorpID")
   ON UPDATE RESTRICT ON DELETE RESTRICT

Comments

The problem was that the constraint naming error would cause a cascading failure that resulted in the non-existent temporary table error.

Resolution

Fixed Problem on 11/6/2009 in version 2.03 build 6

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