# java.sql.SQLSyntaxErrorException: Unknown column 't\_stamp' in 'where clause' **URL:** \ **Category:** Ignition\ **Created:** [August 1, 2025, 6:26pm UTC](https://forum.inductiveautomation.com/t/java-sql-sqlsyntaxerrorexception-unknown-column-t-stamp-in-where-clause/109266 "2025-08-01T18:26:01Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![David\_Anderson1](https://avatars.discourse-cdn.com/v4/letter/d/71c47a/32.png) [@David\_Anderson1](https://forum.inductiveautomation.com/u/David_Anderson1)\ **Post date:** [August 1, 2025, 6:26pm UTC](https://forum.inductiveautomation.com/t/java-sql-sqlsyntaxerrorexception-unknown-column-t-stamp-in-where-clause/109266/1 "2025-08-01T18:26:01Z")
How can I determine what database caused this issue? ---
**Author:** ![lrose](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/lrose/32/62724_2.png) [@lrose](https://forum.inductiveautomation.com/u/lrose)\ **Post date:** [August 1, 2025, 6:28pm UTC](https://forum.inductiveautomation.com/t/java-sql-sqlsyntaxerrorexception-unknown-column-t-stamp-in-where-clause/109266/2 "2025-08-01T18:28:22Z")
The first step would be looking at the full error message. ---
**Author:** ![Cody\_Morgan](https://avatars.discourse-cdn.com/v4/letter/c/db5fbb/32.png) [@Cody\_Morgan](https://forum.inductiveautomation.com/u/Cody_Morgan)\ **Post date:** [August 1, 2025, 6:32pm UTC](https://forum.inductiveautomation.com/t/java-sql-sqlsyntaxerrorexception-unknown-column-t-stamp-in-where-clause/109266/3 "2025-08-01T18:32:29Z")
~~Not just the full error, but also the query and table definition.~~ Edit: sorry, misread the question ---
**Author:** ![lrose](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/lrose/32/62724_2.png) [@lrose](https://forum.inductiveautomation.com/u/lrose)\ **Post date:** [August 1, 2025, 6:33pm UTC](https://forum.inductiveautomation.com/t/java-sql-sqlsyntaxerrorexception-unknown-column-t-stamp-in-where-clause/109266/4 "2025-08-01T18:33:47Z")
Presumably if they don't know the database, then they also don't know the query or table definition? ---
**Author:** ![Cody\_Morgan](https://avatars.discourse-cdn.com/v4/letter/c/db5fbb/32.png) [@Cody\_Morgan](https://forum.inductiveautomation.com/u/Cody_Morgan)\ **Post date:** [August 1, 2025, 6:38pm UTC](https://forum.inductiveautomation.com/t/java-sql-sqlsyntaxerrorexception-unknown-column-t-stamp-in-where-clause/109266/5 "2025-08-01T18:38:28Z")
Yes, you're totally right. I misread the question. ---
**Author:** ![David\_Anderson1](https://avatars.discourse-cdn.com/v4/letter/d/71c47a/32.png) [@David\_Anderson1](https://forum.inductiveautomation.com/u/David_Anderson1)\ **Post date:** [August 5, 2025, 8:18pm UTC](https://forum.inductiveautomation.com/t/java-sql-sqlsyntaxerrorexception-unknown-column-t-stamp-in-where-clause/109266/6 "2025-08-05T20:18:44Z")
Sorry, I should have said the _ **data table** _ that is in question. ---
**Author:** ![lrose](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/lrose/32/62724_2.png) [@lrose](https://forum.inductiveautomation.com/u/lrose)\ **Post date:** [August 6, 2025, 2:55am UTC](https://forum.inductiveautomation.com/t/java-sql-sqlsyntaxerrorexception-unknown-column-t-stamp-in-where-clause/109266/7 "2025-08-06T02:55:09Z")
If you can share the full error message, generally it will give the stack trace and that may give us some clue as to where to look for the query that resulted in this error. That would then indicate which data table produced the error. The error message might even include the exact query as this is a syntax error. ---
**Author:** ![David\_Anderson1](https://avatars.discourse-cdn.com/v4/letter/d/71c47a/32.png) [@David\_Anderson1](https://forum.inductiveautomation.com/u/David_Anderson1)\ **Post date:** [August 8, 2025, 8:08pm UTC](https://forum.inductiveautomation.com/t/java-sql-sqlsyntaxerrorexception-unknown-column-t-stamp-in-where-clause/109266/8 "2025-08-08T20:08:57Z")
```python INFO | jvm 1 | 2025/08/08 14:47:32 | E [s.M.TableDeleteTask] [14:47:32.520]: Error executing table data delete maintenance task.INFO | jvm 1 | 2025/08/08 14:47:32 | java.sql.SQLSyntaxErrorException: Unknown column 't_stamp' in 'where clause'INFO | jvm 1 | 2025/08/08 14:47:32 | at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)INFO | jvm 1 | 2025/08/08 14:47:32 | at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)INFO | jvm 1 | 2025/08/08 14:47:32 | at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953)INFO | jvm 1 | 2025/08/08 14:47:32 | at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1098)INFO | jvm 1 | 2025/08/08 14:47:32 | at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1046)INFO | jvm 1 | 2025/08/08 14:47:32 | at com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1371)INFO | jvm 1 | 2025/08/08 14:47:32 | at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdate(ClientPreparedStatement.java:1031)INFO | jvm 1 | 2025/08/08 14:47:32 | at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:136)INFO | jvm 1 | 2025/08/08 14:47:32 | at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:136)INFO | jvm 1 | 2025/08/08 14:47:32 | at com.inductiveautomation.ignition.gateway.datasource.SRConnectionWrapper$SRPreparedStatement.executeUpdate(SRConnectionWrapper.java:981)INFO | jvm 1 | 2025/08/08 14:47:32 | at com.inductiveautomation.ignition.gateway.datasource.SRConnectionWrapper.runPrepUpdate(SRConnectionWrapper.java:181)INFO | jvm 1 | 2025/08/08 14:47:32 | at com.inductiveautomation.factorysql.maintenance.TableDeleteTask.run(TableDeleteTask.java:134)INFO | jvm 1 | 2025/08/08 14:47:32 | at com.inductiveautomation.ignition.common.execution.impl.BasicExecutionEngine$SelfSchedulingRunner.run(BasicExecutionEngine.java:504)INFO | jvm 1 | 2025/08/08 14:47:32 | at com.inductiveautomation.ignition.common.execution.impl.BasicExecutionEngine$TrackedTask.run(BasicExecutionEngine.java:593)INFO | jvm 1 | 2025/08/08 14:47:32 | at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)INFO | jvm 1 | 2025/08/08 14:47:32 | at java.base/java.util.concurrent.FutureTask.run(Unknown Source)INFO | jvm 1 | 2025/08/08 14:47:32 | at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)INFO | jvm 1 | 2025/08/08 14:47:32 | at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)INFO | jvm 1 | 2025/08/08 14:47:32 | at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)INFO | jvm 1 | 2025/08/08 14:47:32 | at java.base/java.lang.Thread.run(Unknown Source) ``` ---
**Author:** ![lrose](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/lrose/32/62724_2.png) [@lrose](https://forum.inductiveautomation.com/u/lrose)\ **Post date:** [August 8, 2025, 8:19pm UTC](https://forum.inductiveautomation.com/t/java-sql-sqlsyntaxerrorexception-unknown-column-t-stamp-in-where-clause/109266/9 "2025-08-08T20:19:03Z")
The error is being generated by a Transaction Group trying to delete records in it’s maintained table. So not caused by anything that you specifically wrote. What drew your attention to this particular error? Or did you just happen to notice it in the wrapper log? ---
**Author:** ![David\_Anderson1](https://avatars.discourse-cdn.com/v4/letter/d/71c47a/32.png) [@David\_Anderson1](https://forum.inductiveautomation.com/u/David_Anderson1)\ **Post date:** [August 27, 2025, 3:43pm UTC](https://forum.inductiveautomation.com/t/java-sql-sqlsyntaxerrorexception-unknown-column-t-stamp-in-where-clause/109266/10 "2025-08-27T15:43:42Z")
That I agree with. Now, how can I find the particular transaction group that caused the failure?