Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1
  • 2

TOPIC: invalid objectname 'NODES' select * from NODES

invalid objectname 'NODES' select * from NODES 1 year 2 months ago #17863

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
Attachments:

Please Log in or Create an account to join the conversation.

invalid objectname 'NODES' select * from NODES 1 year 2 months ago #17864

  • admin
  • admin's Avatar
  • Away
  • Moderator
  • Moderator
  • Deeds not Words
  • Posts: 7595
  • Karma: 33
  • Thank you received: 418
Hi Jullian

Can you tell us your repository type please?
Mike

Please Log in or Create an account to join the conversation.

invalid objectname 'NODES' select * from NODES 1 year 2 months ago #17865

Hi Mike,

my repository type is MS SQL Server.

Best Regards

Julian

Please Log in or Create an account to join the conversation.

invalid objectname 'NODES' select * from NODES 1 year 2 months ago #17866

  • admin
  • admin's Avatar
  • Away
  • Moderator
  • Moderator
  • Deeds not Words
  • Posts: 7595
  • Karma: 33
  • Thank you received: 418
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
Mike

Please Log in or Create an account to join the conversation.

invalid objectname 'NODES' select * from NODES 1 year 2 months ago #17940

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

Please Log in or Create an account to join the conversation.

invalid objectname 'NODES' select * from NODES 1 year 2 months ago #17941

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

Please Log in or Create an account to join the conversation.

  • Page:
  • 1
  • 2

We have 216 guests and one member online