# Transaction Datasource Unknown **URL:** \ **Category:** Ignition\ **Tags:** database, scripting, ignition81, vision\ **Created:** [January 4, 2023, 4:07pm UTC](https://forum.inductiveautomation.com/t/transaction-datasource-unknown/68222 "2023-01-04T16:07:22Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![israel.jordan](https://avatars.discourse-cdn.com/v4/letter/i/ce73a5/32.png) [@israel.jordan](https://forum.inductiveautomation.com/u/israel.jordan)\ **Post date:** [January 4, 2023, 4:07pm UTC](https://forum.inductiveautomation.com/t/transaction-datasource-unknown/68222/1 "2023-01-04T16:07:22Z")
Hello All, I am trying to use transactions in my script when updating and inserting. But I am getting the above error. `Transaction Datasource Unknown` when my code tries to execute `system.db.runUpdateQuery`. I am using the documentation from [system.db.beginTransaction](https://docs.inductiveautomation.com/display/DOC81/system.db.beginTransaction) and [system.db.runUpdateQuery](https://docs.inductiveautomation.com/display/DOC79/system.db.runUpdateQuery) but I must be missing something. For example, when I start my transaction, I am using this: > txId = system.db.beginTransaction(database="my\_database",isolationLevel=1,timeout=5000) and that seems to work ok. But when I try to run an update query: > rowsUpdated = system.db.runUpdateQuery("my\_update\_query",database="my\_database",tx=txId,getKey=0,skipAudit=0) This error appears: > java.lang.Exception: java.lang.Exception: Error executing system.db.runUpdateQuery(my\_update\_query, Transaction datasource unknown, 7cebc364-b0d8-481f-99a5-acdde18cf3bf, false) What the heck am I missing? Thank you for the help! ---
**Author:** ![justinedwards.jle](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/justinedwards.jle/32/37854_2.png) [@justinedwards.jle](https://forum.inductiveautomation.com/u/justinedwards.jle)\ **Post date:** [January 5, 2023, 12:51am UTC](https://forum.inductiveautomation.com/t/transaction-datasource-unknown/68222/2 "2023-01-05T00:51:46Z")
I use transactions when I'm coordinating multiple queries, and it has always seemed to work well, but I haven't ever used equal signs in the command, so perhaps that is the issue. My transactions typically look something like this: ```auto query1 = "SELECT max(`Column1`)+'%s' FROM some_table" query2 = "INSERT INTO some_table (`Column1`, `Column2`) VALUES ('%s','%s')" serialTx = system.db.beginTransaction('myDatabase',timeout=5000) arg1 = '1' arg2 = system.db.runScalarQuery(query1 %(arg1), 'myDatabase', serialTx) args=arg1, arg2 system.db.runUpdateQuery(query2 %(args), 'myDatabase', serialTx) system.db.commitTransaction(serialTx) system.db.closeTransaction(serialTx) ``` ---
**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:** [February 17, 2025, 2:56pm UTC](https://forum.inductiveautomation.com/t/transaction-datasource-unknown/68222/3 "2025-02-17T14:56:51Z")
Split this topic on February 17, 2025, 2:56pm UTC 5 posts were split to a new topic: [Traceback deciphering](https://forum.inductiveautomation.com/t/traceback-deciphering/102431)