Hi,
I am trying to upgrade to latest MagicInfo (21.1010.2)
But during upgrade I recieve error message:
Migration V211010.0__Update.sql failed
--------------------------------------
SQL State : 23502
Error Code : 0
Message : FEL: kolumn "organization_id" innehåller null-värden
Location : C:\MagicInfo Premium\flyway\sql_postgres\V211010.0__Update.sql (C:\MagicInfo Premium\flyway\sql_postgres\V211010.0__Update.sql)
Line : 3
Statement : -- [V9 RC #17] Dashboard Device Status info by ORG
ALTER TABLE MI_STATISTICS_CONNECT_HOUR ADD COLUMN ORGANIZATION_ID DECIMAL(10, 0) NOT NULL
I should be able to change that value before the upgrade maybe? Or does it try to add a table and maybe my db-server need a change?
I am not that familiar with DB.
Anyone have a solution for this?
Br, Pelle