# Finding DB transaction sources

**URL:** <https://forum.inductiveautomation.com/t/finding-db-transaction-sources/105973>\
**Category:** Ignition\
**Tags:** ignition81, scripting\
**Created:** [May 7, 2025, 12:03pm UTC](https://forum.inductiveautomation.com/t/finding-db-transaction-sources/105973 "2025-05-07T12:03:05Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![hw79](https://avatars.discourse-cdn.com/v4/letter/h/838e76/32.png) [@hw79](https://forum.inductiveautomation.com/u/hw79)\
**Post date:** [May 7, 2025, 12:03pm UTC](https://forum.inductiveautomation.com/t/finding-db-transaction-sources/105973/1 "2025-05-07T12:03:05Z")

</div>

I'm trying to debug a gateway that someone else did dev work on and there are several transaction timeout events from transactions that haven't been closed properly. Is there a way to tell the project these transactions are in?

Short of going through every project and finding `system.db.beginTransaction` then looking for a `closeTransaction` I can't think of a way to do this.

Thanks!

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [May 7, 2025, 12:40pm UTC](https://forum.inductiveautomation.com/t/finding-db-transaction-sources/105973/2 "2025-05-07T12:40:13Z")

</div>

I think you are stuck. You will have to do a manual search. In particular, you will need to look to make sure all error handling has the dual java/jython clauses leading to rollback on errors. That is, there probably _ **is** _ a `.closeTransaction()` that isn't being called.

---

<div class="post-metadata">

**Author:** ![hunterdg](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/hunterdg/32/67774_2.png) [@hunterdg](https://forum.inductiveautomation.com/u/hunterdg)\
**Post date:** [May 8, 2025, 6:49am UTC](https://forum.inductiveautomation.com/t/finding-db-transaction-sources/105973/3 "2025-05-08T06:49:25Z")

</div>

FWIW you can open the parent `ignition/data` folder (file system) in VSCode and use the 🔍 icon on the left to search all projects at once. It’s often faster/more thorough than built-in find/replace even for individual projects. I’m sure there are other tools that do the same.

Of course this is useless for binary-encoded vision resource blobs and gateway scripts but works with vision xml and perspective json