Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
- Hyland Connect
- Enterprise Platforms
- Alfresco
- Alfresco Archive
- Re: compliments and question
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
compliments and question
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-28-2008 12:12 PM
I really like this software. I have i on centos 5.1 64 bit with postgresql and tomcat 5.5 I am testing community 2.9b and 3.0. I can't locate 2.9c anywhere. I am using it for a secure large file repository. I can upload up to 2GB files in the web client and I can't see a limit on webdav uploads. I tested about 5 GB on webdav and was successful. Once again great software.
Ok on my "main" setup my alf_data is under
/var/lib/alfresco/alf_data
If I want to do multi-tenancy command line to keep customers data separate should I execute this?
create customer1 password /var/lib/alfresco/alf_data/customer1
or
create customer1 password /var/lib/alfresco/alf_data[size=200]_[/size]customer1
Anyone runing multenancy have a suggestion???
Ok on my "main" setup my alf_data is under
/var/lib/alfresco/alf_data
If I want to do multi-tenancy command line to keep customers data separate should I execute this?
create customer1 password /var/lib/alfresco/alf_data/customer1
or
create customer1 password /var/lib/alfresco/alf_data[size=200]_[/size]customer1
Anyone runing multenancy have a suggestion???
Labels:
- Labels:
-
Archive
3 REPLIES 3
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-01-2008 02:54 PM
here i try to create the tenant
create company1 password
I get
ava.lang.RuntimeException: Tenant does not exist:
at org.alfresco.repo.tenant.MultiTAdminServiceImpl.getTenant(MultiTAdminServiceImpl.java:584)
at org.alfresco.repo.tenant.MultiTServiceImpl.getTenant(MultiTServiceImpl.java:556)
at org.alfresco.repo.content.TenantRoutingFileContentStore.init(TenantRoutingFileContentStore.java:107)
at org.alfresco.repo.content.TenantRoutingFileContentStore.onEnableTenant(TenantRoutingFileContentStore.java:127)
at org.alfresco.repo.tenant.MultiTAdminServiceImpl$1.doWork(MultiTAdminServiceImpl.java:345)
at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:585)
at org.alfresco.repo.tenant.MultiTAdminServiceImpl.createTenant(MultiTAdminServiceImpl.java:319)
at org.alfresco.repo.tenant.TenantInterpreter.executeCommand(TenantInterpreter.java:221)
at org.alfresco.repo.admin.BaseInterpreter$1$1.execute(BaseInterpreter.java:163)
at org.alfresco.repo.admin.BaseInterpreter$1$1.execute(BaseInterpreter.java:161)
at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:242)
at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:172)
at org.alfresco.repo.admin.BaseInterpreter$1.doWork(BaseInterpreter.java:166)
at org.alfresco.repo.admin.BaseInterpreter$1.doWork(BaseInterpreter.java:157)
at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:585)
at org.alfresco.repo.admin.BaseInterpreter.interpretCommand(BaseInterpreter.java:155)
at org.alfresco.repo.tenant.TenantInterpreter.interpretCommand(TenantInterpreter.java:84)
at org.alfresco.web.bean.repository.tenant.TenantAdminConsoleBean.interpretCommand(TenantAdminConsoleBean.java:190)
at org.alfresco.web.bean.repository.tenant.TenantAdminConsoleBean.submitCommand(TenantAdminConsoleBean.java:166)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.myfaces.el.MethodBindingImpl.invoke(MethodBindingImpl.java:132)
at org.apache.myfaces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:61)
at javax.faces.component.UICommand.broadcast(UICommand.java:109)
at javax.faces.component.UIViewRoot._broadcastForPhase(UIViewRoot.java:97)
at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:171)
at org.apache.myfaces.lifecycle.InvokeApplicationExecutor.execute(InvokeApplicationExecutor.java:32)
at org.apache.myfaces.lifecycle.LifecycleImpl.executePhase(LifecycleImpl.java:95)
at org.apache.myfaces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:70)
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:139)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.alfresco.web.app.servlet.AdminAuthenticationFilter.doFilter(AdminAuthenticationFilter.java:80)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.alfresco.web.app.servlet.AuthenticationFilter.doFilter(AuthenticationFilter.java:81)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)
at java.lang.Thread.run(Thread.java:619)
and on catalino.out at the end i get: mysql errors??
[size=85] at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQuery(GeneralStatement.java:205)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:173)
… 12 more
13:49:21,322 ERROR [post.lookup.PostLookup] Exception during select of posts
com.ibatis.common.jdbc.exception.NestedSQLException:
— The error occurred in alfresco/activities/org.hibernate.dialect.MySQLInnoDBDialect/ActivityPost.xml.
— The error occurred while applying a parameter map.
— Check the select.activity.posts.by.status.only-InlineParameterMap.
— Check the statement (query failed).
— Cause: org.postgresql.util.PSQLException: ERROR: relation "alf_activity_post" does not exist
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:185)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList(GeneralStatement.java:123)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:615)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:589)
at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:118)
at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(SqlMapClientImpl.java:95)
at org.alfresco.repo.activities.ibatis.IBatisActivityPostDaoServiceImpl.selectPosts(IBatisActivityPostDaoServiceImpl.java:49)
at org.alfresco.repo.activities.post.lookup.PostLookup.execute(PostLookup.java:115)
at org.alfresco.repo.activities.post.lookup.PostLookupJob.execute(PostLookupJob.java:56)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
Caused by: org.postgresql.util.PSQLException: ERROR: relation "alf_activity_post" does not exist
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:350)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:343)
at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:168)
at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:186)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQuery(GeneralStatement.java:205)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:173)
… 10 more
13:49:36,289 ERROR [post.lookup.PostLookup] Exception during select of posts
com.ibatis.common.jdbc.exception.NestedSQLException:
— The error occurred in alfresco/activities/org.hibernate.dialect.MySQLInnoDBDialect/ActivityPost.xml.
— The error occurred while applying a parameter map.
— Check the select.activity.posts.by.status.only-InlineParameterMap.
— Check the statement (query failed).
— Cause: org.postgresql.util.PSQLException: ERROR: relation "alf_activity_post" does not exist
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:185)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList(GeneralStatement.java:123)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:615)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:589)
at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:118)
at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(SqlMapClientImpl.java:95)
at org.alfresco.repo.activities.ibatis.IBatisActivityPostDaoServiceImpl.selectPosts(IBatisActivityPostDaoServiceImpl.java:49)
at org.alfresco.repo.activities.post.lookup.PostLookup.execute(PostLookup.java:115)
at org.alfresco.repo.activities.post.lookup.PostLookupJob.execute(PostLookupJob.java:56)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
Caused by: org.postgresql.util.PSQLException: ERROR: relation "alf_activity_post" does not exist
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:350)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:343)
at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:168)
at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:186)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQuery(GeneralStatement.java:205)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:173)
… 10 more
13:49:51,322 ERROR [post.lookup.PostLookup] Exception during select of posts
com.ibatis.common.jdbc.exception.NestedSQLException:
— The error occurred in alfresco/activities/org.hibernate.dialect.MySQLInnoDBDialect/ActivityPost.xml.
— The error occurred while applying a parameter map.
— Check the select.activity.posts.by.status.only-InlineParameterMap.
— Check the statement (query failed).
— Cause: org.postgresql.util.PSQLException: ERROR: relation "alf_activity_post" does not exist
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:185)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList(GeneralStatement.java:123)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:615)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:589)
at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:118)
at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(SqlMapClientImpl.java:95)
at org.alfresco.repo.activities.ibatis.IBatisActivityPostDaoServiceImpl.selectPosts(IBatisActivityPostDaoServiceImpl.java:49)
at org.alfresco.repo.activities.post.lookup.PostLookup.execute(PostLookup.java:115)
at org.alfresco.repo.activities.post.lookup.PostLookupJob.execute(PostLookupJob.java:56)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
Caused by: org.postgresql.util.PSQLException: ERROR: relation "alf_activity_post" does not exist
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:350)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:343)
at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:168)
at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:186)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQuery(GeneralStatement.java:205)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:173)
… 10 more
13:49:51,325 ERROR [activities.feed.AbstractFeedGenerator] Exception during generation of feeds
com.ibatis.common.jdbc.exception.NestedSQLException:
— The error occurred in alfresco/activities/org.hibernate.dialect.MySQLInnoDBDialect/ActivityPost.xml.
— The error occurred while applying a parameter map.
— Check the select.activity.post.max.seq-InlineParameterMap.
— Check the statement (query failed).
— Cause: org.postgresql.util.PSQLException: ERROR: relation "alf_activity_post" does not exist
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:185)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForObject(GeneralStatement.java:104)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:566)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:541)
at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(SqlMapSessionImpl.java:106)
at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(SqlMapSessionImpl.java:110)
at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForObject(SqlMapClientImpl.java:87)
at org.alfresco.repo.activities.ibatis.IBatisActivityPostDaoServiceImpl.getMaxActivitySeq(IBatisActivityPostDaoServiceImpl.java:59)
at org.alfresco.repo.activities.feed.local.LocalFeedGenerator.generate(LocalFeedGenerator.java:65)
at org.alfresco.repo.activities.feed.AbstractFeedGenerator.execute(AbstractFeedGenerator.java:134)
at org.alfresco.repo.activities.feed.FeedGeneratorJob.execute(FeedGeneratorJob.java:56)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
Caused by: org.postgresql.util.PSQLException: ERROR: relation "alf_activity_post" does not exist
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:350)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:343)
at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:168)
at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:186)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQuery(GeneralStatement.java:205)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:173)
… 12 more
13:50:06,282 ERROR [post.lookup.PostLookup] Exception during select of posts
com.ibatis.common.jdbc.exception.NestedSQLException:
— The error occurred in alfresco/activities/org.hibernate.dialect.MySQLInnoDBDialect/ActivityPost.xml.
— The error occurred while applying a parameter map.
— Check the select.activity.posts.by.status.only-InlineParameterMap.
— Check the statement (query failed).
— Cause: org.postgresql.util.PSQLException: ERROR: relation "alf_activity_post" does not exist
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:185)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList(GeneralStatement.java:123)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:615)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:589)
at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:118)
at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(SqlMapClientImpl.java:95)
at org.alfresco.repo.activities.ibatis.IBatisActivityPostDaoServiceImpl.selectPosts(IBatisActivityPostDaoServiceImpl.java:49)
at org.alfresco.repo.activities.post.lookup.PostLookup.execute(PostLookup.java:115)
at org.alfresco.repo.activities.post.lookup.PostLookupJob.execute(PostLookupJob.java:56)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
Caused by: org.postgresql.util.PSQLException: ERROR: relation "alf_activity_post" does not exist
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:350)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:343)
at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:168)
at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:186)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQuery(GeneralStatement.java:205)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:173)
… 10 more
13:50:21,278 ERROR [activities.feed.AbstractFeedGenerator] Exception during generation of feeds
com.ibatis.common.jdbc.exception.NestedSQLException:
— The error occurred in alfresco/activities/org.hibernate.dialect.MySQLInnoDBDialect/ActivityPost.xml.
— The error occurred while applying a parameter map.
— Check the select.activity.post.max.seq-InlineParameterMap.
— Check the statement (query failed).
— Cause: org.postgresql.util.PSQLException: ERROR: relation "alf_activity_post" does not exist
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:185)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForObject(GeneralStatement.java:104)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:566)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:541)
at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(SqlMapSessionImpl.java:106)
at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(SqlMapSessionImpl.java:110)
at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForObject(SqlMapClientImpl.java:87)
at org.alfresco.repo.activities.ibatis.IBatisActivityPostDaoServiceImpl.getMaxActivitySeq(IBatisActivityPostDaoServiceImpl.java:59)
at org.alfresco.repo.activities.feed.local.LocalFeedGenerator.generate(LocalFeedGenerator.java:65)
at org.alfresco.repo.activities.feed.AbstractFeedGenerator.execute(AbstractFeedGenerator.java:134)
at org.alfresco.repo.activities.feed.FeedGeneratorJob.execute(FeedGeneratorJob.java:56)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
Caused by: org.postgresql.util.PSQLException: ERROR: relation "alf_activity_post" does not exist
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:350)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:343)
at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:168)
at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:186)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQuery(GeneralStatement.java:205)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:173)
… 12 more
13:50:21,279 ERROR [post.lookup.PostLookup] Exception during select of posts
com.ibatis.common.jdbc.exception.NestedSQLException:
— The error occurred in alfresco/activities/org.hibernate.dialect.MySQLInnoDBDialect/ActivityPost.xml.
— The error occurred while applying a parameter map.
— Check the select.activity.posts.by.status.only-InlineParameterMap.
— Check the statement (query failed).
— Cause: org.postgresql.util.PSQLException: ERROR: relation "alf_activity_post" does not exist
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:185)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList(GeneralStatement.java:123)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:615)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:589)
at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:118)
at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(SqlMapClientImpl.java:95)
at org.alfresco.repo.activities.ibatis.IBatisActivityPostDaoServiceImpl.selectPosts(IBatisActivityPostDaoServiceImpl.java:49)
at org.alfresco.repo.activities.post.lookup.PostLookup.execute(PostLookup.java:115)
at org.alfresco.repo.activities.post.lookup.PostLookupJob.execute(PostLookupJob.java:56)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
Caused by: org.postgresql.util.PSQLException: ERROR: relation "alf_activity_post" does not exist
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:350)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:343)
at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:168)
at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:186)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQuery(GeneralStatement.java:205)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:173)
… 10 more
13:50:36,287 ERROR [post.lookup.PostLookup] Exception during select of posts
com.ibatis.common.jdbc.exception.NestedSQLException:
— The error occurred in alfresco/activities/org.hibernate.dialect.MySQLInnoDBDialect/ActivityPost.xml.
— The error occurred while applying a parameter map.
— Check the select.activity.posts.by.status.only-InlineParameterMap.
— Check the statement (query failed).
— Cause: org.postgresql.util.PSQLException: ERROR: relation "alf_activity_post" does not exist
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:185)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList(GeneralStatement.java:123)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:615)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:589)
at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:118)
at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(SqlMapClientImpl.java:95)
at org.alfresco.repo.activities.ibatis.IBatisActivityPostDaoServiceImpl.selectPosts(IBatisActivityPostDaoServiceImpl.java:49)
at org.alfresco.repo.activities.post.lookup.PostLookup.execute(PostLookup.java:115)
at org.alfresco.repo.activities.post.lookup.PostLookupJob.execute(PostLookupJob.java:56)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
Caused by: org.postgresql.util.PSQLException: ERROR: relation "alf_activity_post" does not exist
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:350)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:343)
at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:168)
at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:186)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQuery(GeneralStatement.java:205)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:173)
… 10 more[/size]
on alfresco.log i get more mysql errors.
[size=85]13:51:21,288 ERROR [org.alfresco.repo.activities.post.lookup.PostLookup] Exception during select of posts
com.ibatis.common.jdbc.exception.NestedSQLException:
— The error occurred in alfresco/activities/org.hibernate.dialect.MySQLInnoDBDialect/ActivityPost.xml.
— The error occurred while applying a parameter map.
— Check the select.activity.posts.by.status.only-InlineParameterMap.
— Check the statement (query failed).
— Cause: org.postgresql.util.PSQLException: ERROR: relation "alf_activity_post" does not exist
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:185)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList(GeneralStatement.java:123)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:615)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:589)
at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:118)
at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(SqlMapClientImpl.java:95)
at org.alfresco.repo.activities.ibatis.IBatisActivityPostDaoServiceImpl.selectPosts(IBatisActivityPostDaoServiceImpl.java:49)
at org.alfresco.repo.activities.post.lookup.PostLookup.execute(PostLookup.java:115)
at org.alfresco.repo.activities.post.lookup.PostLookupJob.execute(PostLookupJob.java:56)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
Caused by: org.postgresql.util.PSQLException: ERROR: relation "alf_activity_post" does not exist
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:350)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:343)
at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:168)
at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:186)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQuery(GeneralStatement.java:205)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:173)
… 10 more
13:51:21,289 ERROR [org.alfresco.repo.activities.feed.cleanup.FeedCleaner] Exception during cleanup of feeds
com.ibatis.common.jdbc.exception.NestedSQLException:
— The error occurred in alfresco/activities/org.hibernate.dialect.MySQLInnoDBDialect/ActivityFeed.xml.
— The error occurred while applying a parameter map.
— Check the delete.activity.feed.entries.older.than.date-InlineParameterMap.
— Check the statement (update failed).
— Cause: org.postgresql.util.PSQLException: ERROR: relation "alf_activity_feed" does not exist
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeUpdate(GeneralStatement.java:91)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.update(SqlMapExecutorDelegate.java:505)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.delete(SqlMapExecutorDelegate.java:528)
at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.delete(SqlMapSessionImpl.java:98)
at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.delete(SqlMapClientImpl.java:75)
at org.alfresco.repo.activities.ibatis.IBatisActivityFeedDaoServiceImpl.deleteFeedEntries(IBatisActivityFeedDaoServiceImpl.java:44)
at org.alfresco.repo.activities.feed.cleanup.FeedCleaner.execute(FeedCleaner.java:85)
at org.alfresco.repo.activities.feed.cleanup.FeedCleanupJob.execute(FeedCleanupJob.java:56)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
Caused by: org.postgresql.util.PSQLException: ERROR: relation "alf_activity_feed" does not exist
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:350)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:343)
at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:168)
at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeUpdate(SqlExecutor.java:81)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteUpdate(GeneralStatement.java:200)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeUpdate(GeneralStatement.java:78)
… 9 more
13:51:36,287 ERROR [org.alfresco.repo.activities.post.lookup.PostLookup] Exception during select of posts
com.ibatis.common.jdbc.exception.NestedSQLException:
— The error occurred in alfresco/activities/org.hibernate.dialect.MySQLInnoDBDialect/ActivityPost.xml.
— The error occurred while applying a parameter map.
— Check the select.activity.posts.by.status.only-InlineParameterMap.
— Check the statement (query failed).
— Cause: org.postgresql.util.PSQLException: ERROR: relation "alf_activity_post" does not exist
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:185)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList(GeneralStatement.java:123)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:615)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:589)
at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:118)
at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(SqlMapClientImpl.java:95)
at org.alfresco.repo.activities.ibatis.IBatisActivityPostDaoServiceImpl.selectPosts(IBatisActivityPostDaoServiceImpl.java:49)
at org.alfresco.repo.activities.post.lookup.PostLookup.execute(PostLookup.java:115)
at org.alfresco.repo.activities.post.lookup.PostLookupJob.execute(PostLookupJob.java:56)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
Caused by: org.postgresql.util.PSQLException: ERROR: relation "alf_activity_post" does not exist
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:350)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:343)
at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:168)
at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:186)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQuery(GeneralStatement.java:205)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:173)
… 10 more[/size]
Do i need to comment out mysql org.hibernate.dialect.MySQLInnoDBDialect somewhere???
create company1 password
I get
ava.lang.RuntimeException: Tenant does not exist:
at org.alfresco.repo.tenant.MultiTAdminServiceImpl.getTenant(MultiTAdminServiceImpl.java:584)
at org.alfresco.repo.tenant.MultiTServiceImpl.getTenant(MultiTServiceImpl.java:556)
at org.alfresco.repo.content.TenantRoutingFileContentStore.init(TenantRoutingFileContentStore.java:107)
at org.alfresco.repo.content.TenantRoutingFileContentStore.onEnableTenant(TenantRoutingFileContentStore.java:127)
at org.alfresco.repo.tenant.MultiTAdminServiceImpl$1.doWork(MultiTAdminServiceImpl.java:345)
at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:585)
at org.alfresco.repo.tenant.MultiTAdminServiceImpl.createTenant(MultiTAdminServiceImpl.java:319)
at org.alfresco.repo.tenant.TenantInterpreter.executeCommand(TenantInterpreter.java:221)
at org.alfresco.repo.admin.BaseInterpreter$1$1.execute(BaseInterpreter.java:163)
at org.alfresco.repo.admin.BaseInterpreter$1$1.execute(BaseInterpreter.java:161)
at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:242)
at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:172)
at org.alfresco.repo.admin.BaseInterpreter$1.doWork(BaseInterpreter.java:166)
at org.alfresco.repo.admin.BaseInterpreter$1.doWork(BaseInterpreter.java:157)
at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:585)
at org.alfresco.repo.admin.BaseInterpreter.interpretCommand(BaseInterpreter.java:155)
at org.alfresco.repo.tenant.TenantInterpreter.interpretCommand(TenantInterpreter.java:84)
at org.alfresco.web.bean.repository.tenant.TenantAdminConsoleBean.interpretCommand(TenantAdminConsoleBean.java:190)
at org.alfresco.web.bean.repository.tenant.TenantAdminConsoleBean.submitCommand(TenantAdminConsoleBean.java:166)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.myfaces.el.MethodBindingImpl.invoke(MethodBindingImpl.java:132)
at org.apache.myfaces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:61)
at javax.faces.component.UICommand.broadcast(UICommand.java:109)
at javax.faces.component.UIViewRoot._broadcastForPhase(UIViewRoot.java:97)
at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:171)
at org.apache.myfaces.lifecycle.InvokeApplicationExecutor.execute(InvokeApplicationExecutor.java:32)
at org.apache.myfaces.lifecycle.LifecycleImpl.executePhase(LifecycleImpl.java:95)
at org.apache.myfaces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:70)
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:139)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.alfresco.web.app.servlet.AdminAuthenticationFilter.doFilter(AdminAuthenticationFilter.java:80)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.alfresco.web.app.servlet.AuthenticationFilter.doFilter(AuthenticationFilter.java:81)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)
at java.lang.Thread.run(Thread.java:619)
and on catalino.out at the end i get: mysql errors??
[size=85] at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQuery(GeneralStatement.java:205)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:173)
… 12 more
13:49:21,322 ERROR [post.lookup.PostLookup] Exception during select of posts
com.ibatis.common.jdbc.exception.NestedSQLException:
— The error occurred in alfresco/activities/org.hibernate.dialect.MySQLInnoDBDialect/ActivityPost.xml.
— The error occurred while applying a parameter map.
— Check the select.activity.posts.by.status.only-InlineParameterMap.
— Check the statement (query failed).
— Cause: org.postgresql.util.PSQLException: ERROR: relation "alf_activity_post" does not exist
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:185)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList(GeneralStatement.java:123)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:615)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:589)
at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:118)
at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(SqlMapClientImpl.java:95)
at org.alfresco.repo.activities.ibatis.IBatisActivityPostDaoServiceImpl.selectPosts(IBatisActivityPostDaoServiceImpl.java:49)
at org.alfresco.repo.activities.post.lookup.PostLookup.execute(PostLookup.java:115)
at org.alfresco.repo.activities.post.lookup.PostLookupJob.execute(PostLookupJob.java:56)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
Caused by: org.postgresql.util.PSQLException: ERROR: relation "alf_activity_post" does not exist
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:350)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:343)
at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:168)
at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:186)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQuery(GeneralStatement.java:205)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:173)
… 10 more
13:49:36,289 ERROR [post.lookup.PostLookup] Exception during select of posts
com.ibatis.common.jdbc.exception.NestedSQLException:
— The error occurred in alfresco/activities/org.hibernate.dialect.MySQLInnoDBDialect/ActivityPost.xml.
— The error occurred while applying a parameter map.
— Check the select.activity.posts.by.status.only-InlineParameterMap.
— Check the statement (query failed).
— Cause: org.postgresql.util.PSQLException: ERROR: relation "alf_activity_post" does not exist
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:185)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList(GeneralStatement.java:123)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:615)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:589)
at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:118)
at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(SqlMapClientImpl.java:95)
at org.alfresco.repo.activities.ibatis.IBatisActivityPostDaoServiceImpl.selectPosts(IBatisActivityPostDaoServiceImpl.java:49)
at org.alfresco.repo.activities.post.lookup.PostLookup.execute(PostLookup.java:115)
at org.alfresco.repo.activities.post.lookup.PostLookupJob.execute(PostLookupJob.java:56)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
Caused by: org.postgresql.util.PSQLException: ERROR: relation "alf_activity_post" does not exist
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:350)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:343)
at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:168)
at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:186)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQuery(GeneralStatement.java:205)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:173)
… 10 more
13:49:51,322 ERROR [post.lookup.PostLookup] Exception during select of posts
com.ibatis.common.jdbc.exception.NestedSQLException:
— The error occurred in alfresco/activities/org.hibernate.dialect.MySQLInnoDBDialect/ActivityPost.xml.
— The error occurred while applying a parameter map.
— Check the select.activity.posts.by.status.only-InlineParameterMap.
— Check the statement (query failed).
— Cause: org.postgresql.util.PSQLException: ERROR: relation "alf_activity_post" does not exist
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:185)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList(GeneralStatement.java:123)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:615)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:589)
at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:118)
at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(SqlMapClientImpl.java:95)
at org.alfresco.repo.activities.ibatis.IBatisActivityPostDaoServiceImpl.selectPosts(IBatisActivityPostDaoServiceImpl.java:49)
at org.alfresco.repo.activities.post.lookup.PostLookup.execute(PostLookup.java:115)
at org.alfresco.repo.activities.post.lookup.PostLookupJob.execute(PostLookupJob.java:56)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
Caused by: org.postgresql.util.PSQLException: ERROR: relation "alf_activity_post" does not exist
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:350)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:343)
at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:168)
at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:186)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQuery(GeneralStatement.java:205)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:173)
… 10 more
13:49:51,325 ERROR [activities.feed.AbstractFeedGenerator] Exception during generation of feeds
com.ibatis.common.jdbc.exception.NestedSQLException:
— The error occurred in alfresco/activities/org.hibernate.dialect.MySQLInnoDBDialect/ActivityPost.xml.
— The error occurred while applying a parameter map.
— Check the select.activity.post.max.seq-InlineParameterMap.
— Check the statement (query failed).
— Cause: org.postgresql.util.PSQLException: ERROR: relation "alf_activity_post" does not exist
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:185)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForObject(GeneralStatement.java:104)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:566)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:541)
at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(SqlMapSessionImpl.java:106)
at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(SqlMapSessionImpl.java:110)
at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForObject(SqlMapClientImpl.java:87)
at org.alfresco.repo.activities.ibatis.IBatisActivityPostDaoServiceImpl.getMaxActivitySeq(IBatisActivityPostDaoServiceImpl.java:59)
at org.alfresco.repo.activities.feed.local.LocalFeedGenerator.generate(LocalFeedGenerator.java:65)
at org.alfresco.repo.activities.feed.AbstractFeedGenerator.execute(AbstractFeedGenerator.java:134)
at org.alfresco.repo.activities.feed.FeedGeneratorJob.execute(FeedGeneratorJob.java:56)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
Caused by: org.postgresql.util.PSQLException: ERROR: relation "alf_activity_post" does not exist
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:350)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:343)
at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:168)
at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:186)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQuery(GeneralStatement.java:205)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:173)
… 12 more
13:50:06,282 ERROR [post.lookup.PostLookup] Exception during select of posts
com.ibatis.common.jdbc.exception.NestedSQLException:
— The error occurred in alfresco/activities/org.hibernate.dialect.MySQLInnoDBDialect/ActivityPost.xml.
— The error occurred while applying a parameter map.
— Check the select.activity.posts.by.status.only-InlineParameterMap.
— Check the statement (query failed).
— Cause: org.postgresql.util.PSQLException: ERROR: relation "alf_activity_post" does not exist
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:185)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList(GeneralStatement.java:123)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:615)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:589)
at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:118)
at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(SqlMapClientImpl.java:95)
at org.alfresco.repo.activities.ibatis.IBatisActivityPostDaoServiceImpl.selectPosts(IBatisActivityPostDaoServiceImpl.java:49)
at org.alfresco.repo.activities.post.lookup.PostLookup.execute(PostLookup.java:115)
at org.alfresco.repo.activities.post.lookup.PostLookupJob.execute(PostLookupJob.java:56)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
Caused by: org.postgresql.util.PSQLException: ERROR: relation "alf_activity_post" does not exist
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:350)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:343)
at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:168)
at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:186)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQuery(GeneralStatement.java:205)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:173)
… 10 more
13:50:21,278 ERROR [activities.feed.AbstractFeedGenerator] Exception during generation of feeds
com.ibatis.common.jdbc.exception.NestedSQLException:
— The error occurred in alfresco/activities/org.hibernate.dialect.MySQLInnoDBDialect/ActivityPost.xml.
— The error occurred while applying a parameter map.
— Check the select.activity.post.max.seq-InlineParameterMap.
— Check the statement (query failed).
— Cause: org.postgresql.util.PSQLException: ERROR: relation "alf_activity_post" does not exist
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:185)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForObject(GeneralStatement.java:104)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:566)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:541)
at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(SqlMapSessionImpl.java:106)
at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(SqlMapSessionImpl.java:110)
at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForObject(SqlMapClientImpl.java:87)
at org.alfresco.repo.activities.ibatis.IBatisActivityPostDaoServiceImpl.getMaxActivitySeq(IBatisActivityPostDaoServiceImpl.java:59)
at org.alfresco.repo.activities.feed.local.LocalFeedGenerator.generate(LocalFeedGenerator.java:65)
at org.alfresco.repo.activities.feed.AbstractFeedGenerator.execute(AbstractFeedGenerator.java:134)
at org.alfresco.repo.activities.feed.FeedGeneratorJob.execute(FeedGeneratorJob.java:56)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
Caused by: org.postgresql.util.PSQLException: ERROR: relation "alf_activity_post" does not exist
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:350)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:343)
at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:168)
at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:186)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQuery(GeneralStatement.java:205)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:173)
… 12 more
13:50:21,279 ERROR [post.lookup.PostLookup] Exception during select of posts
com.ibatis.common.jdbc.exception.NestedSQLException:
— The error occurred in alfresco/activities/org.hibernate.dialect.MySQLInnoDBDialect/ActivityPost.xml.
— The error occurred while applying a parameter map.
— Check the select.activity.posts.by.status.only-InlineParameterMap.
— Check the statement (query failed).
— Cause: org.postgresql.util.PSQLException: ERROR: relation "alf_activity_post" does not exist
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:185)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList(GeneralStatement.java:123)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:615)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:589)
at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:118)
at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(SqlMapClientImpl.java:95)
at org.alfresco.repo.activities.ibatis.IBatisActivityPostDaoServiceImpl.selectPosts(IBatisActivityPostDaoServiceImpl.java:49)
at org.alfresco.repo.activities.post.lookup.PostLookup.execute(PostLookup.java:115)
at org.alfresco.repo.activities.post.lookup.PostLookupJob.execute(PostLookupJob.java:56)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
Caused by: org.postgresql.util.PSQLException: ERROR: relation "alf_activity_post" does not exist
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:350)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:343)
at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:168)
at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:186)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQuery(GeneralStatement.java:205)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:173)
… 10 more
13:50:36,287 ERROR [post.lookup.PostLookup] Exception during select of posts
com.ibatis.common.jdbc.exception.NestedSQLException:
— The error occurred in alfresco/activities/org.hibernate.dialect.MySQLInnoDBDialect/ActivityPost.xml.
— The error occurred while applying a parameter map.
— Check the select.activity.posts.by.status.only-InlineParameterMap.
— Check the statement (query failed).
— Cause: org.postgresql.util.PSQLException: ERROR: relation "alf_activity_post" does not exist
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:185)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList(GeneralStatement.java:123)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:615)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:589)
at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:118)
at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(SqlMapClientImpl.java:95)
at org.alfresco.repo.activities.ibatis.IBatisActivityPostDaoServiceImpl.selectPosts(IBatisActivityPostDaoServiceImpl.java:49)
at org.alfresco.repo.activities.post.lookup.PostLookup.execute(PostLookup.java:115)
at org.alfresco.repo.activities.post.lookup.PostLookupJob.execute(PostLookupJob.java:56)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
Caused by: org.postgresql.util.PSQLException: ERROR: relation "alf_activity_post" does not exist
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:350)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:343)
at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:168)
at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:186)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQuery(GeneralStatement.java:205)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:173)
… 10 more[/size]
on alfresco.log i get more mysql errors.
[size=85]13:51:21,288 ERROR [org.alfresco.repo.activities.post.lookup.PostLookup] Exception during select of posts
com.ibatis.common.jdbc.exception.NestedSQLException:
— The error occurred in alfresco/activities/org.hibernate.dialect.MySQLInnoDBDialect/ActivityPost.xml.
— The error occurred while applying a parameter map.
— Check the select.activity.posts.by.status.only-InlineParameterMap.
— Check the statement (query failed).
— Cause: org.postgresql.util.PSQLException: ERROR: relation "alf_activity_post" does not exist
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:185)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList(GeneralStatement.java:123)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:615)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:589)
at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:118)
at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(SqlMapClientImpl.java:95)
at org.alfresco.repo.activities.ibatis.IBatisActivityPostDaoServiceImpl.selectPosts(IBatisActivityPostDaoServiceImpl.java:49)
at org.alfresco.repo.activities.post.lookup.PostLookup.execute(PostLookup.java:115)
at org.alfresco.repo.activities.post.lookup.PostLookupJob.execute(PostLookupJob.java:56)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
Caused by: org.postgresql.util.PSQLException: ERROR: relation "alf_activity_post" does not exist
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:350)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:343)
at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:168)
at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:186)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQuery(GeneralStatement.java:205)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:173)
… 10 more
13:51:21,289 ERROR [org.alfresco.repo.activities.feed.cleanup.FeedCleaner] Exception during cleanup of feeds
com.ibatis.common.jdbc.exception.NestedSQLException:
— The error occurred in alfresco/activities/org.hibernate.dialect.MySQLInnoDBDialect/ActivityFeed.xml.
— The error occurred while applying a parameter map.
— Check the delete.activity.feed.entries.older.than.date-InlineParameterMap.
— Check the statement (update failed).
— Cause: org.postgresql.util.PSQLException: ERROR: relation "alf_activity_feed" does not exist
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeUpdate(GeneralStatement.java:91)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.update(SqlMapExecutorDelegate.java:505)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.delete(SqlMapExecutorDelegate.java:528)
at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.delete(SqlMapSessionImpl.java:98)
at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.delete(SqlMapClientImpl.java:75)
at org.alfresco.repo.activities.ibatis.IBatisActivityFeedDaoServiceImpl.deleteFeedEntries(IBatisActivityFeedDaoServiceImpl.java:44)
at org.alfresco.repo.activities.feed.cleanup.FeedCleaner.execute(FeedCleaner.java:85)
at org.alfresco.repo.activities.feed.cleanup.FeedCleanupJob.execute(FeedCleanupJob.java:56)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
Caused by: org.postgresql.util.PSQLException: ERROR: relation "alf_activity_feed" does not exist
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:350)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:343)
at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:168)
at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeUpdate(SqlExecutor.java:81)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteUpdate(GeneralStatement.java:200)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeUpdate(GeneralStatement.java:78)
… 9 more
13:51:36,287 ERROR [org.alfresco.repo.activities.post.lookup.PostLookup] Exception during select of posts
com.ibatis.common.jdbc.exception.NestedSQLException:
— The error occurred in alfresco/activities/org.hibernate.dialect.MySQLInnoDBDialect/ActivityPost.xml.
— The error occurred while applying a parameter map.
— Check the select.activity.posts.by.status.only-InlineParameterMap.
— Check the statement (query failed).
— Cause: org.postgresql.util.PSQLException: ERROR: relation "alf_activity_post" does not exist
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:185)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList(GeneralStatement.java:123)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:615)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:589)
at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:118)
at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(SqlMapClientImpl.java:95)
at org.alfresco.repo.activities.ibatis.IBatisActivityPostDaoServiceImpl.selectPosts(IBatisActivityPostDaoServiceImpl.java:49)
at org.alfresco.repo.activities.post.lookup.PostLookup.execute(PostLookup.java:115)
at org.alfresco.repo.activities.post.lookup.PostLookupJob.execute(PostLookupJob.java:56)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
Caused by: org.postgresql.util.PSQLException: ERROR: relation "alf_activity_post" does not exist
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:350)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:343)
at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:168)
at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:186)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQuery(GeneralStatement.java:205)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:173)
… 10 more[/size]
Do i need to comment out mysql org.hibernate.dialect.MySQLInnoDBDialect somewhere???
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-02-2008 10:13 AM
Thanks for the feedback. The two issues are unrelated.
1. The first issue is probably due to an unintentional merge bug (https://issues.alfresco.com/browse/ETWONINE-1). If you still wish to experiment with multi-tenancy then one option is to download the Alfresco 2.9 Labs release (http://sourceforge.net/project/showfiles.php?group_id=143373&package_id=157460&release_id=555679) until this fix gets merged to HEAD.
2. The second issue is caused by the fact that the new activity service (being introduced in 3.0-dev) does not yet include support for PostgreSQL dialect (https://issues.alfresco.com/browse/SLNG-278). For the time being, you can safely ignore these errors or (as a workaround) you can try disabling the background jobs. eg. add file: …/tomcat/shared/classes/alfresco/extension/custom-scheduled-action-services-context.xml
Jan
1. The first issue is probably due to an unintentional merge bug (https://issues.alfresco.com/browse/ETWONINE-1). If you still wish to experiment with multi-tenancy then one option is to download the Alfresco 2.9 Labs release (http://sourceforge.net/project/showfiles.php?group_id=143373&package_id=157460&release_id=555679) until this fix gets merged to HEAD.
2. The second issue is caused by the fact that the new activity service (being introduced in 3.0-dev) does not yet include support for PostgreSQL dialect (https://issues.alfresco.com/browse/SLNG-278). For the time being, you can safely ignore these errors or (as a workaround) you can try disabling the background jobs. eg. add file: …/tomcat/shared/classes/alfresco/extension/custom-scheduled-action-services-context.xml
<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE beans PUBLIC '-//SPRING//DTD BEAN//EN' 'http://www.springframework.org/dtd/spring-beans.dtd'>
<beans>
<!– TEMP (http://forums.alfresco.com/en/viewtopic.php?f=9&t=13093&p=43250) –>
<bean id="feedCleanerJobDetail" class="org.springframework.scheduling.quartz.JobDetailBean">
<property name="jobClass">
<value>org.alfresco.repo.activities.feed.cleanup.FeedCleanupJob</value>
</property>
<property name="jobDataAsMap">
<map>
<entry key="feedCleaner">
<ref bean="feedCleaner" />
</entry>
</map>
</property>
</bean>
<bean id="feedCleanerTrigger" class="org.alfresco.util.TriggerBean">
<property name="jobDetail">
<ref bean="feedCleanerJobDetail" />
</property>
</bean>
<bean id="feedGeneratorJobDetail" class="org.springframework.scheduling.quartz.JobDetailBean">
<property name="jobClass">
<value>org.alfresco.repo.activities.feed.FeedGeneratorJob</value>
</property>
<property name="jobDataAsMap">
<map>
<entry key="feedGenerator">
<ref bean="feedGenerator" />
</entry>
</map>
</property>
</bean>
<bean id="feedGeneratorTrigger" class="org.alfresco.util.TriggerBean">
<property name="jobDetail">
<ref bean="feedGeneratorJobDetail" />
</property>
</bean>
<bean id="postLookupJobDetail" class="org.springframework.scheduling.quartz.JobDetailBean">
<property name="jobClass">
<value>org.alfresco.repo.activities.post.lookup.PostLookupJob</value>
</property>
<property name="jobDataAsMap">
<map>
<entry key="postLookup">
<ref bean="postLookup" />
</entry>
</map>
</property>
</bean>
<bean id="postLookupTrigger" class="org.alfresco.util.TriggerBean">
<property name="jobDetail">
<ref bean="postLookupJobDetail" />
</property>
</bean>
<bean id="postCleanerJobDetail" class="org.springframework.scheduling.quartz.JobDetailBean">
<property name="jobClass">
<value>org.alfresco.repo.activities.post.cleanup.PostCleanupJob</value>
</property>
<property name="jobDataAsMap">
<map>
<entry key="postCleaner">
<ref bean="postCleaner" />
</entry>
</map>
</property>
</bean>
<bean id="postCleanerTrigger" class="org.alfresco.util.TriggerBean">
<property name="jobDetail">
<ref bean="postCleanerJobDetail" />
</property>
</bean>
</beans>
Jan
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-07-2008 01:39 PM
Thanks, that fixed the Multitenancy error going to 2.9 dev version.
Related Content
- Elasticsearch Frequently Asked Question in Alfresco Blog
- Any Google Professional Machine Learning Engineer Exam Questions or Practice Tests 2024? in Alfresco Forum
- Seamless transition to a better experience: Site freeze on 25 September 2024 in Alfresco Blog
- Upgrade pdfjs APS 2.4.12 in Alfresco Forum
- Configuring AOS to not use basic authentication in Alfresco Forum
Getting started
Tags
Find what you came for
We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.
