Why do I get an error when building the Business Data Model for Getting Started tutorial?
I am working my way through the Bonita 7.7 getting-started-tutorial. I have installed version Bonita Community Edition Version 7.7.2.
When I click finish on Manage Business Data Model dialogue box, the Deploy Failed box appears.
Among a lot of other stuff, it says, "org.h2.jdbc.JdbcSQLException: NULL not allowed for column "DESTINATION"; SQL statement: alter table TRAVELREQUEST add column DESTINATION varchar(255) not null [23502-175]
The data has a definition for each TravelRequest. All the data is displayed when I Preview the page.
Some more information. In the Defining the data model chapter, from the Bonita Studio Philippe Ozil selects Development-Business Data Model-Manage. I do not have a Manage options; so I selected Define.... I get a dialogue box labeled Manage Business Data Model.
When I have finished editing the custom query, down by the label Result Type, I have a caution symbol that says "It is currently not possible to use multiple SELECT expressions like 'SELECT e.name, e.id FROM ...'."
His dialogue box looks just like mine. The query is the same. The parameters are the same. The result type is the same.
I think you have records and you want to add another column with not null setting and in that case your new columns will be null for old records which is not allowed. You could try to deploy bdm with "Reset BDM Database" option checked or set your "DESTINATION" column's mandatory option unchecked.