topic Error after pointing activiti-explorer to postgresql db in Alfresco Archive

Error after pointing activiti-explorer to postgresql db

shreyashp — Thu, 07 Jan 2016 06:26:36 GMT

I have deployed activiti db schema using DbSchemaCreate's main method. i.e an db with no data.Further i have deployed activiti-explorer-5.18 web app on tomcat.Db-Properties:db=postgresjdbc.driver=org.postgresql.Driverjdbc.url=jdbcostgresql://localhost:5432/mydb?currentSchema=activitijdbc.username=

Re: Error after pointing activiti-explorer to postgresql db

shreyashp — Thu, 07 Jan 2016 06:52:10 GMT

Stacktrace continued:
Jan 7, 2016 12:20:01 PM org.apache.catalina.core.StandardContext listenerStop
SEVERE: Exception sending context destroyed event to listener instance of class org.activiti.explorer.servlet.WebConfigurer
java.lang.IllegalStateException: No WebApplicationContext found: no ContextLoaderListener registered?
at org.springframework.web.context.support.WebApplicationContextUtils.getRequiredWebApplicationContext(WebApplicationContextUtils.java:83)
at org.activiti.explorer.servlet.WebConfigurer.contextDestroyed(WebConfigurer.java:73)
at org.apache.catalina.core.StandardContext.listenerStop(StandardContext.java:4805)
at org.apache.catalina.core.StandardContext.stopInternal(StandardContext.java:5453)
at org.apache.catalina.util.LifecycleBase.stop(LifecycleBase.java:232)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:160)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:866)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:842)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:615)
at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:958)
at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1599)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)

Re: Error after pointing activiti-explorer to postgresql db

jbarrez — Thu, 07 Jan 2016 13:27:40 GMT

That error seems to be coming from here: https://github.com/Activiti/Activiti/blob/activiti-5.18.0/modules/activiti-engine/src/main/java/org/activiti/engine/impl/db/DbSqlSession.java#L1081

Which means that
1) the table was present, but
2) did not contain the right information

How did you create the database schema?

Re: Error after pointing activiti-explorer to postgresql db

shreyashp — Thu, 07 Jan 2016 14:26:00 GMT

I have deployed activiti db schema using DbSchemaCreate's main method. Changed the activiti.cfg.xml to point to an empty schema.
act_ge_property contained:
"next.dbid";"1";1
"schema.history";"create(5.20.0.1)";1
"schema.version";"5.20.0.1";1

All other tables are empty.

Re: Error after pointing activiti-explorer to postgresql db

hari — Mon, 18 Jan 2016 12:24:29 GMT

Hi Shreyash,

Try it in this way,
Go to the Activiti zip that you have downloaded. It will contain the database folder and inside of it, you will find create and inside you will find 3 db script files related to postgres database with names activiti.postgres.create.engine.sql, activiti.postgres.create.history.sql, activiti.postgres.create.identity.sql.
1) Now open your DB and create an empty database and run these scripts in that db. You will have all necessary db objects created.
2) Next go to your tomcat's webapps\activiti-explorer\WEB-INF\classes folder and set the db properties appropriately.
3) Make sure you have the postgresql jar file in your tomcat lib folder.
That's it. Every thing should work smooth now.

Re: Error after pointing activiti-explorer to postgresql db

uzair_zaman — Mon, 20 Jun 2016 15:12:10 GMT

Hi Hari,
I had followed the same steps you have explained about 5 months before to setup msql and it worked exactly fine.
Now I am trying to follow the same steps for mssql but it's not working.
I have copied the sqljdbc4 under\apache-tomcat-7.0.67 - Activiti Tomcat\webapps\activiti-explorer\WEB-INF\lib and have changed the db.properties file accordingly:
db=mssql
jdbc.driver=com.microsoft.sqlsever.jdbc.SQLServerDriver
jdbc.url=jdbc:sqlserver://10.10.44.1:1433;databaseName=activiti
jdbc.username=sa
jdbc.password=password

Any suggestions?