org.postgresql.util.PSQLException: ERROR: syntax error at or near ")" Position: 185

Mirth Project | Alex Aitougan | 3 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Attempting text search in Channel Messages fails with the following error: [2014-05-14 10:28:22,501] ERROR (com.mirth.connect.server.servlets.MessageObjectServlet:294): org.apache.ibatis.exceptions.PersistenceException: ### Error querying database. Cause: org.postgresql.util.PSQLException: ERROR: syntax error at or near ")" Position: 185 ### The error may exist in postgres/postgres-message.xml ### The error may involve Message.searchCustomMetaDataTable-Inline ### The error occurred while setting parameters ### SQL: SELECT MESSAGE_ID AS MESSAGE_ID, METADATA_ID AS METADATA_ID FROM D_MCM15 WHERE MESSAGE_ID >= ? AND MESSAGE_ID <= ? AND () ### Cause: org.postgresql.util.PSQLException: ERROR: syntax error at or near ")" Position: 185 at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:23) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:104) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:95) at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.apache.ibatis.session.SqlSessionManager$SqlSessionInterceptor.invoke(SqlSessionManager.java:282) at com.sun.proxy.$Proxy7.selectList(Unknown Source) at org.apache.ibatis.session.SqlSessionManager.selectList(SqlSessionManager.java:171) at com.mirth.connect.server.controllers.DonkeyMessageController.searchText(DonkeyMessageController.java:1065) at com.mirth.connect.server.controllers.DonkeyMessageController.searchAll(DonkeyMessageController.java:872) at com.mirth.connect.server.controllers.DonkeyMessageController.searchMessages(DonkeyMessageController.java:641) at com.mirth.connect.server.controllers.DonkeyMessageController.getMessages(DonkeyMessageController.java:192) at com.mirth.connect.server.servlets.MessageObjectServlet.doPost(MessageObjectServlet.java:97) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:652) at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:447) at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:225) at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1038) at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:374) at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:189) at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:972) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:135) at org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:52) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116) at org.eclipse.jetty.server.Server.handle(Server.java:363) at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:483) at org.eclipse.jetty.server.AbstractHttpConnection.content(AbstractHttpConnection.java:931) at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.content(AbstractHttpConnection.java:992) at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:856) at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:240) at org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:82) at org.eclipse.jetty.io.nio.SslConnection.handle(SslConnection.java:196) at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:627) at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:51) at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:608) at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:543) at java.lang.Thread.run(Thread.java:744) Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or near ")" Position: 185 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2101) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1834) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:510) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:386) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:379) at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:56) at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:70) at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:57) at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:267) at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:141) at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:105) at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:81) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:101) ... 37 more

    Mirth Project | 3 years ago | Alex Aitougan
    org.postgresql.util.PSQLException: ERROR: syntax error at or near ")" Position: 185
  2. 0

    Attempting text search in Channel Messages fails with the following error: [2014-05-14 10:28:22,501] ERROR (com.mirth.connect.server.servlets.MessageObjectServlet:294): org.apache.ibatis.exceptions.PersistenceException: ### Error querying database. Cause: org.postgresql.util.PSQLException: ERROR: syntax error at or near ")" Position: 185 ### The error may exist in postgres/postgres-message.xml ### The error may involve Message.searchCustomMetaDataTable-Inline ### The error occurred while setting parameters ### SQL: SELECT MESSAGE_ID AS MESSAGE_ID, METADATA_ID AS METADATA_ID FROM D_MCM15 WHERE MESSAGE_ID >= ? AND MESSAGE_ID <= ? AND () ### Cause: org.postgresql.util.PSQLException: ERROR: syntax error at or near ")" Position: 185 at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:23) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:104) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:95) at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.apache.ibatis.session.SqlSessionManager$SqlSessionInterceptor.invoke(SqlSessionManager.java:282) at com.sun.proxy.$Proxy7.selectList(Unknown Source) at org.apache.ibatis.session.SqlSessionManager.selectList(SqlSessionManager.java:171) at com.mirth.connect.server.controllers.DonkeyMessageController.searchText(DonkeyMessageController.java:1065) at com.mirth.connect.server.controllers.DonkeyMessageController.searchAll(DonkeyMessageController.java:872) at com.mirth.connect.server.controllers.DonkeyMessageController.searchMessages(DonkeyMessageController.java:641) at com.mirth.connect.server.controllers.DonkeyMessageController.getMessages(DonkeyMessageController.java:192) at com.mirth.connect.server.servlets.MessageObjectServlet.doPost(MessageObjectServlet.java:97) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:652) at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:447) at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:225) at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1038) at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:374) at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:189) at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:972) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:135) at org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:52) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116) at org.eclipse.jetty.server.Server.handle(Server.java:363) at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:483) at org.eclipse.jetty.server.AbstractHttpConnection.content(AbstractHttpConnection.java:931) at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.content(AbstractHttpConnection.java:992) at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:856) at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:240) at org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:82) at org.eclipse.jetty.io.nio.SslConnection.handle(SslConnection.java:196) at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:627) at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:51) at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:608) at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:543) at java.lang.Thread.run(Thread.java:744) Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or near ")" Position: 185 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2101) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1834) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:510) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:386) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:379) at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:56) at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:70) at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:57) at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:267) at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:141) at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:105) at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:81) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:101) ... 37 more

    Mirth Project | 3 years ago | Alex Aitougan
    org.postgresql.util.PSQLException: ERROR: syntax error at or near ")" Position: 185
  3. 0

    The custom metadata columns for a channel may change after a user has already entered the message browser. If a user enters the message browser and meanwhile some other user removes a custom metadata column on the channel, searching may cause SQLExceptions: {code}ERROR 2014-05-14 08:29:26,350 [qtp72633090-87] com.mirth.connect.server.servlets.MessageObjectServlet: org.apache.ibatis.exceptions.PersistenceException: ### Error querying database. Cause: org.postgresql.util.PSQLException: ERROR: column "SOURCE" does not exist Position: 191 ### The error may exist in postgres/postgres-message.xml ### The error may involve Message.searchCustomMetaDataTable-Inline ### The error occurred while setting parameters ### SQL: SELECT MESSAGE_ID AS MESSAGE_ID, METADATA_ID AS METADATA_ID FROM D_MCM13 WHERE MESSAGE_ID >= ? AND MESSAGE_ID <= ? AND ( "SOURCE" ILIKE '%' || ? || '%' ) ### Cause: org.postgresql.util.PSQLException: ERROR: column "SOURCE" does not exist Position: 191 at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:23) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:104) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:95) at sun.reflect.GeneratedMethodAccessor8.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.ibatis.session.SqlSessionManager$SqlSessionInterceptor.invoke(SqlSessionManager.java:282) at com.sun.proxy.$Proxy7.selectList(Unknown Source) at org.apache.ibatis.session.SqlSessionManager.selectList(SqlSessionManager.java:171) at com.mirth.connect.server.controllers.DonkeyMessageController.searchText(DonkeyMessageController.java:1075) at com.mirth.connect.server.controllers.DonkeyMessageController.searchAll(DonkeyMessageController.java:880) at com.mirth.connect.server.controllers.DonkeyMessageController.searchMessages(DonkeyMessageController.java:649) at com.mirth.connect.server.controllers.DonkeyMessageController.getMessages(DonkeyMessageController.java:192) at com.mirth.connect.server.servlets.MessageObjectServlet.doPost(MessageObjectServlet.java:97) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:652) at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:447) at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:225) at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1038) at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:374) at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:189) at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:972) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:135) at org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:52) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116) at org.eclipse.jetty.server.Server.handle(Server.java:363) at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:483) at org.eclipse.jetty.server.AbstractHttpConnection.content(AbstractHttpConnection.java:931) at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.content(AbstractHttpConnection.java:992) at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:856) at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:240) at org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:82) at org.eclipse.jetty.io.nio.SslConnection.handle(SslConnection.java:196) at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:627) at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:51) at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:608) at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:543) at java.lang.Thread.run(Thread.java:680) Caused by: org.postgresql.util.PSQLException: ERROR: column "SOURCE" does not exist Position: 191 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2101) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1834) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:510) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:386) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:379) at sun.reflect.GeneratedMethodAccessor40.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:58) at com.sun.proxy.$Proxy11.execute(Unknown Source) at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:56) at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:70) at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:57) at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:267) at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:141) at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:105) at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:81) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:101) ... 37 more{code}

    Mirth Project | 3 years ago | Nick Rupley
    org.postgresql.util.PSQLException: ERROR: column "SOURCE" does not exist Position: 191
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Active VM's snapshot Removal is available from rest-api,the result is a useless VM which cannot be activated and db exceptions

    https://bugzilla.redhat.com/bugzilla/ | 3 years ago | Ori Gofen
    org.postgresql.util.PSQLException: ERROR: null value in column "snapshot_id" violates not-null constraint Where: SQL statement "INSERT INTO snapshots( snapshot_id, status, vm_id, snapshot_type, description, creation_date, app_list, vm_configuration, memory_volume) VALUES( $1 , $2 , $3 , $4 , $5 , $6 , $7 , $8 , $9 )" PL/pgSQL function "insertsnapshot" line 2 at SQL statement
  6. 0

    The custom metadata columns for a channel may change after a user has already entered the message browser. If a user enters the message browser and meanwhile some other user removes a custom metadata column on the channel, searching may cause SQLExceptions: {code}ERROR 2014-05-14 08:29:26,350 [qtp72633090-87] com.mirth.connect.server.servlets.MessageObjectServlet: org.apache.ibatis.exceptions.PersistenceException: ### Error querying database. Cause: org.postgresql.util.PSQLException: ERROR: column "SOURCE" does not exist Position: 191 ### The error may exist in postgres/postgres-message.xml ### The error may involve Message.searchCustomMetaDataTable-Inline ### The error occurred while setting parameters ### SQL: SELECT MESSAGE_ID AS MESSAGE_ID, METADATA_ID AS METADATA_ID FROM D_MCM13 WHERE MESSAGE_ID >= ? AND MESSAGE_ID <= ? AND ( "SOURCE" ILIKE '%' || ? || '%' ) ### Cause: org.postgresql.util.PSQLException: ERROR: column "SOURCE" does not exist Position: 191 at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:23) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:104) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:95) at sun.reflect.GeneratedMethodAccessor8.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.ibatis.session.SqlSessionManager$SqlSessionInterceptor.invoke(SqlSessionManager.java:282) at com.sun.proxy.$Proxy7.selectList(Unknown Source) at org.apache.ibatis.session.SqlSessionManager.selectList(SqlSessionManager.java:171) at com.mirth.connect.server.controllers.DonkeyMessageController.searchText(DonkeyMessageController.java:1075) at com.mirth.connect.server.controllers.DonkeyMessageController.searchAll(DonkeyMessageController.java:880) at com.mirth.connect.server.controllers.DonkeyMessageController.searchMessages(DonkeyMessageController.java:649) at com.mirth.connect.server.controllers.DonkeyMessageController.getMessages(DonkeyMessageController.java:192) at com.mirth.connect.server.servlets.MessageObjectServlet.doPost(MessageObjectServlet.java:97) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:652) at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:447) at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:225) at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1038) at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:374) at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:189) at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:972) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:135) at org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:52) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116) at org.eclipse.jetty.server.Server.handle(Server.java:363) at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:483) at org.eclipse.jetty.server.AbstractHttpConnection.content(AbstractHttpConnection.java:931) at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.content(AbstractHttpConnection.java:992) at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:856) at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:240) at org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:82) at org.eclipse.jetty.io.nio.SslConnection.handle(SslConnection.java:196) at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:627) at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:51) at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:608) at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:543) at java.lang.Thread.run(Thread.java:680) Caused by: org.postgresql.util.PSQLException: ERROR: column "SOURCE" does not exist Position: 191 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2101) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1834) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:510) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:386) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:379) at sun.reflect.GeneratedMethodAccessor40.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:58) at com.sun.proxy.$Proxy11.execute(Unknown Source) at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:56) at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:70) at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:57) at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:267) at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:141) at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:105) at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:81) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:101) ... 37 more{code}

    Mirth Project | 3 years ago | Nick Rupley
    org.postgresql.util.PSQLException: ERROR: column "SOURCE" does not exist Position: 191

  1. silex 6 times, last 4 months ago
