Cannot insert the value NULL

Q&A
1

Hello,

I am currently using Bonita BPM 5.5.2. While trying to start a process, i received such an error :

Bonita Error: bsi_HEI_3 Exception caught while executing Hook: org.bonitasoft.connectors.database.mssqlserver.MSSQLServerConnector because Cannot insert the value NULL into column ‘kritikDurumu’, table ‘GridTelekom_MetaData.dbo.GRID_AccessDB’; column does not allow nulls. INSERT fails.

It may be irrelavant but it started to occur shortly after i made a copy of the mentioned table and than deleted the original one and renamed the copy as the original one. Might it have anything to do with this problem ?

2

Hi,

I don’t think it’s related to Bonita itself. You are using a Database connector to insert a new ROW in a DB Table. You have to make sure that the data provided by the connector respect the Table constraint. In your case, the column ‘kritikDurumu’ does not allow NULL value. Maybe you had a NULL Constraint during the copy of the Table.

Cheers