Modifying the bdm that has been in production

1
0
-1

Hi Community, I have a question regarding BDM. What would be the strategy if I should modify the BDM by adding or removing data fields in the objects?

What happens to the previous cases, are they still maintained in the BDM?

Is it convenient to create a BDM with auxiliary data fields?

Thank you

Regards

Juan

Comments

Submitted by Dibyajit.Roy on Sun, 09/24/2017 - 13:15

Hi
What I have learned from Experience is that Bonita does not delete any columns (fields).
If you remove a field from BDM, the column would still exist in Database.
But if its a mandatory field and its missing from BPM, the affected Proces will show error.
It will show as Database configuration unresolved. There would be an Red Exclaimation sign.
Its better to not remove fields from BDM.

But you can add new fields in the BDM. Thats fine.

For changing the column Type or Field type, changing in BDM does not reflect in Database. I had to manually write a SQL script to update the Database column type.
Again, if there is existing data, it might not allow you to do so.

Be careful. Modifying Existing BDM can affect process configurations and show error.
Always keep a copy of the Existing BDM as backup.

regards

Submitted by jagch on Mon, 09/25/2017 - 02:51

OK understood. Do not delete and do not modify fields. But if it is possible to add new fields and continue with the data of the BDM and the cases that have been executed.

Now, if the process changes quickly by a significant percentage, is it convenient to have a BDM refactoring? how do I get information from a case of the process in an earlier version?

Thank you

Submitted by Dibyajit.Roy on Mon, 09/25/2017 - 13:04

In the scenario that the Process changes significantly, try to see if adding new fields will help or not.
This means your new Process has existing fields plus new fields.

We think that it might cause overhead or slow performance. Since no of Records increases , data retrieval or insertion will be slow.

But There is no such indication from Bonitasoft on this. They expect the Process to respond normally. No slowness should be expected.

I had a process where I was having around 100 columns (fields) for a Particular process.
Then we modified the process and removed close to around 70 columns. Same process but version was different.
Instead of using the same table, I created a new table with less columns. The New version of the Process was referring to the new table.
I have not performed any Test to measure if there is any change in performance but on a high level, it appears both have same response time.

In order to show records from Previous table , I just create a instance of the Previous table and fetch records based on Request Id or case Id.

There are multiple API available to fetch information regarding the case overview.
But for database, you need to use BDM API and specific for your table to pull records and display

regards

Submitted by jagch on Tue, 09/26/2017 - 16:23

Thank you very much!!

No answers yet.
Notifications