Menu

Show posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Show posts Menu

Messages - RobR

Pages1
#1
General Support / 2.1 M3 alarms not come to alarm browser window but visible in alarm log
April 26, 2017, 12:43:24 PM
in 2.1 M3 alarms visible in alarm log but not come to alarm browser window
#2
General Support / upgrade to 2.1-M.3 failed
April 24, 2017, 05:06:13 PM
Upgrading database...
Upgrading from version 410 to 411
Converting table tdata_100:   0%SQL query failed ([Microsoft][SQL Server Native
Client 10.0]COUNT field incorrect or syntax error):
INSERT INTO tdata_100 (item_id,tdata_timestamp,tdata_value) VALUES (?,?,?)
failed
Rolling back last stage due to upgrade errors...
Database upgrade failed

C:\NetXMS\bin>nxdbmgr upgrade -t
NetXMS Database Manager Version 2.1-M3 Build 9008 (2.1-M3) (UNICODE)

Upgrading database...
Upgrading from version 410 to 411
>>> SELECT var_value FROM metadata WHERE var_name='TdataTableUpdated'
>>> SELECT var_name,var_value FROM metadata WHERE var_name LIKE 'TDataTableCreat
ionCommand_%' OR var_name LIKE 'TDataIndexCreationCommand_%'
>>> DELETE FROM metadata WHERE var_name LIKE 'TDataTableCreationCommand_%' OR va
r_name LIKE 'TDataIndexCreationCommand_%'
>>> INSERT INTO metadata (var_name,var_value) VALUES ('TDataTableCreationCommand
_0','CREATE TABLE tdata_%d (item_id integer not null,tdata_timestamp integer not
null,tdata_value text null)')
>>> INSERT INTO metadata (var_name,var_value) VALUES ('TDataIndexCreationCommand
_0','CREATE CLUSTERED INDEX idx_tdata_%d ON tdata_%d(item_id,tdata_timestamp)')
>>> SELECT id FROM nodes
Converting table tdata_100:   0%>>> EXEC sp_rename 'tdata_100','tdata_temp_100'
>>> SELECT var_value FROM metadata WHERE var_name='TDataTableCreationCommand_0'
>>> CREATE TABLE tdata_100 (item_id integer not null,tdata_timestamp integer not
null,tdata_value text null)
>>> SELECT var_value FROM metadata WHERE var_name='TDataTableCreationCommand_1'
>>> SELECT var_value FROM metadata WHERE var_name='TDataTableCreationCommand_2'
>>> SELECT var_value FROM metadata WHERE var_name='TDataTableCreationCommand_3'
>>> SELECT var_value FROM metadata WHERE var_name='TDataTableCreationCommand_4'
>>> SELECT var_value FROM metadata WHERE var_name='TDataTableCreationCommand_5'
>>> SELECT var_value FROM metadata WHERE var_name='TDataTableCreationCommand_6'
>>> SELECT var_value FROM metadata WHERE var_name='TDataTableCreationCommand_7'
>>> SELECT var_value FROM metadata WHERE var_name='TDataTableCreationCommand_8'
>>> SELECT var_value FROM metadata WHERE var_name='TDataTableCreationCommand_9'
>>> SELECT var_value FROM metadata WHERE var_name='TDataIndexCreationCommand_0'
>>> CREATE CLUSTERED INDEX idx_tdata_100 ON tdata_100(item_id,tdata_timestamp)
>>> SELECT var_value FROM metadata WHERE var_name='TDataIndexCreationCommand_1'
>>> SELECT var_value FROM metadata WHERE var_name='TDataIndexCreationCommand_2'
>>> SELECT var_value FROM metadata WHERE var_name='TDataIndexCreationCommand_3'
>>> SELECT var_value FROM metadata WHERE var_name='TDataIndexCreationCommand_4'
>>> SELECT var_value FROM metadata WHERE var_name='TDataIndexCreationCommand_5'
>>> SELECT var_value FROM metadata WHERE var_name='TDataIndexCreationCommand_6'
>>> SELECT var_value FROM metadata WHERE var_name='TDataIndexCreationCommand_7'
>>> SELECT var_value FROM metadata WHERE var_name='TDataIndexCreationCommand_8'
>>> SELECT var_value FROM metadata WHERE var_name='TDataIndexCreationCommand_9'
>>> INSERT INTO tdata_100 (item_id,tdata_timestamp,tdata_value) VALUES (?,?,?)
SQL query failed ([Microsoft][SQL Server Native Client 10.0]COUNT field incorrec
t or syntax error):
INSERT INTO tdata_100 (item_id,tdata_timestamp,tdata_value) VALUES (?,?,?)
>>> DROP TABLE tdata_100
>>> EXEC sp_rename 'tdata_temp_100','tdata_100'
failed
>>> DELETE FROM metadata WHERE var_name LIKE 'TDataTableCreationCommand_%' OR va
r_name LIKE 'TDataIndexCreationCommand_%'
>>> INSERT INTO metadata (var_name,var_value) VALUES ('TDataIndexCreationCommand
_0','CREATE CLUSTERED INDEX idx_tdata_%d_id_timestamp ON tdata_%d(item_id,tdata_
timestamp)')
>>> INSERT INTO metadata (var_name,var_value) VALUES ('TDataIndexCreationCommand
_1','CREATE INDEX idx_tdata_rec_%d_instance ON tdata_records_%d(instance)')
>>> INSERT INTO metadata (var_name,var_value) VALUES ('TDataIndexCreationCommand
_2','CREATE INDEX idx_tdata_rec_%d_id ON tdata_records_%d(record_id)')
>>> INSERT INTO metadata (var_name,var_value) VALUES ('TDataTableCreationCommand
_0','CREATE TABLE tdata_%d (item_id integer not null,tdata_timestamp integer not
null,record_id bigint not null,UNIQUE(record_id))')
>>> INSERT INTO metadata (var_name,var_value) VALUES ('TDataTableCreationCommand
_1','CREATE TABLE tdata_records_%d (record_id bigint not null,row_id bigint not
null,instance varchar(255) null,PRIMARY KEY(row_id),FOREIGN KEY (record_id) REFE
RENCES tdata_%d(record_id) ON DELETE CASCADE)')
>>> INSERT INTO metadata (var_name,var_value) VALUES ('TDataTableCreationCommand
_2','CREATE TABLE tdata_rows_%d (row_id bigint not null,column_id integer not nu
ll,value varchar(255) null,PRIMARY KEY(row_id,column_id),FOREIGN KEY (row_id) RE
FERENCES tdata_records_%d(row_id) ON DELETE CASCADE)')
Rolling back last stage due to upgrade errors...
Database upgrade failed



other update try as below
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

C:\NetXMS\bin>nxdbmgr upgrade
NetXMS Database Manager Version 2.1-M3 Build 9008 (2.1-M3) (UNICODE)

Upgrading database...
Upgrading from version 410 to 411
Converting table tdata_100:  99%SQL query failed ([Microsoft][SQL Server Native
Client 10.0]COUNT field incorrect or syntax error):
INSERT INTO tdata_100 (item_id,tdata_timestamp,tdata_value) VALUES (?,?,?)
failed
Rolling back last stage due to upgrade errors...
Database upgrade failed


xxxxxxx

>>> SELECT var_value FROM metadata WHERE var_name='TDataIndexCreationCommand_6'
>>> SELECT var_value FROM metadata WHERE var_name='TDataIndexCreationCommand_7'
>>> SELECT var_value FROM metadata WHERE var_name='TDataIndexCreationCommand_8'
>>> SELECT var_value FROM metadata WHERE var_name='TDataIndexCreationCommand_9'
99%>>> INSERT INTO tdata_100 (item_id,tdata_timestamp,tdata_value) VALUES (?,?,
?)
SQL query failed ([Microsoft][SQL Server Native Client 10.0]COUNT field incorrec
t or syntax error):
INSERT INTO tdata_100 (item_id,tdata_timestamp,tdata_value) VALUES (?,?,?)
>>> DROP TABLE tdata_100
>>> EXEC sp_rename 'tdata_temp_100','tdata_100'
failed
>>> DELETE FROM metadata WHERE var_name LIKE 'TDataTableCreationCommand_%' OR va
r_name LIKE 'TDataIndexCreationCommand_%'
>>> INSERT INTO metadata (var_name,var_value) VALUES ('TDataIndexCreationCommand
_0','CREATE CLUSTERED INDEX idx_tdata_%d_id_timestamp ON tdata_%d(item_id,tdata_
timestamp)')
>>> INSERT INTO metadata (var_name,var_value) VALUES ('TDataIndexCreationCommand
_1','CREATE INDEX idx_tdata_rec_%d_instance ON tdata_records_%d(instance)')
>>> INSERT INTO metadata (var_name,var_value) VALUES ('TDataIndexCreationCommand
_2','CREATE INDEX idx_tdata_rec_%d_id ON tdata_records_%d(record_id)')
>>> INSERT INTO metadata (var_name,var_value) VALUES ('TDataTableCreationCommand
_0','CREATE TABLE tdata_%d (item_id integer not null,tdata_timestamp integer not
null,record_id bigint not null,UNIQUE(record_id))')
>>> INSERT INTO metadata (var_name,var_value) VALUES ('TDataTableCreationCommand
_1','CREATE TABLE tdata_records_%d (record_id bigint not null,row_id bigint not
null,instance varchar(255) null,PRIMARY KEY(row_id),FOREIGN KEY (record_id) REFE
RENCES tdata_%d(record_id) ON DELETE CASCADE)')
>>> INSERT INTO metadata (var_name,var_value) VALUES ('TDataTableCreationCommand
_2','CREATE TABLE tdata_rows_%d (row_id bigint not null,column_id integer not nu
ll,value varchar(255) null,PRIMARY KEY(row_id,column_id),FOREIGN KEY (row_id) RE
FERENCES tdata_records_%d(row_id) ON DELETE CASCADE)')
Rolling back last stage due to upgrade errors...
Database upgrade failed

C:\NetXMS\bin>



Pages1