Hi Team,

Hoping you can help me find the source of this issue. The log file monitor triggers on already detected entries.

We have it set to run every hour, but we were still receiving the alert 4 hours after the last entry matching.

Here is the set-up Match: "FATAL ERROR in SQL call"

501 matches have been found in file \xxx.log:

r
11-12-2017 12:00:20.070 [176040746, 24215.000,123047936,2950147157]: sql_exec_direct_internal:SQLExecDirect: FATAL ERROR in SQL call
SQL State: 08S02, SQL Code: -1, Message: [Microsoft][SQL Server Native Client 11.0]SMux Provider: Physical connection is not usable [xFFFFFFFF].
SQL State: 08S02, SQL Code: -1, Message: [Microsoft][SQL Server Native Client 11.0]Unable to open a logical session
11-12-2017 12:00:20.070 [176040746, 24215.000,123047936,2950147176]: sql_fetch_internal: FATAL ERROR in SQL call


11-12-2017 12:00:20.070 [176040746, 24215.000,123047936,2950147157]: sql_exec_direct_internal:SQLExecDirect: FATAL ERROR in SQL call
SQL State: 08S02, SQL Code: -1, Message: [Microsoft][SQL Server Native Client 11.0]SMux Provider: Physical connection is not usable [xFFFFFFFF].
SQL State: 08S02, SQL Code: -1, Message: [Microsoft][SQL Server Native Client 11.0]Unable to open a logical session
11-12-2017 12:00:20.070 [176040746, 24215.000,123047936,2950147176]: sql_fetch_internal: FATAL ERROR in SQL call
SQL State: HY010, SQL Code: 0, Message: [Microsoft][ODBC Driver Manager] Function sequence error
11-12-2017 12:00:20.070 [176040748, 24215.000,123047936,2950147547]: sql_exec_direct_internal:SQLExecDirect: FATAL ERROR in SQL call
SQL State: 08S02, SQL Code: -1, Message: [Microsoft][SQL Server Native Client 11.0]SMux Provider: Physical connection is not usable [xFFFFFFFF].


asked 11 Dec '17, 18:50

shaunscott's gravatar image

shaunscott
4821316
accept rate: 16%


Hi shaunscott,

What maybe happening is that the log file is rolling over and monitor can't find the where it ended on the last scan. When the log file monitor runs it keeps track of where it left off. However when a log file rolls over that location no longer matches what the monitor thinks is the last scanned location.

Try setting your log file monitor to run more frequently. This should help with large files.

Thanks
Quinn

Please make sure to mark your questions accepted when you have your answer by clicking the gray check mark to the left of the answer.

link

answered 12 Dec '17, 14:03

Quinn's gravatar image

Quinn ♦♦
14.5k3925
accept rate: 35%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×33
×17

Asked: 11 Dec '17, 18:50

Seen: 4,207 times

Last updated: 12 Dec '17, 14:03