mTail - Windows Real time Log Monitoring Tool, Log Searching - Free Tools

This post is for mTail - Log monitoring tool on windows. I have used it it is very good. The benefits are

• Monitor multiple Servers with multiple instances of this tool concurrently
• Simple and easy to use
• Start / Stop option to stop in case you have viewed error

Free tools for File Search / Exception Checking in logs

• Agent Ransack
• Textpad (Find in Files Feature)
• Notepad++

Happy Learning!!

Interesting Bug

Sharing one Unique Interesting bug identified during testing

Case #1 - Property_Id values mismatch was the primary issue. Two tables were defined in two databases. The scenario is Property_Id on Database A is based on master tables defined , example Master A. Issue was## mapping of MasterA was used in DatabaseB instead of MasterB. It was difficult to identify as Property_Id values were always overlapping for a smaller set of input data

Database A

MasterA

Property_Id Value

1    A

2    B

3    C

.......

10    D

TableA

Property_Id  Local_Id (Identity Column) Value

1 1

2 2

3 3

1 4

2 5

2 6

Database B

MasterB

Property_Id Value

10    A

20    B

30    C

TableB (Expected)

Property_Id          Local_Id (Identity Column) Value

10 1

20 2

30 3

10 4

20 5

20 6

TableB (Actual)

Property_Id           Local_Id (Identity Column) Value

1 1

2 2

3 3

10 4

2 5

2 6

The bug was not easily identified as Property values in MasterA and MasterB overlapped.  The values were matching in most cases for a smaller dataset.

Happy Learning!!!