SiteScope 10.12 – Technology Database Integration monitor does not work correctly

SiteScope 10.12 – Technology Database Integration monitor does not work correctly

Customer has various Technology Database Integration monitors set up (63 in total, this number will increase)

– there is only one monitor working as expected

– various other do NOT work

– all monitors query the same database with a similar query like

SELECT d.dns_name, t.tname, e.color,e.created FROM devices d, present_events e, tests t WHERE (d.did=e.hostname_id and t.tid=e.testname_id and d.did=’1938′ and t.tname=’brian’)

– the monitors should always return a value ( 1 row collected)

This is due to the nature of the table (view) the monitor queries. The entries are feed in from a different system and updated all two minutes, and reflect one particular status.

The monitor thus is supposed to pick up the current status, and pass it on to BAC.

trace of a working monitor:

2010-07-14 09:31:01,362 [ALFA_brian(group.71/1) ] (DefaultDataCollector.java:67) DEBUG – going to execute query: SELECT d.dns_name, t.tname, e.color,e.created FROM devices d, present_events e, tests t WHERE (d.did=e.hostname_id and t.tid=e.testname_id and d.did=’1938′ and t.tname=’brian’) AND e.created > 2010-07-14 09:18:37.497 ORDER BY e.created

2010-07-14 09:31:01,362 [ALFA_brian(group.71/1) ] (DefaultDataCollector.java:97) DEBUG – add event to the buffer

2010-07-14 09:31:01,362 [ALFA_brian(group.71/1) ] (DefaultDataCollector.java:126) DEBUG – New enumerating field’s value is: 2010-07-14 09:18:37.497258

2010-07-14 09:31:01,362 [ALFA_brian(group.71/1) ] (DefaultDataCollector.java:129) DEBUG – 1 events created of 1 data rows

2010-07-14 09:31:01,799 [ALFA_brian(group.71/1) ] (ObserverSource.java:81) DEBUG – update method started

2010-07-14 09:31:01,799 [ALFA_brian(group.71/1) ] (ObserverSource.java:87) DEBUG – pushing the event {COLOR=green, TNAME=brian, DNS_NAME=ALFA, created=2010-07-14 09:18:37.497258}

2010-07-14 09:31:01,799 [ALFA_brian(group.71/1) ] (Probe.java:138) DEBUG – ==>pushEvent

2010-07-14 09:31:01,799 [ALFA_brian(group.71/1) ] (Probe.java:152) DEBUG – <==pushEvent execution time 0 seconds

2010-07-14 09:31:01,799 [ALFA_brian(group.71/1) ] (JdbcMonitor.java:92) DEBUG – the monitor updated successfully collected 1 events , sent 1 events to Topaz, ignored 0 events

2010-07-14 09:31:01,799 [ALFA_brian(group.71/1) ] (Probe.java:39) DEBUG – ctor

trace of a non-working monitor:

2010-07-14 09:31:02,143 [axalfa_conn(group.72/1) ] (DefaultDataCollector.java:67) DEBUG – going to execute query: SELECT d.dns_name, t.tname, e.color,e.created FROM devices d, present_events e, tests t WHERE (d.did=e.hostname_id and t.tid=e.testname_id and d.dns_name=’mnp.server.na.avtenti’ and t.tname=’http’) AND e.created > 2010-01-22 13:11:57.0 ORDER BY e.created

2010-07-14 09:31:02,143 [axalfa_conn(group.72/1) ] (DefaultDataCollector.java:97) DEBUG – add event to the buffer

2010-07-14 09:31:02,143 [axalfa_conn(group.72/1) ] (DefaultDataCollector.java:144) DEBUG – 1 events removed from the collection

2010-07-14 09:31:02,143 [axalfa_conn(group.72/1) ] (DefaultDataCollector.java:126) DEBUG – New enumerating field’s value is: null

2010-07-14 09:31:02,143 [axalfa_conn(group.72/1) ] (DefaultDataCollector.java:129) DEBUG – 0 events created of 1 data rows

2010-07-14 09:31:02,596 [axalfa_conn(group.72/1) ] (JdbcMonitor.java:92) DEBUG – the monitor updated successfully collected 0 events , sent 0 events to Topaz, ignored 0 events

The cause is unknown at the moment:

– DB query is perfectly fine. From the DB design the data queried is just a status, feedback from another system, and updated all 2 minutes

– stopped SiteScope, deleted mg.bak and .dyn file for axalfa_conn, started SiteScope, now the new timestamp is reflected, but still nothing is returned

To fix this issue,

– all monitors run all 5 minutes, after changing this to 1 minute, the monitor starts to work as expected!

– one minute nothing is returned, as the data in the database has not been updated,

DEBUG – add event to the buffer

DEBUG – 1 events removed from the collection

DEBUG – New enumerating field’s value is: null

DEBUG – 0 events created of 1 data rows

DEBUG – the monitor updated successfully collected 0 events , sent 0 events to Topaz, ignored 0 events

in the next run (one minute later), data is retrieved and we see a trace like

DEBUG – add event to the buffer

DEBUG – New enumerating field’s value is: 2010-07-15 13:18:37.497258

DEBUG – 1 events created of 1 data rows

DEBUG – pushing the event {COLOR=green, .. , created=2010-07-15 13:16:37.497258}

DEBUG – the monitor updated successfully collected 1 events , sent 1 events to Topaz, ignored 0 events

– tried with 5 minutes again, then the monitor doesn’t work anymore, same for 2,3,4 minutes, or 110 seconds

only 1 minute works

Change all monitors to execute every 1 minute.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s