topic Error installing MSSQL database - 5.3 in Alfresco Archive

Error installing MSSQL database - 5.3

jchildress — Sat, 05 Mar 2011 14:26:14 GMT

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

Re: Error installing MSSQL database - 5.3

jchildress — Sat, 05 Mar 2011 16:00:45 GMT

It looks like the PRIORITY column is already there… checking the file "activiti.mssql.create.history.sql"

Is there anyway to skip the upgrade process if it's a clean install?

John

Re: Error installing MSSQL database - 5.3

frederikherema1 — Mon, 07 Mar 2011 09:38:20 GMT

Hi,

On a clean DB, no upgrade should be performed. Are you sure the DB doesn't have any 5.2 tables?
You can always set the databaseSchemaUpgrade property to false (see http://activiti.org/userguide/index.html#databaseUpgrade).

Re: Error installing MSSQL database - 5.3

weiyi2011 — Mon, 14 Mar 2011 13:09:31 GMT

Hi,

On a clean DB, no upgrade should be performed. Are you sure the DB doesn't have any 5.2 tables?
You can always set the databaseSchemaUpgrade property to false (see http://activiti.org/userguide/index.html#databaseUpgrade).

Hi, All.

I have the same problem. Acitiviti 5.3, SQL2008, JTDS-1.2.4.JAR
And my database is a new one. But Activiti5.2 work well by execute the create SQL by yourself.
I need your help, my project use SQL2008. Thanks very much!

log4j:WARN No appenders could be found for logger (org.springframework.context.support.ClassPathXmlApplicationContext).
log4j:WARN Please initialize the log4j system properly.
12:57:12,468 FIN  | database product name: 'Microsoft SQL Server'  [org.activiti.engine.impl.cfg.ProcessEngineConfigurationImpl]
12:57:12,468 FIN  | using database type: mssql  [org.activiti.engine.impl.cfg.ProcessEngineConfigurationImpl]
SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".
SLF4J: Defaulting to no-operation (NOP) logger implementation
SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further details.
12:57:13,078 FIN  |                                                                                                       [org.activiti.engine.impl.interceptor.LogInterceptor]
12:57:13,078 FIN  | — starting SchemaOperationsProcessEngineBuild ——————————————————–  [org.activiti.engine.impl.interceptor.LogInterceptor]
12:57:13,187 INF  | upgrading activiti engine schema from 5.1 to 5.3  [org.activiti.engine.impl.db.DbSqlSession]
12:57:13,187 FIN  | no schema resource org/activiti/db/upgrade/activiti.mssql.upgradestep.51.to.52.engine.sql for upgrade  [org.activiti.engine.impl.db.DbSqlSession]
12:57:13,187 FIN  | no schema resource org/activiti/db/upgrade/activiti.mssql.upgradestep.52.to.53.engine.sql for upgrade  [org.activiti.engine.impl.db.DbSqlSession]
12:57:13,218 INF  | upgrading activiti history schema from 5.1 to 5.3  [org.activiti.engine.impl.db.DbSqlSession]
12:57:13,218 FIN  | no schema resource org/activiti/db/upgrade/activiti.mssql.upgradestep.51.to.52.history.sql for upgrade  [org.activiti.engine.impl.db.DbSqlSession]
12:57:13,218 INF  | performing upgrade on history with resource org/activiti/db/upgrade/activiti.mssql.upgradestep.52.to.53.history.sql  [org.activiti.engine.impl.db.DbSqlSession]
12:57:13,218 FIN  | removing not null constraint from ACT_HI_DETAIL.PROC_INST_ID_ and ACT_HI_DETAIL.EXECUTION_ID_  [org.activiti.engine.impl.db.DbSqlSession]
12:57:13,234 FIN  | Add column PRIORITY_ to ACT_HI_TASKINST and set to default priority (ACT-484)  [org.activiti.engine.impl.db.DbSqlSession]
12:57:13,234 SEV  | problem during schema upgrade, statement 'alter table ACT_HI_TASKINST add column PRIORITY_ int
java.sql.SQLException: 关键字 'column' 附近有语法错误。
 at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
 at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2820)
 at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2258)
 at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:632)
 at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:584)
 at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:546)
 at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:723)
 at net.sourceforge.jtds.jdbc.JtdsStatement.execute(JtdsStatement.java:1160)
 at org.activiti.engine.impl.db.DbSqlSession.executeSchemaResource(DbSqlSession.java:769)
 at org.activiti.engine.impl.db.DbSqlSession.executeSchemaResource(DbSqlSession.java:722)
 at org.activiti.engine.impl.db.DbSqlSession.dbSchemaUpgrade(DbSqlSession.java:701)
 at org.activiti.engine.impl.db.DbSqlSession.dbSchemaUpdate(DbSqlSession.java:627)
 at org.activiti.engine.impl.db.DbSqlSession.performSchemaOperationsProcessEngineBuild(DbSqlSession.java:854)
 at org.activiti.engine.impl.SchemaOperationsProcessEngineBuild.execute(SchemaOperationsProcessEngineBuild.java:25)
 at org.activiti.engine.impl.interceptor.CommandExecutorImpl.execute(CommandExecutorImpl.java:24)
 at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:42)
 at org.activiti.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:42)
 at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130)
 at org.activiti.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:40)
 at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:33)
 at org.activiti.engine.impl.ProcessEngineImpl.<init>(ProcessEngineImpl.java:77)
 at org.activiti.engine.impl.cfg.ProcessEngineConfigurationImpl.buildProcessEngine(ProcessEngineConfigurationImpl.java:233)
 at org.activiti.spring.SpringProcessEngineConfiguration.buildProcessEngine(SpringProcessEngineConfiguration.java:61)
 at org.activiti.spring.ProcessEngineFactoryBean.getObject(ProcessEngineFactoryBean.java:56)
 at org.activiti.spring.ProcessEngineFactoryBean.getObject(ProcessEngineFactoryBean.java:32)
 at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:142)
 at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.getObjectFromFactoryBean(FactoryBeanRegistrySupport.java:102)
 at org.springframework.beans.factory.support.AbstractBeanFactory.getObjectForBeanInstance(AbstractBeanFactory.java:1433)
 at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:249)
 at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
 at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:353)
 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:983)
 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:879)
 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:485)
 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
 at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:295)
 at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
 at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:292)
 at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
 at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:580)
 at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:900)
 at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:455)
 at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:139)
 at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:83)
 at org.activiti.designer.test.LfxjTest.<init>(LfxjTest.java:32)
 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
 at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
 at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
 at java.lang.reflect.Constructor.newInstance(Constructor.java:494)
 at junit.framework.TestSuite.createTest(TestSuite.java:61)
 at junit.framework.TestSuite.addTestMethod(TestSuite.java:283)
 at junit.framework.TestSuite.<init>(TestSuite.java:146)
 at org.junit.internal.runners.JUnit38ClassRunner.<init>(JUnit38ClassRunner.java:71)
 at org.junit.internal.builders.JUnit3Builder.runnerForClass(JUnit3Builder.java:14)
 at org.junit.runners.model.RunnerBuilder.safeRunnerForClass(RunnerBuilder.java:57)
 at org.junit.internal.builders.AllDefaultPossibilitiesBuilder.runnerForClass(AllDefaultPossibilitiesBuilder.java:29)
 at org.junit.runners.model.RunnerBuilder.safeRunnerForClass(RunnerBuilder.java:57)
 at org.junit.internal.requests.ClassRequest.getRunner(ClassRequest.java:24)
 at org.junit.internal.requests.FilterRequest.getRunner(FilterRequest.java:33)
 at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.<init>(JUnit4TestReference.java:32)
 at org.eclipse.jdt.internal.junit4.runner.JUnit4TestMethodReference.<init>(JUnit4TestMethodReference.java:25)
 at org.eclipse.jdt.internal.junit4.runner.JUnit4TestLoader.createTest(JUnit4TestLoader.java:42)
 at org.eclipse.jdt.internal.junit4.runner.JUnit4TestLoader.loadTests(JUnit4TestLoader.java:31)
 at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:452)
 at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:683)
 at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:390)
 at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:197)
  [org.activiti.engine.impl.db.DbSqlSession]
