Error installing MSSQL database - 5.3

[jchildress]

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)

[weiyi2011]

Hi, frederikheremans.

Yes, the problem is solved.

[lstrzelecki]

I've this problem too. Currently I'm using:
mssql 2005
activiti 5.3

I've checked activiti.mssql.create.engine.sql, content below:

insert into ACT_GE_PROPERTY
values ('schema.version', '5.1', 1);

insert into ACT_GE_PROPERTY
values ('schema.history', 'create(5.1)', 1);
weiyi2011 is right. In resources for mssql is old insert statements.

[frederikherema1]

As I stated before, this is fixed on trunk, will be available in 5.4

[delamotte]

Hi Frederik,
It seems to be the same in two upgrade scripts (mssql) for Activiti 6 beta 2.
Regards,

Phil

[jbarrez]

Not sure why you're bumping a 5 year old post? Nor do I get your remark … can you explain?

[delamotte]

Just wanted to say that one also find keyword "ADD COLUMN" in mssql scripts of Activiti 6 beta2. So, users will have the same problem as the one discussed in this old thread.

[jbarrez]

Ah ok, now I get it. Many thanks!

[jbarrez]

Fixed, see https://github.com/Activiti/Activiti/commit/8e50d710624acd8530ff63de3bddd500f47f6c7f