Cannot insert new tuple with GUI

When I tried to insert the tuple (7, "Felis Catus", 10, 11) into the OTU table 
in the ppodln Orchestra schema, the operation 
failed. Here is a log extract:

Error executing SELECT "7" AS OTU_ID, R0.LABEL AS LABEL, R0.OBJ_VERSION AS 
OBJ_VERSION,
  R0.PPOD_VERSION AS PPOD_VERSION, 1 AS OTU_ID_LN, R0.LABEL_LN AS LABEL_LN,
  R0.OBJ_VERSION_LN AS OBJ_VERSION_LN, R0.PPOD_VERSION_LN AS PPOD_VERSION_LN
  FROM PPOD1.OTU AS R0
  WHERE ((R0.OTU_ID = 7) AND (R0.OTU_ID_LN = 1))

com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -206, SQLSTATE: 42703, 
SQLERRMC: 7
    at com.ibm.db2.jcc.b.ig.e(ig.java:1594)
    at com.ibm.db2.jcc.b.ig.a(ig.java:1204)
    at com.ibm.db2.jcc.c.gb.g(gb.java:140)
    at com.ibm.db2.jcc.c.gb.a(gb.java:39)
    at com.ibm.db2.jcc.c.w.a(w.java:34)
    at com.ibm.db2.jcc.c.vb.f(vb.java:139)
    at com.ibm.db2.jcc.b.ig.n(ig.java:1175)
    at com.ibm.db2.jcc.b.ig.a(ig.java:1835)
    at com.ibm.db2.jcc.b.ig.a(ig.java:476)
    at com.ibm.db2.jcc.b.ig.executeQuery(ig.java:460)
    at edu.upenn.cis.orchestra.dbms.SqlDb.evaluateQuery(SqlDb.java:960)
    at edu.upenn.cis.orchestra.dbms.SqlDb.evalQueryRule(SqlDb.java:1629)
    at edu.upenn.cis.orchestra.exchange.BasicEngine.evalQueryRule(BasicEngine.java:555)
    at edu.upenn.cis.orchestra.gui.schemas.RelationDataEditorUpdTrans.isKeyUsed(RelationDataEditorUpdTrans.java:266)
    at edu.upenn.cis.orchestra.gui.schemas.RelationDataModel.insert(RelationDataModel.java:416)
    at edu.upenn.cis.orchestra.gui.schemas.RelationDataInsertionModel.validate(RelationDataInsertionModel.java:116)
    at edu.upenn.cis.orchestra.gui.schemas.RelationDataPanel$5.actionPerformed(RelationDataPanel.java:301)

Insertions straight into DB2 are handled correctly.
Original issue reported on code.google.com by jwfro...@gmail.com on 2 Mar 2010 at 8:48
ceperez / penn-orchestra

Cannot insert new tuple with GUI #6
