NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
# Did the previous database that you worked with on the V6.0 computer had any attachments? If yes, delete them before restoring this database;
# Restore the raw PostgresSQL PostgreSQL dump on a computer with IMSMA V6.0;
# Scan the restore log for error messages;
#: the two error messages below are the so far '''encountered''' error messages but since table structure, relation rules between tables and contents of all {{IMSMANG}} databases are different there might be other error messages that you need to react on. As a general rule of thumb, between ''NOTICE: index "workitem_has_cdfvalue_workitemhascdfvalue_cdfvalue_key" does not exist, skipping'' and ''SqlDump restore Completed'' it is '''not''' normal to get any error messages;
#:* error message ''COPY fieldreportdesc'' means that it was not possible to load the table so the table is '''empty''';
#:* error message ''ERROR: insert or update on table "fieldreport" violates foreign key constraint "fieldreport_fieldreportdesc_guid_fkey'' means that ''mandatory '' reference (FKs) between tables did not work get created because of missing values in e.g. imsmaenum table. {{IMSMANG}} depends on that FKs are created.;
# The upgrade scripts will '''wrongly''' change enumvalues to Inactive and therefore the current values must be documented [[Imsmaenum Duplicate fix | query]]
# The upgrade script will change ''Location point'' to ''Reference point'', run this [[Location point | query]] '''before''' and '''after''' the upgrade.