12:57:13,250 SEV  | Error while closing command context

Re: Error installing MSSQL database - 5.3

frederikherema1 — Mon, 14 Mar 2011 13:22:59 GMT

Hi,

Translated messages states: "Keyword 'column' Incorrect syntax near."

Looks like the "ADD COLUMN" should just be "ADD" on MS SQL. We don't have QA for MSSQL yet so it slipped through:


alter table ACT_HI_TASKINST add column PRIORITY_ int;

I'll make sure the SQL is altered on trunk. As a workaround, you could edit the org/activiti/db/upgrade/activiti.mssql.upgradestep.52.to.53.history.sql in activiti-engine.jar.

Re: Error installing MSSQL database - 5.3

weiyi2011 — Mon, 14 Mar 2011 14:36:43 GMT

Hi,

Translated messages states: "Keyword 'column' Incorrect syntax near."

Looks like the "ADD COLUMN" should just be "ADD" on MS SQL. We don't have QA for MSSQL yet so it slipped through:
alter table ACT_HI_TASKINST add column PRIORITY_ int;
I'll make sure the SQL is altered on trunk. As a workaround, you could edit the org/activiti/db/upgrade/activiti.mssql.upgradestep.52.to.53.history.sql in activiti-engine.jar.

Hi,

When I edit activiti.mssql.create.engine.sql in activiti-engine.jar. 5.1 to 5.3. It work well!

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

