Error E-unk-000-000 Failed To Make A Connection To Server
row; probe disconnect; results processing failed Technote (troubleshooting) Problem(Abstract) The error "ERROR=Attempt to insert duplicate row on line 1 of statement" , what does this mean in the probe log? Why does the probe repeatedly disconnect and reconnect? Symptom 2012-04-30T08:40:31: Error: E-UNK-000-000: Server 'NCOMS': ERROR=Attempt to insert duplicate row on line 1 of statement 'insert into custom.status values ( 'DS=2-0-2-1-2-3-2',0,'NODE','10.10.10.10','mttrapd','SNMP probe','DS=2-0-2-1-2-3-2','',1,'DS alert with 1 entities affected.',0,1335793231,1335793231,0,0,1,0,4100,0,'',65...' 2012-04-30T08:40:31: Warning: W-UNK-000-000: Results processing failed 2012-04-30T08:40:31: Error: E-UNK-000-000: Connection to object server 'NCOMS' marked DEAD ! 2012-04-30T08:40:31: Debug: D-UNK-000-000: SAF: Writing DisconnectionTime file for NCOMS 2012-04-30T08:40:31: Debug: D-UNK-000-000: Attempting a connection to server 'NCOMS'. Resolving the problem The duplicate row error will cause the probe to disconnect and reconnect to the Object Server. If the probe is inserting into the alerts.status table, check that the default trigger deduplication exists and is enabled. To prevent the error and the probe disconnection for other tables than alerts.status, a deduplication trigger should be written for the custom table on what action to take when there is a duplicate row. Below is an example which simply drops the incoming duplicate event data and make no updates. This will prevent the probe disconnections, but you may want to update the trigger to take a different action when the duplicate row is received. If the duplicate event data is really needed, either the probe rules file can be updated to make the Identifier unique or the trigger updated to update the existing row in the custom table. create or replace trigger custom_dedup group default_triggers debug false enabled true priority 1 comment 'Deduplication processing for custom.status' before reinse
config 5 replies Latest Post - 2010-04-08T10:02:24Z by SystemAdmin Display:ConversationsBy Date 1-6 of 6 Previous Next SystemAdmin 110000D4XK 1283 Posts Pinned topic Probe Server config 2010-04-06T16:12:30Z | Tags: Answered question This question has been answered. Unanswered question This question has not been answered yet. We are just getting started and need some assistance. We decided to use a seperate server for our probe server (as others have suggested) but http://www-01.ibm.com/support/docview.wss?uid=swg21622825 cannot find any documentation specific for installing/configuring a probe server. What we've done so far on our "probe" server is run the basic ./install.bin but used the customized install and only installed "Probe Support". We then installed the Simnet probe, uncommented the simnet.props file, pointed the Server parameter to https://www.ibm.com/developerworks/community/forums/thread.jspa?threadID=324422 our ObjectServer and started the probe. The following errors are recorded in the simnet.log: 2010-04-06T11:54:29: Error: E-UNK-000-000: ct_connect(): directory service layer: internal directory control layer error: Requested server name not found. 2010-04-06T11:54:29: Error: E-UNK-000-000: Failed to make a connection to server 'OMNIOST1'. 2010-04-06T11:54:29: Error: E-UNK-000-000: Failed to connect to all required ObjectServers. 2010-04-06T11:54:29: Error: E-UNK-000-000: Failed to read rules - aborting What are we missing? Do we need to install other things on the probe server? Im not understanding how the probe knows about our ObjectServer and think this is probably the problem. Im sure this is something silly that we didnt do. Any help appreciated. Thanks Jab Log in to reply. Updated on 2010-04-08T10:02:24Z at 2010-04-08T10:02:24Z by SystemAdmin SystemAdmin 110000D4XK 1283 Posts Re: Probe Server config 2010-04-06T16:28:49Z This is the accepted answer. This is the accepted answer. You need to define the ObjectServer hos
[ thread ] [ subject ] [ author ] Thanks Alex, yes the server is in secure mode - and I thought I had configured the probe correctly, but will do that again. --Geff --- On Thu, 2/17/11, Alex Greenbank https://netcoolusers.org/archives/users/2011-February/061808.html
[ date ] [ thread ] [ subject ] [ author ] William, The props file seems ok, pointing to the right places. I have this error on the mttrapd.log: 2013-08-06T10:48:12: Information: I-UNK-000-000: Connecting ... 2013-08-06T10:48:12: Debug: D-UNK-000-000: Shutting down Probewatch heartbeat thread. 2013-08-06T10:48:12: Debug: D-UNK-000-000: Probewatch heartbeat thread is already shutdown. 2013-08-06T10:48:12: Debug: D-UNK-000-000: Stopping separate communications threads if they are running. 2013-08-06T10:48:12: Debug: D-UNK-000-000: Running with single threaded communications. 2013-08-06T10:48:12: Debug: D-UNK-000-000: Reading /opt/IBM/tivoli/netcool/omnibus/etc/rules/snmptrap.rules 2013-08-06T10:48:12: Debug: D-UNK-000-000: Plain text rules file detected. 2013-08-06T10:48:12: Error: E-UNK-000-000: Rules file '/opt/IBM/tivoli/netcool/omnibus/etc/rules/snmptrap.rules' line 119: Failed to read lookup table file '$NC_RULES_HOME/include-snmptrap/CorrScore.snmptrap.lookup' 2013-08-06T10:48:12: Information: I-UNK-000-000: Falling back to previous rules file. 2013-08-06T10:48:12: Error: E-UNK-000-000: Failed to read rules: error in rules file 2013-08-06T10:48:12: Error: E-P_M-102-000: Failed to initialise session: Opl library error (see previous messages) ...and here is line 119 from the snmtrap.rules file: table snmptrapCorrScore = "$NC_RULES_HOME/include-snmptrap/CorrScore.snmptrap.lookup" I´ve checked and this file exists and is in this exact path....so, what could be wrong? Thanks Mario ________________________________ From: William Cain