[RADIATOR] refresh time on clientlistsql

[Alexander Hartmaier]

Hi Mike,

the config section

<ClientListSQL>
    DBSource        dbi:Oracle:NAC
    DBUsername      foo
    DBAuth          bar

    ConnectionHook  sub { \
        $_[1]->do("ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS'"); \
        $_[1]->do("ALTER SESSION SET CURRENT_SCHEMA  = nacadm"); \
    }

    # store the supportgroup from the CMDB in the OSC-Group-Identifier attribute
    GetClientQuery SELECT device.ipaddr, 'key', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, device.hostid, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'OSC-Group-Identifier=' || tblhost.hsup FROM device JOIN core.tblhost at PCMSAT01 ON (device.hostid = tblhost.hostid) WHERE device.fk_collector = 5

    # Reread the client list every hour
    RefreshPeriod 3600
</ClientListSQL>


the error from the level 3 logfile:

Thu Oct 14 12:57:42 2010: ERR: Execute failed for 'SELECT device.ipaddr, 'key', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, device.hostid, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'OSC-Group-Identifier=' || tblhost.hsup FROM device JOIN core.tblhost at PCMSAT01 ON (device.hostid = tblhost.hostid) WHERE device.fk_collector = 5': SQL Timeout



--
Best regards, Alex




Am Montag, den 11.10.2010, 23:27 +0200 schrieb Mike McCauley:


Hello Alexander,

On Tuesday 12 October 2010 03:07:16 am Alexander Hartmaier wrote:
> Hi Mike,
>
> 4.7 rpm, without patches.

OK, so we will need to see the config file and the log file showing the error
and what happens before.

Cheers.




*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*
T-Systems Austria GesmbH Rennweg 97-99, 1030 Wien
Handelsgericht Wien, FN 79340b
*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*
Notice: This e-mail contains information that is confidential and may be privileged.
If you are not the intended recipient, please notify the sender and then
delete this e-mail immediately.
*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.open.com.au/pipermail/radiator/attachments/20101014/1dfe8746/attachment.html