# On Window Transaction trigger not always useful

**URL:** <https://the.fmsoup.org/t/on-window-transaction-trigger-not-always-useful/4277>\
**Category:** Heads-Up!\
**Tags:** scripting, filemaker-server\
**Created:** [September 9, 2024, 3:37pm UTC](https://the.fmsoup.org/t/on-window-transaction-trigger-not-always-useful/4277 "2024-09-09T15:37:55Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![iwitschi](https://yyz2.discourse-cdn.com/flex030/user_avatar/the.fmsoup.org/iwitschi/32/709_2.png) [@iwitschi](https://the.fmsoup.org/u/iwitschi)\
**Post date:** [September 9, 2024, 3:37pm UTC](https://the.fmsoup.org/t/on-window-transaction-trigger-not-always-useful/4277/1 "2024-09-09T15:37:55Z")

</div>

Hi  
We experienced problems on windows servers when the OnWindowTransaction trigger and the OnLastWindowClose trigger are enabled together and a lot of server scripting is happening.

The effect was that after some time other server scripts, in the same or other apps, are just not run anymore until we changed the amount of allowed server sessions, or, in the end, disabled the OnWindowTransaction trigger completely.

It looks as if sessions are not closed properly on the server side. It's our experience on two servers with the same app, although we cannot prove it. We don't have possibilities to count sessions on the FMS.  
This is for the record. Be careful if you use this feature.  
Cheers

---

<div class="post-metadata">

**Author:** ![Malcolm](https://yyz2.discourse-cdn.com/flex030/user_avatar/the.fmsoup.org/malcolm/32/196_2.png) [@Malcolm](https://the.fmsoup.org/u/Malcolm)\
**Post date:** [September 9, 2024, 10:11pm UTC](https://the.fmsoup.org/t/on-window-transaction-trigger-not-always-useful/4277/2 "2024-09-09T22:11:52Z")

</div>

Sounds nasty. Have you drawn flow charts to map the differences between desired behaviour and current behaviour? You may find a solution there.

---

<div class="post-metadata">

**Author:** ![iwitschi](https://yyz2.discourse-cdn.com/flex030/user_avatar/the.fmsoup.org/iwitschi/32/709_2.png) [@iwitschi](https://the.fmsoup.org/u/iwitschi)\
**Post date:** [September 16, 2024, 7:09am UTC](https://the.fmsoup.org/t/on-window-transaction-trigger-not-always-useful/4277/3 "2024-09-16T07:09:33Z")

</div>

Thanks for your hint.  
I tried already different possibilities and tried to provide a complete description here: [Claris Community (English)](https://community.claris.com/en/s/question/0D5Vy00000DXF5lKAH/app-not-closing-on-onlastwindowclose-with-onwindowtransaction-script-triggered)

There is currently no solution to that, I guess.

---

<div class="post-metadata">

**Author:** ![Kirk](https://yyz2.discourse-cdn.com/flex030/user_avatar/the.fmsoup.org/kirk/32/2197_2.png) [@Kirk](https://the.fmsoup.org/u/Kirk)\
**Post date:** [October 4, 2024, 6:02pm UTC](https://the.fmsoup.org/t/on-window-transaction-trigger-not-always-useful/4277/4 "2024-10-04T18:02:46Z")

</div>

Take a look at this server side script queue as a possible option......

> [@Performance update from 24u and server side script queues](https://the.fmsoup.org/t/performance-update-from-24u-and-server-side-script-queues/4339):
>
> 24u is a great resource for lots of FM things and Honza is truly focused on performance. This new blog post on their site has some good info. For those not aware of the “server side script queue” mentioned in the post as an alternative to PSoS execution, it is functionally equivalent to the old school mainframe job scheduler. A script places the name of a script to execute into a new record in a table. A server side script running on short intervals looks for a record in that table and runs a…