Denika isn't polling

[nobjojoh]

Our company have been using the free version of Denika for a few months now and we like the user interface as well as the easy way to graph Cisco SLA probes. However, on sunday it suddenly stopped polling for existing reports and new reports does not come up at all. I have checked the cron service which is running ok. I have also restarted all other logalot services. We are planning to buy the commercial version but we would like to resolve this issue. Is there a time limit on the free version?

Thanks
Bjorn-Erik

[tomp]

There is no time limit to the free version. It sounds like there might be some DB corruption. Let's try running the poller from command line:

Open a command prompt on the server and navigate to \SOE\cgi-bin\

run:

poller.exe

You should see a couple of command prompts open. If you don't, there may be a problem. If they open and close immediately, this may indicate a problem as well.

How many reports do you have?

Try running: cli -maint from the \SOE\cgi-bin\ as well. This is a nightly maintenance routine that will tell us if there is a problem with any database tables.

Let me know if you what the results of a running poller manually are and what the cli -maint returns.

-Tom

[nobjojoh]

Here is the info, as you said the windows open and close immediately after i run poller.exe.

C:\SOE\cgi-bin>poller.exe

-----------------------------------------------------------------
Somix Technologies, Inc. (Poll Started )
-----------------------------------------------------------------



Creating necessary poll files for poller ... DONE!
initiated background poller for pollFile_1.cfg ... DONE!

C:\SOE\cgi-bin>cli -maint

Maintenance Command Initiated ...


Done!
CLI version 3.01 working on MySQL 5.0.41-community-nt @ 195.70.164.108

Examining tables on Database "information_schema"
CHARACTER_SETS: Table type MEMORY not supported
COLLATIONS: Table type MEMORY not supported
COLLATION_CHARACTER_SET_APPLICABILITY: Table type MEMORY not supported
COLUMNS: Table is already up to date
COLUMN_PRIVILEGES: Table type MEMORY not supported
KEY_COLUMN_USAGE: Table type MEMORY not supported
PROFILING: Table type MEMORY not supported
ROUTINES: Table is already up to date
SCHEMATA: Table type MEMORY not supported
SCHEMA_PRIVILEGES: Table type MEMORY not supported
STATISTICS: Table type MEMORY not supported
TABLES: Table type MEMORY not supported
TABLE_CONSTRAINTS: Table type MEMORY not supported
TABLE_PRIVILEGES: Table type MEMORY not supported
TRIGGERS: Table is already up to date
USER_PRIVILEGES: Table type MEMORY not supported
VIEWS: Table is already up to date

Examining tables on Database "global"
activitylog: Table is already up to date
alerts: OK
conf: Table is already up to date
credentials: Table is already up to date
css: Table is already up to date
env_schema: Table is already up to date
env_system: Table is already up to date
env_user: Table is already up to date
notification: Table is already up to date
notify: Table is already up to date
rotate: Table is already up to date
sessions: Table is already up to date
soeservers: Table is already up to date
tasks: Table is already up to date
updates: Table is already up to date

Examining tables on Database "logalot"
bulletin_board: OK
bulletin_board_header: OK
eventlog_history_012009: Table is already up to date
eventlog_history_022009: Table is already up to date
eventlog_history_032009: Table is already up to date
eventlog_history_042009: Table is already up to date
eventlog_history_052009: Table is already up to date
eventlog_history_102008: Table is already up to date
eventlog_history_112008: Table is already up to date
eventlog_history_122008: Table is already up to date
eventlog_setup: Table is already up to date
eventlog_summary: Table is already up to date
history_012009: Table is already up to date
history_022009: Table is already up to date
history_032009: Table is already up to date
history_042009: Table is already up to date
history_052009: Table is already up to date
history_102008: Table is already up to date
history_112008: Table is already up to date
history_122008: Table is already up to date
merged_0: Table type MRG_MyISAM not supported
non_eventlog_summary: OK
notify_specific: Table is already up to date
orphan: Table is already up to date
policies: Table is already up to date
reports: Table is already up to date
scheduled_data: Table is already up to date
session: Table is already up to date
violations: OK

Examining tables on Database "mysql"
columns_priv: Table is already up to date
db: Table is already up to date
func: Table is already up to date
help_category: Table is already up to date
help_keyword: Table is already up to date
help_relation: Table is already up to date
help_topic: Table is already up to date
host: Table is already up to date
proc: Table is already up to date
procs_priv: Table is already up to date
tables_priv: Table is already up to date
time_zone: Table is already up to date
time_zone_leap_second: Table is already up to date
time_zone_name: Table is already up to date
time_zone_transition: Table is already up to date
time_zone_transition_type: Table is already up to date
user: Table is already up to date

Examining tables on Database "perfrpt"
adisctemplates: Table is already up to date
customrpts: Table is already up to date
deviceindex: Table is already up to date
favorites: Table is already up to date
filters: Table is already up to date
groupindex: Table is already up to date
groupmembers: Table is already up to date
reportindex: OK
reportsummary: OK
rptparameters: Table is already up to date
rpttemplates: Table is already up to date
topx: Table is already up to date
typecatalog: Table is already up to date
vendorindex: Table is already up to date

Examining tables on Database "security"
assignedrights: Table is already up to date
availablepermissions: Table is already up to date
useraccounts: Table is already up to date
userpreferences: Table is already up to date

Examining tables on Database "somix_help"
denika_7_00: Table is already up to date
faq: Table is already up to date
logalot_5_00: Table is already up to date
soe_3_00: Table is already up to date

Examining tables on Database "test"

Examining tables on Database "toc"
commontasks: Table is already up to date
favorites: Table is already up to date
navigation: Table is already up to date

[nathanh]

We may have to check that poller and make sure that it's successfully polling all of your reports. You mentioned that it polled quickly, which makes me wonder...

Send me an e-mail with your contact information and we'll get you taken care of.


nathanh@plixer.com