Skip to content

Instantly share code, notes, and snippets.

@pescobar
Created January 27, 2016 17:22
Show Gist options
  • Select an option

  • Save pescobar/d8ed83836a5bb2967d30 to your computer and use it in GitHub Desktop.

Select an option

Save pescobar/d8ed83836a5bb2967d30 to your computer and use it in GitHub Desktop.
labkey error
org.springframework.jdbc.BadSqlGrammarException: SqlExecutor.execute(); bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: ERROR: column "domainid" does not exist
Position: 52
at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:97)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
at org.labkey.api.data.ExceptionFramework$1.translate(ExceptionFramework.java:37)
at org.labkey.api.data.ExceptionFramework$1.translate(ExceptionFramework.java:31)
at org.labkey.api.data.SqlExecutor.execute(SqlExecutor.java:104)
at org.labkey.api.data.SqlExecutor.execute(SqlExecutor.java:73)
at org.labkey.api.data.SqlExecutor.execute(SqlExecutor.java:68)
at org.labkey.api.exp.OntologyManager$7.exec(OntologyManager.java:3642)
at org.labkey.api.exp.OntologyManager$7.exec(OntologyManager.java:3636)
at org.labkey.api.data.BaseSelector$2.handle(BaseSelector.java:205)
at org.labkey.api.data.BaseSelector.handleResultSet(BaseSelector.java:256)
at org.labkey.api.data.BaseSelector.forEach(BaseSelector.java:199)
at org.labkey.api.data.BaseSelector.forEach(BaseSelector.java:194)
at org.labkey.api.exp.OntologyManager.fixProjectColumn(OntologyManager.java:3635)
at org.labkey.api.exp.OntologyManager.access$1000(OntologyManager.java:93)
at org.labkey.api.exp.OntologyManager$6.exec(OntologyManager.java:3597)
at org.labkey.api.exp.OntologyManager$6.exec(OntologyManager.java:3581)
at org.labkey.api.data.BaseSelector$2.handle(BaseSelector.java:205)
at org.labkey.api.data.BaseSelector.handleResultSet(BaseSelector.java:256)
at org.labkey.api.data.BaseSelector.forEach(BaseSelector.java:199)
at org.labkey.api.data.BaseSelector.forEach(BaseSelector.java:194)
at org.labkey.api.exp.OntologyManager.doProjectColumnCheck(OntologyManager.java:3580)
at org.labkey.api.exp.OntologyManager.doProjectColumnCheck(OntologyManager.java:3569)
at org.labkey.core.admin.AdminController$DoCheckAction.getView(AdminController.java:3656)
at org.labkey.core.admin.AdminController$DoCheckAction.getView(AdminController.java:3641)
at org.labkey.api.action.SimpleViewAction.handleRequest(SimpleViewAction.java:80)
at org.labkey.api.action.BaseViewAction.handleRequest(BaseViewAction.java:215)
at org.labkey.api.action.SpringActionController.handleRequest(SpringActionController.java:414)
at org.labkey.api.module.DefaultModule.dispatch(DefaultModule.java:1205)
at org.labkey.api.view.ViewServlet._service(ViewServlet.java:189)
at org.labkey.api.view.ViewServlet.service(ViewServlet.java:123)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.labkey.api.data.TransactionFilter.doFilter(TransactionFilter.java:38)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.labkey.core.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:118)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.labkey.api.module.ModuleLoader.doFilter(ModuleLoader.java:1117)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.labkey.api.security.AuthFilter.doFilter(AuthFilter.java:184)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1040)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:313)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
Caused by: org.postgresql.util.PSQLException: ERROR: column "domainid" does not exist
Position: 52
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2270)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1998)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:570)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:420)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:413)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
at org.labkey.api.data.dialect.StatementWrapper.execute(StatementWrapper.java:1506)
at org.labkey.api.data.SqlExecutor$NormalStatementExecutor.execute(SqlExecutor.java:143)
at org.labkey.api.data.SqlExecutor$NormalStatementExecutor.execute(SqlExecutor.java:119)
at org.labkey.api.data.SqlExecutor.execute(SqlExecutor.java:97)
... 58 more
DialectSQL = UPDATE exp.objectproperty SET DomainID = 305 WHERE DomainID = 254
request attributes
LABKEY.OriginalURL = http://bc2-labkey-dev.bc2.unibas.ch/labkey/admin/doCheck.view?_fix=descriptor
LABKEY.StartTime = 1453915245697
LABKEY.action = doCheck
org.springframework.web.servlet.DispatcherServlet.CONTEXT = Root WebApplicationContext: startup date [Wed Jan 27 17:23:17 CET 2016]; parent: Root WebApplicationContext
LABKEY.controller = admin
LABKEY.Counter = 0
X-LABKEY-CSRF = 65b8c0f1fb87c0a2f18258d326aa8102
LABKEY.container =
LABKEY.RequestURL = /labkey/admin/doCheck.view?_fix=descriptor
LABKEY.OriginalURLHelper = /labkey/admin/doCheck.view?_fix=descriptor
core schema database configuration
Server URL jdbc:postgresql://127.0.0.1/labkey
Product Name PostgreSQL
Product Version 9.2.8
Driver Name PostgreSQL Native Driver
Driver Version PostgreSQL 9.4 JDBC4.1 (build 1201)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment