[kepler-dev] [Bug 4350] New: - Integrity constraint violation - no parent SYS_FK_59 table - during _first_ startup

[bugzilla-daemon at ecoinformatics.org]

http://bugzilla.ecoinformatics.org/show_bug.cgi?id=4350

           Summary: Integrity constraint violation - no parent SYS_FK_59
                    table - during _first_ startup
           Product: Kepler
           Version: 1.x dev
          Platform: Other
        OS/Version: All
            Status: NEW
          Severity: normal
          Priority: P2
         Component: general
        AssignedTo: berkley at nceas.ucsb.edu
        ReportedBy: michalo at man.poznan.pl
         QAContact: kepler-dev at kepler-project.org


During Kepler startup - from Eclipse project, following error occurs.

NOTE! This error occurs during first start-up, when there is _no_ "~/.kepler"
directory.

Scanning Local Repositories for KAR files...
java.sql.SQLException: Integrity constraint violation - no parent SYS_FK_59
table: CACHECONTENTTABLE in statement [insert into KAR_CONTENTS ( karlsid,
lsid, name, type ) values ( ?, ?, ?, ? ) ]
        at org.hsqldb.jdbc.Util.throwError(Unknown Source)
        at org.hsqldb.jdbc.jdbcPreparedStatement.executeUpdate(Unknown Source)
        at
org.kepler.kar.KARCacheManager.insertEntriesIntoCache(KARCacheManager.java:345)
        at
org.kepler.kar.KARCacheManager.insertIntoCache(KARCacheManager.java:295)
        at
org.kepler.kar.KARCacheManager.synchronizeKARCacheWithLocalRepositories(KARCacheManager.java:149)
        at
org.kepler.objectmanager.library.LibraryManager.buildLibrary(LibraryManager.java:663)
        at
org.kepler.objectmanager.library.LibraryManager.initialize(LibraryManager.java:935)
        at
org.kepler.moml.KARLibraryBuilder.buildLibrary(KARLibraryBuilder.java:68)
        at
ptolemy.actor.gui.UserActorLibrary.openLibrary(UserActorLibrary.java:202)
        at
ptolemy.actor.gui.UserActorLibrary.openUserLibrary(UserActorLibrary.java:140)
        at
ptolemy.vergil.VergilApplication._createDefaultConfiguration(VergilApplication.java:305)
        at
ptolemy.vergil.VergilApplication._createEmptyConfiguration(VergilApplication.java:322)
        at
ptolemy.actor.gui.ConfigurationApplication._parseArgs(ConfigurationApplication.java:1109)
        at
ptolemy.vergil.VergilApplication._parseArgs(VergilApplication.java:452)
        at
ptolemy.actor.gui.ConfigurationApplication.<init>(ConfigurationApplication.java:226)
        at ptolemy.actor.gui.MoMLApplication.<init>(MoMLApplication.java:81)
        at ptolemy.vergil.VergilApplication.<init>(VergilApplication.java:104)
        at ptolemy.vergil.VergilApplication$1.run(VergilApplication.java:194)
        at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
        at java.awt.EventQueue.dispatchEvent(EventQueue.java:597)
        at
java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
        at
java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
        at
java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
        at
java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
        at
java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
        at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
java.sql.SQLException: Integrity constraint violation - no parent SYS_FK_59
table: CACHECONTENTTABLE in statement [insert into KAR_CONTENTS ( karlsid,
lsid, name, type ) values ( ?, ?, ?, ? ) ]
        at org.hsqldb.jdbc.Util.throwError(Unknown Source)
        at org.hsqldb.jdbc.jdbcPreparedStatement.executeUpdate(Unknown Source)
        at
org.kepler.kar.KARCacheManager.insertEntriesIntoCache(KARCacheManager.java:345)
        at
org.kepler.kar.KARCacheManager.insertIntoCache(KARCacheManager.java:295)
        at
org.kepler.kar.KARCacheManager.synchronizeKARCacheWithLocalRepositories(KARCacheManager.java:149)
        at
org.kepler.objectmanager.library.LibraryManager.buildLibrary(LibraryManager.java:663)
        at
org.kepler.objectmanager.library.LibraryManager.initialize(LibraryManager.java:935)
        at
org.kepler.moml.KARLibraryBuilder.buildLibrary(KARLibraryBuilder.java:68)
        at
ptolemy.actor.gui.UserActorLibrary.openLibrary(UserActorLibrary.java:202)
        at
ptolemy.actor.gui.UserActorLibrary.openUserLibrary(UserActorLibrary.java:140)
        at
ptolemy.vergil.VergilApplication._createDefaultConfiguration(VergilApplication.java:305)
        at
ptolemy.vergil.VergilApplication._createEmptyConfiguration(VergilApplication.java:322)
        at
ptolemy.actor.gui.ConfigurationApplication._parseArgs(ConfigurationApplication.java:1109)
        at
ptolemy.vergil.VergilApplication._parseArgs(VergilApplication.java:452)
        at
