IBConsole

Dan Richardson
email: dan@dstreamd.com

When I attempt to view data of one of my tables in the
data tab of the properties dialog, I get the following
error:

internal gds software consistency check (can't
continue after bugcheck)

In keeping with the error message, IBConsole must be
closed and restarted in order to continue.

The error occurs in both IBConsole 1.0.0.336 and
1.0.0.339. This particular table is empty. I'll be
happy to full metadata of the database or even a
backup if anyone is interested.

The metadata of the table is:


/* Table: CALCTIMEELEMENT, Owner: SYSDBA */

CREATE TABLE "CALCTIMEELEMENT"
(
"CALC_TIME_ELEMENT" INTEGER NOT NULL,
"PROJECT" INTEGER NOT NULL,
"NAME" VARCHAR(40) NOT NULL,
"DESCRIPTION" VARCHAR(256),
"FORMULA" BLOB SUB_TYPE TEXT SEGMENT SIZE 80,
CONSTRAINT "CALC_TIME_ELEMENT_PK" PRIMARY KEY
("CALC_TIME_ELEMENT"),
CONSTRAINT "CTELEMENT_PROJ_CTE_NAME_UC" UNIQUE
("PROJECT", "CALC_TIME_ELEMENT", "NAME")
);
ALTER TABLE "CALCTIMEELEMENT" ADD
CONSTRAINT "CALCTIMEELEMENT_PROJECT_FK" FOREIGN KEY
("PROJECT") REFERENCES PROJECT ("PROJECT");
SET TERM ^ ;


/* Triggers only will work for SQL triggers */

CREATE TRIGGER "CALCTIMEELEMENT_BINS"
FOR "CALCTIMEELEMENT"
ACTIVE BEFORE INSERT POSITION 0
as
begin
if (new.CALC_TIME_ELEMENT is null) then
new.CALC_TIME_ELEMENT = gen_id(CALCTIMEELEMENT,
1);
end
^

CREATE TRIGGER "CALCTIMEELEMENT_AINS"
FOR "CALCTIMEELEMENT"
ACTIVE AFTER INSERT POSITION 0
as
begin
post_event 'CALCTIMEELEMENT_INSERT';
end
^

CREATE TRIGGER "CALCTIMEELEMENT_AUPD"
FOR "CALCTIMEELEMENT"
ACTIVE AFTER UPDATE POSITION 0
as
begin
post_event 'CALCTIMEELEMENT_UPDATE';
end
^

CREATE TRIGGER "CALCTIMEELEMENT_ADEL"
FOR "CALCTIMEELEMENT"
ACTIVE AFTER DELETE POSITION 0
as
begin
post_event 'CALCTIMEELEMENT_DELETE';
end
^

COMMIT WORK ^
SET TERM ;^