topic Re: Hi, in Alfresco Forum

I have an issue to find out the response of a process in rest api via the rest client, which is present in Activiti-explorer of the same tomcat serve

anindita_user — Thu, 01 Mar 2018 13:57:26 GMT

I have an issue to find out the response of a process in rest api via the rest client, which is present in Activiti-explorer of the same tomcat server.I have the URL by which I can find out some other processes from the activiti explorer; like this -http://127.0.0.1:8085/activiti-rest/service/reposi

Re: Hi,

ryandawson — Fri, 02 Mar 2018 13:57:41 GMT

Are the explorer and activiti-rest definitely pointing at the same database? See for example

Re: Hi,

anindita_user — Mon, 05 Mar 2018 08:11:14 GMT

Yes, I have updated the db details of both the activity rest and activity explorer and then again tried. Still the details for the required process is not coming under the list of the published processes while the url is being hit in the rest client.

Please help.

Re: Hi,

anindita_user — Mon, 05 Mar 2018 08:52:15 GMT

Re: Hi,

ryandawson — Mon, 05 Mar 2018 08:58:48 GMT

Do you see any process definitions in Activiti REST?

Re: Hi,

anindita_user — Mon, 05 Mar 2018 13:22:08 GMT

Yes I can see some process definitions as depicted below:

The processes above have been exposed and available when the http://127.0.0.1:8085/activiti-rest/service/repository/process-definitions?size=1000 URL is hit,

any one of the processes can be exposed by hitting the URL in the rest client : http://127.0.0.1:8085/activiti-rest/service/repository/process-definitions/createTimersProcess:1:31

One of the processes I created, deployed and ran successfully in activiti-explorer as depicted below :

But I cannot expose this process via Rest API similar to the above processes.

What should be the URL similar to http://127.0.0.1:8085/activiti-rest/service/repository/process-definitions/createTimersProcess:1:31

for the process I created to expose from Rest?

I need to know what is the URL to hit from rest client for the process running from the activiti-explorer.

Please help.

Re: Hi,

ryandawson — Mon, 05 Mar 2018 14:06:30 GMT

So you are able to start process instances for this process from the explorer? If so maybe check whether you can see those instances from the REST API (Activiti User Guide )

Re: Hi,

anindita_user — Mon, 05 Mar 2018 14:52:28 GMT

Yes I am able to start my process from activiti explorer. But I am not able to understand from where i can find the instance/process id as it is 31 for the process http://127.0.0.1:8085/activiti-rest/service/repository/process-definitions/createTimersProcess:1:31, similarly how to find out the process instance id as described in the guide you have indicated as -

How to get the processInstanceId value for my process.?

Re: Hi,

ryandawson — Mon, 05 Mar 2018 15:32:41 GMT

I was wondering if you could just query for all of them and find it in the list. Or is it a really big list?

I am still not clear on whether any of the process definitions that you see in the explorer are also shown in REST? Is there any overlap between the data? Are all the process instances and definitions that you see in explorer present in REST except for that one process definition?

Others have reported problems with this Not able to view newly deployed process information from Rest api calls but I think it should work if you use the same database . You could also try connecting with a database/SQL client directly to the database and querying to see what process definitions are there.

Re: Hi,

anindita_user — Tue, 06 Mar 2018 09:25:07 GMT

It is a list of 10-11 processes in the activiti explorer out of which only 6processes are being displayed as the response of the activiti-rest api call.

There are total 11processes present in the activiti explorer. But out of them only 6processes are getting generated as the response in the rest api. But rest (11-6)=5 processes [available in activiti explorer] are not getting generated in the rest api call. The process created by me is among those 5 processes which are present in activiti explorer but not coming in the activiti rest api.

I have the same DB configuration in db.properties file for both the activiti rest and activiti explorer as follows :

Please let me know how to connect with a database/SQL client directly to the database and to query to see what process definitions are there.

Re: Hi,

ryandawson — Tue, 06 Mar 2018 09:36:23 GMT

Those are in-memory h2 databases. The databases they create are available only to the java process using that h2. Those configurations might be the same but the databases won't be shared across java applications. In-memory h2 is normally only used for test purposes. You need to switch to a standalone database if you want it to be shared. You could configure a standalone h2 or use another database like mysql.

Re: Hi,

anindita_user — Tue, 06 Mar 2018 12:43:19 GMT

Hi,

How to configure a standalone h2 or use another database like mysql?

Please assist me.

Re: Hi,

ryandawson — Tue, 06 Mar 2018 15:34:23 GMT

There is a guide available at How to configure Activiti Explorer and REST to use the same database are some other threads available on this - How to configure Activiti Explorer and REST to use the same database or Activiti with persistent database (bug using mysql?) or Avoid generating demodata in rest-webapp

If you use a standalone database then you'll be able to inspect it with a tool such as dbvisualizer (Database Management Software Tools - DbVisualizer ) or Toad (Toad Database Developer and Administration Software Tools )

Re: I have an issue to find out the response of a process in rest api via the rest client, which is present in Activiti-explorer of the same tomcat serve

anindita_user — Fri, 09 Mar 2018 13:58:01 GMT

The above url How to configure Activiti Explorer and REST to use the same database redirects to the page like this -

I have already tried to connect the database by using the above properties like :

But, it is not working. I cannot find the process deployed by me in the activiti rest.

Please let me know the exact place where to write the other properties of the database as described in the page redirected from URL.

Re: I have an issue to find out the response of a process in rest api via the rest client, which is present in Activiti-explorer of the same tomcat serve

ryandawson — Fri, 09 Mar 2018 14:24:09 GMT

That is an in-memory database though - the "h2:mem" tells you it's in-memory. I am not sure what you mean about that page redirecting. There are several links above and some of them refer to mysql, which is a standalone database. Perhaps a clearer guide for this purpose is http://alfrescoblog.com/2014/06/08/how-to-install-activiti-with-mysql/

Re: I have an issue to find out the response of a process in rest api via the rest client, which is present in Activiti-explorer of the same tomcat serve

anindita_user — Tue, 13 Mar 2018 13:11:27 GMT

Hi,

I have done the following according to the instructions provided above:

- I have downloaded the mysql connector

- put the mysql connector jars from there to libs folder of activiti activiti-5.22.0:

in the path : activiti-5.22.0\activiti-5.22.0\libs

as depicted below -

- changed the DB configuration as mentioned in the page[redirected from the URL http://alfrescoblog.com/2014/06/08/how-to-install-activiti-with-mysql/ ] as :

      db=activitiblog
      jdbc.driver=com.mysql.jdbc.Driver
      jdbc.url=jdbc:mysql://localhost:3306/activitiblog?characterEncoding=UTF-8
      jdbc.username=activiti
      jdbc.password=activitiPass

But after doing all these, I cannot find anything in the tomcat activiti explorer window like:

And if I do not change anything in the db.properties file and keep it as it was :

db=h2
jdbc.driver=org.h2.Driver
jdbc.url=jdbc:h2:mem:activiti;DB_CLOSE_DELAY=-1
jdbc.username=sa
jdbc.password=

The same problem persisits, i.e., I cannot find my process running in the rest api although it has been deployed and run through activiti-exploer.

Please let me know what should be the remedy for this case.