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

Mirth Project | Nick Rupley | 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

    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 | 3 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. Unknown User 4 times, last 3 days ago
  2. silex 6 times, last 5 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: 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