Skip to content

Instantly share code, notes, and snippets.

@pescobar
Created January 27, 2016 17:22
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
Star You must be signed in to star a gist
Embed
What would you like to do?
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