Can't start up alfresco

cancel
Showing results for 
Search instead for 
Did you mean: 
lmtoo
Member II

Can't start up alfresco

I deployed alfresco war(community edition)  to tomcat  and configured alfresco-global.properties in the shared/classes folder , alfresco-global.properties configured a new empty database named "alfresco" , and the app start failed

Caused by: java.sql.SQLSyntaxErrorException: Table 'alfresco.act_ge_property' doesn't exist
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:118)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:95)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:960)
at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:388)
at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:62)
at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:78)
at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:62)
at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:303)
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:154)
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:102)
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:82)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:120)
... 67 more

2 Replies
krutik_jayswal
Senior Member II

Re: Can't start up alfresco

Alfresco is storing data in 2 places.First is alf_data in which physical files are getting store and another is database where the metadata of files are stored.

When cleaning up, You need to clean both things, otherwise there will be mismatch in physical files and its metadata and the server will crash because of that reason.

lmtoo
Member II

Re: Can't start up alfresco

the alf_data is empty ,  it seems activiti schema doesn't init , how to config init activit tables