BDM data update reflecting in object model after a delay

Q&A
1

Hi,

I have a process where in I try to update the business data as part of human task operations. The data gets updated in BDM DB schema instantly. But it doesn’t reflect in business object model instantly. I am using BDM search API to search for the business data, but I don’t get the latest copy of data. Latest data gets reflected in business object model after some delay. I need to be able to search for latest business data immediately after its updated by the process. Looks like there is some type of caching that is preventing me to get the latest data. Does anyone have a solution for this?

Regards,
Kinjal

1 Like
2

Does anyone have a solution for this? We are kind of stuck here.

Regards,
Kinjal

3

Interesting can you share a sample of the process?

thanks

4

There is a business object WithdrawalRequest. When I installed the BDM, it created WITHDRAWALREQUEST table in BDM schema in Oracle DB (I am using oracle as backend). I have a process Withdrawal Request Processing which has a human task and a custom form. As part of the human task, I have set of operations which modify the attributes of WithdrawalRequest based on inputs from user. I execute the human task through ProcessAPI passing the human task contract inputs. I check the BDM schema, I can see that the data has been updated successfully.

Immediately after executing human task, I run a business data search query using the BDM search API as below.

gov.nih.era.priorapproval.domain.WithdrawalRequest?q=searchWithdrawalRequest&p=0&c=0&f=requestId=1001

where searchWithdrawalRequest is a custom query defined in BDM. The above query returns JSON representation of WithdrawalRequest object. But it returns old instance without any recent changes. If I wait for few seconds then it reflects the recent changes. This happens intermittently.

5

I suggest you add this to the Bug List, while not quite a bug, it is a bug from your perspective. And I agree it should be possible to read the data as soon as it’s written…

the link is https://bonita.atlassian.net/secure/Dashboard.jspa

When you create the report - make sure to post the number here so others can follow it,

regards
Seán

6

JIRA issue has been created for this. Issue no - BBPMC-362

https://bonita.atlassian.net/browse/BBPMC-362

7

Kingal, as per Philippe’s request can you upload a simple process to show the problem.

regards
Seán

8

Not sure if I can share the project with you as we have some restrictions at our end. But if you want we can set up a webex session and show you the demo for the issue that we are facing. Its a critical issue and stopping us from going into the production. If not resolved in time, we may have to scrap Bonita solution from our project and look for other alternatives or possibly custom solution.

9

As mention on the issue I tried to reproduce the issue but without any success. Can you test that on latest version of Bonita BPM?