SQL error message when saving psdb

[jcanderan]

When saving a Reporter psdb, the following error message in the log is obtained:

Windows GUI:

org.sqlite.SQLiteException: [SQLITE_CONSTRAINT_PRIMARYKEY]  A PRIMARY KEY constraint failed (UNIQUE constraint failed: data.id)
	at org.sqlite.core.DB.newSQLException(DB.java:909)
	at org.sqlite.core.DB.newSQLException(DB.java:921)
	at org.sqlite.core.DB.throwex(DB.java:886)
	at org.sqlite.core.DB.executeBatch(DB.java:774)
	at org.sqlite.core.CorePreparedStatement.executeBatch(CorePreparedStatement.java:79)
	at com.compomics.util.db.object.ObjectsCache.saveObjects(ObjectsCache.java:350)
	at com.compomics.util.db.object.ObjectsCache.saveCache(ObjectsCache.java:411)
	at com.compomics.util.db.object.ObjectsDB.lock(ObjectsDB.java:784)
	at eu.isas.peptideshaker.export.PsdbExporter.saveAs(PsdbExporter.java:130)
	at eu.isas.peptideshaker.utils.PsdbParent.saveProject(PsdbParent.java:371)
	at eu.isas.reporter.io.ProjectSaver.saveProject(ProjectSaver.java:76)
	at eu.isas.reporter.gui.ReporterGUI$19.run(ReporterGUI.java:1106)

linux command-line (different psdb file than above):

org.sqlite.SQLiteException: [SQLITE_CONSTRAINT_PRIMARYKEY]  A PRIMARY KEY constraint failed (UNIQUE constraint failed: data.id)
        at org.sqlite.core.DB.newSQLException(DB.java:909)
        at org.sqlite.core.DB.newSQLException(DB.java:921)
        at org.sqlite.core.DB.throwex(DB.java:886)
        at org.sqlite.core.DB.executeBatch(DB.java:774)
        at org.sqlite.core.CorePreparedStatement.executeBatch(CorePreparedStatement.java:79)
        at com.compomics.util.db.object.ObjectsCache.saveObjects(ObjectsCache.java:350)
        at com.compomics.util.db.object.ObjectsCache.saveCache(ObjectsCache.java:411)
        at com.compomics.util.db.object.ObjectsDB.lock(ObjectsDB.java:784)
        at eu.isas.peptideshaker.export.PsdbExporter.saveAs(PsdbExporter.java:130)
        at eu.isas.peptideshaker.utils.PsdbParent.saveProject(PsdbParent.java:371)
        at eu.isas.reporter.io.ProjectSaver.saveProject(ProjectSaver.java:76)
        at eu.isas.reporter.cli.ReporterCLI.call(ReporterCLI.java:557)
        at eu.isas.reporter.cli.ReporterCLI.main(ReporterCLI.java:845)

I don't know what this affects exactly as the output file is generated but I wanted to mention it.

[hbarsnes]

I can confirm that I see the same thing. I will look into it.

Note that saving Reporter projects does not matter all that much at the moment though, as we do not yet support reopening saved projects in Reporter...