ptolemy.actor.gui.ConfigurationApplication.<init>(ConfigurationApplication.java:226)
        at ptolemy.actor.gui.MoMLApplication.<init>(MoMLApplication.java:81)
        at ptolemy.vergil.VergilApplication.<init>(VergilApplication.java:104)
        at ptolemy.vergil.VergilApplication$1.run(VergilApplication.java:194)
        at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
        at java.awt.EventQueue.dispatchEvent(EventQueue.java:597)
        at
java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
        at
java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
        at
java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
        at
java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
        at
java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
        at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
java.sql.SQLException: Integrity constraint violation - no parent SYS_FK_59
table: CACHECONTENTTABLE in statement [insert into KAR_CONTENTS ( karlsid,
lsid, name, type ) values ( ?, ?, ?, ? ) ]
        at org.hsqldb.jdbc.Util.throwError(Unknown Source)
        at org.hsqldb.jdbc.jdbcPreparedStatement.executeUpdate(Unknown Source)
        at
org.kepler.kar.KARCacheManager.insertEntriesIntoCache(KARCacheManager.java:345)
        at
org.kepler.kar.KARCacheManager.insertIntoCache(KARCacheManager.java:295)
        at
org.kepler.kar.KARCacheManager.synchronizeKARCacheWithLocalRepositories(KARCacheManager.java:149)
        at
org.kepler.objectmanager.library.LibraryManager.buildLibrary(LibraryManager.java:663)
        at
org.kepler.objectmanager.library.LibraryManager.initialize(LibraryManager.java:935)
        at
org.kepler.moml.KARLibraryBuilder.buildLibrary(KARLibraryBuilder.java:68)
        at
ptolemy.actor.gui.UserActorLibrary.openLibrary(UserActorLibrary.java:202)
        at
ptolemy.actor.gui.UserActorLibrary.openUserLibrary(UserActorLibrary.java:140)
        at
ptolemy.vergil.VergilApplication._createDefaultConfiguration(VergilApplication.java:305)
        at
ptolemy.vergil.VergilApplication._createEmptyConfiguration(VergilApplication.java:322)
        at
ptolemy.actor.gui.ConfigurationApplication._parseArgs(ConfigurationApplication.java:1109)
        at
ptolemy.vergil.VergilApplication._parseArgs(VergilApplication.java:452)
        at
ptolemy.actor.gui.ConfigurationApplication.<init>(ConfigurationApplication.java:226)
        at ptolemy.actor.gui.MoMLApplication.<init>(MoMLApplication.java:81)
        at ptolemy.vergil.VergilApplication.<init>(VergilApplication.java:104)
        at ptolemy.vergil.VergilApplication$1.run(VergilApplication.java:194)
        at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
        at java.awt.EventQueue.dispatchEvent(EventQueue.java:597)
        at
java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
        at
java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
        at
java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
        at
java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
        at
java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
        at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
java.sql.SQLException: Integrity constraint violation - no parent SYS_FK_59
table: CACHECONTENTTABLE in statement [insert into KAR_CONTENTS ( karlsid,
lsid, name, type ) values ( ?, ?, ?, ? ) ]
        at org.hsqldb.jdbc.Util.throwError(Unknown Source)
        at org.hsqldb.jdbc.jdbcPreparedStatement.executeUpdate(Unknown Source)
        at
org.kepler.kar.KARCacheManager.insertEntriesIntoCache(KARCacheManager.java:345)
        at
org.kepler.kar.KARCacheManager.insertIntoCache(KARCacheManager.java:295)
        at
org.kepler.kar.KARCacheManager.synchronizeKARCacheWithLocalRepositories(KARCacheManager.java:149)
        at
org.kepler.objectmanager.library.LibraryManager.buildLibrary(LibraryManager.java:663)
        at
org.kepler.objectmanager.library.LibraryManager.initialize(LibraryManager.java:935)
        at
org.kepler.moml.KARLibraryBuilder.buildLibrary(KARLibraryBuilder.java:68)
        at
ptolemy.actor.gui.UserActorLibrary.openLibrary(UserActorLibrary.java:202)
        at
ptolemy.actor.gui.UserActorLibrary.openUserLibrary(UserActorLibrary.java:140)
        at
ptolemy.vergil.VergilApplication._createDefaultConfiguration(VergilApplication.java:305)
        at
ptolemy.vergil.VergilApplication._createEmptyConfiguration(VergilApplication.java:322)
        at
ptolemy.actor.gui.ConfigurationApplication._parseArgs(ConfigurationApplication.java:1109)
        at
ptolemy.vergil.VergilApplication._parseArgs(VergilApplication.java:452)
        at
ptolemy.actor.gui.ConfigurationApplication.<init>(ConfigurationApplication.java:226)
        at ptolemy.actor.gui.MoMLApplication.<init>(MoMLApplication.java:81)
        at ptolemy.vergil.VergilApplication.<init>(VergilApplication.java:104)
        at ptolemy.vergil.VergilApplication$1.run(VergilApplication.java:194)
        at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
        at java.awt.EventQueue.dispatchEvent(EventQueue.java:597)
        at
java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
        at
java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
        at
java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
        at
java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
        at
java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
        at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)