How To Update nGrinder Controller

How to update ngrinder controller

Commonly ngrinder controller is automatically updated when you run a newer version of controller. But, if you are using a version below 3.5.0 and want to update to 3.5.0 above then, you have to notice some issues.

1. If you are using cubrid, you must migrate database to mysql, refer to MySQL migration guide.

2. If you are using H2 and the controller version you are currently using is below 3.5.0, you will encount below exception when you run a newer version of controller.

   Caused by: liquibase.exception.DatabaseException: Error executing SQL UPDATE PUBLIC.DATABASECHANGELOGLOCK SET LOCKED = TRUE, LOCKED = FALSE: Value too long for column "LOCKED CHAR(1) NOT NULL": "'TRUE' (4)"; SQL statement:
   

   Please follow the steps below to solve it

   1. Access H2 database manually, refer to how to access H2 database.
   2. Run ALTER TABLE DATABASECHANGELOGLOCK ALTER COLUMN LOCKED char(5);
   3. Run a newer version of controller. It will be updated automatically.