NetXMS Support Forum

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>