How to solve DB NOT CLEAN Error

[parul_vipparthi]

Hello

After downloading activiti5.0 and installing, I started playing with the explorer– started some processes, claimed some tasks etc. Then i started running the bundled examples. but the examples give this error

18:29:37,815 INF  | Loading XML bean definitions from class path resource [org/activiti/spring/test/servicetask/servicetaskSpringTest-context.xml]  [org.springframework.beans.factory.xml.XmlBeanDefinitionReader]
18:29:38,174 INF  | Refreshing org.springframework.context.support.GenericApplicationContext@15ff48b: startup date [Fri Dec 03 18:29:38 IST 2010]; root of context hierarchy  [org.springframework.context.support.GenericApplicationContext]
18:29:38,487 INF  | Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@12a0f6c: defining beans [sentenceGenerator,delegateExpressionBean,sentenceToUpperCaseBean,myExecutionListenerBean,myTaskListenerBean,dataSource,transactionManager,processEngineConfiguration,processEngine,repositoryService,runtimeService,taskService,historyService,managementService,org.springframework.context.annotation.internalConfigurationAnnotationProcessor,org.springframework.context.annotation.internalAutowiredAnnotationProcessor,org.springframework.context.annotation.internalRequiredAnnotationProcessor,org.springframework.context.annotation.internalCommonAnnotationProcessor,org.springframework.context.annotation.internalPersistenceAnnotationProcessor]; root of factory hierarchy  [org.springframework.beans.factory.support.DefaultListableBeanFactory]
18:29:40,768 INF  | ProcessEngine default created  [org.activiti.engine.impl.ProcessEngineImpl]
18:29:40,862 SEV  |                                                                                              [org.activiti.engine.impl.test.PluggableActivitiTestCase]
18:29:41,002 INF  | Processing resource org/activiti/spring/test/servicetask/ServiceTaskSpringDelegationTest.testDelegateExpression.bpmn20.xml  [org.activiti.engine.impl.bpmn.deployer.BpmnDeployer]
18:29:41,237 INF  | XMLSchema currently not supported as typeLanguage  [org.activiti.engine.impl.bpmn.parser.BpmnParse]
18:29:41,237 INF  | XPath currently not supported as expressionLanguage  [org.activiti.engine.impl.bpmn.parser.BpmnParse]
18:29:41,831 SEV  |                                                                                              [org.activiti.engine.impl.test.PluggableActivitiTestCase]
18:29:41,831 SEV  | DB NOT CLEAN: 
  ACT_RE_DEPLOYMENT: 1 record(s)   ACT_RE_PROCDEF: 8 record(s)   ACT_HI_ACTINST: 10 record(s)   ACT_ID_MEMBERSHIP: 12 record(s)   ACT_GE_BYTEARRAY: 11 record(s)   ACT_RU_JOB: 2 record(s)   ACT_RU_TASK: 8 record(s)   ACT_ID_GROUP: 7 record(s)   ACT_HI_PROCINST: 8 record(s)   ACT_ID_USER: 3 record(s)   ACT_RU_IDENTITYLINK: 7 record(s)   ACT_RU_EXECUTION: 11 record(s)   [org.activiti.engine.impl.test.PluggableActivitiTestCase]
‍‍‍‍‍‍‍‍‍‍‍‍‍

Please guide me on how to clean up the error.

Thank you
–
parul

[frederikherema1]

Parul,

The examples are actually test-cases that assume the database is clean. Since the examples are using the same database schema as the demo, the test will fail because data is present in the db which was created when playing around with the demo.

What you can do:

Alter the configuration of the example you want to run, to use another schema

Delete all deployments from within activiti-probe to have a clean database.

From the /setup/ folder in your distro, run 'ant db.drop' to remove all data and tables from the schema. When you run the example (depending on the schema strategy), an empty schema will be created that will be used in your test.

[parul_vipparthi]

Thank you for a reply.

Using another schema for testing helps.