NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
# Restore the raw PostGresSQL 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 mandatory reference between tables did not work because of missing values in e.g. imsmaenum table;
