topic Activiti with persistent database (bug using mysql?) in Alfresco Archive

Activiti with persistent database (bug using mysql?)

pfeard — Tue, 20 May 2014 19:34:16 GMT

Hi,I've tried everything now. My goal is to have one database for the activiti explorer and the activiti rest API, so that if I change something via rest I also could see it in the activiti explorer. I already tried two attempts:1. I tried to run the h2 database in server mode. Therefore I gave the

Re: Activiti with persistent database (bug using mysql?)

jbarrez — Wed, 21 May 2014 09:36:58 GMT

How did you get both Explorer and Rest together?

The url seems to indicate

org%2Factiviti%2Fexplorer%2Fdemo%2Fprocess%2FcreateTimersProcess.bpmn20.xml

That somehow explorer is interfering with your REST install? Are these two separate wars?

MySQL doesnt have any influence on those urls whatsoever.

Re: Activiti with persistent database (bug using mysql?)

pfeard — Wed, 21 May 2014 19:27:43 GMT

You might be right, but how can I solve that?
I just copied and pasted the two wars <code>activiti-explorer.war</code> and <code>activiti-rest.war</code> in the webapps directory of my tomcat server.

I got a little further with my first attempt so that explorer and REST are using the same h2 database on a server. That means if I post e.g. a process instance via REST I see it on the explorer. But now the same issue occurs as if I use one MySQL Database. It's somehow interfering and I get those not working resource URLs.

Or does that mean, that I can't use REST and explorer with the same database without errors?

Re: Activiti with persistent database (bug using mysql?)

pfeard — Thu, 22 May 2014 08:03:18 GMT

Or is there a way to only have one *.war file which includes both, REST and explorer?

Re: Activiti with persistent database (bug using mysql?)

jbarrez — Thu, 22 May 2014 11:36:14 GMT

> Or does that mean, that I can't use REST and explorer with the same database without errors?

No, that works for sure.

> Or is there a way to only have one *.war file which includes both, REST and explorer?

Yes, but it shouldn't be. It should work out of the box.

What is in your database? More specifically the ACT_GE_BYTEARRAY and ACT_RE_DEPLOYMENT ?

Re: Activiti with persistent database (bug using mysql?)

pfeard — Thu, 22 May 2014 16:46:07 GMT

In ACT_GE_BYTEARRAY the NAME_ column looks good, like <code>org/activiti/explorer/demo/process/VacationRequest.bpmn20.xml</code> and in ACT_RE_DEPLOYMENT I have two entries: Demo processes and Demo reports. But still I get the not working resource URLs via REST with the %2F…

Re: Activiti with persistent database (bug using mysql?)

jbarrez — Tue, 27 May 2014 07:37:05 GMT

OK, im officially really puzzled now. really don't have a clue :s

Could you post the REST http request you do to get the data here? Maybe there is something off there (although i dont think so)

Re: Activiti with persistent database (bug using mysql?)

pfeard — Tue, 10 Jun 2014 11:58:53 GMT

Sorry havn't worked on it for a while.
The REST http request is simply <code>http://localhost:8080/activiti-rest/service/repository/process-definitions</code>
If I use different databases (like it is on default) everything is fine both on activit-explorer and activiti REST. I can post a process instance via <code>http://localhost:8080/activiti-rest/service/runtime/process-instances</code> and see it with the same request <code>http://localhost:8080/activiti-rest/service/runtime/process-instances</code> but I can't see it on activiti explorer (since I use different databases in this case)
As soon as I use one database for both, the resource URL on this GET request <code>http://localhost:8080/activiti-rest/service/repository/process-definitions</code> are not working anymore.

Re: Activiti with persistent database (bug using mysql?)

alfheim — Thu, 03 Jul 2014 05:02:57 GMT

I've got the same problem.
Activiti version: 5.15.1
Tomcat version: 7.0.54

First I try with H2
http://192.168.56.150:8080/activiti-rest/service/repository/process-definitions

{
           "id": "fixSystemFailure:1:35",
           "url": "http://192.168.56.150:8080/activiti-rest/service/repository/process-definitions/fixSystemFailure%3A1%3A35",
           "key": "fixSystemFailure",
           "version": 1,
           "name": "Fix system failure",
           "description": null,
           "deploymentId": "20",
           "deploymentUrl": "http://192.168.56.150:8080/activiti-rest/service/repository/deployments/20",
           "resource": "http://192.168.56.150:8080/activiti-rest/service/repository/deployments/20/resources/FixSystemFailureProcess.bpmn20.xml",
           "diagramResource": "http://192.168.56.150:8080/activiti-rest/service/repository/deployments/20/resources/FixSystemFailureProcess.png",
           "category": "Examples",
           "graphicalNotationDefined": false,
           "suspended": false,
           "startFormDefined": false
       },

