- SAP Managed Tags:
(see update at bottom)
Why does the SQL Anywhere monitor show "Monitoring Stopped" for one remote database for almost an hour after the monitor is started, and then suddenly start monitoring?
The following SQL Anywhere Monitor 12.0.1.3810 screenshot shows the following for the "Inventory XP" database:
Status = "Monitoring Stopped" for Inventory XP, even though (a) no action was ever taken to stop monitoring, and (b) Test Connection works OK.
Server Info - Last Checked Time = 2012/11/30 8:56 is approximately the current time, even though the status has been "Monitoring Stopped" for quite a while.
Key Performance Metrics - Queries Processed = 5.17 queries/second even though no other metrics show any activity; in particular, CPU Usage = 0% when in fact it is 50%, and the Connections widget shows nothing even though there are 14 connections.
(more information after screenshot...)
Also...
Tools - Administration - Exception Reports is empty.
Tools - Administration - Message Log (see below) shows that the service was started at about 8:20 AM, almost an hour before the above screen shot was taken:
(more information after Message Log...)
2012/11/30 9:00 Inventory XP Error: sending email failed. 2012/11/30 9:00 Inventory XP Could not send email alert, reason: 2012/11/30 8:59 Inventory XP Accessing a closed Connection object (SQLCODE: 0, SQLSTATE: null) 2012/11/30 8:58 Inventory XP Accessing a closed Connection object (SQLCODE: 0, SQLSTATE: null) 2012/11/30 8:57 Inventory XP Accessing a closed Connection object (SQLCODE: 0, SQLSTATE: null) 2012/11/30 8:56 Inventory XP Accessing a closed Connection object (SQLCODE: 0, SQLSTATE: null) 2012/11/30 8:55 Inventory XP Accessing a closed Connection object (SQLCODE: 0, SQLSTATE: null) 2012/11/30 8:54 Inventory XP Accessing a closed Connection object (SQLCODE: 0, SQLSTATE: null) 2012/11/30 8:54 Inventory XP Accessing a closed Connection object (SQLCODE: 0, SQLSTATE: null) 2012/11/30 8:53 Inventory XP Accessing a closed Connection object (SQLCODE: 0, SQLSTATE: null) 2012/11/30 8:53 Inventory XP Accessing a closed Connection object (SQLCODE: 0, SQLSTATE: null) 2012/11/30 8:51 Inventory XP Accessing a closed Connection object (SQLCODE: 0, SQLSTATE: null) 2012/11/30 8:50 Inventory XP Accessing a closed Connection object (SQLCODE: 0, SQLSTATE: null) 2012/11/30 8:50 Inventory XP Accessing a closed Connection object (SQLCODE: 0, SQLSTATE: null) 2012/11/30 8:50 Inventory XP Accessing a closed Connection object (SQLCODE: 0, SQLSTATE: null) 2012/11/30 8:50 Inventory XP Accessing a closed Connection object (SQLCODE: 0, SQLSTATE: null) 2012/11/30 8:50 Inventory XP Accessing a closed Connection object (SQLCODE: 0, SQLSTATE: null) 2012/11/30 8:49 Inventory XP Accessing a closed Connection object (SQLCODE: 0, SQLSTATE: null) 2012/11/30 8:48 Inventory XP Accessing a closed Connection object (SQLCODE: 0, SQLSTATE: null) 2012/11/30 8:47 Inventory XP Accessing a closed Connection object (SQLCODE: 0, SQLSTATE: null) 2012/11/30 8:47 Inventory XP Accessing a closed Connection object (SQLCODE: 0, SQLSTATE: null) 2012/11/30 8:47 Inventory XP Accessing a closed Connection object (SQLCODE: 0, SQLSTATE: null) 2012/11/30 8:21 ddd010 SA resource initialized 2012/11/30 8:21 ddd009 SA resource initialized 2012/11/30 8:21 Inventory SA resource initialized 2012/11/30 8:21 ddd007 SA resource initialized 2012/11/30 8:21 Inventory XP SA resource initialized 2012/11/30 8:20 ddd006 SA resource initialized 2012/11/30 8:20 ddd004 SA resource initialized 2012/11/30 8:20 ddd001 SA resource initialized 2012/11/30 8:20 ddd002 SA resource initialized 2012/11/30 8:20 ddd005 SA resource initialized 2012/11/30 8:20 ddd010 SA resource initializing... 2012/11/30 8:20 ddd008 SA resource initialized 2012/11/30 8:20 ddd009 SA resource initializing... 2012/11/30 8:20 ddd003 SA resource initialized 2012/11/30 8:20 ddd008 SA resource initializing... 2012/11/30 8:20 SQL Anywhere Monitor SA resource initialized 2012/11/30 8:20 ddd007 SA resource initializing... 2012/11/30 8:20 ddd001 SA resource initializing... 2012/11/30 8:20 ddd003 SA resource initializing... 2012/11/30 8:20 ddd006 SA resource initializing... 2012/11/30 8:20 Inventory XP SA resource initializing... 2012/11/30 8:20 ddd005 SA resource initializing... 2012/11/30 8:20 Inventory SA resource initializing... 2012/11/30 8:20 SQL Anywhere Monitor SA resource initializing... 2012/11/30 8:20 ddd004 SA resource initializing... 2012/11/30 8:20 ddd002 SA resource initializing... 2012/11/30 8:20 <system message=""> <<< This SQL Anywhere Monitor was built on 12.0.1.3810 >>> 2012/11/28 16:44 Inventory [Sybase][JDBC Driver][SQL Anywhere]Connection was terminated (SQLCODE: -308, SQLSTATE: 08S01) 2012/11/28 16:44 ddd002 [Sybase][JDBC Driver][SQL Anywhere]Connection was terminated (SQLCODE: -308, SQLSTATE: 08S01) 2012/11/28 16:44 ddd010 [Sybase][JDBC Driver][SQL Anywhere]Connection was terminated (SQLCODE: -308, SQLSTATE: 08S01) 2012/11/28 16:44 ddd009 [Sybase][JDBC Driver][SQL Anywhere]Connection was terminated (SQLCODE: -308, SQLSTATE: 08S01) 2012/11/28 16:44 ddd001 [Sybase][JDBC Driver][SQL Anywhere]Connection was terminated (SQLCODE: -308, SQLSTATE: 08S01) 2012/11/28 16:44 Inventory Error: sending email failed. 2012/11/28 16:44 Inventory Could not send email alert, reason: 2012/11/28 16:43 Inventory [Sybase][JDBC Driver][SQL Anywhere]Connection was terminated (SQLCODE: -308, SQLSTATE: HY000) 2012/11/28 16:43 ddd005 [Sybase][JDBC Driver][SQL Anywhere]Connection was terminated (SQLCODE: -308, SQLSTATE: HY000) 2012/11/28 16:43 ddd008 [Sybase][JDBC Driver][SQL Anywhere]Connection was terminated (SQLCODE: -308, SQLSTATE: HY000) 2012/11/28 16:43 ddd004 [Sybase][JDBC Driver][SQL Anywhere]Connection was terminated (SQLCODE: -308, SQLSTATE: HY000) 2012/11/28 16:43 ddd003 [Sybase][JDBC Driver][SQL Anywhere]Connection was terminated (SQLCODE: -308, SQLSTATE: HY000) 2012/11/28 16:43 ddd006 [Sybase][JDBC Driver][SQL Anywhere]Connection was terminated (SQLCODE: -308, SQLSTATE: HY000) 2012/11/28 16:43 ddd009 [Sybase][JDBC Driver][SQL Anywhere]Connection was terminated (SQLCODE: -308, SQLSTATE: HY000) 2012/11/28 16:43 ddd010 [Sybase][JDBC Driver][SQL Anywhere]Connection was terminated (SQLCODE: -308, SQLSTATE: HY000) 2012/11/28 16:43 ddd002 [Sybase][JDBC Driver][SQL Anywhere]Connection was terminated (SQLCODE: -308, SQLSTATE: HY000) 2012/11/28 16:43 ddd007 [Sybase][JDBC Driver][SQL Anywhere]Connection was terminated (SQLCODE: -308, SQLSTATE: HY000) 2012/11/28 16:43 ddd001 [Sybase][JDBC Driver][SQL Anywhere]Connection was terminated (SQLCODE: -308, SQLSTATE: HY000) 2012/11/28 16:43 ddd005 [Sybase][JDBC Driver][SQL Anywhere]Database server not found (SQLCODE: -100, SQLSTATE: 08001) 2012/11/28 16:43 ddd007 [Sybase][JDBC Driver][SQL Anywhere]Database server not found (SQLCODE: -100, SQLSTATE: 08001) 2012/11/28 16:43 ddd004 [Sybase][JDBC Driver][SQL Anywhere]Database server not found (SQLCODE: -100, SQLSTATE: 08001) 2012/11/28 16:43 ddd003 [Sybase][JDBC Driver][SQL Anywhere]Database server not found (SQLCODE: -100, SQLSTATE: 08001) 2012/11/28 16:43 ddd006 [Sybase][JDBC Driver][SQL Anywhere]Database server not found (SQLCODE: -100, SQLSTATE: 08001) 2012/11/28 16:43 ddd008 [Sybase][JDBC Driver][SQL Anywhere]Database server not found (SQLCODE: -100, SQLSTATE: 08001) 2012/11/28 13:38 Inventory XP Error: sending email failed. 2012/11/28 13:38 Inventory XP Could not send email alert, reason: 2012/11/28 13:35 ddd010 SA resource initialized 2012/11/28 13:35 ddd010 SA resource initializing... 2012/11/28 13:35 ddd009 SA resource initialized 2012/11/28 13:35 ddd009 SA resource initializing... 2012/11/28 13:35 ddd008 SA resource initialized 2012/11/28 13:35 ddd008 SA resource initializing... 2012/11/28 13:35 ddd007 SA resource initialized 2012/11/28 13:35 ddd007 SA resource initializing... 2012/11/28 13:35 ddd005 SA resource initialized 2012/11/28 13:35 ddd005 SA resource initializing... 2012/11/28 13:35 ddd004 SA resource initialized 2012/11/28 13:35 ddd004 SA resource initializing... 2012/11/28 13:35 ddd006 SA resource initialized 2012/11/28 13:35 ddd002 SA resource initialized 2012/11/28 13:35 ddd003 SA resource initialized 2012/11/28 13:35 ddd001 SA resource initialized 2012/11/28 13:35 ddd006 SA resource initializing... 2012/11/28 13:35 ddd002 SA resource initializing... 2012/11/28 13:35 ddd003 SA resource initializing... 2012/11/28 13:35 ddd001 SA resource initializing... 2012/11/28 11:47 Inventory XP Error: sending email failed. 2012/11/28 11:47 Inventory XP Could not send email alert, reason: 2012/11/28 11:34 Inventory Error: sending email failed. 2012/11/28 11:34 Inventory Could not send email alert, reason: 2012/11/28 11:34 Inventory [Sybase][JDBC Driver][SQL Anywhere]Invalid user ID or password (SQLCODE: -103, SQLSTATE: 28000) 2012/11/28 11:01 Inventory XP SA resource initialized 2012/11/28 11:01 Inventory XP SA resource initializing... 2012/11/28 10:27 Inventory XP SA resource initialized 2012/11/28 10:27 Inventory XP SA resource initializing... 2012/11/28 7:46 Inventory SA resource initialized 2012/11/28 7:46 SQL Anywhere Monitor SA resource initialized 2012/11/28 7:46 Inventory SA resource initializing... 2012/11/28 7:46 SQL Anywhere Monitor SA resource initializing... 2012/11/28 7:46 <system message=""> <<< This SQL Anywhere Monitor was built on 12.0.1.3810 >>> 2012/11/27 17:16 Inventory [Sybase][JDBC Driver][SQL Anywhere]Connection was terminated (SQLCODE: -308, SQLSTATE: 08S01) 2012/11/27 17:16 Inventory [Sybase][JDBC Driver][SQL Anywhere]Connection was terminated (SQLCODE: -308, SQLSTATE: HY000) 2012/11/27 16:26 Inventory SA resource initialized 2012/11/27 16:26 SQL Anywhere Monitor SA resource initialized 2012/11/27 16:26 Inventory SA resource initializing... 2012/11/27 16:26 SQL Anywhere Monitor SA resource initializing... 2012/11/27 16:26 <system message=""> <<< This SQL Anywhere Monitor was built on 12.0.1.3810 >>> 2012/11/27 16:22 Inventory [Sybase][JDBC Driver][SQL Anywhere]Connection was terminated (SQLCODE: -308, SQLSTATE: 08S01) 2012/11/27 16:22 Inventory [Sybase][JDBC Driver][SQL Anywhere]Connection was terminated (SQLCODE: -308, SQLSTATE: 08S01) 2012/11/27 16:22 Inventory [Sybase][JDBC Driver][SQL Anywhere]Connection was terminated (SQLCODE: -308, SQLSTATE: HY000) 2012/11/27 16:19 Inventory SA resource initialized 2012/11/27 16:19 SQL Anywhere Monitor SA resource initialized 2012/11/27 16:19 Inventory SA resource initializing... 2012/11/27 16:19 SQL Anywhere Monitor SA resource initializing... 2012/11/27 16:19 <system message=""> <<< This SQL Anywhere Monitor was built on 12.0.1.3810 >>> 2012/11/27 16:15 Inventory [Sybase][JDBC Driver][SQL Anywhere]Connection was terminated (SQLCODE: -308, SQLSTATE: 08S01) 2012/11/27 16:15 Inventory [Sybase][JDBC Driver][SQL Anywhere]Connection was terminated (SQLCODE: -308, SQLSTATE: HY000) 2012/11/27 16:07 Inventory SA resource initialized 2012/11/27 16:07 Inventory SA resource initializing... 2012/11/27 16:04 SQL Anywhere Monitor SA resource initialized 2012/11/27 16:04 SQL Anywhere Monitor SA resource initializing... 2012/11/27 16:04 <system message=""> <<< This SQL Anywhere Monitor was built on 12.0.1.3810 >>>
Then, all of a sudden, at about 9:09 AM, monitoring for Inventory XP started!
(more information after screenshot...)
Curiously, the Message Log shows no activity for all of November 29; on that day (yesterday), the SQL Anywhere Monitor GUI was not launched, but as far as I know the SQL Anywhere Monitor service was running all day.
FWIW Inventory XP is running 24 by 7 on a different computer, although it was restarted on November 29 (which is not shown in the Message Log). The SQL Anywhere Monitor is run on a laptop which is shut down and restarted one or more times each day.
Update: After a power failure and restart of all components, the Inventory XP resource showed up as "Monitoring Stopped".
Interestingly, when the "Inventory XP - Monitoring Stopped" line was selected, the "Stop" button was enabled at the bottom of the frame... not "Start", but "Stop"...
So I pressed "Stop", and the button changed to "Start", and when I pressed it nothing happened right away... but on the next refresh cycle monitoring did start for that resource.
So... this appears to be reproducible at my end, so feel free to ask for more information 🙂
Accepted Solutions (0)
Answers (0)
| User | Count |
|---|---|
| 62 | |
| 7 | |
| 7 | |
| 6 | |
| 6 | |
| 5 | |
| 5 | |
| 4 | |
| 4 | |
| 4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.