# Query error Invalid Object Name when the tables actually exist **URL:** \ **Category:** Ignition\ **Tags:** ignition79, database\ **Created:** [November 22, 2021, 7:36pm UTC](https://forum.inductiveautomation.com/t/query-error-invalid-object-name-when-the-tables-actually-exist/53359 "2021-11-22T19:36:17Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![JORGE.REYES](https://avatars.discourse-cdn.com/v4/letter/j/85f322/32.png) [@JORGE.REYES](https://forum.inductiveautomation.com/u/JORGE.REYES)\ **Post date:** [November 22, 2021, 7:36pm UTC](https://forum.inductiveautomation.com/t/query-error-invalid-object-name-when-the-tables-actually-exist/53359/1 "2021-11-22T19:36:17Z")
Hello, Im continuously getting an Invalid Object Name error on all queries called from a data base connection. The tables and sp’s exist in the db, The db connection shows valid and doesnt show any error, if I disable and then enable the connection the problem is gone for some hours but then the error appears again. And if I run the query in SQL it runs as it should. Im not sure if the error would be from SQL server or if it from Ignition. Here is an example of the log when the error happens. Message: Error running query: SQLQuery(query=SELECT a.scheduleId, b.[LpaeAreaName] Dpto ,[expectedcompletationdate] Fecha FROM [dbo].[LPA\_Schedules] a inner join [dbo].[LPA\_Auditable\_Areas] b on a.areaid = b.id where AuditorUsr = ‘JIReyes’ and expectedcompletationdate \> getdate() and [Status] = 1, database=)@0ms On: MyAudits.Root Container.todayLpas Time: Mon Nov 22 12:16:56PM Severity: WARN Logger: Vision.Binding.SQLPropertyAdapter Stack Trace: java.lang.Exception: Error running query: SQLQuery(query=SELECT a.scheduleId, b.[LpaeAreaName] Dpto ,[expectedcompletationdate] Fecha FROM [dbo].[LPA\_Schedules] a inner join [dbo].[LPA\_Auditable\_Areas] b on a.areaid = b.id where AuditorUsr = ‘JIReyes’ and expectedcompletationdate \> getdate() and [Status] = 1, database=)@0ms On: MyAudits.Root Container.todayLpas     at com.inductiveautomation.factorypmi.application.gateway.QueryManager$QueryExecutor.run(QueryManager.java:308)     at java.lang.Thread.run(Unknown Source) Caused by: com.inductiveautomation.ignition.client.gateway\_interface.GatewayException: Invalid object name ‘dbo.LPA\_Schedules’.     at com.inductiveautomation.ignition.client.gateway\_interface.GatewayInterface.newGatewayException(GatewayInterface.java:341)     at com.inductiveautomation.ignition.client.gateway\_interface.GatewayInterface.sendMessage(GatewayInterface.java:315)     at com.inductiveautomation.ignition.client.gateway\_interface.GatewayInterface.sendMessage(GatewayInterface.java:268)     at com.inductiveautomation.ignition.client.gateway\_interface.GatewayInterface.runLimitQuery(GatewayInterface.java:819)     at com.inductiveautomation.ignition.client.gateway\_interface.GatewayInterface.runQuery(GatewayInterface.java:789)     at com.inductiveautomation.factorypmi.application.gateway.SQLQuery.execute(SQLQuery.java:50)     at com.inductiveautomation.factorypmi.application.gateway.QueryManager$Query.execute(QueryManager.java:657)     at com.inductiveautomation.factorypmi.application.gateway.QueryManager$Query.access$500(QueryManager.java:630)     at com.inductiveautomation.factorypmi.application.gateway.QueryManager$QueryExecutor.run(QueryManager.java:306)     … 1 common frames omitted Caused by: com.inductiveautomation.ignition.client.gateway\_interface.GatewayResponse$GatewayThrowable: Invalid object name ‘dbo.LPA\_Schedules’.     at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:196)     at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1454)     at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:786)     at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:685)     at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4026)     at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1416)     at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:185)     at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:160)     at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeQuery(SQLServerStatement.java:620)     at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)     at com.inductiveautomation.ignition.gateway.datasource.DelegatingStatement.executeQuery(DelegatingStatement.java:64)     at com.inductiveautomation.ignition.gateway.datasource.SRConnectionWrapper$SRStatement.executeQuery(SRConnectionWrapper.java:764)     at com.inductiveautomation.ignition.gateway.servlets.gateway.functions.RunQuery.run(RunQuery.java:102)     at com.inductiveautomation.ignition.gateway.servlets.gateway.functions.AbstractDBAction.invoke(AbstractDBAction.java:77)     at com.inductiveautomation.ignition.gateway.servlets.Gateway.doPost(Gateway.java:404)     at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)     at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)     at com.inductiveautomation.ignition.gateway.bootstrap.MapServlet.service(MapServlet.java:85)     at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:837)     at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:583)     at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)     at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:548)     at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:226)     at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1160)     at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:511)     at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185)     at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1092)     at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)     at org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:52)     at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:134)     at org.eclipse.jetty.server.Server.handle(Server.java:518)     at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:308)     at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:244)     at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:273)     at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:95)     at org.eclipse.jetty.io.SelectChannelEndPoint$2.run(SelectChannelEndPoint.java:93)     at org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.produceAndRun(ExecuteProduceConsume.java:246)     at org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.run(ExecuteProduceConsume.java:156)     at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:654)     at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:572)     at java.lang.Thread.run(null) ---
**Author:** ![Sebastian\_coor](https://avatars.discourse-cdn.com/v4/letter/s/8e8cbc/32.png) [@Sebastian\_coor](https://forum.inductiveautomation.com/u/Sebastian_coor)\ **Post date:** [November 19, 2024, 1:26pm UTC](https://forum.inductiveautomation.com/t/query-error-invalid-object-name-when-the-tables-actually-exist/53359/2 "2024-11-19T13:26:12Z")
did you find any solution, having the same issue but on 8.1 ---
**Author:** ![Michael\_Everts](https://avatars.discourse-cdn.com/v4/letter/m/7ea924/32.png) [@Michael\_Everts](https://forum.inductiveautomation.com/u/Michael_Everts)\ **Post date:** [May 13, 2025, 3:59pm UTC](https://forum.inductiveautomation.com/t/query-error-invalid-object-name-when-the-tables-actually-exist/53359/3 "2025-05-13T15:59:37Z")
Is the Schema on the database table something other that dbo? If so you need to add the schema to your query.