/gist:d8ed83836a5bb2967d30 Secret
Created
January 27, 2016 17:22
Star
You must be signed in to star a gist
labkey error
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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