Install Business Data Model, It didn't create relative table in business_data.db
Hi, I am using Bonita Studio (version 7.9.4) create bdm and export it to bdm.zip,
when i trying to install the bdm.zip to a new Server(for testing environment) , It didn't create relative table in business_data.db (Mariadb Server version10)
I found that qualifiedName seems have a length limit
when i short the qualifiedName
from "com.baeshiow.model.BSCancelLeaveApplication"
to "com.baeshiow.model.BSCancelLeaveAp" , it can create table successfully after install bdm.
But the weird thing is, i use the same bdm install successfully on another server(production environment) earlier.
So, I have check and reinstall for several days, just can't find the problem.
Note: I found this because when i start a new process it occurred error, then i found it that the table didn't exists in logs, then i found it didn't create relative table after i install bdm.zip
Thanks a lot.
Hello,
That's arrived because you have some conflicts when you deploy your BDM
See the explanation here https://youtu.be/6kq5WRu5kGk
Use the SnowMobile to figure out what is your issue, and prepare in advance your database
https://community.bonitasoft.com/project/snow-mobile
Hope this help
Comments
bdm infomation
<businessObjectModel modelVersion="1.0" productVersion="7.9.4">
<businessObjects>
<businessObject qualifiedName="com.baeshiow.model.BSCancelLeaveApplication">
<fields>
<field type="STRING" length="255" name="status" nullable="true" collection="false"/>
<field type="OFFSETDATETIME" length="255" name="leaveStart" nullable="true" collection="false"/>
<field type="OFFSETDATETIME" length="255" name="leaveEnd" nullable="true" collection="false"/>
<field type="STRING" length="255" name="leaveType" nullable="true" collection="false"/>
<field type="STRING" length="255" name="leaveHour" nullable="true" collection="false"/>
<field type="STRING" length="255" name="leaveReason" nullable="true" collection="false"/>
<field type="STRING" length="255" name="empAgent" nullable="true" collection="false"/>
<field type="STRING" length="255" name="empDept" nullable="true" collection="false"/>
<field type="STRING" length="255" name="empFirstName" nullable="true" collection="false"/>
<field type="STRING" length="255" name="empLastName" nullable="true" collection="false"/>
<field type="STRING" length="255" name="empManagerFirstName" nullable="true" collection="false"/>
<field type="STRING" length="255" name="empNo" nullable="true" collection="false"/>
<field type="STRING" length="255" name="opinion" nullable="true" collection="false"/>
</fields>
<uniqueConstraints/>
<queries/>
<indexes/>
</businessObject>
<businessObject qualifiedName="com.baeshiow.model.BSLeaveApplication">
<fields>
<field type="STRING" length="255" name="status" nullable="true" collection="false"/>
<field type="OFFSETDATETIME" length="255" name="leaveStart" nullable="true" collection="false"/>
<field type="OFFSETDATETIME" length="255" name="leaveEnd" nullable="true" collection="false"/>
<field type="STRING" length="255" name="leaveType" nullable="true" collection="false"/>
<field type="STRING" length="255" name="leaveHour" nullable="true" collection="false"/>
<field type="STRING" length="255" name="leaveReason" nullable="true" collection="false"/>
<field type="STRING" length="255" name="empAgent" nullable="true" collection="false"/>
<field type="STRING" length="255" name="empDept" nullable="true" collection="false"/>
<field type="STRING" length="255" name="empFirstName" nullable="true" collection="false"/>
<field type="STRING" length="255" name="empLastName" nullable="true" collection="false"/>
<field type="STRING" length="255" name="empManagerFirstName" nullable="true" collection="false"/>
<field type="STRING" length="255" name="empNo" nullable="true" collection="false"/>
<field type="STRING" length="255" name="opinion" nullable="true" collection="false"/>
</fields>
<uniqueConstraints/>
<queries/>
<indexes/>
</businessObject>
</businessObjects>
</businessObjectModel>