recurring errors

Started by Tread, February 18, 2014, 05:02:08 PM

Previous topic - Next topic

Tread


I keep getting these errors every minute.  What is this about?

My setup is:

Windows Server 2008 R2
SQL Express 2012 on the same box.

Thanks


18.02.2014 08:32:51   FSB-NETMONITOR   Critical   SYS_DB_QUERY_FAILED   Database query failed (Query: INSERT INTO idata_242 (item_id,idata_timestamp,idata_value) VALUES (?,?,?); Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'idata_242'.)
18.02.2014 08:32:51   FSB-NETMONITOR   Critical   SYS_DB_QUERY_FAILED   Database query failed (Query: INSERT INTO idata_225 (item_id,idata_timestamp,idata_value) VALUES (?,?,?); Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'idata_225'.)
18.02.2014 08:32:51   FSB-NETMONITOR   Critical   SYS_DB_QUERY_FAILED   Database query failed (Query: INSERT INTO idata_223 (item_id,idata_timestamp,idata_value) VALUES (?,?,?); Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'idata_223'.)
18.02.2014 08:32:51   FSB-NETMONITOR   Critical   SYS_DB_QUERY_FAILED   Database query failed (Query: INSERT INTO idata_219 (item_id,idata_timestamp,idata_value) VALUES (?,?,?); Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'idata_219'.)
18.02.2014 08:32:51   FSB-NETMONITOR   Critical   SYS_DB_QUERY_FAILED   Database query failed (Query: INSERT INTO idata_216 (item_id,idata_timestamp,idata_value) VALUES (?,?,?); Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'idata_216'.)
18.02.2014 08:32:51   FSB-NETMONITOR   Critical   SYS_DB_QUERY_FAILED   Database query failed (Query: INSERT INTO idata_215 (item_id,idata_timestamp,idata_value) VALUES (?,?,?); Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'idata_215'.)
18.02.2014 08:32:51   FSB-NETMONITOR   Critical   SYS_DB_QUERY_FAILED   Database query failed (Query: INSERT INTO idata_213 (item_id,idata_timestamp,idata_value) VALUES (?,?,?); Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'idata_213'.)
18.02.2014 08:32:51   FSB-NETMONITOR   Critical   SYS_DB_QUERY_FAILED   Database query failed (Query: INSERT INTO idata_211 (item_id,idata_timestamp,idata_value) VALUES (?,?,?); Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'idata_211'.)
18.02.2014 08:32:51   FSB-NETMONITOR   Critical   SYS_DB_QUERY_FAILED   Database query failed (Query: INSERT INTO idata_210 (item_id,idata_timestamp,idata_value) VALUES (?,?,?); Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'idata_210'.)
18.02.2014 08:32:51   FSB-NETMONITOR   Critical   SYS_DB_QUERY_FAILED   Database query failed (Query: INSERT INTO idata_208 (item_id,idata_timestamp,idata_value) VALUES (?,?,?); Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'idata_208'.)
18.02.2014 08:32:51   FSB-NETMONITOR   Critical   SYS_DB_QUERY_FAILED   Database query failed (Query: INSERT INTO idata_206 (item_id,idata_timestamp,idata_value) VALUES (?,?,?); Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'idata_206'.)
18.02.2014 08:32:51   FSB-NETMONITOR   Critical   SYS_DB_QUERY_FAILED   Database query failed (Query: INSERT INTO idata_204 (item_id,idata_timestamp,idata_value) VALUES (?,?,?); Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'idata_204'.)
18.02.2014 08:32:51   FSB-NETMONITOR   Critical   SYS_DB_QUERY_FAILED   Database query failed (Query: INSERT INTO idata_202 (item_id,idata_timestamp,idata_value) VALUES (?,?,?); Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'idata_202'.)
18.02.2014 08:32:51   FSB-NETMONITOR   Critical   SYS_DB_QUERY_FAILED   Database query failed (Query: INSERT INTO idata_200 (item_id,idata_timestamp,idata_value) VALUES (?,?,?); Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'idata_200'.)
18.02.2014 08:32:51   FSB-NETMONITOR   Critical   SYS_DB_QUERY_FAILED   Database query failed (Query: INSERT INTO idata_196 (item_id,idata_timestamp,idata_value) VALUES (?,?,?); Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'idata_196'.)
18.02.2014 08:32:51   FSB-NETMONITOR   Critical   SYS_DB_QUERY_FAILED   Database query failed (Query: INSERT INTO idata_194 (item_id,idata_timestamp,idata_value) VALUES (?,?,?); Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'idata_194'.)
18.02.2014 08:32:51   FSB-NETMONITOR   Critical   SYS_DB_QUERY_FAILED   Database query failed (Query: INSERT INTO idata_192 (item_id,idata_timestamp,idata_value) VALUES (?,?,?); Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'idata_192'.)
18.02.2014 08:32:51   FSB-NETMONITOR   Critical   SYS_DB_QUERY_FAILED   Database query failed (Query: INSERT INTO idata_190 (item_id,idata_timestamp,idata_value) VALUES (?,?,?); Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'idata_190'.)
18.02.2014 08:32:51   FSB-NETMONITOR   Critical   SYS_DB_QUERY_FAILED   Database query failed (Query: INSERT INTO idata_188 (item_id,idata_timestamp,idata_value) VALUES (?,?,?); Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'idata_188'.)
18.02.2014 08:32:51   FSB-NETMONITOR   Critical   SYS_DB_QUERY_FAILED   Database query failed (Query: INSERT INTO idata_186 (item_id,idata_timestamp,idata_value) VALUES (?,?,?); Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'idata_186'.)
18.02.2014 08:32:51   FSB-NETMONITOR   Critical   SYS_DB_QUERY_FAILED   Database query failed (Query: INSERT INTO idata_184 (item_id,idata_timestamp,idata_value) VALUES (?,?,?); Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'idata_184'.)
18.02.2014 08:32:51   FSB-NETMONITOR   Critical   SYS_DB_QUERY_FAILED   Database query failed (Query: INSERT INTO idata_182 (item_id,idata_timestamp,idata_value) VALUES (?,?,?); Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'idata_182'.)
18.02.2014 08:32:51   FSB-NETMONITOR   Critical   SYS_DB_QUERY_FAILED   Database query failed (Query: INSERT INTO idata_179 (item_id,idata_timestamp,idata_value) VALUES (?,?,?); Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'idata_179'.)
18.02.2014 08:32:51   FSB-NETMONITOR   Critical   SYS_DB_QUERY_FAILED   Database query failed (Query: INSERT INTO idata_140 (item_id,idata_timestamp,idata_value) VALUES (?,?,?); Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'idata_140'.)
18.02.2014 08:32:51   FSB-NETMONITOR   Critical   SYS_DB_QUERY_FAILED   Database query failed (Query: INSERT INTO idata_138 (item_id,idata_timestamp,idata_value) VALUES (?,?,?); Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'idata_138'.)
18.02.2014 08:32:51   FSB-NETMONITOR   Critical   SYS_DB_QUERY_FAILED   Database query failed (Query: INSERT INTO idata_136 (item_id,idata_timestamp,idata_value) VALUES (?,?,?); Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'idata_136'.)
18.02.2014 08:32:51   FSB-NETMONITOR   Critical   SYS_DB_QUERY_FAILED   Database query failed (Query: INSERT INTO idata_134 (item_id,idata_timestamp,idata_value) VALUES (?,?,?); Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'idata_134'.)
18.02.2014 08:32:51   FSB-NETMONITOR   Critical   SYS_DB_QUERY_FAILED   Database query failed (Query: INSERT INTO idata_132 (item_id,idata_timestamp,idata_value) VALUES (?,?,?); Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'idata_132'.)
18.02.2014 08:32:51   FSB-NETMONITOR   Critical   SYS_DB_QUERY_FAILED   Database query failed (Query: INSERT INTO idata_130 (item_id,idata_timestamp,idata_value) VALUES (?,?,?); Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'idata_130'.)
18.02.2014 08:32:51   FSB-NETMONITOR   Critical   SYS_DB_QUERY_FAILED   Database query failed (Query: INSERT INTO idata_128 (item_id,idata_timestamp,idata_value) VALUES (?,?,?); Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'idata_128'.)
18.02.2014 08:32:51   FSB-NETMONITOR   Critical   SYS_DB_QUERY_FAILED   Database query failed (Query: INSERT INTO idata_126 (item_id,idata_timestamp,idata_value) VALUES (?,?,?); Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'idata_126'.)
18.02.2014 08:32:51   FSB-NETMONITOR   Critical   SYS_DB_QUERY_FAILED   Database query failed (Query: INSERT INTO idata_124 (item_id,idata_timestamp,idata_value) VALUES (?,?,?); Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'idata_124'.)
18.02.2014 08:32:51   FSB-NETMONITOR   Critical   SYS_DB_QUERY_FAILED   Database query failed (Query: INSERT INTO idata_122 (item_id,idata_timestamp,idata_value) VALUES (?,?,?); Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'idata_122'.)
18.02.2014 08:32:51   FSB-NETMONITOR   Critical   SYS_DB_QUERY_FAILED   Database query failed (Query: INSERT INTO idata_120 (item_id,idata_timestamp,idata_value) VALUES (?,?,?); Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'idata_120'.)
18.02.2014 08:32:51   FSB-NETMONITOR   Critical   SYS_DB_QUERY_FAILED   Database query failed (Query: INSERT INTO idata_118 (item_id,idata_timestamp,idata_value) VALUES (?,?,?); Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'idata_118'.)
18.02.2014 08:32:51   FSB-NETMONITOR   Critical   SYS_DB_QUERY_FAILED   Database query failed (Query: INSERT INTO idata_116 (item_id,idata_timestamp,idata_value) VALUES (?,?,?); Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'idata_116'.)
18.02.2014 08:32:51   FSB-NETMONITOR   Critical   SYS_DB_QUERY_FAILED   Database query failed (Query: INSERT INTO idata_114 (item_id,idata_timestamp,idata_value) VALUES (?,?,?); Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'idata_114'.)
18.02.2014 08:32:51   FSB-NETMONITOR   Critical   SYS_DB_QUERY_FAILED   Database query failed (Query: INSERT INTO idata_112 (item_id,idata_timestamp,idata_value) VALUES (?,?,?); Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'idata_112'.)
18.02.2014 08:32:51   FSB-NETMONITOR   Critical   SYS_DB_QUERY_FAILED   Database query failed (Query: INSERT INTO idata_109 (item_id,idata_timestamp,idata_value) VALUES (?,?,?); Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'idata_109'.)
18.02.2014 08:32:51   FSB-NETMONITOR   Critical   SYS_DB_QUERY_FAILED   Database query failed (Query: INSERT INTO idata_107 (item_id,idata_timestamp,idata_value) VALUES (?,?,?); Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'idata_107'.)
18.02.2014 08:32:51   FSB-NETMONITOR   Critical   SYS_DB_QUERY_FAILED   Database query failed (Query: INSERT INTO idata_105 (item_id,idata_timestamp,idata_value) VALUES (?,?,?); Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'idata_105'.)
18.02.2014 08:32:51   FSB-NETMONITOR   Critical   SYS_DB_QUERY_FAILED   Database query failed (Query: INSERT INTO idata_103 (item_id,idata_timestamp,idata_value) VALUES (?,?,?); Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'idata_103'.)
18.02.2014 08:32:51   FSB-NETMONITOR   Critical   SYS_DB_QUERY_FAILED   Database query failed (Query: INSERT INTO idata_100 (item_id,idata_timestamp,idata_value) VALUES (?,?,?); Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'idata_100'.)
18.02.2014 08:32:51   FSB-NETMONITOR   Critical   SYS_DB_QUERY_FAILED   Database query failed (Query: INSERT INTO idata_100 (item_id,idata_timestamp,idata_value) VALUES (?,?,?); Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'idata_100'.)
18.02.2014 08:32:51   FSB-NETMONITOR   Critical   SYS_DB_QUERY_FAILED   Database query failed (Query: INSERT INTO idata_100 (item_id,idata_timestamp,idata_value) VALUES (?,?,?); Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'idata_100'.)
18.02.2014 08:32:51   FSB-NETMONITOR   Critical   SYS_DB_QUERY_FAILED   Database query failed (Query: INSERT INTO idata_100 (item_id,idata_timestamp,idata_value) VALUES (?,?,?); Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'idata_100'.)
18.02.2014 08:32:51   FSB-NETMONITOR   Critical   SYS_DB_QUERY_FAILED   Database query failed (Query: INSERT INTO idata_100 (item_id,idata_timestamp,idata_value) VALUES (?,?,?); Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'idata_100'.)
18.02.2014 08:32:51   FSB-NETMONITOR   Critical   SYS_DB_QUERY_FAILED   Database query failed (Query: INSERT INTO idata_100 (item_id,idata_timestamp,idata_value) VALUES (?,?,?); Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'idata_100'.)
18.02.2014 08:32:51   FSB-NETMONITOR   Critical   SYS_DB_QUERY_FAILED   Database query failed (Query: INSERT INTO idata_100 (item_id,idata_timestamp,idata_value) VALUES (?,?,?); Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'idata_100'.)
18.02.2014 08:32:51   FSB-NETMONITOR   Critical   SYS_DB_QUERY_FAILED   Database query failed (Query: INSERT INTO idata_100 (item_id,idata_timestamp,idata_value) VALUES (?,?,?); Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'idata_100'.)

Victor Kirhenshtein

Hi!

Looks like lot of data tables are missing. Is it new setup or errors appear after upgrade?

Best regards,
Victor

Tread


This is a new setup.  So not a major deal to rebuild if that is the easiest fix.

Victor Kirhenshtein

I think that rebuild database is easiest fix here.

Best regards,
Victor

Tread


Is there a way to build a new database without doing a complete re-install?


Victor Kirhenshtein

Yes. Drop all tables from database and then initialize it with command

nxdbmgr init c:\netxms\lib\sql\dbinit_mssql.sql

Best regards,
Victor