1 Reply Latest reply on Nov 4, 2008 8:41 AM by Yann

    syslog question

    lchance

      anyone know what causes this event message flood?

      An Exception was thrown while updating the DNS cache.

      Error Detail-Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

        • Re: syslog question
          Yann

          This error means that your database is processing too slowly the update DNS request for the Syslog messages or that Orion is requesting too much entries to be updated.

          1) You can firstly increase the SQL Query Timeout.

          Edit the \Program Files\Solarwinds\Orion\SWNetPerfMon.db

          and modify at the bottom of it the CommandTimeout:

          ! ! Database Command timeout in seconds CommandTimeout=xx

          to something higher such as 180 seconds.

          Restart the services

          Start > All Programs > Solarwinds Orion > Advanced Features > Orion Service Manager

          Shutdown Everything and then Start Everything.

          If you keep having the error message, try to increase again this variable and try the 2), 3) and 4) steps.

          2) You can reduce the number of Syslog Messages that have to be processed.

          Start > All Programs > Solarwinds Orion > Syslog Viewer

          File > Settings

          Decrease the "Retain Syslog Messages for how many days ?" value in the general tab.

          Click on ok.

          3) Truncate the table if you do not need to keep historical syslog messages

          Open Database Manager

          Start > All Programs > Solarwinds Orion > Database Utilities > Database Manager

          If this is the first time you use the tool, add your database server by clicking on the Add server button.

          Expand your database and right-click on the SysLog table.

          Select Query Table.

          Type the below SQL query:

          TRUNCATE TABLE SysLog

          and click on Refresh to execute the query.

          This may take a while depending how many entries are recorded.

          Once done, right-click on the database and select Compact Database.

          Compacting a database shrinks it, reindexes it, and removes whitespace.

          4) You can increase the DNS cache lookup interval by editing a database value.

          Open Database Manager

          Expand your Orion database

          Right-Click on the Settings table and select Query Table.

          Select "Read-Write (Results can be edited)"

          Click on Refresh

          Increase the "CurrentValue" field of the "SysLog Service - DNS Cache Time" entry.

          Ensure the new value has been written by refreshing the contents once more.

           

          Hope that helps.

           Yann