topic Activiti Explorer with sql server in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/activiti-explorer-with-sql-server/m-p/243152#M196282 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>I tried to configure activiti explorer with mssql. Which is throwing following exception on server start up.</SPAN><BR /><BR /><SPAN>springframework.beans.factory.BeanCreationException: Error creating bean with name 'processEngine': FactoryBean threw exception on object creation; nested exception is org.apache.ibatis.exceptions.PersistenceException: </SPAN><BR /><SPAN>### Error querying database.&nbsp; Cause: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'ACT_GE_PROPERTY'.</SPAN><BR /><SPAN>### The error may exist in org/activiti/db/mapping/entity/Property.xml</SPAN><BR /><SPAN>### The error may involve defaultParameterMap</SPAN><BR /><SPAN>### The error occurred while setting parameters</SPAN><BR /><SPAN>### SQL: select VALUE_ from ACT_GE_PROPERTY where NAME_ = 'schema.version'</SPAN><BR /><SPAN>### Cause: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'ACT_GE_PROPERTY'.</SPAN><BR /><BR /><BR /><SPAN>Tables are not getting created in activiti database.</SPAN><BR /><BR /><SPAN>I did following things to configure mssql with activiti explorer</SPAN><BR /><SPAN>1. Add driver 'sqljdbc4-3.0.0.jar' to 'activiti-explorer/WEB-INF/lib' </SPAN><BR /><SPAN>2. Modified db.properties (Please find attached)</SPAN><BR /><SPAN>3. Modified activiti-custom-context.xml (Please find attached)</SPAN><BR /><BR /><SPAN>Please find 'catalina.out' attached for detailed logs</SPAN><BR /><BR /><SPAN>Thanks</SPAN><BR /></BODY></HTML> Tue, 14 Jun 2016 11:27:13 GMT rutvi 2016-06-14T11:27:13Z Activiti Explorer with sql server https://connect.hyland.com/t5/alfresco-archive/activiti-explorer-with-sql-server/m-p/243152#M196282 Hi,I tried to configure activiti explorer with mssql. Which is throwing following exception on server start up.springframework.beans.factory.BeanCreationException: Error creating bean with name 'processEngine': FactoryBean threw exception on object creation; nested exception is org.apache.ibatis.exc Tue, 14 Jun 2016 11:27:13 GMT https://connect.hyland.com/t5/alfresco-archive/activiti-explorer-with-sql-server/m-p/243152#M196282 rutvi 2016-06-14T11:27:13Z Re: Activiti Explorer with sql server https://connect.hyland.com/t5/alfresco-archive/activiti-explorer-with-sql-server/m-p/243153#M196283 <HTML><HEAD></HEAD><BODY><SPAN>It should create the tables on first bootup. Did you change anything in the process engine config xml? Or the java config? Or just the defaults.</SPAN></BODY></HTML> Mon, 20 Jun 2016 13:00:43 GMT https://connect.hyland.com/t5/alfresco-archive/activiti-explorer-with-sql-server/m-p/243153#M196283 jbarrez 2016-06-20T13:00:43Z