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.tblh...@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.tblh...@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. *"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*
_______________________________________________ radiator mailing list radiator@open.com.au http://www.open.com.au/mailman/listinfo/radiator