Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

#74 Invalid PO Info

closed
nobody
None
5
2010-04-04
2010-03-19
Bala Chandar
No

HI all

Invalid PO Info

------------------------------------------> MProduct.saveFinish: afterSave [11]
java.lang.IllegalArgumentException: Invalid PO Info - POInfo[null,AD_Table_ID=327]
at org.compiere.model.PO.<init>(PO.java:176)
at org.compiere.model.PO.<init>(PO.java:134)
at org.compiere.model.X_M_Product_Costing.<init>(X_M_Product_Costing.java:39)
at org.compiere.model.MProductCosting.<init>(MProductCosting.java:115)
at org.compiere.model.MProduct.afterSave(MProduct.java:683)
at org.compiere.model.PO.saveFinish(PO.java:2150)
at org.compiere.model.PO.saveNew(PO.java:2703)
at org.compiere.model.PO.save(PO.java:2044)
at org.compiere.model.GridTable.dataSavePO(GridTable.java:1831)
at org.compiere.model.GridTable.dataSave(GridTable.java:1190)
at org.compiere.model.GridTab.dataSave(GridTab.java:887)
at org.compiere.apps.APanel.cmd_save(APanel.java:1837)
at org.compiere.apps.APanel.actionPerformed(APanel.java:1518)
at org.compiere.apps.AppsAction.actionPerformed(AppsAction.java:286)

-----------> GridTable.saveWarning: Error - Invalid PO Info - POInfo[null,AD_Table_ID=327] [11]
===========> DB.executeUpdate: INSERT INTO M_Product_Trl (AD_Language,M_Product_ID, Description,DocumentNote,DownloadURL,Name, IsTranslated,AD_Client_ID,AD_Org_ID,Created,Createdby,Updated,UpdatedBy) SELECT l.AD_Language,t.M_Product_ID, t.Description,t.DocumentNote,t.DownloadURL,t.Name, 'N',t.AD_Client_ID,t.AD_Org_ID,t.Created,t.Createdby,t.Updated,t.UpdatedBy FROM AD_Language l, M_Product t WHERE l.IsActive='Y' AND l.IsSystemLanguage='Y' AND l.IsBaseLanguage='N' AND t.M_Product_ID=1000018 AND EXISTS (SELECT * FROM M_Product_Trl tt WHERE tt.AD_Language!=l.AD_Language OR tt.M_Product_ID!=t.M_Product_ID) [POSave_265c3da5-3766-4cd3-b2bd-69b814d0093d] [11]
org.postgresql.util.PSQLException: ERROR: column "downloadurl" of relation "m_product_trl" does not exist; State=42703; ErrorCode=0
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1316)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:351)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:305)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.compiere.db.StatementProxy.invoke(StatementProxy.java:100)
at $Proxy1.executeUpdate(Unknown Source)
at org.compiere.util.DB.executeUpdate(DB.java:1008)
at org.compiere.util.DB.executeUpdate(DB.java:871)
at org.compiere.util.DB.executeUpdate(DB.java:858)
at org.compiere.model.PO.insertTranslations(PO.java:3126)
at org.compiere.model.PO.saveFinish(PO.java:2143)
at org.compiere.model.PO.saveNew(PO.java:2703)
at org.compiere.model.PO.save(PO.java:2044)
at org.compiere.model.GridTable.dataSavePO(GridTable.java:1831)
at org.compiere.model.GridTable.dataSave(GridTable.java:1190)
at org.compiere.model.GridTab.dataSave(GridTab.java:887)
at org.compiere.apps.APanel.cmd_save(APanel.java:1837)
at org.compiere.apps.APanel.actionPerformed(APanel.java:1518)
at org.compiere.apps.AppsAction.actionPerformed(AppsAction.java:286)

regards...

Discussion

  • Carlos Ruiz
    Carlos Ruiz
    2010-03-19

    • labels: 897048 -->
    • status: open --> pending
     
  • Carlos Ruiz
    Carlos Ruiz
    2010-03-19

    Sounds like you mistakenly changed the translated flag for the column M_Product.DownloadURL

    Regards,

    Carlos Ruiz

     
  • This Tracker item was closed automatically by the system. It was
    previously set to a Pending status, and the original submitter
    did not respond within 14 days (the time period specified by
    the administrator of this Tracker).

     
    • status: pending --> closed