upgrade to 2.1-M.3 failed
-
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 failedC:\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 failedother update try as below
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxC:\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 failedxxxxxxx
>>> 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 failedC:\NetXMS\bin>
Hello! It looks like you're interested in this conversation, but you don't have an account yet.
Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.
With your input, this post could be even better 💗
Register Login