Print Page - SQL Query event logs

Title: SQL Query event logs
Post by: orddie on January 12, 2014, 01:41:40 PM

Hi All,

Looking in my windows 7 event log today under system, i saw a ton of these messages. A few every second.

SQL query failed (Query = "INSERT INTO idata_360 (item_id,idata_timestamp,idata_value) VALUES (?,?,?)"): Table 'netxms.idata_360' doesn't exist

Any idea how to resolve?

Title: Re: SQL Query event logs
Post by: Victor Kirhenshtein on January 13, 2014, 04:15:36 PM

Hi!

seems that for some reason one of the data collection tables was not created. Try to create it manually as following:

CREATE TABLE idata_360 (item_id integer not null,idata_timestamp integer not null,idata_value varchar(255) null);

Then create index on it. Depending on your database:

PostgreSQL:

CREATE INDEX idx_idata_360_timestamp_id ON idata_360(idata_timestamp,item_id);

MS SQL:

CREATE CLUSTERED INDEX idx_idata_360_id_timestamp ON idata_360(item_id,idata_timestamp);

Other databases:

CREATE INDEX idx_idata_360_id_timestamp ON idata_360(item_id,idata_timestamp);

Best regards,
Victor

Title: Re: SQL Query event logs
Post by: orddie on January 13, 2014, 05:15:05 PM

spot on. thanks much!

NetXMS Support Forum

English Support => General Support => Topic started by: orddie on January 12, 2014, 01:41:40 PM