insert into ACT_GE_PROPERTY
values ('schema.history', 'create(5.3)', 1);

Re: Error installing MSSQL database - 5.3

weiyi2011 — Mon, 14 Mar 2011 14:59:07 GMT

OH NO!

I found that It work well by org.activiti.engine.impl.cfg.StandaloneInMemProcessEngineConfiguration.
But When I use org.activiti.spring.SpringProcessEngineConfiguration have a test.
There is only identityService can save data, other Service have no a transaction.
What is the problem?


14:58:06,781 FIN  |                                                                                                       [org.activiti.engine.impl.interceptor.LogInterceptor]
14:58:06,781 FIN  | — starting SchemaOperationsProcessEngineBuild ——————————————————–  [org.activiti.engine.impl.interceptor.LogInterceptor]
14:58:07,000 FIN  | flush summary:  [org.activiti.engine.impl.db.DbSqlSession]
14:58:07,000 FIN  | now executing flush…  [org.activiti.engine.impl.db.DbSqlSession]
14:58:07,000 FIN  | — SchemaOperationsProcessEngineBuild finished ——————————————————–  [org.activiti.engine.impl.interceptor.LogInterceptor]
14:58:07,000 FIN  |                                                                                                       [org.activiti.engine.impl.interceptor.LogInterceptor]
14:58:07,000 INF  | ProcessEngine default created  [org.activiti.engine.impl.ProcessEngineImpl]

Re: Error installing MSSQL database - 5.3

frederikherema1 — Mon, 14 Mar 2011 16:37:14 GMT

Hi,

Can you show your FULL spring-context you are using?

Re: Error installing MSSQL database - 5.3

weiyi2011 — Tue, 15 Mar 2011 01:16:37 GMT

ops:

No problem with my spring-context. Beacause Junit Annotation doesn't work.

Re: Error installing MSSQL database - 5.3

frederikherema1 — Wed, 16 Mar 2011 10:45:59 GMT

So is your problem solved then?

Re: Error installing MSSQL database - 5.3

weiyi2011 — Thu, 17 Mar 2011 12:15:09 GMT

Hi, frederikheremans.

Yes, the problem is solved.

Re: Error installing MSSQL database - 5.3

lstrzelecki — Thu, 17 Mar 2011 22:34:15 GMT

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.

Re: Error installing MSSQL database - 5.3

frederikherema1 — Tue, 22 Mar 2011 19:20:27 GMT

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

Re: Error installing MSSQL database - 5.3

delamotte — Mon, 15 Feb 2016 13:18:47 GMT

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

Phil

Re: Error installing MSSQL database - 5.3

jbarrez — Tue, 16 Feb 2016 11:42:46 GMT

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

Re: Error installing MSSQL database - 5.3

delamotte — Wed, 02 Mar 2016 14:42:02 GMT

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.

Re: Error installing MSSQL database - 5.3

jbarrez — Mon, 07 Mar 2016 08:49:20 GMT

Ah ok, now I get it. Many thanks!

Re: Error installing MSSQL database - 5.3

jbarrez — Mon, 07 Mar 2016 08:53:27 GMT

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