Error in eBA Notes

If the following errors are received when entering the eBA Notes section, you can follow the relevant steps.

"Objecct cannot be cast from DbNull to other types" error and "Cannot insert the value NULL into column 'MESSAGE', table 'EBATST.dbo.DOCUMENTNOTES'; column does not allow nulls :

The reason for the error is that when eBA 6.7.142, one of the old versions of eBA, is updated to version 6.7.142 and above, LOGINTYPE and ACTIONUSERID fields are added to the Notes section of eBA, and although the relevant fields are in the Db, an error is received because there is no data in it.

In order to solve the error, the ACTIONUSERID of the notes previously created in the system in the DB should be revised to 'admin' and the LoginType field to '2'.

Then, in the notes created in the system, these fields will be automatically filled in according to the user and login type (proxy, login ass, etc.).

UPDATE DOCUMENTNOTES SET LOGINTYPE = '2' WHERE LOGINTYPE IS NULL
UPDATE DOCUMENTNOTES SET ACTIONUSERID = 'admin' WHERE ACTIONUSERID IS NULL