org.postgresql.util.PSQLException: ERROR: column "SOURCE" does not exist Position: 191

Mirth Project | Nick Rupley | 3 years ago
  1. 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
  2. 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
  3. 0

    Problem of case with "PUBLIC" schema in PostGIS

    GitHub | 3 years ago | gpetit
    org.postgresql.util.PSQLException: ERREUR: la table « test » n'existe pas
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    PrecomputedTableManager fails with SimpleObjects

    GitHub | 2 years ago | rnsmith
    org.postgresql.util.PSQLException: ERROR: column "orderbyfield0, orderbyfield0, a1_peptideAlleles, a1_polyphenPre" does not exist
  6. 0

    Can't start ActiveMQ 5.4.2 with PostgreSQL 8.4 as persistence backend

    activemq-users | 6 years ago | Stanislaw Kogut
    org.postgresql.util.PSQLException: ERROR: syntax error at or near "PRIMARY" Position: 32

  1. silex 16 times, last 3 weeks ago
  2. silex 1 times, last 5 months ago
10 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: column "SOURCE" does not exist Position: 191

    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. Java RT
    Method.invoke
    1. sun.reflect.GeneratedMethodAccessor40.invoke(Unknown Source)
    2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    3. java.lang.reflect.Method.invoke(Method.java:597)
    3 frames
  4. MyBatis
    PreparedStatementLogger.invoke
    1. org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:58)
    1 frame
  5. com.sun.proxy
    $Proxy11.execute
    1. com.sun.proxy.$Proxy11.execute(Unknown Source)
    1 frame
  6. 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
  7. Java RT
    Method.invoke
    1. sun.reflect.GeneratedMethodAccessor8.invoke(Unknown Source)
    2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    3. java.lang.reflect.Method.invoke(Method.java:597)
    3 frames
  8. MyBatis
    SqlSessionManager$SqlSessionInterceptor.invoke
    1. org.apache.ibatis.session.SqlSessionManager$SqlSessionInterceptor.invoke(SqlSessionManager.java:282)
    1 frame
  9. com.sun.proxy
    $Proxy7.selectList
    1. com.sun.proxy.$Proxy7.selectList(Unknown Source)
    1 frame
  10. MyBatis
    SqlSessionManager.selectList
    1. org.apache.ibatis.session.SqlSessionManager.selectList(SqlSessionManager.java:171)
    1 frame
  11. com.mirth.connect
    MessageObjectServlet.doPost
    1. com.mirth.connect.server.controllers.DonkeyMessageController.searchText(DonkeyMessageController.java:1075)
    2. com.mirth.connect.server.controllers.DonkeyMessageController.searchAll(DonkeyMessageController.java:880)
    3. com.mirth.connect.server.controllers.DonkeyMessageController.searchMessages(DonkeyMessageController.java:649)
    4. com.mirth.connect.server.controllers.DonkeyMessageController.getMessages(DonkeyMessageController.java:192)
    5. com.mirth.connect.server.servlets.MessageObjectServlet.doPost(MessageObjectServlet.java:97)
    5 frames
  12. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
    2. javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
    2 frames
  13. 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
  14. 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
  15. 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
  16. Java RT
    Thread.run
    1. java.lang.Thread.run(Thread.java:680)
    1 frame