Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Oracle error when trying to update timeseries #67

Closed
OFR-IIASA opened this issue Jul 6, 2018 · 3 comments
Closed

Oracle error when trying to update timeseries #67

OFR-IIASA opened this issue Jul 6, 2018 · 3 comments
Labels
awaiting info Needs more information from the issuer to continue backend.jdbc Interaction with ixmp_source via JDBCBackend & JPype

Comments

@OFR-IIASA
Copy link

If timeseries have already been uploaded e.g. for 1990 to 2110, and the same timeseries are then updated e.g. for 2020-2100 then the following error occurs:

2018-07-06 09:54:39,554 ERROR at.ac.iiasa.ixmp.database.DbDAO:766 - Error writing the timeseries data to the IXMP database!
java.sql.BatchUpdateException: ORA-00001: unique constraint (ENE_IXMP.SYS_C0065938) violated

    at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:12296)
    at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:246)
    at at.ac.iiasa.ixmp.database.OracleDAO.saveTimeseriesToDB(OracleDAO.java:187)
    at at.ac.iiasa.ixmp.objects.Scenario.commit(Scenario.java:2014)
    at at.ac.iiasa.ixmp.objects.Scenario.commit(Scenario.java:1906)
    at at.ac.iiasa.ixmp.objects.MsgScenario.commit(MsgScenario.java:1316)
    at at.ac.iiasa.ixmp.objects.MsgScenario.commit(MsgScenario.java:1301)
@gidden
Copy link
Member

gidden commented Jul 6, 2018

cc: @danielhuppmann, @zikolach, @peterkolp

@zikolach
Copy link
Contributor

zikolach commented Jul 6, 2018

@OFR-IIASA can you please provide a test for this? or more details how to reproduce (in particular branch)

@khaeru khaeru removed the TimeSeries label Oct 1, 2019
@khaeru khaeru added awaiting info Needs more information from the issuer to continue backend.jdbc Interaction with ixmp_source via JDBCBackend & JPype labels Jul 15, 2020
@khaeru
Copy link
Member

khaeru commented Aug 6, 2020

Closing this as it is two years stale and no additional information was provided.

If the error is still occurring, or recurs, please open a new issue, and specify the affected version(s) of ixmp.

@khaeru khaeru closed this as completed Aug 6, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
awaiting info Needs more information from the issuer to continue backend.jdbc Interaction with ixmp_source via JDBCBackend & JPype
Projects
None yet
Development

No branches or pull requests

4 participants