Ticket #473 (closed: not an issue)
Ecosim may crash when saving TS data in older EwE6 databases
Reported by: | jeroens | Owned by: | jeroens |
---|---|---|---|
Priority: | normal | Milestone: | Ecopath 6: build 6.0.7 |
Component: | Database / Import | Version: | |
Severity: | minor | Keywords: | |
Cc: |
Description (last modified by jeroens) (diff)
Symptom:
Application crashes when saving changes to Time Series.
Reproduce:
- Open carie's 'Lab 3' test database
- Load time series
- Modify any time series data to flag the scenario as dirty
- Save the scenario
Cause:
Database of EwE6 pre-release candidates cannot be updated using Microsoft Access SQL. The tables EcosimTimeSeriesGroup? and -Fleet in this particular database have a compound primary key which was changed prior to the September release. The EwE6 save sim scenario code expects only a singular primary key and crashes.
Solution:
None at this moment. Access SQL does not support dropping existing Primary Keys, so we cannot write an update to fix this issue.
Severity:
Low since the database schema was changed prior to the September 2007 release. However, I logged this issue just in case it were to surface unexectedly.
Just to keep on it