GET http://192.168.56.150:8080/activiti-rest/service/repository/deployments/20/resources/FixSystemFailureProcess.png

    {
       "id": "FixSystemFailureProcess.png",
       "url": "http://192.168.56.150:8080/activiti-rest/service/repository/deployments/20/resources/FixSystemFailureProcess.png",
       "contentUrl": "http://192.168.56.150:8080/activiti-rest/service/repository/deployments/20/resourcedata/FixSystemFailureProcess.png",
       "mediaType": "image/png",
       "type": "resource"
    }

GET http://192.168.56.150:8080/activiti-rest/service/repository/deployments/20/resourcedata/FixSystemFailureProcess.png
Image OK

Then I configure mysql db
lib: mysql-connector-java-5.1.31-bin.jar

file db.properties
db=mysql
jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/activiti
jdbc.username=activiti
jdbc.password=Password1

cp /root/db.properties /usr/local/tomcat/webapps/activiti-explorer/WEB-INF/classes/
cp /root/db.properties /usr/local/tomcat/webapps/activiti-rest/WEB-INF/classes/

http://192.168.56.150:8080/activiti-rest/service/repository/process-definitions

{
           "id": "fixSystemFailure:1:35",
           "url": "http://192.168.56.150:8080/activiti-rest/service/repository/process-definitions/fixSystemFailure%3A1%3A35",
           "key": "fixSystemFailure",
           "version": 1,
           "name": "Fix system failure",
           "description": null,
           "deploymentId": "23",
           "deploymentUrl": "http://192.168.56.150:8080/activiti-rest/service/repository/deployments/23",
           "resource": "http://192.168.56.150:8080/activiti-rest/service/repository/deployments/23/resources/org%2Factiviti%2Fexplorer%2Fdemo%2Fprocess%2FFixSystemFailureProcess.bpmn20.xml",
           "diagramResource": "http://192.168.56.150:8080/activiti-rest/service/repository/deployments/23/resources/org%2Factiviti%2Fexplorer%2Fdemo%2Fprocess%2FFixSystemFailureProcess.png",
           "category": "Examples",
           "graphicalNotationDefined": false,
           "suspended": false,
           "startFormDefined": false
       },

GET http://192.168.56.150:8080/activiti-rest/service/repository/deployments/23/resources/org%2Factiviti%2Fexplorer%2Fdemo%2Fprocess%2FFixSystemFailureProcess.png

    Status Code: 400 Bad Request
    Connection: close
    Content-Length: 0
    Date: Thu, 03 Jul 2014 04:52:42 GMT
    Server: Apache-Coyote/1.1

Then I try to use the same url format as H2
GET http://192.168.56.150:8080/activiti-rest/service/repository/deployments/23/resources/FixSystemFailureProcess.png

    Status Code: 404 Not Found
    Accept-Ranges: bytes
    Content-Length: 78
    Content-Type: application/json;charset=UTF-8
    Date: Thu, 03 Jul 2014 04:54:14 GMT
    Server: Restlet-Framework/2.1.4
    Vary: Accept-Charset, Accept-Encoding, Accept-Language, Accept

Hope this helps

Cheers

Re: Activiti with persistent database (bug using mysql?)

martin_grofcik — Thu, 03 Jul 2014 05:23:44 GMT

Hi,

I do not have answer, but I ask more questions 🙂 :
1. Is there any stack trace?
2. Did you try to debug rest service?

Regards
Martin

Re: Activiti with persistent database (bug using mysql?)

alfheim — Thu, 03 Jul 2014 06:08:39 GMT

No stack trace, logs are clean

Can you tell me how to debug rest service?

Re: Activiti with persistent database (bug using mysql?)

martin_grofcik — Fri, 04 Jul 2014 05:05:51 GMT

Hi,

Run tomcat in debug mode (catalina.sh jpda start) and connect to JVM remotely.

Regards
Martin

Re: Activiti with persistent database (bug using mysql?)

martin_grofcik — Fri, 04 Jul 2014 05:06:48 GMT

Hi,

As soon as I use one database for both, the resource URL on this GET request http://localhost:8080/activiti-rest/service/repository/process-definitions are not working anymore.

Any stacktrace? jUnit test?

Regards
Martin

Re: Activiti with persistent database (bug using mysql?)

alfheim — Sun, 06 Jul 2014 05:25:35 GMT

Reading documentation I find this rest endpoint to fetch diagram:

/activiti-rest/service/process-definition/fixSystemFailure:1:35/diagram

and it works like a charm, with mysql too

Thank you