Database schema is not updated after changes made to BDM

Q&A
1

Greetings!

I'm facing a problem where a change made to the BDM is seemingly not reflected in the database schema, and that causes errors while executing certain tasks.

I have a Business Data Object which had an Int field for an external ID, linking it to an entity from another system. In the external system, the ID field has been changed from an integer to a UUID, and I've changed the BDM object's externalId field to be a String to reflect this change. I've exported the BDM, and uploaded it through the Bonita portal (twice at this point, actually), but I'm still getting errors upon task execution stating that the string (UUID) value could not be converted to an integer. This error rises while executing the INSERT statement, and the attached SQL statement shows that although I've updated the BDM, the underlying database still has an integer field instead of a varchar.

What am I missing here? Why doesn't the db schema update after updating the BDM?

2

Hello
Which version of Bonita are you using ?

In the Newer version of Bonita , First you need to manually write the Alter statement and execute in the Database end.
Once the Alter command has been successfully executed, then you need to deploy the Modified BDM.

Creating new tables works fine but any alter table script always fails. Hence it is advised to run the alter command manually in the database end.

 

Regards