Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 4 of 4 total |
Error 401 - makes no sense. |
Mon, May 12 2008 4:30 PM | Permanent Link |
"keith crusius" | I deleted an index called byFolderId then deleted that field. When I try to
open the table now I get error 401: the index byFolderId does not exist. (which is true). The only way I can get the table to open is to create an index called byFolderId (on any field). What's going on? I don't want the field or the index. Repairing the table didn't help. There are no constraints. FolderId was just another field, not the primary key. All this done using the EDB Manager. The reverse engineer code for the table is below. EXECUTE IMMEDIATE 'CREATE TABLE "IGNMsgList" ( "PK" INTEGER GENERATED BY DEFAULT AS IDENTITY (START WITH 13763, INCREMENT BY 1) NOT NULL, "MsgListGuid" VARCHAR(22) COLLATE "ANSI" NOT NULL, "MessageGUID" VARCHAR(22) COLLATE "ANSI", "ItemNo" SMALLINT, "JurisCode" VARCHAR(4) COLLATE "ANSI_CI", "CaseNo" VARCHAR(8) COLLATE "ANSI_CI", "CaseName" VARCHAR(75) COLLATE "ANSI_CI", "IsNew" BOOLEAN DEFAULT true, "IsRead" BOOLEAN DEFAULT false, "ProcessedFlag" VARCHAR(1) COLLATE "ANSI", "NumPdfExpected" SMALLINT, "NumPdfRetrieved" SMALLINT, "NumPdfMissed" SMALLINT, "NumPDFSkipped" SMALLINT, "NumErrorsOnPdf" SMALLINT, "MsgState" VARCHAR(5) COLLATE "ANSI", "Subject" VARCHAR(100) COLLATE "ANSI_CI", "SubSubject" CLOB COLLATE "ANSI_CI" COMPRESSION 6, "Date" TIMESTAMP, "EMailAddress" VARCHAR(50) COLLATE "ANSI_CI", "From" VARCHAR(75) COLLATE "ANSI_CI", "DocNo" SMALLINT, "ClaimNo" SMALLINT, "DocketText" CLOB COLLATE "ANSI_CI" COMPRESSION 6, "CredName" CLOB COLLATE "ANSI_CI" COMPRESSION 6, "TotAmtClaimed" FLOAT, "IsOfInterest" BOOLEAN, "NumAutoEvents" SMALLINT, "NumEvents" SMALLINT, "MsgEventsSummary" VARCHAR(5) COLLATE "ANSI", "Forwarded" BOOLEAN, "PreviewNote" CLOB COLLATE "ANSI_CI" COMPRESSION 6, "FolderGuid" VARCHAR(22) COLLATE "ANSI", CONSTRAINT "PrimaryKey" PRIMARY KEY ("PK") ) VERSION 1.08 UNENCRYPTED INDEX PAGE SIZE 4096 BLOB BLOCK SIZE 256 MAX ROW BUFFER SIZE 32768 MAX INDEX BUFFER SIZE 65536 MAX BLOB BUFFER SIZE 32768'; EXECUTE IMMEDIATE 'CREATE INDEX "ByMessageGUID" ON "IGNMsgList" ("MessageGUID" COLLATE "ANSI")'; EXECUTE IMMEDIATE 'CREATE INDEX "ByIsNew" ON "IGNMsgList" ("IsNew")'; EXECUTE IMMEDIATE 'CREATE INDEX "ByIsRead" ON "IGNMsgList" ("IsRead")'; EXECUTE IMMEDIATE 'CREATE INDEX "ByProcessedFlag" ON "IGNMsgList" ("ProcessedFlag" COLLATE "ANSI")'; EXECUTE IMMEDIATE 'CREATE INDEX "ByCaseNo" ON "IGNMsgList" ("CaseNo" COLLATE "ANSI_CI")'; EXECUTE IMMEDIATE 'CREATE INDEX "BySubject" ON "IGNMsgList" ("Subject" COLLATE "ANSI_CI")'; EXECUTE IMMEDIATE 'CREATE INDEX "ByDate" ON "IGNMsgList" ("Date")'; EXECUTE IMMEDIATE 'CREATE INDEX "ByItemNo" ON "IGNMsgList" ("ItemNo")'; EXECUTE IMMEDIATE 'CREATE INDEX "ByCaseName" ON "IGNMsgList" ("CaseName" COLLATE "ANSI_CI")'; EXECUTE IMMEDIATE 'CREATE INDEX "ByEMailAddress" ON "IGNMsgList" ("EMailAddress" COLLATE "ANSI_CI")'; EXECUTE IMMEDIATE 'CREATE INDEX "ByMsgState" ON "IGNMsgList" ("MsgState" COLLATE "ANSI")'; EXECUTE IMMEDIATE 'CREATE INDEX "ByNormalDisplayOrder" ON "IGNMsgList" ("JurisCode" COLLATE "ANSI", "CaseNo" COLLATE "ANSI", "Date")'; EXECUTE IMMEDIATE 'CREATE INDEX "ByDateDesc" ON "IGNMsgList" ("Date" DESC)'; EXECUTE IMMEDIATE 'CREATE TEXT INDEX "Text_DocketText" ON "IGNMsgList" ("DocketText" COLLATE "ANSI_CI") INDEXED WORD LENGTH ''15'' WORD GENERATOR "Default"'; EXECUTE IMMEDIATE 'CREATE TEXT INDEX "Text_Subject" ON "IGNMsgList" ("Subject" COLLATE "ANSI_CI") INDEXED WORD LENGTH ''15'' WORD GENERATOR "Default"'; EXECUTE IMMEDIATE 'CREATE TEXT INDEX "Text_CaseName" ON "IGNMsgList" ("CaseName" COLLATE "ANSI_CI") INDEXED WORD LENGTH ''15'' WORD GENERATOR "Default"'; EXECUTE IMMEDIATE 'CREATE TEXT INDEX "Text_CredName" ON "IGNMsgList" ("CredName" COLLATE "ANSI_CI") INDEXED WORD LENGTH ''15'' WORD GENERATOR "Default"'; EXECUTE IMMEDIATE 'CREATE INDEX "ByJurisCode" ON "IGNMsgList" ("JurisCode" COLLATE "ANSI_CI")'; EXECUTE IMMEDIATE 'CREATE INDEX "byMsgListGuid" ON "IGNMsgList" ("MsgListGuid" COLLATE "ANSI")'; EXECUTE IMMEDIATE 'CREATE INDEX "byFolderGuid" ON "IGNMsgList" ("FolderGuid" COLLATE "ANSI")'; EXECUTE IMMEDIATE 'CREATE INDEX "byfolderid" ON "IGNMsgList" ("NumEvents")'; |
Tue, May 13 2008 3:21 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | keith
Is there RI from another table using that index or is it used in a function somewhere? Roy Lambert [Team Elevate] |
Tue, May 13 2008 11:37 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Keith,
<< I deleted an index called byFolderId then deleted that field. When I try to open the table now I get error 401: the index byFolderId does not exist. (which is true). >> It may be an issue with the EDB Manager. I'll check it out and make sure that it is corrected for the next build. -- Tim Young Elevate Software www.elevatesoft.com |
Thu, May 15 2008 9:51 AM | Permanent Link |
"keith crusius" | No to both.
|
This web page was last updated on Wednesday, May 15, 2024 at 08:40 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |