I took a look at the SYSPERMS table and there is no entry for the table causing the error in ipreparetree.
Is there a way we can trace the sql commands run and see why this line is never added?
My sql script used to create the table looks like this:
DROP TABLE PropertyStore;
DROP TABLE FileStore;
-- Set Index Directory --
--SET INDEXSPACE='F:\';
-- Create the PropertyStore Table and indexes --
CREATE TABLE PropertyStore
(
DocumentUrl
VARCHAR(255)
NOT NULL
PRIMARY KEY,
Hash
CHAR(50),
DocumentIdentifier
CHAR(40)
NOT NULL,
SessionIdentifier
CHAR(40)
NOT NULL,
LastVerified
DATE
);
CREATE UNIQUE INDEX DocUrlIndex on PropertyStore (DocumentUrl);
CREATE INDEX DocUrlHashIndex on PropertyStore(DocumentUrl, Hash);
-- Create The FileStore table and index --
CREATE TABLE FileStore
(
DocumentIdentifier
CHAR(40)
NOT NULL
PRIMARY KEY,
PageNumber
INTEGER
NOT NULL
PRIMARY KEY,
PlainText
VARCHAR(1000)
NOT NULL,
BinaryContent
BLOB
);
CREATE METAMORPH INVERTED INDEX FTPlainTextIndex on FileStore(PlainText);
CREATE UNIQUE INDEX DocIdentifierPageNumberIndex on FileStore(DocumentIdentifier, PageNumber);
Is there a way we can trace the sql commands run and see why this line is never added?
My sql script used to create the table looks like this:
DROP TABLE PropertyStore;
DROP TABLE FileStore;
-- Set Index Directory --
--SET INDEXSPACE='F:\';
-- Create the PropertyStore Table and indexes --
CREATE TABLE PropertyStore
(
DocumentUrl
VARCHAR(255)
NOT NULL
PRIMARY KEY,
Hash
CHAR(50),
DocumentIdentifier
CHAR(40)
NOT NULL,
SessionIdentifier
CHAR(40)
NOT NULL,
LastVerified
DATE
);
CREATE UNIQUE INDEX DocUrlIndex on PropertyStore (DocumentUrl);
CREATE INDEX DocUrlHashIndex on PropertyStore(DocumentUrl, Hash);
-- Create The FileStore table and index --
CREATE TABLE FileStore
(
DocumentIdentifier
CHAR(40)
NOT NULL
PRIMARY KEY,
PageNumber
INTEGER
NOT NULL
PRIMARY KEY,
PlainText
VARCHAR(1000)
NOT NULL,
BinaryContent
BLOB
);
CREATE METAMORPH INVERTED INDEX FTPlainTextIndex on FileStore(PlainText);
CREATE UNIQUE INDEX DocIdentifierPageNumberIndex on FileStore(DocumentIdentifier, PageNumber);