Icon View Incident Report

Serious Serious
Reported By: Keith Crusius
Reported On: 3/31/2008
For: Version 1.09 Build 1
# 2589 An Attempt to Create a Duplicate Index Name using CREATE INDEX Causes Table Version Number Increment

I have a table that won't open and gives error #100 "..error in the metadata...(signature, password, char set, or version number mismatch)"

Below is how the problem started. The table that won't open is named IGNDocs001. I wanted to make at 17th table but when I ran the below script the first time I accidently left the second to last line as

EXECUTE IMMEDIATE 'CREATE INDEX "ByDocGUID" ON "IGNDocs001"

because I had copied the code. So I got an error that the index already existed (which it did for IGNDocs001). So I fixed the error and reran the script after dropping the 017 table. The 017 table was created and opens fine, but now I can't get the 001 table to open. I did all this from ElevateDB Manager.

EXECUTE IMMEDIATE 'CREATE TABLE "IGNDocs017"
                  (
                  "PK" INTEGER GENERATED BY DEFAULT AS IDENTITY
                    (START WITH 1, INCREMENT BY 1),
                  "DocGUID" VARCHAR(22) COLLATE "ANSI",
                  "CompressedDocument" BLOB,
                  "CompressedDocumentSize" INTEGER,
                  CONSTRAINT "PrimaryKey" PRIMARY KEY ("PK")
                  )
                  VERSION 1
                  UNENCRYPTED
                  INDEX PAGE SIZE 4096
                  BLOB BLOCK SIZE 512
                  MAX ROW BUFFER SIZE 32768
                  MAX INDEX BUFFER SIZE 65536
                  MAX BLOB BUFFER SIZE 32768';

EXECUTE IMMEDIATE 'CREATE INDEX "ByDocGUID" ON "IGNDocs017"
                  ("DocGUID" COLLATE "ANSI")';



Resolution Resolution
Fixed Problem on 4/2/2008 in version 1.09 build 2


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 VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial

Image