Event Monitor

More
1 month 4 weeks ago #26126 by pat.mccarty
Event Monitor was created by pat.mccarty
Hello,
We watched your video and set up the Event Monitor to watch for new files in a directory. When a new file is created, it is configured to execute a specific transform.
When we manually execute the Event Monitor, it works as expected. Otherwise, it repeatedly shows a “Duplicated Event” message and does not execute the transform.

5/26/2026 2:46:54 PM    MAIN-SQL    sa_deploy    1    \\main-fs\DeptShares\Treasury\AccountAnalysis\Remote Deposit File    AdvancedAAPlus_5_22_2026 10_10_56 AM.prn    waRemoved    AdvanceAA*.prn    0
5/26/2026 2:47:30 PM    MAIN-SQL    sa_deploy    2    \\main-fs\DeptShares\Treasury\AccountAnalysis\Remote Deposit File    AdvancedAAPlus_5_22_2026 9_47_05 AM.prn    waAdded    AdvanceAA*.prn    0
5/26/2026 2:47:30 PM    MAIN-SQL    sa_deploy    3    \\main-fs\DeptShares\Treasury\AccountAnalysis\Remote Deposit File    AdvancedAAPlus_5_22_2026 9_47_05 AM.prn    waModified    AdvanceAA*.prn    0
5/26/2026 2:47:30 PM    MAIN-SQL    sa_deploy    4    \\main-fs\DeptShares\Treasury\AccountAnalysis\Remote Deposit File    AdvancedAAPlus_5_22_2026 9_47_05 AM.prn    waModified    AdvanceAA*.prn    0
5/26/2026 2:47:30 PM    MAIN-SQL    sa_deploy    Duplicated Event
5/26/2026 2:47:30 PM    MAIN-SQL    sa_deploy    5    \\main-fs\DeptShares\Treasury\AccountAnalysis\Remote Deposit File    AdvancedAAPlus_5_22_2026 9_47_05 AM.prn    waModified    AdvanceAA*.prn    0
5/26/2026 2:47:30 PM    MAIN-SQL    sa_deploy    Duplicated Event
5/26/2026 2:47:30 PM    MAIN-SQL    sa_deploy    6    \\main-fs\DeptShares\Treasury\AccountAnalysis\Remote Deposit File    AdvancedAAPlus_5_22_2026 9_47_05 AM.prn    waModified    AdvanceAA*.prn    0
5/26/2026 2:47:30 PM    MAIN-SQL    sa_deploy    Duplicated Event


Thank you
Attachments:

Please Log in or Create an account to join the conversation.

More
1 month 4 weeks ago #26127 by admin
Replied by admin on topic Event Monitor
Please post Monitor Settings screenshot

Mike
ETL Architect

Please Log in or Create an account to join the conversation.

More
1 month 4 weeks ago #26128 by pat.mccarty
Replied by pat.mccarty on topic Event Monitor
Properties Attached
Attachments:
The following user(s) said Thank You: admin

Please Log in or Create an account to join the conversation.

More
1 month 4 weeks ago #26129 by admin
Replied by admin on topic Event Monitor
Directory monitor can be very confusing.
It is normal to see duplicated events, because quite often data is copied in chunks. 

File is added = waAdded event (File is open and locked for writing)
Chuck Is written  = waModified event
Chuck Is written  = waModified event
Once writing is completed the file is released

There in no "Completed Writing" event.

So what we have to do it to try to open the the file for writing, once successful = copy is completed.

In your case you shoud be able to see "Matched" in the log, let me run some tests in the office, I will get back to you

Mike
ETL Architect

Please Log in or Create an account to join the conversation.

More
1 month 4 weeks ago #26130 by admin
Replied by admin on topic Event Monitor
I've found a problem

Mask is incorrect d is missing. EG: it should be AdvancedAA*.prn ad not AdvanceAA*.prn

AdvancedAAPlus_5_26_2026 2_55_28 PM.prn, AdvanceAA*.prn
 

Mike
ETL Architect

Please Log in or Create an account to join the conversation.

More
1 month 4 weeks ago #26131 by admin
Replied by admin on topic Event Monitor
Yes it is definitely Mask problem

Mine is working

27/05/2026 09:45:54    DBSLAMD    dbsl    1    C:\DATA\MonitorTest    AdvancedAAPlus_5_28_2026 9_47_05 PM.prn    waRemoved    AdvancedAA*.prn    0
27/05/2026 09:46:37    DBSLAMD    dbsl    2    C:\DATA\MonitorTest    AdvancedAAPlus_5_28_2026 9_47_05 PM.prn    waAdded    AdvancedAA*.prn    0
27/05/2026 09:46:37    DBSLAMD    dbsl    Matched :AdvancedAAPlus_5_28_2026 9_47_05 PM.prn, Mask:AdvancedAA*.prn, Action: waAdded in [waAdded]
27/05/2026 09:46:37    DBSLAMD    dbsl    3    C:\DATA\MonitorTest    AdvancedAAPlus_5_28_2026 9_47_05 PM.prn    waModified    AdvancedAA*.prn    0
27/05/2026 09:46:37    DBSLAMD    dbsl    4    C:\DATA\MonitorTest    AdvancedAAPlus_5_28_2026 9_47_05 PM.prn    waModified    AdvancedAA*.prn    0
27/05/2026 09:46:37    DBSLAMD    dbsl    Duplicated Event
27/05/2026 09:46:37    DBSLAMD    dbsl    File ready: C:\DATA\MonitorTest\AdvancedAAPlus_5_28_2026 9_47_05 PM.prn 

Mike
ETL Architect
The following user(s) said Thank You: pat.mccarty

Please Log in or Create an account to join the conversation.

Cookies user preferences
We use cookies to ensure you to get the best experience on our website. If you decline the use of cookies, this website may not function as expected.
Accept all
Decline all
Read more
Marketing
Set of techniques which have for object the commercial strategy and in particular the market study.
Google
Accept
Decline
Analytics
Tools used to analyze the data to measure the effectiveness of a website and to understand how it works.
Google Analytics
Accept
Decline
Google Analytics
Accept
Decline
Functional
Tools used to give you more features when navigating on the website, this can include social sharing.
Advertisement
If you accept, the ads on the page will be adapted to your preferences.
Google Ad
Accept
Decline
Save