AnsweredAssumed Answered

Historic Process Variable Not Being Returned

Question asked by bcymet on Jun 20, 2014
Latest reply on Feb 26, 2015 by marcuss
Hi,

I am using activiti 5.15.1 with a postgresql db.

When I use the rest api to query historic process variables and I am getting all process variables but one back:

https://blqadb3.ls.cbn/restactiviti/service/history/historic-variable-instances?processInstanceId=701


{"data":[{"id":"718","processInstanceId":"701","processInstanceUrl":"https://blqadb3.ls.cbn/restactiviti/service/history/historic-process-instances/701','taskId':null,'variable':{'name':'bankTransId','type':'string','value':'fakeTransID','scope':null}},{'id':'717','processInstanceId':'701','processInstanceUrl':'https://blqadb3.ls.cbn/restactiviti/service/history/historic-process-instances/701','taskId':null,'variable':{'name':'bankTransResult','type':'boolean','value':true,'scope':null}},{'id':'707','processInstanceId':'701','processInstanceUrl':'https://blqadb3.ls.cbn/restactiviti/service/history/historic-process-instances/701','taskId':null,'variable':{'name':'calcval','type':'string','value':'25.0','scope':null}},{'id':'723','processInstanceId':'701','processInstanceUrl':'https://blqadb3.ls.cbn/restactiviti/service/history/historic-process-instances/701','taskId':null,'variable':{'name':'currentWalletBal','type':'double','value':25.0,'scope':null}},{'id':'711','processInstanceId':'701','processInstanceUrl':'https://blqadb3.ls.cbn/restactiviti/service/history/historic-process-instances/701','taskId':null,'variable':{'name':'eWalletBalence','type':'string','value':'0.0','scope':null}},{'id':'710','processInstanceId':'701','processInstanceUrl':'https://blqadb3.ls.cbn/restactiviti/service/history/historic-process-instances/701','taskId':null,'variable':{'name':'eWalletCheckResult','type':'boolean','value':false,'scope':null}},{'id':'702','processInstanceId':'701','processInstanceUrl':'https://blqadb3.ls.cbn/restactiviti/service/history/historic-process-instances/701','taskId':null,'variable':{'name':'Initiator','type':'string','value':'kermit','scope':null}},{'id':'709','processInstanceId':'701','processInstanceUrl':'https://blqadb3.ls.cbn/restactiviti/service/history/historic-process-instances/701','taskId':null,'variable':{'name':'limitCheckResult','type':'boolean','value':true,'scope':null}},{'id':'705','processInstanceId':'701','processInstanceUrl':'https://blqadb3.ls.cbn/restactiviti/service/history/historic-process-instances/701','taskId':null,'variable':{'name':'playdata','type':'string','value':'{\'initialPurchaseRequest\':{\'userIdentifier\':\'user__500192@blqaweb1\',\'businessProcID\':\'VARCHAR_PROC_ID\',\'tickets\":[[{\"numberOfDraws\":1,\"gamename\":\"La Diaria\",\"purchaseStructureName\":\"Regular\",\"wagerAmount\":5,\"quickPick\":true,\"playData\":\"\"},{\"numberOfDraws\":1,\"gamename\":\"La Diaria\",\"purchaseStructureName\":\"Regular\",\"wagerAmount\":5,\"quickPick\":true,\"playData\":\"\"},{\"numberOfDraws\":1,\"gamename\":\"La Diaria\",\"purchaseStructureName\":\"Regular\",\"wagerAmount\":5,\"quickPick\":true,\"playData\":\"\"},{\"numberOfDraws\":1,\"gamename\":\"La Diaria\",\"purchaseStructureName\":\"Regular\",\"wagerAmount\":5,\"quickPick\":true,\"playData\":\"\"},{\"numberOfDraws\":1,\"gamename\":\"La Diaria\",\"purchaseStructureName\":\"Regular\",\"wagerAmount\":5,\"quickPick\":true,\"playData\":\"\"}]]}}","scope":null}},{"id":"728","processInstanceId":"701","processInstanceUrl":"https://blqadb3.ls.cbn/restactiviti/service/history/historic-process-instances/701','taskId':null,'variable':{'name':'purchaseSuccessful','type':'boolean','value':true,'scope':null}}],'total':17,'start':0,'sort':'variableName','order':'asc','size':10}


Even thought that variable is in the databae


SELECT * from act_hi_varinst where name_ = 'serialNumber' and proc_inst_id_ = '701';
id_ | proc_inst_id_ | execution_id_ | task_id_ |    name_     | var_type_ | rev_ | bytearray_id_ | double_ | long_ | text_ | text2_ |      create_time_       |   last_updated_time_   
—–+—————+—————+———-+————–+———–+——+—————+———+——-+——-+——–+————————-+————————-
727 | 701           | 701           |          | serialNumber | string    |    0 |               |         |       | A     |        | 2014-06-20 15:18:07.206 | 2014-06-20 15:18:07.221


I thought it might be that I had set to many process variables so I tired not setting one I still got the same result.

Any ideas why the variable would be in the DB but not returned in the rest query?

Thanks,

Bram

Outcomes