Activiti: Getting Variables from graphql
Sirs
I have tried searching in the forum for my kinda error. Sorry if this is a repeat.
I'm using 7.0.0.SR1 Runtime Bundle. With latest activiti/activiti-cloud-notifications-graphql:7.1.58.
Here is my query:
query {
ProcessInstances(where: {
OR: {
status: { IN: RUNNING }
}
}) {
select {
id
status
variables{
name
value
}
}
}
}
I managed to get:
{
"data": {
"ProcessInstances": {
"select": [
{
"id": "750f8cf1-61e1-11e9-84b3-0242ac130002",
"status": "RUNNING",
"variables": []
},
{
"id": "818996f2-6342-11e9-89c8-0242ac13001e",
"status": "RUNNING",
"variables": []
},
{
"id": "8b2c0563-6342-11e9-89c8-0242ac13001e",
"status": "RUNNING",
"variables": []
}
]
}
}
}
How can I get the variables values and names from graphql?
Using the JPA query service REST API, I managed to get all of them. But I have to iterate per process instance id in order to get all the variables.
Regards
alaksmana
All 15 comments
@alaksmana Thank you for your question. I can help you to troubleshoot. Can you provide more details below?
How do you start the process?
What is the payload?
igdianov
on 20 Apr 2019
@igdianov Thank you for helping.
- I started by :
runtimeService.startProcessInstanceByKey(job.getString("approvaltype"),
job.getString("type"),//BusinessKey
job);
- The payload is:
job is a mongoDB Document instance. For example:
Document newJob = new Document();
newJob.append("name", "jobname");
newJob.append("type", "approval");
newJob.append("approvaltype", approvaltype);
newJob.append("requestor", requestor);
newJob.append("username", auth.getString("username"));
newJob.append("databefore", before);
newJob.append("dataafter", "na");
newJob.append("querytype", "delete");
newJob.append("querytoexecute", query);
newJob.append("fileimportlink", "na");
newJob.append("database", database);
newJob.append("useragent", useragent);
newJob.append("remotehost", remotehost);
newJob.append("tablename", tabel);
newJob.append("formcode", formcode);
newJob.append("formname", form.getString("form_name"));
newJob.append("moduleid", form.getString("moduleid"));
newJob.append("logsource", Log.logSource(this.getClass(), Thread.currentThread()));
newJob.append("logmessage", Log.logMessage(req));
Currently I use REST API /v1/process-instances/{uuid}/variables/ to get the variables and managed to get all variables and their values nicely.
The result is:
{
"_embedded": {
"variables": [
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 1,
"type": "string",
"name": "name",
"processInstanceId": "750f8cf1-61e1-11e9-84b3-0242ac130002",
"createTime": "2019-04-18T13:54:17.107+0000",
"lastUpdatedTime": "2019-04-18T13:54:17.107+0000",
"value": "jobname",
"markedAsDeleted": false,
"taskVariable": false,
"_links": {
"self": {
"href": "http://myserver:8884/v1/variables/1"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 2,
"type": "string",
"name": "type",
"processInstanceId": "750f8cf1-61e1-11e9-84b3-0242ac130002",
"createTime": "2019-04-18T13:54:17.107+0000",
"lastUpdatedTime": "2019-04-18T13:54:17.107+0000",
"value": "approval",
"markedAsDeleted": false,
"taskVariable": false,
"_links": {
"self": {
"href": "http://myserver:8884/v1/variables/2"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 3,
"type": "string",
"name": "approvaltype",
"processInstanceId": "750f8cf1-61e1-11e9-84b3-0242ac130002",
"createTime": "2019-04-18T13:54:17.107+0000",
"lastUpdatedTime": "2019-04-18T13:54:17.107+0000",
"value": "singleapprover",
"markedAsDeleted": false,
"taskVariable": false,
"_links": {
"self": {
"href": "http://myserver:8884/v1/variables/3"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 4,
"type": "string",
"name": "requestor",
"processInstanceId": "750f8cf1-61e1-11e9-84b3-0242ac130002",
"createTime": "2019-04-18T13:54:17.107+0000",
"lastUpdatedTime": "2019-04-18T13:54:17.107+0000",
"value": "2caf29e4-fefb-4715-a4b4-2e55589aa541",
"markedAsDeleted": false,
"taskVariable": false,
"_links": {
"self": {
"href": "http://myserver:8884/v1/variables/4"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 5,
"type": "string",
"name": "username",
"processInstanceId": "750f8cf1-61e1-11e9-84b3-0242ac130002",
"createTime": "2019-04-18T13:54:17.107+0000",
"lastUpdatedTime": "2019-04-18T13:54:17.107+0000",
"value": "andrelaksmana",
"markedAsDeleted": false,
"taskVariable": false,
"_links": {
"self": {
"href": "http://myserver:8884/v1/variables/5"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 6,
"type": "json",
"name": "databefore",
"processInstanceId": "750f8cf1-61e1-11e9-84b3-0242ac130002",
"createTime": "2019-04-18T13:54:17.110+0000",
"lastUpdatedTime": "2019-04-18T13:54:17.110+0000",
"value": {
"commoncode": "XTEST",
"moduleid": "LBU",
"parentcode": "XTEST",
"commonname": "XTEST",
"commondesc": "XTEST",
"commonusage": "XTEST",
"pkid": 1144
},
"markedAsDeleted": false,
"taskVariable": false,
"_links": {
"self": {
"href": "http://myserver:8884/v1/variables/6"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 7,
"type": "json",
"name": "dataafter",
"processInstanceId": "750f8cf1-61e1-11e9-84b3-0242ac130002",
"createTime": "2019-04-18T13:54:17.110+0000",
"lastUpdatedTime": "2019-04-18T13:54:17.110+0000",
"value": {
"commoncode": "XTEST",
"moduleid": "LBU",
"parentcode": "XTEST1",
"commonname": "XTEST1",
"commondesc": "XTEST1",
"commonusage": "XTEST1"
},
"markedAsDeleted": false,
"taskVariable": false,
"_links": {
"self": {
"href": "http://myserver:8884/v1/variables/7"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 8,
"type": "string",
"name": "querytype",
"processInstanceId": "750f8cf1-61e1-11e9-84b3-0242ac130002",
"createTime": "2019-04-18T13:54:17.110+0000",
"lastUpdatedTime": "2019-04-18T13:54:17.110+0000",
"value": "update",
"markedAsDeleted": false,
"taskVariable": false,
"_links": {
"self": {
"href": "http://myserver:8884/v1/variables/8"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 9,
"type": "string",
"name": "querytoexecute",
"processInstanceId": "750f8cf1-61e1-11e9-84b3-0242ac130002",
"createTime": "2019-04-18T13:54:17.110+0000",
"lastUpdatedTime": "2019-04-18T13:54:17.110+0000",
"value": "update tblm_commoncodeheader set commoncode='XTEST' , moduleid='LBU' , parentcode='XTEST1' , commonname='XTEST1' , commondesc='XTEST1' , commonusage='XTEST1' where pkid=1144",
"markedAsDeleted": false,
"taskVariable": false,
"_links": {
"self": {
"href": "http://myserver:8884/v1/variables/9"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 10,
"type": "string",
"name": "fileimportlink",
"processInstanceId": "750f8cf1-61e1-11e9-84b3-0242ac130002",
"createTime": "2019-04-18T13:54:17.110+0000",
"lastUpdatedTime": "2019-04-18T13:54:17.110+0000",
"value": "na",
"markedAsDeleted": false,
"taskVariable": false,
"_links": {
"self": {
"href": "http://myserver:8884/v1/variables/10"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 11,
"type": "string",
"name": "database",
"processInstanceId": "750f8cf1-61e1-11e9-84b3-0242ac130002",
"createTime": "2019-04-18T13:54:17.110+0000",
"lastUpdatedTime": "2019-04-18T13:54:17.110+0000",
"value": "application_common",
"markedAsDeleted": false,
"taskVariable": false,
"_links": {
"self": {
"href": "http://myserver:8884/v1/variables/11"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 12,
"type": "string",
"name": "useragent",
"processInstanceId": "750f8cf1-61e1-11e9-84b3-0242ac130002",
"createTime": "2019-04-18T13:54:17.110+0000",
"lastUpdatedTime": "2019-04-18T13:54:17.110+0000",
"value": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36",
"markedAsDeleted": false,
"taskVariable": false,
"_links": {
"self": {
"href": "http://myserver:8884/v1/variables/12"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 13,
"type": "string",
"name": "remotehost",
"processInstanceId": "750f8cf1-61e1-11e9-84b3-0242ac130002",
"createTime": "2019-04-18T13:54:17.111+0000",
"lastUpdatedTime": "2019-04-18T13:54:17.111+0000",
"value": "172.19.0.7",
"markedAsDeleted": false,
"taskVariable": false,
"_links": {
"self": {
"href": "http://myserver:8884/v1/variables/13"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 14,
"type": "string",
"name": "tablename",
"processInstanceId": "750f8cf1-61e1-11e9-84b3-0242ac130002",
"createTime": "2019-04-18T13:54:17.111+0000",
"lastUpdatedTime": "2019-04-18T13:54:17.111+0000",
"value": "tblm_commoncodeheader",
"markedAsDeleted": false,
"taskVariable": false,
"_links": {
"self": {
"href": "http://myserver:8884/v1/variables/14"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 15,
"type": "string",
"name": "formcode",
"processInstanceId": "750f8cf1-61e1-11e9-84b3-0242ac130002",
"createTime": "2019-04-18T13:54:17.111+0000",
"lastUpdatedTime": "2019-04-18T13:54:17.111+0000",
"value": "common",
"markedAsDeleted": false,
"taskVariable": false,
"_links": {
"self": {
"href": "http://myserver:8884/v1/variables/15"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 16,
"type": "string",
"name": "formname",
"processInstanceId": "750f8cf1-61e1-11e9-84b3-0242ac130002",
"createTime": "2019-04-18T13:54:17.111+0000",
"lastUpdatedTime": "2019-04-18T13:54:17.111+0000",
"value": "CommonCodeHeader",
"markedAsDeleted": false,
"taskVariable": false,
"_links": {
"self": {
"href": "http://myserver:8884/v1/variables/16"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 17,
"type": "string",
"name": "moduleid",
"processInstanceId": "750f8cf1-61e1-11e9-84b3-0242ac130002",
"createTime": "2019-04-18T13:54:17.111+0000",
"lastUpdatedTime": "2019-04-18T13:54:17.111+0000",
"value": "ADMIN",
"markedAsDeleted": false,
"taskVariable": false,
"_links": {
"self": {
"href": "http://myserver:8884/v1/variables/17"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 18,
"type": "string",
"name": "logsource",
"processInstanceId": "750f8cf1-61e1-11e9-84b3-0242ac130002",
"createTime": "2019-04-18T13:54:17.111+0000",
"lastUpdatedTime": "2019-04-18T13:54:17.111+0000",
"value": "myapplication.dataapplicationservice.service.DataService [1207]",
"markedAsDeleted": false,
"taskVariable": false,
"_links": {
"self": {
"href": "http://myserver:8884/v1/variables/18"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 19,
"type": "string",
"name": "logmessage",
"processInstanceId": "750f8cf1-61e1-11e9-84b3-0242ac130002",
"createTime": "2019-04-18T13:54:17.111+0000",
"lastUpdatedTime": "2019-04-18T13:54:17.111+0000",
"value": "Successfull PUT /application/oracle/update/common/F/application_common/tblm_commoncodeheader/1144/1-986-227",
"markedAsDeleted": false,
"taskVariable": false,
"_links": {
"self": {
"href": "http://myserver:8884/v1/variables/19"
}
}
}
]
},
"_links": {
"self": {
"href": "http://myserver:8884/v1/process-instances/750f8cf1-61e1-11e9-84b3-0242ac130002/variables/?page=0&size=100"
}
},
"page": {
"size": 100,
"totalElements": 19,
"totalPages": 1,
"number": 0
}
}
But I really love to use the graphql for performance and simplification of our queries (filter, sorting, etc).
Regards
alaksmana
on 21 Apr 2019
@alaksmana Thank you for providing details. I have tested GraphQL query with both activiti/activiti-cloud-notifications-graphql:7.0.0.SR1 and activiti/activiti-cloud-notifications-graphql:7.1.58.
If I start the process with POST to http://{{activiti-cloud-gateway}}/{{rb-my-app}}/v1/process-instances and the following payload:
{
"processDefinitionKey": "SimpleProcess",
"businessKey" : "8",
"name": "Simple Process with Task",
"payloadType":"StartProcessPayload",
"variables": {
"customerEntity" : {
"id": 8,
"firstName": "John",
"middleName": "m",
"lastName": "Doe",
"accountNumber": "1234",
"country": "USA",
"email": "[email protected]"
}
}
}
And then run your query from GraphiQL App: http://activiti-cloud-gateway-host/graphiql :
query {
ProcessInstances(where: {
OR: {
status: { IN: RUNNING }
}
}) {
select {
id
status
variables{
name
value
}
}
}
}
I get the following response with process variables:
{
"data": {
"ProcessInstances": {
"select": [
{
"id": "ffbd6e7d-63d1-11e9-8b15-0a580a08026f",
"status": "RUNNING",
"variables": [
{
"name": "customerEntity",
"value": {
"id": 8,
"firstName": "John",
"middleName": "m",
"lastName": "Doe",
"accountNumber": "1234",
"country": "USA",
"email": "[email protected]"
}
}
]
}
]
}
}
}
Are you converting your Document into Map to invoke runtimeService.startProcessInstanceByKey?
igdianov
on 21 Apr 2019
@igdianov. Thanks for your reply.
I did not convert org.bson.Document to Map because Document implements Map
Another difference is I use the Activiti RuntimeProcess object to start my process when you use the API of the runtime bundle instead of the RuntimeProcess. I can try that as well.
Why I use the above ways of invoking the process start is because I follow the TTC blueprint. But yes I did not use Map. But its working and so far so good. Only the graphql is not coming out with the variables.
I will first try changing Document to Map.
Then If not working I will try start the process using the REST api of runtime bundle instead of the object RuntimeProcess.
Regards
alaksmana
on 21 Apr 2019
@alaksmana Try to convert your Bson Document to Map first.
Also, you are using Rb Rest Api to get variables from running process instance. But GraphQL uses Query service Posgresql database to get the aggregated data optimized for queries. The Query service aggregates the events from Rb and updates the Postgres query data entities to provide eventual consistency for queries.
Can you check Query service logs and try to use Query Rest Api to retrieve the variables for your process instance:
GET http://{{activiti-cloud-gateway}}/query/v1/process-instances/{{processInstanceId}}/variables
igdianov
on 21 Apr 2019
@igdianov. Thank you for your reply.
I use the rb to start process. Approve. And end.
But i actually use the query service to get variables and their values.
I had put the results from query service.
https://github.com/Activiti/Activiti/issues/2710#issuecomment-485195331
alaksmana
on 21 Apr 2019
@alaksmana I had used runtimeService to start a process with variables and then query them via graphql. My guts feeling is that Bson Document is the problem. Try to start the process via Rest Api to see if it helps
igdianov
on 21 Apr 2019
@igdianov I have tried changing from Document to Map. It has the same result.
I use the runtimeService to start the process with Map
Query
query {
ProcessInstances(where: {
OR: {
status: { IN: RUNNING }
}
}) {
select {
id
status
variables{
name
value
}
}
}
}
Result
{
"data": {
"ProcessInstances": {
"select": [
{
"id": "750f8cf1-61e1-11e9-84b3-0242ac130002",
"status": "RUNNING",
"variables": []
},
{
"id": "d2de1855-64cb-11e9-bc10-0242ac130016",
"status": "RUNNING",
"variables": []
}
]
}
}
}
If I use the Query service it returns all variables nicely. Below is the result from Query Service:
{
"_embedded": {
"variables": [
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 2199,
"type": "string",
"name": "useragent",
"processInstanceId": "d2de1855-64cb-11e9-bc10-0242ac130016",
"createTime": "2019-04-22T06:56:59.049+0000",
"lastUpdatedTime": "2019-04-22T06:56:59.049+0000",
"value": "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:66.0) Gecko/20100101 Firefox/66.0",
"markedAsDeleted": false,
"taskVariable": false,
"_links": {
"self": {
"href": "http://myserver:8884/v1/variables/2199"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 2200,
"type": "string",
"name": "formname",
"processInstanceId": "d2de1855-64cb-11e9-bc10-0242ac130016",
"createTime": "2019-04-22T06:56:59.049+0000",
"lastUpdatedTime": "2019-04-22T06:56:59.049+0000",
"value": "CommonCodeHeader",
"markedAsDeleted": false,
"taskVariable": false,
"_links": {
"self": {
"href": "http://myserver:8884/v1/variables/2200"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 2201,
"type": "string",
"name": "logmessage",
"processInstanceId": "d2de1855-64cb-11e9-bc10-0242ac130016",
"createTime": "2019-04-22T06:56:59.049+0000",
"lastUpdatedTime": "2019-04-22T06:56:59.049+0000",
"value": "Successfull DELETE /myapplication/oracle/delete/common/F/myapplication_common/tblm_commoncodeheader/151/1-986-227",
"markedAsDeleted": false,
"taskVariable": false,
"_links": {
"self": {
"href": "http://myserver:8884/v1/variables/2201"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 2202,
"type": "string",
"name": "type",
"processInstanceId": "d2de1855-64cb-11e9-bc10-0242ac130016",
"createTime": "2019-04-22T06:56:59.049+0000",
"lastUpdatedTime": "2019-04-22T06:56:59.049+0000",
"value": "approval",
"markedAsDeleted": false,
"taskVariable": false,
"_links": {
"self": {
"href": "http://myserver:8884/v1/variables/2202"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 2203,
"type": "string",
"name": "logsource",
"processInstanceId": "d2de1855-64cb-11e9-bc10-0242ac130016",
"createTime": "2019-04-22T06:56:59.049+0000",
"lastUpdatedTime": "2019-04-22T06:56:59.049+0000",
"value": "com.mycompany.rnd.bali.datamyapplicationservice.service.DataService [1914]",
"markedAsDeleted": false,
"taskVariable": false,
"_links": {
"self": {
"href": "http://myserver:8884/v1/variables/2203"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 2204,
"type": "string",
"name": "requestor",
"processInstanceId": "d2de1855-64cb-11e9-bc10-0242ac130016",
"createTime": "2019-04-22T06:56:59.050+0000",
"lastUpdatedTime": "2019-04-22T06:56:59.050+0000",
"value": "16033377-5d7e-44b2-b87b-4ac70617ff42",
"markedAsDeleted": false,
"taskVariable": false,
"_links": {
"self": {
"href": "http://myserver:8884/v1/variables/2204"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 2205,
"type": "string",
"name": "database",
"processInstanceId": "d2de1855-64cb-11e9-bc10-0242ac130016",
"createTime": "2019-04-22T06:56:59.050+0000",
"lastUpdatedTime": "2019-04-22T06:56:59.050+0000",
"value": "myapplication_common",
"markedAsDeleted": false,
"taskVariable": false,
"_links": {
"self": {
"href": "http://myserver:8884/v1/variables/2205"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 2206,
"type": "string",
"name": "formcode",
"processInstanceId": "d2de1855-64cb-11e9-bc10-0242ac130016",
"createTime": "2019-04-22T06:56:59.050+0000",
"lastUpdatedTime": "2019-04-22T06:56:59.050+0000",
"value": "common",
"markedAsDeleted": false,
"taskVariable": false,
"_links": {
"self": {
"href": "http://myserver:8884/v1/variables/2206"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 2207,
"type": "string",
"name": "approvaltype",
"processInstanceId": "d2de1855-64cb-11e9-bc10-0242ac130016",
"createTime": "2019-04-22T06:56:59.050+0000",
"lastUpdatedTime": "2019-04-22T06:56:59.050+0000",
"value": "singleapprover",
"markedAsDeleted": false,
"taskVariable": false,
"_links": {
"self": {
"href": "http://myserver:8884/v1/variables/2207"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 2208,
"type": "json",
"name": "databefore",
"processInstanceId": "d2de1855-64cb-11e9-bc10-0242ac130016",
"createTime": "2019-04-22T06:56:59.053+0000",
"lastUpdatedTime": "2019-04-22T06:56:59.053+0000",
"value": {
"data": [
{
"commoncode": "AP013_XX",
"countryid": "ID",
"moduleid": "LHBU",
"commonname": "Upload Form Web Path LHBU",
"commondesc": "Upload Form LHBU Web Path",
"commonusage": "\\\\150.14.45.206\\airr\\DATAMODEL\\TEXTFILE\\",
"type": "S",
"formattype": " ",
"createddate": "2012-06-03T00:00:00Z",
"pkid": 151
}
],
"error": "java.lang.NullPointerException"
},
"markedAsDeleted": false,
"taskVariable": false,
"_links": {
"self": {
"href": "http://myserver:8884/v1/variables/2208"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 2209,
"type": "string",
"name": "remotehost",
"processInstanceId": "d2de1855-64cb-11e9-bc10-0242ac130016",
"createTime": "2019-04-22T06:56:59.053+0000",
"lastUpdatedTime": "2019-04-22T06:56:59.053+0000",
"value": "172.19.0.7",
"markedAsDeleted": false,
"taskVariable": false,
"_links": {
"self": {
"href": "http://myserver:8884/v1/variables/2209"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 2210,
"type": "string",
"name": "name",
"processInstanceId": "d2de1855-64cb-11e9-bc10-0242ac130016",
"createTime": "2019-04-22T06:56:59.053+0000",
"lastUpdatedTime": "2019-04-22T06:56:59.053+0000",
"value": "jobname",
"markedAsDeleted": false,
"taskVariable": false,
"_links": {
"self": {
"href": "http://myserver:8884/v1/variables/2210"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 2211,
"type": "string",
"name": "querytoexecute",
"processInstanceId": "d2de1855-64cb-11e9-bc10-0242ac130016",
"createTime": "2019-04-22T06:56:59.053+0000",
"lastUpdatedTime": "2019-04-22T06:56:59.053+0000",
"value": "delete from tblm_commoncodeheader where pkid=151",
"markedAsDeleted": false,
"taskVariable": false,
"_links": {
"self": {
"href": "http://myserver:8884/v1/variables/2211"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 2212,
"type": "string",
"name": "fileimportlink",
"processInstanceId": "d2de1855-64cb-11e9-bc10-0242ac130016",
"createTime": "2019-04-22T06:56:59.053+0000",
"lastUpdatedTime": "2019-04-22T06:56:59.053+0000",
"value": "na",
"markedAsDeleted": false,
"taskVariable": false,
"_links": {
"self": {
"href": "http://myserver:8884/v1/variables/2212"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 2213,
"type": "string",
"name": "tablename",
"processInstanceId": "d2de1855-64cb-11e9-bc10-0242ac130016",
"createTime": "2019-04-22T06:56:59.053+0000",
"lastUpdatedTime": "2019-04-22T06:56:59.053+0000",
"value": "tblm_commoncodeheader",
"markedAsDeleted": false,
"taskVariable": false,
"_links": {
"self": {
"href": "http://myserver:8884/v1/variables/2213"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 2214,
"type": "string",
"name": "moduleid",
"processInstanceId": "d2de1855-64cb-11e9-bc10-0242ac130016",
"createTime": "2019-04-22T06:56:59.053+0000",
"lastUpdatedTime": "2019-04-22T06:56:59.053+0000",
"value": "ADMIN",
"markedAsDeleted": false,
"taskVariable": false,
"_links": {
"self": {
"href": "http://myserver:8884/v1/variables/2214"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 2215,
"type": "string",
"name": "querytype",
"processInstanceId": "d2de1855-64cb-11e9-bc10-0242ac130016",
"createTime": "2019-04-22T06:56:59.054+0000",
"lastUpdatedTime": "2019-04-22T06:56:59.054+0000",
"value": "delete",
"markedAsDeleted": false,
"taskVariable": false,
"_links": {
"self": {
"href": "http://myserver:8884/v1/variables/2215"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 2216,
"type": "string",
"name": "username",
"processInstanceId": "d2de1855-64cb-11e9-bc10-0242ac130016",
"createTime": "2019-04-22T06:56:59.054+0000",
"lastUpdatedTime": "2019-04-22T06:56:59.054+0000",
"value": "idamluqmana",
"markedAsDeleted": false,
"taskVariable": false,
"_links": {
"self": {
"href": "http://myserver:8884/v1/variables/2216"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 2217,
"type": "string",
"name": "dataafter",
"processInstanceId": "d2de1855-64cb-11e9-bc10-0242ac130016",
"createTime": "2019-04-22T06:56:59.054+0000",
"lastUpdatedTime": "2019-04-22T06:56:59.054+0000",
"value": "na",
"markedAsDeleted": false,
"taskVariable": false,
"_links": {
"self": {
"href": "http://myserver:8884/v1/variables/2217"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 2218,
"type": "string",
"name": "approverlist",
"processInstanceId": "d2de1855-64cb-11e9-bc10-0242ac130016",
"createTime": "2019-04-22T06:57:00.515+0000",
"lastUpdatedTime": "2019-04-22T06:57:00.515+0000",
"value": "{ \"user_id\" : \"16033377-5d7e-44b2-b87b-4ac70617ff42\", \"user_name\" : \"idamluqmana\", \"user_firstname\" : \"Idam\", \"user_lastname\" : \"Luqmana\", \"user_email\" : \"[email protected]\", \"user_approvaltype\" : \"singleapprover\", \"approval-list\" : [{ \"user_approve_id\" : \"16033377-5d7e-44b2-b87b-4ac70617ff42\", \"user_approve_name\" : \"idamluqmana\", \"user_approve_firstname\" : \"Idam\", \"user_approve_lastname\" : \"Luqmana\", \"user_approve_email\" : \"[email protected]\" }], \"branch-list\" : [] }",
"markedAsDeleted": false,
"taskVariable": false,
"_links": {
"self": {
"href": "http://myserver:8884/v1/variables/2218"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 2219,
"type": "string",
"name": "requestorinfo",
"processInstanceId": "d2de1855-64cb-11e9-bc10-0242ac130016",
"createTime": "2019-04-22T06:57:00.515+0000",
"lastUpdatedTime": "2019-04-22T06:57:00.515+0000",
"value": "{ \"user_id\" : \"16033377-5d7e-44b2-b87b-4ac70617ff42\", \"user_name\" : \"idamluqmana\", \"user_firstname\" : \"Idam\", \"user_lastname\" : \"Luqmana\", \"user_email\" : \"[email protected]\" }",
"markedAsDeleted": false,
"taskVariable": false,
"_links": {
"self": {
"href": "http://myserver:8884/v1/variables/2219"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 2220,
"type": "string",
"name": "approvermailstatus0",
"processInstanceId": "d2de1855-64cb-11e9-bc10-0242ac130016",
"createTime": "2019-04-22T06:57:04.660+0000",
"lastUpdatedTime": "2019-04-22T06:57:04.660+0000",
"value": "{\"mailok\":true,\"message\":\"org.springframework.mail.javamail.SmartMimeMessage@10f8ebf8\"}",
"markedAsDeleted": false,
"taskVariable": false,
"_links": {
"self": {
"href": "http://myserver:8884/v1/variables/2220"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 2221,
"type": "string",
"name": "approvermailstatus0",
"processInstanceId": "d2de1855-64cb-11e9-bc10-0242ac130016",
"taskId": "d637cabf-64cb-11e9-bc10-0242ac130016",
"createTime": "2019-04-22T06:57:04.665+0000",
"lastUpdatedTime": "2019-04-22T06:57:04.665+0000",
"value": "{\"mailok\":true,\"message\":\"org.springframework.mail.javamail.SmartMimeMessage@10f8ebf8\"}",
"markedAsDeleted": false,
"taskVariable": true,
"_links": {
"self": {
"href": "http://myserver:8884/v1/variables/2221"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 2222,
"type": "string",
"name": "useragent",
"processInstanceId": "d2de1855-64cb-11e9-bc10-0242ac130016",
"taskId": "d637cabf-64cb-11e9-bc10-0242ac130016",
"createTime": "2019-04-22T06:57:04.665+0000",
"lastUpdatedTime": "2019-04-22T06:57:04.665+0000",
"value": "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:66.0) Gecko/20100101 Firefox/66.0",
"markedAsDeleted": false,
"taskVariable": true,
"_links": {
"self": {
"href": "http://myserver:8884/v1/variables/2222"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 2223,
"type": "string",
"name": "formname",
"processInstanceId": "d2de1855-64cb-11e9-bc10-0242ac130016",
"taskId": "d637cabf-64cb-11e9-bc10-0242ac130016",
"createTime": "2019-04-22T06:57:04.665+0000",
"lastUpdatedTime": "2019-04-22T06:57:04.665+0000",
"value": "CommonCodeHeader",
"markedAsDeleted": false,
"taskVariable": true,
"_links": {
"self": {
"href": "http://myserver:8884/v1/variables/2223"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 2224,
"type": "string",
"name": "logmessage",
"processInstanceId": "d2de1855-64cb-11e9-bc10-0242ac130016",
"taskId": "d637cabf-64cb-11e9-bc10-0242ac130016",
"createTime": "2019-04-22T06:57:04.665+0000",
"lastUpdatedTime": "2019-04-22T06:57:04.665+0000",
"value": "Successfull DELETE /myapplication/oracle/delete/common/F/myapplication_common/tblm_commoncodeheader/151/1-986-227",
"markedAsDeleted": false,
"taskVariable": true,
"_links": {
"self": {
"href": "http://myserver:8884/v1/variables/2224"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 2225,
"type": "string",
"name": "type",
"processInstanceId": "d2de1855-64cb-11e9-bc10-0242ac130016",
"taskId": "d637cabf-64cb-11e9-bc10-0242ac130016",
"createTime": "2019-04-22T06:57:04.665+0000",
"lastUpdatedTime": "2019-04-22T06:57:04.665+0000",
"value": "approval",
"markedAsDeleted": false,
"taskVariable": true,
"_links": {
"self": {
"href": "http://myserver:8884/v1/variables/2225"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 2226,
"type": "string",
"name": "logsource",
"processInstanceId": "d2de1855-64cb-11e9-bc10-0242ac130016",
"taskId": "d637cabf-64cb-11e9-bc10-0242ac130016",
"createTime": "2019-04-22T06:57:04.665+0000",
"lastUpdatedTime": "2019-04-22T06:57:04.665+0000",
"value": "com.mycompany.rnd.bali.datamyapplicationservice.service.DataService [1914]",
"markedAsDeleted": false,
"taskVariable": true,
"_links": {
"self": {
"href": "http://myserver:8884/v1/variables/2226"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 2227,
"type": "string",
"name": "requestorinfo",
"processInstanceId": "d2de1855-64cb-11e9-bc10-0242ac130016",
"taskId": "d637cabf-64cb-11e9-bc10-0242ac130016",
"createTime": "2019-04-22T06:57:04.665+0000",
"lastUpdatedTime": "2019-04-22T06:57:04.665+0000",
"value": "{ \"user_id\" : \"16033377-5d7e-44b2-b87b-4ac70617ff42\", \"user_name\" : \"idamluqmana\", \"user_firstname\" : \"Idam\", \"user_lastname\" : \"Luqmana\", \"user_email\" : \"[email protected]\" }",
"markedAsDeleted": false,
"taskVariable": true,
"_links": {
"self": {
"href": "http://myserver:8884/v1/variables/2227"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 2228,
"type": "string",
"name": "requestor",
"processInstanceId": "d2de1855-64cb-11e9-bc10-0242ac130016",
"taskId": "d637cabf-64cb-11e9-bc10-0242ac130016",
"createTime": "2019-04-22T06:57:04.665+0000",
"lastUpdatedTime": "2019-04-22T06:57:04.665+0000",
"value": "16033377-5d7e-44b2-b87b-4ac70617ff42",
"markedAsDeleted": false,
"taskVariable": true,
"_links": {
"self": {
"href": "http://myserver:8884/v1/variables/2228"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 2229,
"type": "string",
"name": "approverlist",
"processInstanceId": "d2de1855-64cb-11e9-bc10-0242ac130016",
"taskId": "d637cabf-64cb-11e9-bc10-0242ac130016",
"createTime": "2019-04-22T06:57:04.666+0000",
"lastUpdatedTime": "2019-04-22T06:57:04.666+0000",
"value": "{ \"user_id\" : \"16033377-5d7e-44b2-b87b-4ac70617ff42\", \"user_name\" : \"idamluqmana\", \"user_firstname\" : \"Idam\", \"user_lastname\" : \"Luqmana\", \"user_email\" : \"[email protected]\", \"user_approvaltype\" : \"singleapprover\", \"approval-list\" : [{ \"user_approve_id\" : \"16033377-5d7e-44b2-b87b-4ac70617ff42\", \"user_approve_name\" : \"idamluqmana\", \"user_approve_firstname\" : \"Idam\", \"user_approve_lastname\" : \"Luqmana\", \"user_approve_email\" : \"[email protected]\" }], \"branch-list\" : [] }",
"markedAsDeleted": false,
"taskVariable": true,
"_links": {
"self": {
"href": "http://myserver:8884/v1/variables/2229"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 2230,
"type": "string",
"name": "database",
"processInstanceId": "d2de1855-64cb-11e9-bc10-0242ac130016",
"taskId": "d637cabf-64cb-11e9-bc10-0242ac130016",
"createTime": "2019-04-22T06:57:04.666+0000",
"lastUpdatedTime": "2019-04-22T06:57:04.666+0000",
"value": "myapplication_common",
"markedAsDeleted": false,
"taskVariable": true,
"_links": {
"self": {
"href": "http://myserver:8884/v1/variables/2230"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 2231,
"type": "string",
"name": "formcode",
"processInstanceId": "d2de1855-64cb-11e9-bc10-0242ac130016",
"taskId": "d637cabf-64cb-11e9-bc10-0242ac130016",
"createTime": "2019-04-22T06:57:04.666+0000",
"lastUpdatedTime": "2019-04-22T06:57:04.666+0000",
"value": "common",
"markedAsDeleted": false,
"taskVariable": true,
"_links": {
"self": {
"href": "http://myserver:8884/v1/variables/2231"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 2232,
"type": "string",
"name": "remotehost",
"processInstanceId": "d2de1855-64cb-11e9-bc10-0242ac130016",
"taskId": "d637cabf-64cb-11e9-bc10-0242ac130016",
"createTime": "2019-04-22T06:57:04.666+0000",
"lastUpdatedTime": "2019-04-22T06:57:04.666+0000",
"value": "172.19.0.7",
"markedAsDeleted": false,
"taskVariable": true,
"_links": {
"self": {
"href": "http://myserver:8884/v1/variables/2232"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 2233,
"type": "json",
"name": "databefore",
"processInstanceId": "d2de1855-64cb-11e9-bc10-0242ac130016",
"taskId": "d637cabf-64cb-11e9-bc10-0242ac130016",
"createTime": "2019-04-22T06:57:04.667+0000",
"lastUpdatedTime": "2019-04-22T06:57:04.667+0000",
"value": {
"data": [
{
"commoncode": "AP013_XX",
"countryid": "ID",
"moduleid": "LHBU",
"commonname": "Upload Form Web Path LHBU",
"commondesc": "Upload Form LHBU Web Path",
"commonusage": "\\\\150.14.45.206\\airr\\DATAMODEL\\TEXTFILE\\",
"type": "S",
"formattype": " ",
"createddate": "2012-06-03T00:00:00Z",
"pkid": 151
}
],
"error": "java.lang.NullPointerException"
},
"markedAsDeleted": false,
"taskVariable": true,
"_links": {
"self": {
"href": "http://myserver:8884/v1/variables/2233"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 2234,
"type": "string",
"name": "approvaltype",
"processInstanceId": "d2de1855-64cb-11e9-bc10-0242ac130016",
"taskId": "d637cabf-64cb-11e9-bc10-0242ac130016",
"createTime": "2019-04-22T06:57:04.667+0000",
"lastUpdatedTime": "2019-04-22T06:57:04.667+0000",
"value": "singleapprover",
"markedAsDeleted": false,
"taskVariable": true,
"_links": {
"self": {
"href": "http://myserver:8884/v1/variables/2234"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 2235,
"type": "string",
"name": "querytoexecute",
"processInstanceId": "d2de1855-64cb-11e9-bc10-0242ac130016",
"taskId": "d637cabf-64cb-11e9-bc10-0242ac130016",
"createTime": "2019-04-22T06:57:04.667+0000",
"lastUpdatedTime": "2019-04-22T06:57:04.667+0000",
"value": "delete from tblm_commoncodeheader where pkid=151",
"markedAsDeleted": false,
"taskVariable": true,
"_links": {
"self": {
"href": "http://myserver:8884/v1/variables/2235"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 2236,
"type": "string",
"name": "name",
"processInstanceId": "d2de1855-64cb-11e9-bc10-0242ac130016",
"taskId": "d637cabf-64cb-11e9-bc10-0242ac130016",
"createTime": "2019-04-22T06:57:04.667+0000",
"lastUpdatedTime": "2019-04-22T06:57:04.667+0000",
"value": "jobname",
"markedAsDeleted": false,
"taskVariable": true,
"_links": {
"self": {
"href": "http://myserver:8884/v1/variables/2236"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 2237,
"type": "string",
"name": "fileimportlink",
"processInstanceId": "d2de1855-64cb-11e9-bc10-0242ac130016",
"taskId": "d637cabf-64cb-11e9-bc10-0242ac130016",
"createTime": "2019-04-22T06:57:04.667+0000",
"lastUpdatedTime": "2019-04-22T06:57:04.667+0000",
"value": "na",
"markedAsDeleted": false,
"taskVariable": true,
"_links": {
"self": {
"href": "http://myserver:8884/v1/variables/2237"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 2238,
"type": "string",
"name": "tablename",
"processInstanceId": "d2de1855-64cb-11e9-bc10-0242ac130016",
"taskId": "d637cabf-64cb-11e9-bc10-0242ac130016",
"createTime": "2019-04-22T06:57:04.667+0000",
"lastUpdatedTime": "2019-04-22T06:57:04.667+0000",
"value": "tblm_commoncodeheader",
"markedAsDeleted": false,
"taskVariable": true,
"_links": {
"self": {
"href": "http://myserver:8884/v1/variables/2238"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 2239,
"type": "string",
"name": "moduleid",
"processInstanceId": "d2de1855-64cb-11e9-bc10-0242ac130016",
"taskId": "d637cabf-64cb-11e9-bc10-0242ac130016",
"createTime": "2019-04-22T06:57:04.667+0000",
"lastUpdatedTime": "2019-04-22T06:57:04.667+0000",
"value": "ADMIN",
"markedAsDeleted": false,
"taskVariable": true,
"_links": {
"self": {
"href": "http://myserver:8884/v1/variables/2239"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 2240,
"type": "string",
"name": "querytype",
"processInstanceId": "d2de1855-64cb-11e9-bc10-0242ac130016",
"taskId": "d637cabf-64cb-11e9-bc10-0242ac130016",
"createTime": "2019-04-22T06:57:04.667+0000",
"lastUpdatedTime": "2019-04-22T06:57:04.667+0000",
"value": "delete",
"markedAsDeleted": false,
"taskVariable": true,
"_links": {
"self": {
"href": "http://myserver:8884/v1/variables/2240"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 2241,
"type": "string",
"name": "username",
"processInstanceId": "d2de1855-64cb-11e9-bc10-0242ac130016",
"taskId": "d637cabf-64cb-11e9-bc10-0242ac130016",
"createTime": "2019-04-22T06:57:04.668+0000",
"lastUpdatedTime": "2019-04-22T06:57:04.668+0000",
"value": "idamluqmana",
"markedAsDeleted": false,
"taskVariable": true,
"_links": {
"self": {
"href": "http://myserver:8884/v1/variables/2241"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 2242,
"type": "string",
"name": "dataafter",
"processInstanceId": "d2de1855-64cb-11e9-bc10-0242ac130016",
"taskId": "d637cabf-64cb-11e9-bc10-0242ac130016",
"createTime": "2019-04-22T06:57:04.668+0000",
"lastUpdatedTime": "2019-04-22T06:57:04.668+0000",
"value": "na",
"markedAsDeleted": false,
"taskVariable": true,
"_links": {
"self": {
"href": "http://myserver:8884/v1/variables/2242"
}
}
}
]
},
"_links": {
"self": {
"href": "http://myserver:8884/v1/process-instances/d2de1855-64cb-11e9-bc10-0242ac130016/variables?page=0&size=100"
}
},
"page": {
"size": 100,
"totalElements": 44,
"totalPages": 1,
"number": 0
}
}
@igdianov I just tested using the RB API to start process with below payload:
{
"processDefinitionKey": "singleapprover",
"businessKey" : "approval",
"name": "approval-service",
"payloadType":"StartProcessPayload",
"variables": {
"name" : "jobname",
"type" : "approval",
"approvaltype" : "singleapprover",
"requestor" : "2caf29e4-fefb-4715-a4b4-2e55589aa541",
"username" : "andrelaksmana",
"databefore" : {
"commoncode": "XTEST",
"moduleid": "LBU",
"parentcode": "XTEST",
"commonname": "XTEST",
"commondesc": "XTEST",
"commonusage": "XTEST",
"pkid": 1144
},
"dataafter" : {
"commoncode": "XTEST",
"moduleid": "LBU",
"parentcode": "XTEST1",
"commonname": "XTEST1",
"commondesc": "XTEST1",
"commonusage": "XTEST1"
},
"querytype" : "update",
"querytoexecute" : "update tblm_commoncodeheader set commoncode='XTEST' , moduleid='LBU' , parentcode='XTEST1' , commonname='XTEST1' , commondesc='XTEST1' , commonusage='XTEST1' where pkid=1144",
"fileimportlink" : "na",
"database" : "myapplication_common",
"useragent" : "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36",
"remotehost" : "172.19.0.7",
"tablename" : "tblm_commoncodeheader",
"formcode" : "common",
"formname" : "CommonCodeHeader",
"moduleid" : "ADMIN",
"logsource" : "com.mycompany.rnd.bali.datamyapplicationservice.service.DataService [1207]",
"logmessage" : "Successfull PUT /myapplication/oracle/update/common/F/myapplication_common/tblm_commoncodeheader/1144/1-986-227"
}
}
It starts the process instance nicely.
However, when I query with graphql, it still returns [] variables:
{
"data": {
"ProcessInstances": {
"select": [
{
"id": "750f8cf1-61e1-11e9-84b3-0242ac130002",
"status": "RUNNING",
"variables": []
},
{
"id": "d80465ff-64d1-11e9-bc10-0242ac130016",
"status": "RUNNING",
"variables": []
}
]
}
}
}
and I can successfully query variables using Query Service:
{
"_embedded": {
"variables": [
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 2301,
"type": "string",
"name": "useragent",
"processInstanceId": "d80465ff-64d1-11e9-bc10-0242ac130016",
"createTime": "2019-04-22T07:40:04.663+0000",
"lastUpdatedTime": "2019-04-22T07:40:04.663+0000",
"value": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36",
"markedAsDeleted": false,
"taskVariable": false,
"_links": {
"self": {
"href": "http://keycloak:8884/v1/variables/2301"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 2302,
"type": "string",
"name": "formname",
"processInstanceId": "d80465ff-64d1-11e9-bc10-0242ac130016",
"createTime": "2019-04-22T07:40:04.663+0000",
"lastUpdatedTime": "2019-04-22T07:40:04.663+0000",
"value": "CommonCodeHeader",
"markedAsDeleted": false,
"taskVariable": false,
"_links": {
"self": {
"href": "http://keycloak:8884/v1/variables/2302"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 2303,
"type": "string",
"name": "logmessage",
"processInstanceId": "d80465ff-64d1-11e9-bc10-0242ac130016",
"createTime": "2019-04-22T07:40:04.663+0000",
"lastUpdatedTime": "2019-04-22T07:40:04.663+0000",
"value": "Successfull PUT /regla/oracle/update/common/F/regla_common/tblm_commoncodeheader/1144/1-986-227",
"markedAsDeleted": false,
"taskVariable": false,
"_links": {
"self": {
"href": "http://keycloak:8884/v1/variables/2303"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 2304,
"type": "string",
"name": "type",
"processInstanceId": "d80465ff-64d1-11e9-bc10-0242ac130016",
"createTime": "2019-04-22T07:40:04.663+0000",
"lastUpdatedTime": "2019-04-22T07:40:04.663+0000",
"value": "approval",
"markedAsDeleted": false,
"taskVariable": false,
"_links": {
"self": {
"href": "http://keycloak:8884/v1/variables/2304"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 2305,
"type": "string",
"name": "logsource",
"processInstanceId": "d80465ff-64d1-11e9-bc10-0242ac130016",
"createTime": "2019-04-22T07:40:04.663+0000",
"lastUpdatedTime": "2019-04-22T07:40:04.663+0000",
"value": "com.emerio.rnd.bali.datareglaservice.service.DataService [1207]",
"markedAsDeleted": false,
"taskVariable": false,
"_links": {
"self": {
"href": "http://keycloak:8884/v1/variables/2305"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 2306,
"type": "string",
"name": "requestor",
"processInstanceId": "d80465ff-64d1-11e9-bc10-0242ac130016",
"createTime": "2019-04-22T07:40:04.663+0000",
"lastUpdatedTime": "2019-04-22T07:40:04.663+0000",
"value": "2caf29e4-fefb-4715-a4b4-2e55589aa541",
"markedAsDeleted": false,
"taskVariable": false,
"_links": {
"self": {
"href": "http://keycloak:8884/v1/variables/2306"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 2307,
"type": "string",
"name": "database",
"processInstanceId": "d80465ff-64d1-11e9-bc10-0242ac130016",
"createTime": "2019-04-22T07:40:04.664+0000",
"lastUpdatedTime": "2019-04-22T07:40:04.664+0000",
"value": "regla_common",
"markedAsDeleted": false,
"taskVariable": false,
"_links": {
"self": {
"href": "http://keycloak:8884/v1/variables/2307"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 2308,
"type": "string",
"name": "formcode",
"processInstanceId": "d80465ff-64d1-11e9-bc10-0242ac130016",
"createTime": "2019-04-22T07:40:04.664+0000",
"lastUpdatedTime": "2019-04-22T07:40:04.664+0000",
"value": "common",
"markedAsDeleted": false,
"taskVariable": false,
"_links": {
"self": {
"href": "http://keycloak:8884/v1/variables/2308"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 2309,
"type": "string",
"name": "approvaltype",
"processInstanceId": "d80465ff-64d1-11e9-bc10-0242ac130016",
"createTime": "2019-04-22T07:40:04.664+0000",
"lastUpdatedTime": "2019-04-22T07:40:04.664+0000",
"value": "singleapprover",
"markedAsDeleted": false,
"taskVariable": false,
"_links": {
"self": {
"href": "http://keycloak:8884/v1/variables/2309"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 2310,
"type": "json",
"name": "databefore",
"processInstanceId": "d80465ff-64d1-11e9-bc10-0242ac130016",
"createTime": "2019-04-22T07:40:04.664+0000",
"lastUpdatedTime": "2019-04-22T07:40:04.664+0000",
"value": {
"commoncode": "XTEST",
"moduleid": "LBU",
"parentcode": "XTEST",
"commonname": "XTEST",
"commondesc": "XTEST",
"commonusage": "XTEST",
"pkid": 1144
},
"markedAsDeleted": false,
"taskVariable": false,
"_links": {
"self": {
"href": "http://keycloak:8884/v1/variables/2310"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 2311,
"type": "string",
"name": "remotehost",
"processInstanceId": "d80465ff-64d1-11e9-bc10-0242ac130016",
"createTime": "2019-04-22T07:40:04.664+0000",
"lastUpdatedTime": "2019-04-22T07:40:04.664+0000",
"value": "172.19.0.7",
"markedAsDeleted": false,
"taskVariable": false,
"_links": {
"self": {
"href": "http://keycloak:8884/v1/variables/2311"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 2312,
"type": "string",
"name": "name",
"processInstanceId": "d80465ff-64d1-11e9-bc10-0242ac130016",
"createTime": "2019-04-22T07:40:04.664+0000",
"lastUpdatedTime": "2019-04-22T07:40:04.664+0000",
"value": "jobname",
"markedAsDeleted": false,
"taskVariable": false,
"_links": {
"self": {
"href": "http://keycloak:8884/v1/variables/2312"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 2313,
"type": "string",
"name": "querytoexecute",
"processInstanceId": "d80465ff-64d1-11e9-bc10-0242ac130016",
"createTime": "2019-04-22T07:40:04.664+0000",
"lastUpdatedTime": "2019-04-22T07:40:04.664+0000",
"value": "update tblm_commoncodeheader set commoncode='XTEST' , moduleid='LBU' , parentcode='XTEST1' , commonname='XTEST1' , commondesc='XTEST1' , commonusage='XTEST1' where pkid=1144",
"markedAsDeleted": false,
"taskVariable": false,
"_links": {
"self": {
"href": "http://keycloak:8884/v1/variables/2313"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 2314,
"type": "string",
"name": "fileimportlink",
"processInstanceId": "d80465ff-64d1-11e9-bc10-0242ac130016",
"createTime": "2019-04-22T07:40:04.664+0000",
"lastUpdatedTime": "2019-04-22T07:40:04.664+0000",
"value": "na",
"markedAsDeleted": false,
"taskVariable": false,
"_links": {
"self": {
"href": "http://keycloak:8884/v1/variables/2314"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 2315,
"type": "string",
"name": "tablename",
"processInstanceId": "d80465ff-64d1-11e9-bc10-0242ac130016",
"createTime": "2019-04-22T07:40:04.664+0000",
"lastUpdatedTime": "2019-04-22T07:40:04.664+0000",
"value": "tblm_commoncodeheader",
"markedAsDeleted": false,
"taskVariable": false,
"_links": {
"self": {
"href": "http://keycloak:8884/v1/variables/2315"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 2316,
"type": "string",
"name": "moduleid",
"processInstanceId": "d80465ff-64d1-11e9-bc10-0242ac130016",
"createTime": "2019-04-22T07:40:04.665+0000",
"lastUpdatedTime": "2019-04-22T07:40:04.665+0000",
"value": "ADMIN",
"markedAsDeleted": false,
"taskVariable": false,
"_links": {
"self": {
"href": "http://keycloak:8884/v1/variables/2316"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 2317,
"type": "string",
"name": "querytype",
"processInstanceId": "d80465ff-64d1-11e9-bc10-0242ac130016",
"createTime": "2019-04-22T07:40:04.665+0000",
"lastUpdatedTime": "2019-04-22T07:40:04.665+0000",
"value": "update",
"markedAsDeleted": false,
"taskVariable": false,
"_links": {
"self": {
"href": "http://keycloak:8884/v1/variables/2317"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 2318,
"type": "string",
"name": "username",
"processInstanceId": "d80465ff-64d1-11e9-bc10-0242ac130016",
"createTime": "2019-04-22T07:40:04.665+0000",
"lastUpdatedTime": "2019-04-22T07:40:04.665+0000",
"value": "andrelaksmana",
"markedAsDeleted": false,
"taskVariable": false,
"_links": {
"self": {
"href": "http://keycloak:8884/v1/variables/2318"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 2319,
"type": "json",
"name": "dataafter",
"processInstanceId": "d80465ff-64d1-11e9-bc10-0242ac130016",
"createTime": "2019-04-22T07:40:04.665+0000",
"lastUpdatedTime": "2019-04-22T07:40:04.665+0000",
"value": {
"commoncode": "XTEST",
"moduleid": "LBU",
"parentcode": "XTEST1",
"commonname": "XTEST1",
"commondesc": "XTEST1",
"commonusage": "XTEST1"
},
"markedAsDeleted": false,
"taskVariable": false,
"_links": {
"self": {
"href": "http://keycloak:8884/v1/variables/2319"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 2320,
"type": "string",
"name": "approverlist",
"processInstanceId": "d80465ff-64d1-11e9-bc10-0242ac130016",
"createTime": "2019-04-22T07:40:04.878+0000",
"lastUpdatedTime": "2019-04-22T07:40:04.878+0000",
"value": "{ \"user_id\" : \"2caf29e4-fefb-4715-a4b4-2e55589aa541\", \"user_name\" : \"andrelaksmana\", \"user_firstname\" : \"andre\", \"user_lastname\" : \"laksmana\", \"user_email\" : \"[email protected]\", \"user_approvaltype\" : \"singleapprover\", \"approval-list\" : [{ \"user_approve_id\" : \"2caf29e4-fefb-4715-a4b4-2e55589aa541\", \"user_approve_name\" : \"andrelaksmana\", \"user_approve_firstname\" : \"andre\", \"user_approve_lastname\" : \"laksmana\", \"user_approve_email\" : \"[email protected]\" }, { \"user_approve_id\" : \"dca0b86e-dc46-45f8-972a-ca8978a0e19e\", \"user_approve_name\" : \"muftiramadhan\", \"user_approve_firstname\" : \"mufti\", \"user_approve_lastname\" : \"ramadhan\", \"user_approve_email\" : \"[email protected]\" }], \"branch-list\" : [] }",
"markedAsDeleted": false,
"taskVariable": false,
"_links": {
"self": {
"href": "http://keycloak:8884/v1/variables/2320"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 2321,
"type": "string",
"name": "requestorinfo",
"processInstanceId": "d80465ff-64d1-11e9-bc10-0242ac130016",
"createTime": "2019-04-22T07:40:04.878+0000",
"lastUpdatedTime": "2019-04-22T07:40:04.878+0000",
"value": "{ \"user_id\" : \"2caf29e4-fefb-4715-a4b4-2e55589aa541\", \"user_name\" : \"andrelaksmana\", \"user_firstname\" : \"andre\", \"user_lastname\" : \"laksmana\", \"user_email\" : \"[email protected]\" }",
"markedAsDeleted": false,
"taskVariable": false,
"_links": {
"self": {
"href": "http://keycloak:8884/v1/variables/2321"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 2322,
"type": "string",
"name": "approvermailstatus1",
"processInstanceId": "d80465ff-64d1-11e9-bc10-0242ac130016",
"createTime": "2019-04-22T07:40:12.398+0000",
"lastUpdatedTime": "2019-04-22T07:40:12.398+0000",
"value": "{\"mailok\":true,\"message\":\"org.springframework.mail.javamail.SmartMimeMessage@2665e330\"}",
"markedAsDeleted": false,
"taskVariable": false,
"_links": {
"self": {
"href": "http://keycloak:8884/v1/variables/2322"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 2323,
"type": "string",
"name": "approvermailstatus0",
"processInstanceId": "d80465ff-64d1-11e9-bc10-0242ac130016",
"createTime": "2019-04-22T07:40:12.398+0000",
"lastUpdatedTime": "2019-04-22T07:40:12.398+0000",
"value": "{\"mailok\":true,\"message\":\"org.springframework.mail.javamail.SmartMimeMessage@58c05a0e\"}",
"markedAsDeleted": false,
"taskVariable": false,
"_links": {
"self": {
"href": "http://keycloak:8884/v1/variables/2323"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 2324,
"type": "string",
"name": "approvermailstatus1",
"processInstanceId": "d80465ff-64d1-11e9-bc10-0242ac130016",
"taskId": "dca11fbb-64d1-11e9-bc10-0242ac130016",
"createTime": "2019-04-22T07:40:12.401+0000",
"lastUpdatedTime": "2019-04-22T07:40:12.401+0000",
"value": "{\"mailok\":true,\"message\":\"org.springframework.mail.javamail.SmartMimeMessage@2665e330\"}",
"markedAsDeleted": false,
"taskVariable": true,
"_links": {
"self": {
"href": "http://keycloak:8884/v1/variables/2324"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 2325,
"type": "string",
"name": "approvermailstatus0",
"processInstanceId": "d80465ff-64d1-11e9-bc10-0242ac130016",
"taskId": "dca11fbb-64d1-11e9-bc10-0242ac130016",
"createTime": "2019-04-22T07:40:12.401+0000",
"lastUpdatedTime": "2019-04-22T07:40:12.401+0000",
"value": "{\"mailok\":true,\"message\":\"org.springframework.mail.javamail.SmartMimeMessage@58c05a0e\"}",
"markedAsDeleted": false,
"taskVariable": true,
"_links": {
"self": {
"href": "http://keycloak:8884/v1/variables/2325"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 2326,
"type": "string",
"name": "useragent",
"processInstanceId": "d80465ff-64d1-11e9-bc10-0242ac130016",
"taskId": "dca11fbb-64d1-11e9-bc10-0242ac130016",
"createTime": "2019-04-22T07:40:12.401+0000",
"lastUpdatedTime": "2019-04-22T07:40:12.401+0000",
"value": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36",
"markedAsDeleted": false,
"taskVariable": true,
"_links": {
"self": {
"href": "http://keycloak:8884/v1/variables/2326"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 2327,
"type": "string",
"name": "logmessage",
"processInstanceId": "d80465ff-64d1-11e9-bc10-0242ac130016",
"taskId": "dca11fbb-64d1-11e9-bc10-0242ac130016",
"createTime": "2019-04-22T07:40:12.401+0000",
"lastUpdatedTime": "2019-04-22T07:40:12.401+0000",
"value": "Successfull PUT /regla/oracle/update/common/F/regla_common/tblm_commoncodeheader/1144/1-986-227",
"markedAsDeleted": false,
"taskVariable": true,
"_links": {
"self": {
"href": "http://keycloak:8884/v1/variables/2327"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 2328,
"type": "string",
"name": "formname",
"processInstanceId": "d80465ff-64d1-11e9-bc10-0242ac130016",
"taskId": "dca11fbb-64d1-11e9-bc10-0242ac130016",
"createTime": "2019-04-22T07:40:12.402+0000",
"lastUpdatedTime": "2019-04-22T07:40:12.402+0000",
"value": "CommonCodeHeader",
"markedAsDeleted": false,
"taskVariable": true,
"_links": {
"self": {
"href": "http://keycloak:8884/v1/variables/2328"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 2329,
"type": "string",
"name": "logsource",
"processInstanceId": "d80465ff-64d1-11e9-bc10-0242ac130016",
"taskId": "dca11fbb-64d1-11e9-bc10-0242ac130016",
"createTime": "2019-04-22T07:40:12.402+0000",
"lastUpdatedTime": "2019-04-22T07:40:12.402+0000",
"value": "com.emerio.rnd.bali.datareglaservice.service.DataService [1207]",
"markedAsDeleted": false,
"taskVariable": true,
"_links": {
"self": {
"href": "http://keycloak:8884/v1/variables/2329"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 2330,
"type": "string",
"name": "type",
"processInstanceId": "d80465ff-64d1-11e9-bc10-0242ac130016",
"taskId": "dca11fbb-64d1-11e9-bc10-0242ac130016",
"createTime": "2019-04-22T07:40:12.402+0000",
"lastUpdatedTime": "2019-04-22T07:40:12.402+0000",
"value": "approval",
"markedAsDeleted": false,
"taskVariable": true,
"_links": {
"self": {
"href": "http://keycloak:8884/v1/variables/2330"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 2331,
"type": "string",
"name": "approverlist",
"processInstanceId": "d80465ff-64d1-11e9-bc10-0242ac130016",
"taskId": "dca11fbb-64d1-11e9-bc10-0242ac130016",
"createTime": "2019-04-22T07:40:12.402+0000",
"lastUpdatedTime": "2019-04-22T07:40:12.402+0000",
"value": "{ \"user_id\" : \"2caf29e4-fefb-4715-a4b4-2e55589aa541\", \"user_name\" : \"andrelaksmana\", \"user_firstname\" : \"andre\", \"user_lastname\" : \"laksmana\", \"user_email\" : \"[email protected]\", \"user_approvaltype\" : \"singleapprover\", \"approval-list\" : [{ \"user_approve_id\" : \"2caf29e4-fefb-4715-a4b4-2e55589aa541\", \"user_approve_name\" : \"andrelaksmana\", \"user_approve_firstname\" : \"andre\", \"user_approve_lastname\" : \"laksmana\", \"user_approve_email\" : \"[email protected]\" }, { \"user_approve_id\" : \"dca0b86e-dc46-45f8-972a-ca8978a0e19e\", \"user_approve_name\" : \"muftiramadhan\", \"user_approve_firstname\" : \"mufti\", \"user_approve_lastname\" : \"ramadhan\", \"user_approve_email\" : \"[email protected]\" }], \"branch-list\" : [] }",
"markedAsDeleted": false,
"taskVariable": true,
"_links": {
"self": {
"href": "http://keycloak:8884/v1/variables/2331"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 2332,
"type": "string",
"name": "requestor",
"processInstanceId": "d80465ff-64d1-11e9-bc10-0242ac130016",
"taskId": "dca11fbb-64d1-11e9-bc10-0242ac130016",
"createTime": "2019-04-22T07:40:12.402+0000",
"lastUpdatedTime": "2019-04-22T07:40:12.402+0000",
"value": "2caf29e4-fefb-4715-a4b4-2e55589aa541",
"markedAsDeleted": false,
"taskVariable": true,
"_links": {
"self": {
"href": "http://keycloak:8884/v1/variables/2332"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 2333,
"type": "string",
"name": "requestorinfo",
"processInstanceId": "d80465ff-64d1-11e9-bc10-0242ac130016",
"taskId": "dca11fbb-64d1-11e9-bc10-0242ac130016",
"createTime": "2019-04-22T07:40:12.402+0000",
"lastUpdatedTime": "2019-04-22T07:40:12.402+0000",
"value": "{ \"user_id\" : \"2caf29e4-fefb-4715-a4b4-2e55589aa541\", \"user_name\" : \"andrelaksmana\", \"user_firstname\" : \"andre\", \"user_lastname\" : \"laksmana\", \"user_email\" : \"[email protected]\" }",
"markedAsDeleted": false,
"taskVariable": true,
"_links": {
"self": {
"href": "http://keycloak:8884/v1/variables/2333"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 2334,
"type": "string",
"name": "database",
"processInstanceId": "d80465ff-64d1-11e9-bc10-0242ac130016",
"taskId": "dca11fbb-64d1-11e9-bc10-0242ac130016",
"createTime": "2019-04-22T07:40:12.402+0000",
"lastUpdatedTime": "2019-04-22T07:40:12.402+0000",
"value": "regla_common",
"markedAsDeleted": false,
"taskVariable": true,
"_links": {
"self": {
"href": "http://keycloak:8884/v1/variables/2334"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 2335,
"type": "string",
"name": "formcode",
"processInstanceId": "d80465ff-64d1-11e9-bc10-0242ac130016",
"taskId": "dca11fbb-64d1-11e9-bc10-0242ac130016",
"createTime": "2019-04-22T07:40:12.402+0000",
"lastUpdatedTime": "2019-04-22T07:40:12.402+0000",
"value": "common",
"markedAsDeleted": false,
"taskVariable": true,
"_links": {
"self": {
"href": "http://keycloak:8884/v1/variables/2335"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 2336,
"type": "string",
"name": "remotehost",
"processInstanceId": "d80465ff-64d1-11e9-bc10-0242ac130016",
"taskId": "dca11fbb-64d1-11e9-bc10-0242ac130016",
"createTime": "2019-04-22T07:40:12.402+0000",
"lastUpdatedTime": "2019-04-22T07:40:12.402+0000",
"value": "172.19.0.7",
"markedAsDeleted": false,
"taskVariable": true,
"_links": {
"self": {
"href": "http://keycloak:8884/v1/variables/2336"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 2337,
"type": "string",
"name": "approvaltype",
"processInstanceId": "d80465ff-64d1-11e9-bc10-0242ac130016",
"taskId": "dca11fbb-64d1-11e9-bc10-0242ac130016",
"createTime": "2019-04-22T07:40:12.402+0000",
"lastUpdatedTime": "2019-04-22T07:40:12.402+0000",
"value": "singleapprover",
"markedAsDeleted": false,
"taskVariable": true,
"_links": {
"self": {
"href": "http://keycloak:8884/v1/variables/2337"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 2338,
"type": "json",
"name": "databefore",
"processInstanceId": "d80465ff-64d1-11e9-bc10-0242ac130016",
"taskId": "dca11fbb-64d1-11e9-bc10-0242ac130016",
"createTime": "2019-04-22T07:40:12.402+0000",
"lastUpdatedTime": "2019-04-22T07:40:12.402+0000",
"value": {
"commoncode": "XTEST",
"moduleid": "LBU",
"parentcode": "XTEST",
"commonname": "XTEST",
"commondesc": "XTEST",
"commonusage": "XTEST",
"pkid": 1144
},
"markedAsDeleted": false,
"taskVariable": true,
"_links": {
"self": {
"href": "http://keycloak:8884/v1/variables/2338"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 2339,
"type": "string",
"name": "querytoexecute",
"processInstanceId": "d80465ff-64d1-11e9-bc10-0242ac130016",
"taskId": "dca11fbb-64d1-11e9-bc10-0242ac130016",
"createTime": "2019-04-22T07:40:12.403+0000",
"lastUpdatedTime": "2019-04-22T07:40:12.403+0000",
"value": "update tblm_commoncodeheader set commoncode='XTEST' , moduleid='LBU' , parentcode='XTEST1' , commonname='XTEST1' , commondesc='XTEST1' , commonusage='XTEST1' where pkid=1144",
"markedAsDeleted": false,
"taskVariable": true,
"_links": {
"self": {
"href": "http://keycloak:8884/v1/variables/2339"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 2340,
"type": "string",
"name": "name",
"processInstanceId": "d80465ff-64d1-11e9-bc10-0242ac130016",
"taskId": "dca11fbb-64d1-11e9-bc10-0242ac130016",
"createTime": "2019-04-22T07:40:12.403+0000",
"lastUpdatedTime": "2019-04-22T07:40:12.403+0000",
"value": "jobname",
"markedAsDeleted": false,
"taskVariable": true,
"_links": {
"self": {
"href": "http://keycloak:8884/v1/variables/2340"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 2341,
"type": "string",
"name": "fileimportlink",
"processInstanceId": "d80465ff-64d1-11e9-bc10-0242ac130016",
"taskId": "dca11fbb-64d1-11e9-bc10-0242ac130016",
"createTime": "2019-04-22T07:40:12.403+0000",
"lastUpdatedTime": "2019-04-22T07:40:12.403+0000",
"value": "na",
"markedAsDeleted": false,
"taskVariable": true,
"_links": {
"self": {
"href": "http://keycloak:8884/v1/variables/2341"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 2342,
"type": "string",
"name": "moduleid",
"processInstanceId": "d80465ff-64d1-11e9-bc10-0242ac130016",
"taskId": "dca11fbb-64d1-11e9-bc10-0242ac130016",
"createTime": "2019-04-22T07:40:12.403+0000",
"lastUpdatedTime": "2019-04-22T07:40:12.403+0000",
"value": "ADMIN",
"markedAsDeleted": false,
"taskVariable": true,
"_links": {
"self": {
"href": "http://keycloak:8884/v1/variables/2342"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 2343,
"type": "string",
"name": "tablename",
"processInstanceId": "d80465ff-64d1-11e9-bc10-0242ac130016",
"taskId": "dca11fbb-64d1-11e9-bc10-0242ac130016",
"createTime": "2019-04-22T07:40:12.403+0000",
"lastUpdatedTime": "2019-04-22T07:40:12.403+0000",
"value": "tblm_commoncodeheader",
"markedAsDeleted": false,
"taskVariable": true,
"_links": {
"self": {
"href": "http://keycloak:8884/v1/variables/2343"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 2344,
"type": "string",
"name": "querytype",
"processInstanceId": "d80465ff-64d1-11e9-bc10-0242ac130016",
"taskId": "dca11fbb-64d1-11e9-bc10-0242ac130016",
"createTime": "2019-04-22T07:40:12.403+0000",
"lastUpdatedTime": "2019-04-22T07:40:12.403+0000",
"value": "update",
"markedAsDeleted": false,
"taskVariable": true,
"_links": {
"self": {
"href": "http://keycloak:8884/v1/variables/2344"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 2345,
"type": "string",
"name": "username",
"processInstanceId": "d80465ff-64d1-11e9-bc10-0242ac130016",
"taskId": "dca11fbb-64d1-11e9-bc10-0242ac130016",
"createTime": "2019-04-22T07:40:12.403+0000",
"lastUpdatedTime": "2019-04-22T07:40:12.403+0000",
"value": "andrelaksmana",
"markedAsDeleted": false,
"taskVariable": true,
"_links": {
"self": {
"href": "http://keycloak:8884/v1/variables/2345"
}
}
},
{
"serviceName": "approval-service",
"serviceFullName": "approval-service",
"serviceVersion": "",
"appName": "approval-service",
"appVersion": "",
"id": 2346,
"type": "json",
"name": "dataafter",
"processInstanceId": "d80465ff-64d1-11e9-bc10-0242ac130016",
"taskId": "dca11fbb-64d1-11e9-bc10-0242ac130016",
"createTime": "2019-04-22T07:40:12.403+0000",
"lastUpdatedTime": "2019-04-22T07:40:12.403+0000",
"value": {
"commoncode": "XTEST",
"moduleid": "LBU",
"parentcode": "XTEST1",
"commonname": "XTEST1",
"commondesc": "XTEST1",
"commonusage": "XTEST1"
},
"markedAsDeleted": false,
"taskVariable": true,
"_links": {
"self": {
"href": "http://keycloak:8884/v1/variables/2346"
}
}
}
]
},
"_links": {
"self": {
"href": "http://keycloak:8884/v1/process-instances/d80465ff-64d1-11e9-bc10-0242ac130016/variables/?page=0&size=100"
}
},
"page": {
"size": 100,
"totalElements": 46,
"totalPages": 1,
"number": 0
}
}
@igdianov So the conclusion:
- Using the Map still have the problem.
- Starting the process with RB API results in the same problem.
Can you help test using below payload?
{
"processDefinitionKey": "singleapprover",
"businessKey" : "approval",
"name": "approval-service",
"payloadType":"StartProcessPayload",
"variables": {
"name" : "jobname",
"type" : "approval",
"approvaltype" : "singleapprover",
"requestor" : "2caf29e4-fefb-4715-a4b4-2e55589aa541",
"username" : "andrelaksmana",
"databefore" : {
"commoncode": "XTEST",
"moduleid": "LBU",
"parentcode": "XTEST",
"commonname": "XTEST",
"commondesc": "XTEST",
"commonusage": "XTEST",
"pkid": 1144
},
"dataafter" : {
"commoncode": "XTEST",
"moduleid": "LBU",
"parentcode": "XTEST1",
"commonname": "XTEST1",
"commondesc": "XTEST1",
"commonusage": "XTEST1"
},
"querytype" : "update",
"querytoexecute" : "update tblm_commoncodeheader set commoncode='XTEST' , moduleid='LBU' , parentcode='XTEST1' , commonname='XTEST1' , commondesc='XTEST1' , commonusage='XTEST1' where pkid=1144",
"fileimportlink" : "na",
"database" : "myapplication_common",
"useragent" : "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36",
"remotehost" : "172.19.0.7",
"tablename" : "tblm_commoncodeheader",
"formcode" : "common",
"formname" : "CommonCodeHeader",
"moduleid" : "ADMIN",
"logsource" : "com.mycompany.rnd.bali.datamyapplicationservice.service.DataService [1207]",
"logmessage" : "Successfull PUT /myapplication/oracle/update/common/F/myapplication_common/tblm_commoncodeheader/1144/1-986-227"
}
}
@alaksmana I am using Activiti 7.0.0.SR1. I can start the process with your payload:
And query variables via GraphQL:
What is your K8s environment and what are your versions of Activiti Query, Notifications, and Audit services and dependencies?
igdianov
on 23 Apr 2019
@igdianov Thanks for your help. Your graphql looks nice.
Ok here it is. Im using simple Docker (18.09.2 (API: 1.39)) on top of RHEL 7.5, not Kubernetes. Below are the docker-compose related to Activiti:
version: "3"
networks:
frontend:
backend:
volumes:
keycloakdata:
pgdata:
services:
#START INFRASTRUCTURE
keycloak:
image: jboss/keycloak:3.3.0.Final
ports:
- "8080:8080"
networks:
- backend
restart: unless-stopped
environment:
- KEYCLOAK_USER=admin
- KEYCLOAK_PASSWORD=admin
volumes:
- "keycloakdata:/opt/jboss/keycloak"
rabbitmq:
image: activiti/rabbitmq-stomp
ports:
- "5672:5672"
- "15672:15672"
- "61613:61613"
networks:
- backend
restart: unless-stopped
activiti-postgres:
image: postgres
ports:
- "5432:5432"
networks:
- backend
environment:
- POSTGRES_PASSWORD=mypassword
- POSTGRES_USER=myuser
- POSTGRES_DB=activitidb
volumes:
- "pgdata:/var/lib/postgresql/data"
restart: unless-stopped
activiti-cloud-notifications-graphql:
image: activiti/activiti-cloud-notifications-graphql:7.1.58
networks:
- backend
ports:
- "8887:8080"
links:
- registry-service
- activiti-postgres
- rabbitmq
- keycloak
depends_on:
- registry-service
- activiti-postgres
- rabbitmq
- keycloak
environment:
- ACT_CLOUD_CONFIG_SERVER_ENABLED=false
- SPRING_DATASOURCE_URL=jdbc:postgresql://activiti-postgres:5432/activitidb
- SPRING_DATASOURCE_USERNAME=myuser
- SPRING_DATASOURCE_PASSWORD=mypassword
- SPRING_JPA_DATABASE_PLATFORM=org.hibernate.dialect.PostgreSQLDialect
- SPRING_JPA_GENERATE_DDL=true
- SPRING_JPA_HIBERNATE_DDL_AUTO=update
- ACT_KEYCLOAK_URL=http://keycloak:8080/auth
- ACT_KEYCLOAK_REALM=activiti
- ACT_KEYCLOAK_RESOURCE=activiti
- ACT_KEYCLOAK_SSL_REQUIRED=none
- ACT_KEYCLOAK_CLIENT=true
- ACT_KEYCLOAK_ROLES=ACTIVITI_USER
- ACT_KEYCLOAK_PATTERNS=/*
- ACT_KEYCLOAK_ADMIN_ROLE=ACTIVITI_ADMIN
- ACT_KEYCLOAK_PRINCIPAL_ATTRIBUTE=preferred-username
- ACT_KEYCLOAK_CLIENT_APP=admin-cli
- ACT_KEYCLOAK_CLIENT_USER=client
- ACT_KEYCLOAK_CLIENT_PASSWORD=client
- ACT_RABBITMQ_HOST=rabbitmq
- ACT_EUREKA_URL=http://registry-service:8761/eureka/
- ACT_NOTIFICATIONS_GRAPHQL_HOST=activiti-cloud-notifications-graphql
- ACT_NOTIFICATIONS_GRAPHQL_EUREKA_CLIENT_ENABLED=true
activiti-cloud-query:
image: activiti/activiti-cloud-query:latest
networks:
- backend
ports:
- "8884:8080"
links:
- registry-service
- activiti-postgres
- rabbitmq
- keycloak
depends_on:
- registry-service
- activiti-postgres
- rabbitmq
- keycloak
environment:
- ACT_QUERY_APP_NAME=activiti-cloud-query
- JAVA_OPTS=-Xmx256m -Xms256m
- ACT_CLOUD_CONFIG_SERVER_ENABLED=false
- SPRING_DATASOURCE_URL=jdbc:postgresql://activiti-postgres:5432/activitidb
- SPRING_DATASOURCE_USERNAME=myuser
- SPRING_DATASOURCE_PASSWORD=mypassword
- SPRING_JPA_DATABASE_PLATFORM=org.hibernate.dialect.PostgreSQLDialect
- SPRING_JPA_GENERATE_DDL=true
- SPRING_JPA_HIBERNATE_DDL_AUTO=update
- ACTIVITI_CLOUD_SERVICE_VERSION="0.1"
- ACTIVITI_CLOUD_APPLICATION_VERSION="0.1"
- SPRING_ACTIVITI_CLOUD_SERVICES_NOTIFICATIONS_GATEWAY_ENABLED=true
- SPRING_ACTIVITI_CLOUD_SERVICES_QUERY_GRAPHQL_ENABLED=true
- SPRING_HATEOAS_USEHALASDEFAULTJSONMEDIATYPE=false
- ACT_KEYCLOAK_URL=http://keycloak:8080/auth
- ACT_KEYCLOAK_REALM=activiti
- ACT_KEYCLOAK_RESOURCE=activiti
- ACT_KEYCLOAK_SSL_REQUIRED=none
- ACT_KEYCLOAK_CLIENT=true
- ACT_KEYCLOAK_USER_ROLE=ACTIVITI_USER
- ACT_KEYCLOAK_PATTERNS=/v1/*
- ACT_KEYCLOAK_ADMIN_ROLE=ACTIVITI_ADMIN
- ACT_KEYCLOAK_PRINCIPAL_ATTRIBUTE=preferred-username
- ACT_KEYCLOAK_CLIENT_APP=admin-cli
- ACT_KEYCLOAK_CLIENT_USER=client
- ACT_KEYCLOAK_CLIENT_PASSWORD=client
- ACT_RABBITMQ_HOST=rabbitmq
- ACT_EUREKA_URL=http://registry-service:8761/eureka/
- ACT_QUERY_HOST=activiti-cloud-query
- ACT_QUERY_EUREKA_CLIENT_ENABLED=true
restart: unless-stopped
# END INFRASTRUCTURE
approval-service:
image: our custom image based on RB from 7.0.0.SR1
ports:
- "8883:8080"
links:
- rabbitmq
- keycloak
- activiti-cloud-query
- registry-service
- mongodb
- samba-service
networks:
- backend
depends_on:
- rabbitmq
- keycloak
- activiti-cloud-query
- registry-service
- mongodb
- samba-service
environment:
- ACT_RABBITMQ_HOST=rabbitmq
- BALI_APPROVAL_KEYCLOAK_HOST=http://keycloak:8080
- BALI_APPROVAL_ACTQUERY_HOST=http://activiti-cloud-query:8080
- ACT_RB_DB_DRIVER=org.postgresql.Driver
- ACT_RB_DB_URI=jdbc:postgresql://activiti-postgres:5432/activitidb
- ACT_RB_DB_USER=myuser
- ACT_RB_DB_PASS=mypassword
- ACT_RB_DB_PLATFORM=org.hibernate.dialect.PostgreSQLDialect
- ACT_RB_GENERATEDDL=true
- ACT_RB_DDLAUTO=create
- ACT_KEYCLOAK_URL=http://keycloak:8080/auth
- BALI_REGISTRY_URL=http://registry-service:8761/eureka/
- BALI_APPROVAL_SAMBAHOST=samba-service
- BALI_APPROVAL_SAMBASHAREDFOLDER=public_samba
- BALI_APPROVAL_FORMCODE=APPROVAL
- BALI_APPROVAL_SAMBAUSER=
- BALI_APPROVAL_SAMBAPASSWORD=
- BALI_APPROVAL_SAMBAPORT=
- BALI_APPROVAL_SAMBADOMAIN=
- BALI_DATASERVICE_MONGO_HOST=mongodb
- BALI_DATASERVICE_FORMATDATE_MONTHYEAR=yyyy-MM
- BALI_DATASERVICE_FORMATDATE_DAYMONTHYEAR=yyyy-MM-dd
- BALI_DATASERVICE_TIMEZONE=Asia/Jakarta
- JAVA_OPTS=-Xmx1024m -Xms128m
restart: unless-stopped
Below is my approval-service POM:
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<parent>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-parent</artifactId>
<version>2.1.3.RELEASE</version>
<relativePath/> <!-- lookup parent from repository -->
</parent>
<groupId>mycompany</groupId>
<artifactId>approval-service</artifactId>
<version>0.0.1-SNAPSHOT</version>
<name>Approval Service</name>
<properties>
<java.version>11</java.version>
<activiti-cloud-dependencies.version>7.0.0.SR1</activiti-cloud-dependencies.version>
<spring-cloud.version>Greenwich.RELEASE</spring-cloud.version>
</properties>
<dependencyManagement>
<dependencies>
<dependency>
<groupId>org.springframework.cloud</groupId>
<artifactId>spring-cloud-dependencies</artifactId>
<version>${spring-cloud.version}</version>
<type>pom</type>
<scope>import</scope>
</dependency>
<dependency>
<groupId>org.activiti.cloud.dependencies</groupId>
<artifactId>activiti-cloud-dependencies</artifactId>
<version>${activiti-cloud-dependencies.version}</version>
<scope>import</scope>
<type>pom</type>
</dependency>
</dependencies>
</dependencyManagement>
<dependencies>
<dependency>
<groupId>org.springframework.cloud</groupId>
<artifactId>spring-cloud-starter-netflix-eureka-client</artifactId>
<exclusions>
<exclusion>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-logging</artifactId>
</exclusion>
</exclusions>
</dependency>
<dependency>
<groupId>org.springframework.cloud</groupId>
<artifactId>spring-cloud-starter-netflix-ribbon</artifactId>
<exclusions>
<exclusion>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-logging</artifactId>
</exclusion>
</exclusions>
</dependency>
<dependency>
<groupId>org.activiti.cloud.rb</groupId>
<artifactId>activiti-cloud-starter-runtime-bundle</artifactId>
</dependency>
<dependency>
<groupId>org.activiti.cloud.common</groupId>
<artifactId>activiti-cloud-services-tracing</artifactId>
</dependency>
<dependency>
<groupId>org.activiti</groupId>
<artifactId>activiti-engine</artifactId>
</dependency>
<dependency>
<groupId>org.activiti.cloud.rb</groupId>
<artifactId>activiti-cloud-services-events</artifactId>
</dependency>
<dependency>
<groupId>javax.xml.bind</groupId>
<artifactId>jaxb-api</artifactId>
<version>2.3.0</version>
</dependency>
<dependency>
<groupId>org.postgresql</groupId>
<artifactId>postgresql</artifactId>
<scope>runtime</scope>
</dependency>
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<scope>test</scope>
</dependency>
<dependency>
<groupId>org.assertj</groupId>
<artifactId>assertj-core</artifactId>
<scope>test</scope>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-test</artifactId>
<scope>test</scope>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-test</artifactId>
<scope>test</scope>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-webflux</artifactId>
</dependency>
<dependency>
<groupId>org.json</groupId>
<artifactId>json</artifactId>
<version>20180813</version>
</dependency>
<dependency>
<groupId>org.mongodb</groupId>
<artifactId>mongo-java-driver</artifactId>
<version>3.10.1</version>
</dependency>
<dependency>
<groupId>jcifs</groupId>
<artifactId>jcifs</artifactId>
<version>1.3.17</version>
</dependency>
</dependencies>
<build>
<plugins>
<plugin>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-maven-plugin</artifactId>
</plugin>
</plugins>
</build>
<repositories>
<repository>
<id>activiti-releases</id>
<name>Activiti Releases</name>
<url>https://artifacts.alfresco.com/nexus/content/repositories/activiti-releases/</url>
</repository>
<repository>
<id>spring-milestones</id>
<name>Spring Milestones</name>
<url>https://repo.spring.io/milestone/</url>
<snapshots>
<enabled>false</enabled>
</snapshots>
</repository>
</repositories>
</project>
And my XML for the approval process workflow:
<?xml version="1.0" encoding="UTF-8"?>
<definitions xmlns="http://www.omg.org/spec/BPMN/20100524/MODEL" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:activiti="http://activiti.org/bpmn" xmlns:bpmndi="http://www.omg.org/spec/BPMN/20100524/DI" xmlns:omgdc="http://www.omg.org/spec/DD/20100524/DC" xmlns:omgdi="http://www.omg.org/spec/DD/20100524/DI" typeLanguage="http://www.w3.org/2001/XMLSchema" expressionLanguage="http://www.w3.org/1999/XPath" targetNamespace="http://www.activiti.org/processdef">
<process id="singleapprover" name="singleapprover" isExecutable="true">
<startEvent id="start"></startEvent>
<sequenceFlow id="flow1" sourceRef="start" targetRef="serviceTaskCreateRequest"></sequenceFlow>
<serviceTask id="serviceTaskCreateRequest" name="identity-service: Get Approver" implementation="ApprovalGetApproverList"></serviceTask>
<sequenceFlow id="flow2" sourceRef="serviceTaskCreateRequest" targetRef="servicetask1"></sequenceFlow>
<serviceTask id="servicetask1" name="mail-service: Notify Approver" implementation="ApprovalNotifyApprover"></serviceTask>
<userTask id="usertask1" name="approver: Decide on Approval"></userTask>
<sequenceFlow id="flow3" sourceRef="servicetask1" targetRef="usertask1"></sequenceFlow>
<exclusiveGateway id="exclusivegateway1" name="Exclusive Gateway"></exclusiveGateway>
<sequenceFlow id="flow4" sourceRef="usertask1" targetRef="exclusivegateway1"></sequenceFlow>
<serviceTask id="servicetask4" name="mail-service: Notify Requestor" implementation="ApprovalNotifyRequestor"></serviceTask>
<sequenceFlow id="flow8" name="rejected" sourceRef="exclusivegateway1" targetRef="servicetask4">
<conditionExpression xsi:type="tFormalExpression">${!jobController.isApproved(approved)}</conditionExpression>
</sequenceFlow>
<endEvent id="endevent2" name="End"></endEvent>
<sequenceFlow id="flow9" sourceRef="servicetask4" targetRef="endevent2"></sequenceFlow>
<exclusiveGateway id="exclusivegateway2" name="Exclusive Gateway"></exclusiveGateway>
<sequenceFlow id="flow10" name="approved" sourceRef="exclusivegateway1" targetRef="exclusivegateway2">
<conditionExpression xsi:type="tFormalExpression">${jobController.isApproved(approved)}</conditionExpression>
</sequenceFlow>
<serviceTask id="servicetask5" name="data-regla-service: Execute Approved Job" implementation="ApprovalExecuteApprovedJob"></serviceTask>
<sequenceFlow id="flow11" name="insert/update/delete" sourceRef="exclusivegateway2" targetRef="servicetask5">
<conditionExpression xsi:type="tFormalExpression">${!jobController.isQuerytypeFileimport(querytype)}</conditionExpression>
</sequenceFlow>
<serviceTask id="servicetask6" name="dynamic-report-service: Execute Approved Job" implementation="ApprovalExecuteApprovedFileimportJob"></serviceTask>
<sequenceFlow id="flow12" name="fileimport" sourceRef="exclusivegateway2" targetRef="servicetask6">
<conditionExpression xsi:type="tFormalExpression">${jobController.isQuerytypeFileimport(querytype)}</conditionExpression>
</sequenceFlow>
<serviceTask id="servicetask7" name="mail-service: Notify Requestor" implementation="ApprovalNotifyRequestor"></serviceTask>
<sequenceFlow id="flow13" sourceRef="servicetask6" targetRef="servicetask7"></sequenceFlow>
<endEvent id="endevent3" name="End"></endEvent>
<sequenceFlow id="flow14" sourceRef="servicetask7" targetRef="endevent3"></sequenceFlow>
<serviceTask id="servicetask8" name="mail-service: Notify Requestor" implementation="ApprovalNotifyRequestor"></serviceTask>
<sequenceFlow id="flow15" sourceRef="servicetask5" targetRef="servicetask8"></sequenceFlow>
<endEvent id="endevent4" name="End"></endEvent>
<sequenceFlow id="flow16" sourceRef="servicetask8" targetRef="endevent4"></sequenceFlow>
</process>
<bpmndi:BPMNDiagram id="BPMNDiagram_singleapprover">
<bpmndi:BPMNPlane bpmnElement="singleapprover" id="BPMNPlane_singleapprover">
<bpmndi:BPMNShape bpmnElement="start" id="BPMNShape_start">
<omgdc:Bounds height="35.0" width="35.0" x="18.0" y="209.0"></omgdc:Bounds>
</bpmndi:BPMNShape>
<bpmndi:BPMNShape bpmnElement="serviceTaskCreateRequest" id="BPMNShape_serviceTaskCreateRequest">
<omgdc:Bounds height="89.0" width="111.0" x="100.0" y="182.0"></omgdc:Bounds>
</bpmndi:BPMNShape>
<bpmndi:BPMNShape bpmnElement="servicetask1" id="BPMNShape_servicetask1">
<omgdc:Bounds height="89.0" width="105.0" x="256.0" y="182.0"></omgdc:Bounds>
</bpmndi:BPMNShape>
<bpmndi:BPMNShape bpmnElement="usertask1" id="BPMNShape_usertask1">
<omgdc:Bounds height="89.0" width="105.0" x="406.0" y="182.0"></omgdc:Bounds>
</bpmndi:BPMNShape>
<bpmndi:BPMNShape bpmnElement="exclusivegateway1" id="BPMNShape_exclusivegateway1">
<omgdc:Bounds height="40.0" width="40.0" x="556.0" y="207.0"></omgdc:Bounds>
</bpmndi:BPMNShape>
<bpmndi:BPMNShape bpmnElement="servicetask4" id="BPMNShape_servicetask4">
<omgdc:Bounds height="91.0" width="105.0" x="640.0" y="309.0"></omgdc:Bounds>
</bpmndi:BPMNShape>
<bpmndi:BPMNShape bpmnElement="endevent2" id="BPMNShape_endevent2">
<omgdc:Bounds height="35.0" width="35.0" x="790.0" y="337.0"></omgdc:Bounds>
</bpmndi:BPMNShape>
<bpmndi:BPMNShape bpmnElement="exclusivegateway2" id="BPMNShape_exclusivegateway2">
<omgdc:Bounds height="40.0" width="40.0" x="672.0" y="207.0"></omgdc:Bounds>
</bpmndi:BPMNShape>
<bpmndi:BPMNShape bpmnElement="servicetask5" id="BPMNShape_servicetask5">
<omgdc:Bounds height="89.0" width="105.0" x="836.0" y="182.0"></omgdc:Bounds>
</bpmndi:BPMNShape>
<bpmndi:BPMNShape bpmnElement="servicetask6" id="BPMNShape_servicetask6">
<omgdc:Bounds height="91.0" width="105.0" x="790.0" y="50.0"></omgdc:Bounds>
</bpmndi:BPMNShape>
<bpmndi:BPMNShape bpmnElement="servicetask7" id="BPMNShape_servicetask7">
<omgdc:Bounds height="91.0" width="105.0" x="940.0" y="50.0"></omgdc:Bounds>
</bpmndi:BPMNShape>
<bpmndi:BPMNShape bpmnElement="endevent3" id="BPMNShape_endevent3">
<omgdc:Bounds height="35.0" width="35.0" x="1090.0" y="78.0"></omgdc:Bounds>
</bpmndi:BPMNShape>
<bpmndi:BPMNShape bpmnElement="servicetask8" id="BPMNShape_servicetask8">
<omgdc:Bounds height="89.0" width="105.0" x="986.0" y="182.0"></omgdc:Bounds>
</bpmndi:BPMNShape>
<bpmndi:BPMNShape bpmnElement="endevent4" id="BPMNShape_endevent4">
<omgdc:Bounds height="35.0" width="35.0" x="1140.0" y="206.0"></omgdc:Bounds>
</bpmndi:BPMNShape>
<bpmndi:BPMNEdge bpmnElement="flow1" id="BPMNEdge_flow1">
<omgdi:waypoint x="53.0" y="226.0"></omgdi:waypoint>
<omgdi:waypoint x="100.0" y="226.0"></omgdi:waypoint>
</bpmndi:BPMNEdge>
<bpmndi:BPMNEdge bpmnElement="flow2" id="BPMNEdge_flow2">
<omgdi:waypoint x="211.0" y="226.0"></omgdi:waypoint>
<omgdi:waypoint x="256.0" y="226.0"></omgdi:waypoint>
</bpmndi:BPMNEdge>
<bpmndi:BPMNEdge bpmnElement="flow3" id="BPMNEdge_flow3">
<omgdi:waypoint x="361.0" y="226.0"></omgdi:waypoint>
<omgdi:waypoint x="406.0" y="226.0"></omgdi:waypoint>
</bpmndi:BPMNEdge>
<bpmndi:BPMNEdge bpmnElement="flow4" id="BPMNEdge_flow4">
<omgdi:waypoint x="511.0" y="226.0"></omgdi:waypoint>
<omgdi:waypoint x="556.0" y="227.0"></omgdi:waypoint>
</bpmndi:BPMNEdge>
<bpmndi:BPMNEdge bpmnElement="flow8" id="BPMNEdge_flow8">
<omgdi:waypoint x="576.0" y="247.0"></omgdi:waypoint>
<omgdi:waypoint x="576.0" y="356.0"></omgdi:waypoint>
<omgdi:waypoint x="640.0" y="354.0"></omgdi:waypoint>
<bpmndi:BPMNLabel>
<omgdc:Bounds height="13.0" width="40.0" x="576.0" y="247.0"></omgdc:Bounds>
</bpmndi:BPMNLabel>
</bpmndi:BPMNEdge>
<bpmndi:BPMNEdge bpmnElement="flow9" id="BPMNEdge_flow9">
<omgdi:waypoint x="745.0" y="354.0"></omgdi:waypoint>
<omgdi:waypoint x="790.0" y="354.0"></omgdi:waypoint>
</bpmndi:BPMNEdge>
<bpmndi:BPMNEdge bpmnElement="flow10" id="BPMNEdge_flow10">
<omgdi:waypoint x="596.0" y="227.0"></omgdi:waypoint>
<omgdi:waypoint x="672.0" y="227.0"></omgdi:waypoint>
<bpmndi:BPMNLabel>
<omgdc:Bounds height="13.0" width="100.0" x="596.0" y="227.0"></omgdc:Bounds>
</bpmndi:BPMNLabel>
</bpmndi:BPMNEdge>
<bpmndi:BPMNEdge bpmnElement="flow11" id="BPMNEdge_flow11">
<omgdi:waypoint x="712.0" y="227.0"></omgdi:waypoint>
<omgdi:waypoint x="836.0" y="226.0"></omgdi:waypoint>
<bpmndi:BPMNLabel>
<omgdc:Bounds height="39.0" width="100.0" x="712.0" y="227.0"></omgdc:Bounds>
</bpmndi:BPMNLabel>
</bpmndi:BPMNEdge>
<bpmndi:BPMNEdge bpmnElement="flow12" id="BPMNEdge_flow12">
<omgdi:waypoint x="692.0" y="207.0"></omgdi:waypoint>
<omgdi:waypoint x="692.0" y="95.0"></omgdi:waypoint>
<omgdi:waypoint x="790.0" y="95.0"></omgdi:waypoint>
<bpmndi:BPMNLabel>
<omgdc:Bounds height="13.0" width="100.0" x="692.0" y="207.0"></omgdc:Bounds>
</bpmndi:BPMNLabel>
</bpmndi:BPMNEdge>
<bpmndi:BPMNEdge bpmnElement="flow13" id="BPMNEdge_flow13">
<omgdi:waypoint x="895.0" y="95.0"></omgdi:waypoint>
<omgdi:waypoint x="940.0" y="95.0"></omgdi:waypoint>
</bpmndi:BPMNEdge>
<bpmndi:BPMNEdge bpmnElement="flow14" id="BPMNEdge_flow14">
<omgdi:waypoint x="1045.0" y="95.0"></omgdi:waypoint>
<omgdi:waypoint x="1090.0" y="95.0"></omgdi:waypoint>
</bpmndi:BPMNEdge>
<bpmndi:BPMNEdge bpmnElement="flow15" id="BPMNEdge_flow15">
<omgdi:waypoint x="941.0" y="226.0"></omgdi:waypoint>
<omgdi:waypoint x="986.0" y="226.0"></omgdi:waypoint>
</bpmndi:BPMNEdge>
<bpmndi:BPMNEdge bpmnElement="flow16" id="BPMNEdge_flow16">
<omgdi:waypoint x="1091.0" y="226.0"></omgdi:waypoint>
<omgdi:waypoint x="1140.0" y="223.0"></omgdi:waypoint>
</bpmndi:BPMNEdge>
</bpmndi:BPMNPlane>
</bpmndi:BPMNDiagram>
</definitions>
@alaksmana Ok, I have looked at your Docker Compose and spotted a few things that need correction:
Make sure that you use 7.0.0.SR1 tag for Query, Audit and Notifications Graphq Docker images. The tags should be consistent with activiti-cloud-dependencies version 7.0.0.SR1 used in Rb.
In
activiti-cloud-notifications-graphqluse the following configuration:
environment:
- SPRING_JPA_GENERATE_DDL=false
- SPRING_JPA_HIBERNATE_DDL_AUTO=none
After making changes, clean you stack
docker-compose down, remove all containers and prune all data volumes withdocker volume pruneanddocker system prune.Start everything with
docker-compose upand test again.
igdianov
on 23 Apr 2019
@igdianov Thanks you very much! It works now! Thank you for your patience!
{
"data": {
"ProcessInstances": {
"select": [
{
"id": "c41b8b54-665a-11e9-bf61-0242ac13000c",
"status": "RUNNING",
"variables": [
{
"name": "logsource",
"value": "com.mycompany.rnd.bali.datamyapplicationservice.service.DataService [1207]"
},
{
"name": "database",
"value": "myapplication_lbu"
},
{
"name": "formcode",
"value": "F0020"
},
{
"name": "databefore",
"value": {
"ymd": "2019-03-21T00:00:00Z",
"ass_lblty_off_flg": "3",
"off_cd": "441",
"gl_acct": "1",
"br_cd": "100",
"bi_br_cd": "032",
"bi_acct_tp": "015",
"bi_curr_cd": "AED",
"prev_mth_bal": 1,
"mtd_dbt_amt": 1,
"mtd_cdt_amt": 1,
"mtd_oth_amt": 1,
"bal": 1,
"int_rt": 100,
"adj_flag": "M",
"acc_no": "1",
"pkid": 15041,
"valid_flg": "O"
}
},
{
"name": "querytype",
"value": "update"
},
{
"name": "logmessage",
"value": "Successfull PUT /myapplication/oracle/update/F0020/S/myapplication_lbu/tbls_interoffice_common_table/15041/2-464-148-120"
},
{
"name": "approvermailstatus0",
"value": "{\"mailok\":true,\"message\":\"org.springframework.mail.javamail.SmartMimeMessage@1fd04275\"}"
},
{
"name": "name",
"value": "jobname"
},
{
"name": "dataafter",
"value": {
"bi_br_cd": "032",
"off_cd": "441",
"bi_acct_tp": "015",
"bi_curr_cd": "AED",
"int_rt": 100,
"prev_mth_bal": 15,
"mtd_dbt_amt": 1,
"mtd_cdt_amt": 1,
"mtd_oth_amt": 1,
"bal": 1
}
},
{
"name": "approverlist",
"value": "{ \"user_id\" : \"fb59f2a0-9bb8-42c0-a2ee-18743f785da7\", \"user_name\" : \"mukhtarharis\", \"user_firstname\" : \"Mukhtar\", \"user_lastname\" : \"Haris\", \"user_email\" : \"[email protected]\", \"user_approvaltype\" : \"singleapprover\", \"approval-list\" : [{ \"user_approve_id\" : \"16033377-5d7e-44b2-b87b-4ac70617ff42\", \"user_approve_name\" : \"idamluqmana\", \"user_approve_firstname\" : \"Idam\", \"user_approve_lastname\" : \"Luqmana\", \"user_approve_email\" : \"[email protected]\" }], \"branch-list\" : [] }"
},
{
"name": "tablename",
"value": "tbls_interoffice_common_table"
},
{
"name": "type",
"value": "approval"
},
{
"name": "remotehost",
"value": "172.19.0.4"
},
{
"name": "useragent",
"value": "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.77 Safari/537.36"
},
{
"name": "username",
"value": "mukhtarharis"
},
{
"name": "fileimportlink",
"value": "na"
},
{
"name": "requestor",
"value": "fb59f2a0-9bb8-42c0-a2ee-18743f785da7"
},
{
"name": "moduleid",
"value": "LBU"
},
{
"name": "approvaltype",
"value": "singleapprover"
},
{
"name": "requestorinfo",
"value": "{ \"user_id\" : \"fb59f2a0-9bb8-42c0-a2ee-18743f785da7\", \"user_name\" : \"mukhtarharis\", \"user_firstname\" : \"Mukhtar\", \"user_lastname\" : \"Haris\", \"user_email\" : \"[email protected]\" }"
},
{
"name": "querytoexecute",
"value": "update tbls_interoffice_common_table set bi_br_cd='032' , off_cd='441' , bi_acct_tp='015' , bi_curr_cd='AED' , int_rt=100 , prev_mth_bal=15 , mtd_dbt_amt=1 , mtd_cdt_amt=1 , mtd_oth_amt=1 , bal=1 where pkid=15041"
},
{
"name": "formname",
"value": "Form-20"
}
]
}
]
}
}
}
👍2
Was this page helpful?
0 / 5 - 0 ratings
Related issues
bikabdel
路
4Comments
salaboy
路
5Comments
mteodori
路
7Comments
785227331
路
8Comments
rishisinghal
路
7Comments
Most helpful comment
@igdianov Thanks you very much! It works now! Thank you for your patience!