SQL Query event logs

[orddie]

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?

[victor]

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

[orddie]

spot on.  thanks much!