11 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. org.postgresql.util.PSQLException

    ERROR: syntax error at or near ")" Position: 185

    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse()
  2. PostgreSQL JDBC Driver
    AbstractJdbc2Statement.execute
    1. org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2101)
    2. org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1834)
    3. org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
    4. org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:510)
    5. org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:386)
    6. org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:379)
    6 frames
  3. MyBatis
    DefaultSqlSession.selectList
    1. org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:56)
    2. org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:70)
    3. org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:57)
    4. org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:267)
    5. org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:141)
    6. org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:105)
    7. org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:81)
    8. org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:101)
    9. org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:95)
    9 frames
  4. Java RT
    Method.invoke
    1. sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source)
    2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    3. java.lang.reflect.Method.invoke(Method.java:606)
    3 frames
  5. MyBatis
    SqlSessionManager$SqlSessionInterceptor.invoke
    1. org.apache.ibatis.session.SqlSessionManager$SqlSessionInterceptor.invoke(SqlSessionManager.java:282)
    1 frame
  6. com.sun.proxy
    $Proxy7.selectList
    1. com.sun.proxy.$Proxy7.selectList(Unknown Source)
    1 frame
  7. MyBatis
    SqlSessionManager.selectList
    1. org.apache.ibatis.session.SqlSessionManager.selectList(SqlSessionManager.java:171)
    1 frame
  8. com.mirth.connect
    MessageObjectServlet.doPost
    1. com.mirth.connect.server.controllers.DonkeyMessageController.searchText(DonkeyMessageController.java:1065)
    2. com.mirth.connect.server.controllers.DonkeyMessageController.searchAll(DonkeyMessageController.java:872)
    3. com.mirth.connect.server.controllers.DonkeyMessageController.searchMessages(DonkeyMessageController.java:641)
    4. com.mirth.connect.server.controllers.DonkeyMessageController.getMessages(DonkeyMessageController.java:192)
    5. com.mirth.connect.server.servlets.MessageObjectServlet.doPost(MessageObjectServlet.java:97)
    5 frames
  9. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
    2. javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
    2 frames
  10. Jetty
    AsyncHttpConnection.handle
    1. org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:652)
    2. org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:447)
    3. org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:225)
    4. org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1038)
    5. org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:374)
    6. org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:189)
    7. org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:972)
    8. org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:135)
    9. org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:52)
    10. org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116)
    11. org.eclipse.jetty.server.Server.handle(Server.java:363)
    12. org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:483)
    13. org.eclipse.jetty.server.AbstractHttpConnection.content(AbstractHttpConnection.java:931)
    14. org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.content(AbstractHttpConnection.java:992)
    15. org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:856)
    16. org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:240)
    17. org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:82)
    17 frames
  11. GWT dev
    SelectChannelEndPoint$1.run
    1. org.eclipse.jetty.io.nio.SslConnection.handle(SslConnection.java:196)
    2. org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:627)
    3. org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:51)
    3 frames
  12. Jetty
    QueuedThreadPool$3.run
    1. org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:608)
    2. org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:543)
    2 frames
  13. Java RT
    Thread.run
    1. java.lang.Thread.run(Thread.java:744)
    1 frame