Hello,

Another error... how can i solve this?

An unexpected error occurred
ExecutingSelector; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: ERROR: relation "exp.ObjectPropertiesView" does not exist Position: 714

org.springframework.jdbc.BadSqlGrammarException: ExecutingSelector; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: ERROR: relation "exp.ObjectPropertiesView" does not exist
Position: 714
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:231)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)
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.SqlExecutingSelector$ExecutingResultSetFactory.handleSqlException(SqlExecutingSelector.java:450)
at org.labkey.api.data.BaseSelector.handleResultSet(BaseSelector.java:280)
at org.labkey.api.data.BaseSelector.getArrayList(BaseSelector.java:102)
at org.labkey.api.data.BaseSelector.getArrayList(BaseSelector.java:97)
at org.labkey.api.exp.OntologyManager.getPropertyObjects(OntologyManager.java:609)
at org.labkey.api.reports.model.ReportPropsManager.getPropertyValue(ReportPropsManager.java:175)
at org.labkey.api.reports.model.ReportPropsManager.getProperties(ReportPropsManager.java:243)
at org.labkey.api.reports.report.ReportDescriptor.initProperties(ReportDescriptor.java:382)
at org.labkey.query.reports.ReportServiceImpl._getInstance(ReportServiceImpl.java:436)
at org.labkey.query.reports.DatabaseReportCache$ReportCollections.lambda$new$0(DatabaseReportCache.java:63)
at org.labkey.api.data.BaseSelector.lambda$forEach$3(BaseSelector.java:314)
at org.labkey.api.data.BaseSelector.lambda$forEachMap$1(BaseSelector.java:232)
at org.labkey.api.data.BaseSelector.handleResultSet(BaseSelector.java:263)
at org.labkey.api.data.BaseSelector.forEachMap(BaseSelector.java:226)
at org.labkey.api.data.BaseSelector.forEach(BaseSelector.java:316)
at org.labkey.api.data.BaseSelector.forEach(BaseSelector.java:295)
at org.labkey.query.reports.DatabaseReportCache$ReportCollections.<init>(DatabaseReportCache.java:62)
at org.labkey.query.reports.DatabaseReportCache$ReportCollections.<init>(DatabaseReportCache.java:47)
at org.labkey.query.reports.DatabaseReportCache.lambda$static$0(DatabaseReportCache.java:45)
at org.labkey.api.cache.BlockingCache.get(BlockingCache.java:144)
at org.labkey.api.cache.BlockingCache.get(BlockingCache.java:81)
at org.labkey.api.cache.BlockingCache.get(BlockingCache.java:203)
at org.labkey.query.reports.DatabaseReportCache.getReportsByReportKey(DatabaseReportCache.java:122)
at org.labkey.query.reports.ReportServiceImpl.getReports(ReportServiceImpl.java:551)
at org.labkey.api.reports.report.view.ReportUtil.getReportsIncludingInherited(ReportUtil.java:330)
at org.labkey.api.query.QueryView.addReportViews(QueryView.java:1650)
at org.labkey.api.query.QueryView.createReportButton(QueryView.java:1386)
at org.labkey.study.assay.query.AssayListPortalView.populateButtonBar(AssayListPortalView.java:59)
at org.labkey.api.query.QueryView.setupDataView(QueryView.java:2002)
at org.labkey.api.query.QueryView.createDataView(QueryView.java:1990)
at org.labkey.study.assay.query.AssayListQueryView.createDataView(AssayListQueryView.java:95)
at org.labkey.study.assay.query.AssayListPortalView.createDataView(AssayListPortalView.java:51)
at org.labkey.api.query.QueryView.renderDataRegion(QueryView.java:2101)
at org.labkey.api.query.QueryView.renderView(QueryView.java:1854)
at org.labkey.api.view.WebPartView.renderInternal(WebPartView.java:370)
at org.labkey.api.view.HttpView.render(HttpView.java:136)
at org.labkey.api.view.HttpView.render(HttpView.java:121)
at org.labkey.api.view.HttpView.include(HttpView.java:516)
at org.labkey.api.view.HttpView.include(HttpView.java:493)
at org.labkey.api.view.HttpView.include(HttpView.java:481)
at org.labkey.api.view.VBox.renderView(VBox.java:80)
at org.labkey.api.view.WebPartView.renderInternal(WebPartView.java:370)
at org.labkey.api.view.HttpView.render(HttpView.java:136)
at org.labkey.api.view.HttpView.render(HttpView.java:121)
at org.labkey.api.view.HttpView.include(HttpView.java:516)
at org.labkey.api.view.HttpView.include(HttpView.java:493)
at org.labkey.api.view.HttpView.include(HttpView.java:481)
at org.labkey.api.view.VBox.renderView(VBox.java:80)
at org.labkey.api.view.WebPartView.renderInternal(WebPartView.java:370)
at org.labkey.api.view.HttpView.render(HttpView.java:136)
at org.labkey.api.view.HttpView.render(HttpView.java:121)
at org.labkey.api.view.HttpView.include(HttpView.java:516)
at org.labkey.api.view.HttpView.include(HttpView.java:493)
at org.labkey.jsp.compiled.org.labkey.api.view.template.HomeTemplate_jsp._jspService(HomeTemplate_jsp.java:224)
at org.labkey.api.view.JspView.renderView(JspView.java:168)
at org.labkey.api.view.WebPartView.renderInternal(WebPartView.java:370)
at org.labkey.api.view.HttpView.render(HttpView.java:136)
at org.labkey.api.view.HttpView.render(HttpView.java:121)
at org.labkey.api.action.SpringActionController.renderInTemplate(SpringActionController.java:528)
at org.labkey.api.action.SpringActionController.handleRequest(SpringActionController.java:423)
at org.labkey.api.module.DefaultModule.dispatch(DefaultModule.java:1208)
at org.labkey.api.view.ViewServlet._service(ViewServlet.java:190)
at org.labkey.api.view.ViewServlet.service(ViewServlet.java:124)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:292)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
at org.labkey.api.data.TransactionFilter.doFilter(TransactionFilter.java:38)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
at org.labkey.core.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:118)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
at org.labkey.api.module.ModuleLoader.doFilter(ModuleLoader.java:1144)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
at org.labkey.api.security.AuthFilter.doFilter(AuthFilter.java:206)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:616)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:528)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1100)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:687)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1520)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1476)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:745)
Caused by: org.postgresql.util.PSQLException: ERROR: relation "exp.ObjectPropertiesView" does not exist
Position: 714
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2453)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2153)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:286)
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:432)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:358)
at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:171)
at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:119)
at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:82)
at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:82)
at org.labkey.api.data.dialect.StatementWrapper.executeQuery(StatementWrapper.java:1157)
at org.labkey.api.data.SqlExecutingSelector$ExecutingResultSetFactory.executeQuery(SqlExecutingSelector.java:391)
at org.labkey.api.data.SqlExecutingSelector$ExecutingResultSetFactory.getResultSet(SqlExecutingSelector.java:331)
at org.labkey.api.data.BaseSelector.handleResultSet(BaseSelector.java:261)
... 95 more
DialectSQL = SELECT *
FROM (
SELECT
ObjectPropertiesView.ObjectId AS ObjectId,
ObjectPropertiesView.Container AS Container,
ObjectPropertiesView.ObjectURI AS ObjectURI,
ObjectPropertiesView.OwnerObjectId AS OwnerObjectId,
ObjectPropertiesView.name AS name,
ObjectPropertiesView.PropertyURI AS PropertyURI,
ObjectPropertiesView.RangeURI AS RangeURI,
ObjectPropertiesView.TypeTag AS TypeTag,
ObjectPropertiesView.FloatValue AS FloatValue,
ObjectPropertiesView.StringValue AS StringValue,
ObjectPropertiesView.DatetimeValue AS DatetimeValue,
ObjectPropertiesView.MvIndicator AS MvIndicator,
ObjectPropertiesView.PropertyId AS PropertyId,
ObjectPropertiesView.ConceptURI AS ConceptURI,
ObjectPropertiesView.Format AS Format
FROM exp."ObjectPropertiesView" ObjectPropertiesView ) x
WHERE (ObjectURI = ?) AND (Container = ?)

...