asked on

I am updating a database and get this error

I am trying to update my database and I get a big error. What is this saying? I can't figure it out. I know this might be a long shot, but any help is helpful! Thank you!!! Here's the error:

com.fbi.util.exception.ExceptionMainFree: com.fbi.dbversioning.DatabaseUpdateException: Unable to update database.
Unable to update to database version 2015.0
      at com.evnt.eve.ProcessingEngine.init(ProcessingEngine.java:110)
      at com.evnt.eve.Eve.init(Eve.java:118)
      at com.evnt.eve.Eve.start(Eve.java:177)
      at com.evnt.eve.ServerUI$EveThread.run(ServerUI.java:1445)
com.fbi.dbversioning.DatabaseUpdateException: Unable to update database.
Unable to update to database version 2015.0
      at com.fbi.dbversioning.DatabaseUpdater.validateDatabase(DatabaseUpdater.java:69)
      at com.evnt.eve.ProcessingEngine.init(ProcessingEngine.java:105)
      at com.evnt.eve.Eve.init(Eve.java:118)
      at com.evnt.eve.Eve.start(Eve.java:177)
      at com.evnt.eve.ServerUI$EveThread.run(ServerUI.java:1445)
com.fbi.dbversioning.DatabaseUpdateException: Unable to update to database version 2015.0
      at com.fbi.dbversioning.DatabaseUpdater.runVersionUpdate(DatabaseUpdater.java:368)
      at com.fbi.dbversioning.DatabaseUpdater.updateDatabase(DatabaseUpdater.java:224)
      at com.fbi.dbversioning.DatabaseUpdater.checkDatabaseVersion(DatabaseUpdater.java:130)
      at com.fbi.dbversioning.DatabaseUpdater.validateDatabase(DatabaseUpdater.java:67)
      at com.evnt.eve.ProcessingEngine.init(ProcessingEngine.java:105)
      at com.evnt.eve.Eve.init(Eve.java:118)
      at com.evnt.eve.Eve.start(Eve.java:177)
      at com.evnt.eve.ServerUI$EveThread.run(ServerUI.java:1445)
com.fbi.dbversioning.DatabaseUpdateException: Unable to update database to FB15, version 66.
      at com.fbi.dbversioning.versions.fb2015.Version66.execute(Version66.java:98)
      at com.fbi.dbversioning.DatabaseUpdater.runVersionUpdate(DatabaseUpdater.java:348)
      at com.fbi.dbversioning.DatabaseUpdater.updateDatabase(DatabaseUpdater.java:224)
      at com.fbi.dbversioning.DatabaseUpdater.checkDatabaseVersion(DatabaseUpdater.java:130)
      at com.fbi.dbversioning.DatabaseUpdater.validateDatabase(DatabaseUpdater.java:67)
      at com.evnt.eve.ProcessingEngine.init(ProcessingEngine.java:105)
      at com.evnt.eve.Eve.init(Eve.java:118)
      at com.evnt.eve.Eve.start(Eve.java:177)
      at com.evnt.eve.ServerUI$EveThread.run(ServerUI.java:1445)
org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544466. violation of FOREIGN KEY constraint "INTEG_1423" on table "SHIP"
Foreign key reference target does not exist
      at org.firebirdsql.jdbc.AbstractStatement.executeUpdate(AbstractStatement.java:280)
      at sun.reflect.GeneratedMethodAccessor66.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
      at java.lang.reflect.Method.invoke(Unknown Source)
      at org.firebirdsql.pool.StatementHandler.invoke(StatementHandler.java:107)
      at com.sun.proxy.$Proxy10.executeUpdate(Unknown Source)
      at com.fbi.dbversioning.versions.fb2015.Version66.moveShipOrderIdData(Version66.java:109)
      at com.fbi.dbversioning.versions.fb2015.Version66.execute(Version66.java:42)
      at com.fbi.dbversioning.DatabaseUpdater.runVersionUpdate(DatabaseUpdater.java:348)
      at com.fbi.dbversioning.DatabaseUpdater.updateDatabase(DatabaseUpdater.java:224)
      at com.fbi.dbversioning.DatabaseUpdater.checkDatabaseVersion(DatabaseUpdater.java:130)
      at com.fbi.dbversioning.DatabaseUpdater.validateDatabase(DatabaseUpdater.java:67)
      at com.evnt.eve.ProcessingEngine.init(ProcessingEngine.java:105)
      at com.evnt.eve.Eve.init(Eve.java:118)
      at com.evnt.eve.Eve.start(Eve.java:177)
      at com.evnt.eve.ServerUI$EveThread.run(ServerUI.java:1445)
org.firebirdsql.gds.GDSException: violation of FOREIGN KEY constraint "INTEG_1423" on table "SHIP"
Foreign key reference target does not exist
      at org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.readStatusVector(AbstractJavaGDSImpl.java:2092)
      at org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.receiveResponse(AbstractJavaGDSImpl.java:2042)
      at org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.iscDsqlExecute2(AbstractJavaGDSImpl.java:1149)
      at org.firebirdsql.gds.impl.GDSHelper.executeStatement(GDSHelper.java:234)
      at org.firebirdsql.jdbc.AbstractStatement.internalExecute(AbstractStatement.java:1424)
      at org.firebirdsql.jdbc.AbstractStatement.executeUpdate(AbstractStatement.java:276)
      at sun.reflect.GeneratedMethodAccessor66.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
      at java.lang.reflect.Method.invoke(Unknown Source)
      at org.firebirdsql.pool.StatementHandler.invoke(StatementHandler.java:107)
      at com.sun.proxy.$Proxy10.executeUpdate(Unknown Source)
      at com.fbi.dbversioning.versions.fb2015.Version66.moveShipOrderIdData(Version66.java:109)
      at com.fbi.dbversioning.versions.fb2015.Version66.execute(Version66.java:42)
      at com.fbi.dbversioning.DatabaseUpdater.runVersionUpdate(DatabaseUpdater.java:348)
      at com.fbi.dbversioning.DatabaseUpdater.updateDatabase(DatabaseUpdater.java:224)
      at com.fbi.dbversioning.DatabaseUpdater.checkDatabaseVersion(DatabaseUpdater.java:130)
      at com.fbi.dbversioning.DatabaseUpdater.validateDatabase(DatabaseUpdater.java:67)
      at com.evnt.eve.ProcessingEngine.init(ProcessingEngine.java:105)
      at com.evnt.eve.Eve.init(Eve.java:118)
      at com.evnt.eve.Eve.start(Eve.java:177)
      at com.evnt.eve.ServerUI$EveThread.run(ServerUI.java:1445)

ASKER CERTIFIED SOLUTION

CEHJ

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

brasiman

ASKER

How do I change a foreign key? Thats a super naive question i'm sure. Sorry about that. The SHIP table is where all my shoe Sales Orders go in my database prior to actually shipping out. How do I find which SO it is? Or how to fix it? Thanks!

SOLUTION

gurpsbassi

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

CEHJ

Well - for one thing, you didn't answer my question ...

brasiman

ASKER

CEHJ, sorry I guess I don't understand your question. I thought you were asking about the SHIP table.

brasiman

ASKER

I tried running the debugger and nothing different came up. :(

CEHJ

Please describe the SHIP table and its foreign keys

Also please show the statement that's failing

brasiman

ASKER

The foreign key for the SHIP table is ID (SHIP.ID). The SHIP table is where all my orders go after being picked. They go from the PICK module to the SHIP. The SHIP module is where all orders ready to ship reside. There are multiple other tables that link with the SHIP table. I don' t know what is failing. The above error is all I see.