NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
''Raw'' as in it is PostGreSQL format but the table structure, etc. are still 5.08.04 and needs to be upgraded to V6.0.
===Restore the raw dump and correct FK constraints upgrade===__NOEDITSECTION__{{Warning| Do '''notNOT''' restore GIS database and map data. You need to rebuild the sandbox and by restoring the map you will '''overwrite''' the ArcGIS 10.1-version of ''imsma.mxd'' in C:\IMSMAng\server\gis\maps with the ArcGIS 9.3.1-version.}}
# Did the backup from the country contain 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 dump on a computer with IMSMA V6.0 and scan # Scan the restore log for error messages. # Apply the ''fix imsmaenum FK constraints'' script# Take backup.# How many rows is there in the attachment table? If more than 0, then you have to verify that the attachments are included in the backup folder or instruct the country on how to handle them.
===Upgrade the database===__NOEDITSECTION__
Start the TrayLauncher for starting the upgrade scripts. When the upgrade scripts are done:
# stop TrayLauncher;
===Templates - Run the image tool===__NOEDITSECTION__
Note that you need the latest version of this tool (1 February 2014) still does . If you do not work. The work-around is want to use the tool, you may delete the images, logotypes in either 5.08.04 or 6.0manually. In 5.08.04 they are easier to see than in V6.0. <br />
[[Image:Upgrade_V6_image.png|300px]]
* Files that are in C:\IMSMAng\client\FormTemplates\MyTemplates.
{{Note that | That other errors in templates are '''notNOT''' fixed by this tool or by upgrading.If you do not address the image issue the templates will not be possible to use for data entry or to edit in V6.0 (after the first publish in V6.0}}
===Templates - Checking the templates by publishing them in V6.0(mandatory)===__NOEDITSECTION__
After you have either run the tool or removed the images manually you should test that all published templates are still working by publish them in V6.0. Check the log when you drag them into the designer.
This error message in the log means that there is still an image in wrong format in the template:
* value list of multi-select is changed.
===Templates - Checking the templates by opening them for data entry(mandatory)===__NOEDITSECTION__
After you have published the templates then open them and check the log when you open them. Scroll through the template and look for any single and multi-select that have default values that do not look OK/normal to be set to default.
If you have errors like this or error message for comboboxes, delete the field from the template, drag it in again and publish.
This error message in the console log:<br/>
Internal Exception: Error retrieving field report description (c0a8-f801-146a9ae9801-3a0d4f83-2-b273) to load into form
java.lang.NullPointerException
at javax.swing.ImageIcon.<init>(Unknown Source)
at com.fgm.freeform.component.ImagePanel.loadFrom('''ImagePanel'''.java:250)<br/>
means that there is an image in wrong format in the template and therefore {{IMSMANG}} may not load the template into the Template Designer or DEF editor.
===Rebuild sandbox===__NOEDITSECTION__