Skip to content

createSimulation fails #257

@Castronova

Description

@Castronova

createService.createSimulation fails with:

OperationalError: (OperationalError) table simulations has no column named outputdatasetid u'INSERT INTO simulations (actionid, simulationname, simulationdescription, simulationstartdatetime, simulationstartdatetimeutcoffset, simulationenddatetime, simulationenddatetimeutcoffset, timestepvalue, timestepunitsid, inputdatasetid, outputdatasetid, modelid) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' (1, 'My Simulation', 'Some model descipription', '2014-03-01', -6, '2014-03-01', -6, 1.0, 1, None, None, 1)

It is looking for a column called outputdatasetid, however this doesn't exist in the ODM2 schema https://github.com/ODM2/ODM2/blob/master/schemas/ODM2_DBWrench_Schema.xml.

To fix:
Remove OutputDataSetID from the models.Simulations table

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions