gaurav - 2006-08-14

Hi All

I am facing a very unusual problem.I created a window with one tab named 'Book Request' against which i created 'MBookRequest.java' file and a table named 'C_BookRequest'.I also created a Reference named 'Book Type' of Validation type 'List Validation'.And executed GenerateModel.java as well. Now when i save data from this window, the vaue in the listbox turns blank..though it gets saved in backend but does not show in listbox and moreover the 'Save' button in toolbar remains active.
It throws the following error.....

===========> DB.executeUpdate: INSERT INTO AD_Issue

(AD_Client_ID,AD_Issue_ID,AD_Org_ID,Created,CreatedBy,DBAddress,DatabaseInfo,ErrorTrace,IsAc

tive,IssueSummary,JavaInfo,LineNo,Local_Host,LoggerName,Name,OperatingSystemInfo,Processed,P

rocessing,ProfileInfo,Record_ID,ReleaseNo,ReleaseTag,SourceClassName,SourceMethodName,StackT

race,StatisticsInfo,SystemStatus,Updated,UpdatedBy,UserName,Version) VALUES

(1000000,1000976,1000006,TO_DATE('2006-08-14 11:50:02','YYYY-MM-DD

HH24:MI:SS'),1000001,'jdbc:oracle:thin:@//oracle10g:1521/compiere','Oracle Database 10g

Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining

options;10.1.0.2.0;DS','org.compiere.model.PO.load(PO.java:1062)
org.compiere.model.PO.load(PO.java:1008)
org.compiere.model.PO.<init>(PO.java:112)
org.compiere.model.PO.<init>(PO.java:63)
compiere.model.X_C_BookRequest.<init>(X_C_BookRequest.java:16)
org.compiere.model.MBookRequest.<init>(MBookRequest.java:12)
','Y','Exception NO Data found for C_BookRequest_ID=1000013','Java HotSpot(TM) Client VM

1.5.0_05-b05',1062,'GauravBhatia/192.168.0.24','org.compiere.model.MBookRequest','?','Window

s 2000 5.0 Service Pack 4','N','N','KC Social Welfare

Trust|GardenWorld|SYSTEM|',1,'253b','unknown','org.compiere.model.PO.load','load','Exception
    at org.compiere.model.PO.load(PO.java:1062)
    at org.compiere.model.PO.load(PO.java:1008)
    at org.compiere.model.PO.<init>(PO.java:112)
    at org.compiere.model.PO.<init>(PO.java:63)
    at compiere.model.X_C_BookRequest.<init>(X_C_BookRequest.java:16)
    at org.compiere.model.MBookRequest.<init>(MBookRequest.java:12)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    at reflect.Constructor.newInstance(Unknown Source)
    at org.compiere.model.M_Table.getPO(M_Table.java:378)
    at org.compiere.model.MTable.dataSavePO(MTable.java:1709)
    at org.compiere.model.MTable.dataSave(MTable.java:1135)
    at org.compiere.model.MTab.dataSave(MTab.java:728)
    at org.compiere.apps.APanel.cmd_save(APanel.java:1276)
    at org.compiere.apps.APanel.actionPerformed(APanel.java:1135)
    at org.compiere.apps.AppsAction.actionPerformed(AppsAction.java:260)
    at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
    at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
    at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
    at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
    at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
    at java.awt.AWTEventMulticaster.mouseReleased(Unknown Source)
    at java.awt.Component.processMouseEvent(Unknown Source)
    at javax.swing.JComponent.processMouseEvent(Unknown Source)
    at java.awt.Component.processEvent(Unknown Source)
    at java.awt.Container.processEvent(Unknown Source)
    at java.awt.Component.dispatchEventImpl(Unknown Source)
    at java.awt.Container.dispatchEventImpl(Unknown Source)
    at java.awt.Component.dispatchEvent(Unknown Source)
    at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
    at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
    at java.awt.L','C3U15B18P41I22M128','E',TO_DATE('2006-08-14 11:50:02','YYYY-MM-DD

HH24:MI:SS'),1000001,'?','2006-01-20') [null] [11]
java.sql.SQLException: ORA-01401: inserted value too large for column
; State=23000; ErrorCode=1401
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)
    at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:623)
    at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:181)
    at

oracle.jdbc.driver.T4CPreparedStatement.execute_for_rows(T4CPreparedStatement.java:543)
    at

oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1028)
    at

oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(OracleStatement.java:3753)
    at

oracle.jdbc.driver.OraclePreparedStatement.doScrollPstmtExecuteUpdate(OraclePreparedStatemen

t.java:8829)
    at

oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2886

)
    at

oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:2960)
    at org.compiere.util.CPreparedStatement.executeUpdate(CPreparedStatement.java:165)
    at org.compiere.util.DB.executeUpdate(DB.java:820)
    at org.compiere.util.DB.executeUpdate(DB.java:730)
    at org.compiere.model.PO.saveNew(PO.java:2175)
    at org.compiere.model.PO.save(PO.java:1714)
    at org.compiere.model.MIssue.create(MIssue.java:48)
    at org.compiere.util.CLogErrorBuffer.publish(CLogErrorBuffer.java:197)
    at java.util.logging.Logger.log(Unknown Source)
    at java.util.logging.Logger.doLog(Unknown Source)
    at java.util.logging.Logger.log(Unknown Source)
    at org.compiere.model.PO.load(PO.java:1062)
    at org.compiere.model.PO.load(PO.java:1008)
    at org.compiere.model.PO.<init>(PO.java:112)
    at org.compiere.model.PO.<init>(PO.java:63)

===========> DB.saveError: DBExecuteError - ORA-01401: inserted value too large for column
[11]
-----------> MIssue.saveNew: Not inserted - AD_Issue [11]
===========> MBookRequest.load: NO Data found for C_BookRequest_ID=1000013 [11]
java.lang.Exception
    at org.compiere.model.PO.load(PO.java:1062)
    at org.compiere.model.PO.load(PO.java:1008)
    at org.compiere.model.PO.<init>(PO.java:112)
    at org.compiere.model.PO.<init>(PO.java:63)
    at compiere.model.X_C_BookRequest.<init>(X_C_BookRequest.java:16)
    at org.compiere.model.MBookRequest.<init>(MBookRequest.java:12)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    at java.lang.reflect.Constructor.newInstance(Unknown Source)
    at org.compiere.model.M_Table.getPO(M_Table.java:378)
    at org.compiere.model.MTable.dataSavePO(MTable.java:1709)
    at org.compiere.model.MTable.dataSave(MTable.java:1135)
    at org.compiere.model.MTab.dataSave(MTab.java:728)
    at org.compiere.apps.APanel.cmd_save(APanel.java:1276)
    at org.compiere.apps.APanel.actionPerformed(APanel.java:1135)
    at org.compiere.apps.AppsAction.actionPerformed(AppsAction.java:260)

-----------> MTable.dataSave: C_BookRequest - No Persistent Object [11]
===========> MTable.saveError: SaveErrorRowNotFound -  [11]

Please help..i am not able it figure it out, what error is this.

Thank You

Regards,
Gaurav Bhatia
www.ViennaSolutions.com