invalid objectname 'NODES' select * from NODES

Hi,

today I installed version 5.3.4.0 of Active Table Editor.
After running the program I get the error message, which is shown in the screenshot. It says: 'invalid objectname 'NODES' select * from NODES'.

If I click OK, Active Table Editor is run.
If I install version 5.3.3.0, I get the same error message. The latest version, which doesn't show the error, is version 5.3.2.0.
I already checked the repository connection details.
Do you know why this error is displayed?

Best Regards

Julian

Hi Jullian

Can you tell us your repository type please?

Hi Mike,

my repository type is MS SQL Server.

Best Regards

Julian

Please run the following SQL script against your repository and let us now the outcome

Insert into OBJECT_TYPES
(OBJECT_TYPE,OBJECT_TYPE_NAME)
Values
('903','MongoDB Connection')

Insert into OBJECT_TYPES
(OBJECT_TYPE,OBJECT_TYPE_NAME)
Values
('904','MongoDB Connections')

INSERT INTO OBJECTS_TREE
(OBJECT_ID,
PARENT_ID,
NAME,
OBJECT_TYPE
)
Select
OBJECT_ID*-4 as OBJECT_ID,
PARENT_ID,
'MongoDB' as NAME,
903 as OBJECT_TYPE
From
OBJECTS_TREE
where OBJECTS_TREE.OBJECT_TYPE=320

UPDATE OBJECT_TYPES
set OBJECT_TYPE_GROUP=22000
WHERE OBJECT_TYPE= '903'

CREATE TABLE [EVENT_MONITORS] (
[EVENT_MONITOR_ID] decimal(28, 0) NOT NULL ,
[EVENT_MONITOR_DESCRIPTION] NVARCHAR (255) NOT NULL ,
[EVENT_MONITOR_TYPE] decimal(28, 0) NOT NULL ,
[ENABLE_EXECUTION] decimal(1, 0) NOT NULL default 0,
[CONNECTION_ID] decimal(28, 0) NULL ,
[COMPUTER_TO_MONITOR] NVARCHAR (64) NOT NULL ,
[EVENT_MONITOR_COMMENTS] [image] NULL ,
[EVENT_MONITOR_PARAMETERS] [image] NULL ,
[OBJECT_ID] decimal(28, 0) NOT NULL ,
[COMPUTER_TO_EXECUTE_ON] NVARCHAR (64) NOT NULL,
[APPLICATION_PLATFORM] NVARCHAR (30) NULL,
[NUMBER_OF_EXECUTIONS] decimal(28, 0) NULL default 0,
[TERMINATE_ON_TIMEOUT] decimal(1, 0) NULL default 0,
[EXPECTED_EXECUTION_TIME] [datetime] NULL ,
[CREATED] [datetime] NOT NULL ,
[CREATED_BY] NVARCHAR (32) NULL ,
[CHANGED] [datetime] NOT NULL ,
[CHANGED_BY] NVARCHAR (32) NOT NULL
)
GO

CREATE TABLE [NODES] (
[NODE_NAME] NVARCHAR (64) NOT NULL ,
[NODE_DESCRIPTION] NVARCHAR (255) NULL,
[OPERATING_SYSTEM] NVARCHAR (255) NULL,
[REGISTERED_COMPANY] NVARCHAR (255) NULL,
[REGISTERED_OWNER] NVARCHAR (255) NULL,
[NETWORK_DOMAIN] NVARCHAR (255) NULL,
[IP_ADDRESS] NVARCHAR (30) NULL,
[CREATED] [datetime] NOT NULL ,
[CREATED_BY] NVARCHAR (32) NULL ,
[CHANGED] [datetime] NOT NULL ,
[CHANGED_BY] NVARCHAR (32) NOT NULL
)
GO



CREATE TABLE [NODE_STATUS] (
[NODE_NAME] NVARCHAR (64) NOT NULL ,
[APPLICATION_NAME] NVARCHAR (64) NOT NULL ,
[APPLICATION_PLATFORM] NVARCHAR (30) NOT NULL ,
[APPLICATION_DESCRIPTION] NVARCHAR (255) NULL ,
[APPLICATION_VERSION] NVARCHAR (30) NULL ,
[APPLICATION_PARAMETERS] [image] NULL ,
[ENABLE_EXECUTION] decimal(1, 0) NOT NULL default 0,
[LICENSED_FROM] [datetime] NULL ,
[LICENSE_OWNER] NVARCHAR (255) NULL ,
[LICENSE_TYPE] NVARCHAR (30) NULL ,
[USER_NAME] NVARCHAR (64) NULL ,
[STARTED] [datetime] NULL ,
[LAST_HART_BEAT] [datetime] NULL ,
[SHUT_DOWN] [datetime] NULL ,
[CREATED] [datetime] NOT NULL ,
[CREATED_BY] NVARCHAR (32) NULL ,
[CHANGED] [datetime] NOT NULL ,
[CHANGED_BY] NVARCHAR (32) NOT NULL
)
GO

ALTER TABLE [EVENT_MONITORS] ADD

CONSTRAINT [PK_EVENT_MONITORS] PRIMARY KEY
(
[EVENT_MONITOR_ID]
)
GO

ALTER TABLE [NODES] ADD
CONSTRAINT [PK_NODES] PRIMARY KEY
(
[NODE_NAME]
)
GO

ALTER TABLE [NODE_STATUS] ADD
CONSTRAINT [PK_NODE_STATUS] PRIMARY KEY
(
[NODE_NAME],
[APPLICATION_NAME],
[APPLICATION_PLATFORM]
)
GO

ALTER TABLE [NODE_STATUS] ADD
CONSTRAINT [FK_NODE_STATUS_NODE_NAME] FOREIGN KEY
(
[NODE_NAME]
) REFERENCES [NODES]
(
[NODE_NAME]
)
GO

ALTER TABLE QUEUE ADD TERMINATE_ON_TIMEOUT decimal(1, 0) NULL default 0
ALTER TABLE QUEUE_HISTORY ADD TERMINATE_ON_TIMEOUT decimal(1, 0) NULL default 0
ALTER TABLE SCHEDULE ADD TERMINATE_ON_TIMEOUT decimal(1, 0) NULL default 0

Hi Mike,

Thank you for providing the script.
If I run it against my repository, I get the error that the column OBJECT_TYPE_GROUP doesn't exist in table OBJECT_TYPES.
I can add this column to the table, if you tell me which data type it should have.

Best Regards

Julian

Hi Julian.

Here is table creation script.

CREATE TABLE [OBJECTS_TREE] (
[OBJECT_ID] decimal(28, 0) NOT NULL ,
[PARENT_ID] decimal(28, 0) NOT NULL ,
[NAME] NVARCHAR (80) NULL ,
[OBJECT_TYPE] decimal(28, 0) NOT NULL,
[READ_ONLY] decimal(28, 0) NULL,
[OBJECT_TYPE_GROUP] decimal(28, 0)
)
GO