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


Samebug tips

Try downgrading PostgresSQL server to 9.5 or update your PostgresSQL driver to 9.4-1211 with the following command: <postgresql.version>9.4.1211</postgresql.version>


7 months ago
Expert tip

Solutions on the web

Solution icon of mirthcorp
via Mirth Project by Nick Rupley, 1 year ago
ERROR: column "SOURCE" does not exist Position: 191

Solution icon of mirthcorp
via Mirth Project by Nick Rupley, 1 year ago
ERROR: column "SOURCE" does not exist Position: 191

Solution icon of mirthcorp
via Mirth Project by Alex Aitougan, 1 year ago
ERROR: syntax error at or near ")" Position: 185

Solution icon of mirthcorp
via Mirth Project by Alex Aitougan, 1 year ago
ERROR: syntax error at or near ")" Position: 185

Solution icon of forgerock
via ForgeRock JIRA by laurent.bristiel, 1 year ago
ERROR: relation "act_re_deployment" does not exist Position: 15

Solution icon of googlegroups
via Google Groups by YamilBracho, 1 year ago
ERROR: operator does not exist: character varying # Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts. Position: 1072

Solution icon of googlegroups
via Google Groups by Gareth, 3 months ago
ERROR: null value in column "name_" violates not-null constraint Detail: Failing row contains (96820ec1-091f-11e5-9d51-8e6e89fb4748, 1, null, null, 96820ec0-091f-11e5-9d51-8e6e89fb4748, 96820ec0-091f-11e5-9d51-8e6e89fb4748, null, null, null, null, null, null, null, null, 96820ec0-091f-11e5-9d51-8e6e89fb4748).

Solution icon of googlegroups
via Google Groups by cweber, 2 months ago
FEHLER: Relation „act_ge_property“ existiert nicht Position: 20

Solution icon of web
via activiti.org by Unknown author, 1 year ago
FEHLER: Relation »act_ru_job« existiert nicht Position: 20

Solution icon of web
via activiti.org by Unknown author, 1 year ago
FEHLER: Relation »act_ru_job« existiert nicht Position: 20

Stack trace

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

Write tip

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 1 year ago
9 times, 4 months ago
Samebug visitor profile picture
Unknown user
Once, 7 months ago
6 times, 10 months ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
97 more bugmates