Historic Process Variable Not Being Returned

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

bcymet

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

bcymet

The even weirder part is if I ask for the variable by name I do get the value I am looking for:

https://blqadb3.ls.cbn/restactiviti/service/history/historic-variable-instances?variableName=serialNumber&processInstanceId=701
<code>
{"data":[{"id":"727","processInstanceId":"701","processInstanceUrl":"https://blqadb3.ls.cbn/restactiviti/service/history/historic-process-instances/701','taskId':null,'variable':{'name':'serialNumber','type':'string','value':'A','scope':null}}],"total":1,"start":0,"sort":"variableName","order":"asc","size":1}
</code>

In the end this is what I really need but I am still confused as to why this variable isn't returned in the complete list.