Symptom: While all vessel spares should have at least one store location defined (for example "Free Store"), some spares do not have any defined at all, or have one or more locations defined but none set as a default.
Status: Data issue, various causes
Affected products: KapaMPI all versions. To check if affected, download and run the diagnostic script "FindSparesNoDefaultStore.hsql". The script will return all problematic spares entries, if any exist.
Resolution: Download and run the attached script "FixDefaultLocationPerSpare.hsql". This script will do the following:
1. Add Free store to Spares without any store location defined.
2. Set a default location for spares that don’t have a default
3. If more than one default locations defined, leave only one.
Any changes done by this script will also be exported to vessels.