AnsweredAssumed Answered

Error installing MSSQL database - 5.3

Question asked by jchildress on Mar 5, 2011
Latest reply on Mar 2, 2016 by delamotte
Running "setup.install" with a new copy of 5.3 on MSSQL Server 2008 R2.

Has anyone got 5.3 working with MSSQL?  I plan on just editing the SQL and re-running , but thought I'd go ahead and post here in case others had a similar error.

I get the following error message:

deploy:
     [copy] Copying 1 file to C:\lib\activiti-5.3\apps\apache-tomcat-6.0.32\webapps\activiti-rest\WEB-INF\lib
[deploy-bar] Initializing process engine default
[deploy-bar] Mar 5, 2011 8:16:44 AM org.activiti.engine.ProcessEngines initProcessEnginFromResource
[deploy-bar] INFO: initializing process engine for resource file:/C:/lib/activiti-5.3/workspace/activiti-engine-examples/src/main/config/activiti.cfg.xml
[deploy-bar] Mar 5, 2011 8:16:44 AM org.springframework.beans.factory.xml.XmlBeanDefinitionReader loadBeanDefinitions
[deploy-bar] INFO: Loading XML bean definitions from resource loaded through InputStream
[deploy-bar] Mar 5, 2011 8:16:45 AM org.activiti.engine.impl.db.DbSqlSession dbSchemaUpgrade
[deploy-bar] INFO: upgrading activiti engine schema from 5.1 to 5.3
[deploy-bar] Mar 5, 2011 8:16:45 AM org.activiti.engine.impl.db.DbSqlSession dbSchemaUpgrade
[deploy-bar] INFO: upgrading activiti history schema from 5.1 to 5.3
[deploy-bar] Mar 5, 2011 8:16:45 AM org.activiti.engine.impl.db.DbSqlSession executeSchemaResource
[deploy-bar] INFO: performing upgrade on history with resource org/activiti/db/upgrade/activiti.mssql.upgradestep.52.to.53.history.sql
[deploy-bar] Mar 5, 2011 8:16:46 AM org.activiti.engine.impl.db.DbSqlSession executeSchemaResource
[deploy-bar] SEVERE: problem during schema upgrade, statement 'alter table ACT_HI_TASKINST add column PRIORITY_ int
[deploy-bar] java.sql.SQLException: Incorrect syntax near the keyword 'column'.
[deploy-bar]    at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
[deploy-bar]    at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2820)
[deploy-bar]    at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2258)
[deploy-bar]    at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:632)

[deploy-bar] Mar 5, 2011 8:16:46 AM org.activiti.engine.impl.interceptor.CommandContext close
[deploy-bar] SEVERE: Error while closing command context
[deploy-bar] org.activiti.engine.ActivitiException: couldn't upgrade db schema: alter table ACT_HI_TASKINST add column PRIORITY_ int
[deploy-bar]    at org.activiti.engine.impl.db.DbSqlSession.executeSchemaResource(DbSqlSession.java:795)
[deploy-bar]    at org.activiti.engine.impl.db.DbSqlSession.executeSchemaResource(DbSqlSession.java:722)
[deploy-bar]    at org.activiti.engine.impl.db.DbSqlSession.dbSchemaUpgrade(DbSqlSession.java:701)
[deploy-bar]    at org.activiti.engine.impl.db.DbSqlSession.dbSchemaUpdate(DbSqlSession.java:627)
[deploy-bar]    at org.activiti.engine.impl.db.DbSqlSession.performSchemaOperationsProcessEngineBuild(DbSqlSession.java:854)
[deploy-bar]    at org.activiti.engine.impl.SchemaOperationsProcessEngineBuild.execute(SchemaOperationsProcessEngineBuild.java:25)

Outcomes