Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0005060 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| backport | [Openbravo ERP] 03. Procurement management | major | always | 2008-09-16 11:34 | 2008-12-09 11:21 | |||
| Reporter | villind | View Status | public | |||||
| Assigned To | shuehner | |||||||
| Priority | normal | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | 2.40 | Fixed in SCM revision | 7441 | |||
| Projection | none | ETA | none | Target Version | ||||
| OS | Linux 64 bit | Database | PostgreSQL | Java version | 1.6 | |||
| OS Version | Redhat | Database version | 8.3 | Ant version | ||||
| Product Version | 2.40 | SCM revision | 7193 | |||||
| Merge Request Status | ||||||||
| Review Assigned To | ||||||||
| OBNetwork customer | No | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0005060: Purchase invoice - Copy lines does not work | |||||||
| Description | SQL Error occurs when trying to copy lines from previous invoice: Log: 16:16:09 [http-8080-Processor22] ERROR org.openbravo.erpCommon.ad_actionButton.CopyFromInvoiceData - SQL error in query: INSERT INTO C_INVOICELINE (C_InvoiceLine_ID, C_Invoice_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY, UPDATED, UPDATEDBY, C_ORDERLINE_ID, M_INOUTLINE_ID, LINE, DESCRIPTION, M_PRODUCT_ID, QTYINVOICED, PRICELIST, PRICEACTUAL, PRICELIMIT, LINENETAMT, C_CHARGE_ID, CHARGEAMT, C_UOM_ID, C_TAX_ID, S_RESOURCEASSIGNMENT_ID, TAXAMT, M_ATTRIBUTESETINSTANCE_ID, ISDESCRIPTION, QUANTITYORDER, M_PRODUCT_UOM_ID, PRICESTD) SELECT TO_NUMBER(?), TO_NUMBER(?), TO_NUMBER(?), TO_NUMBER(?), 'Y', now(), TO_NUMBER(?), now(), TO_NUMBER(?),'', '', (SELECT COALESCE(MAX(LINE),0)+10 FROM C_InvoiceLine WHERE C_InvoiceLine_ID = to_number(?)), DESCRIPTION, M_PRODUCT_ID, QTYINVOICED, PRICELIST, PRICEACTUAL, PRICELIMIT, LINENETAMT, C_CHARGE_ID, CHARGEAMT, C_UOM_ID, C_TAX_ID, S_RESOURCEASSIGNMENT_ID, TAXAMT, M_ATTRIBUTESETINSTANCE_ID, ISDESCRIPTION, QUANTITYORDER, M_PRODUCT_UOM_ID, PRICESTD FROM C_INVOICELINE WHERE C_INVOICELINE_ID = to_number(?) Exception:org.postgresql.util.PSQLException: ERROR: invalid input syntax for type numeric: "" 16:16:09 [http-8080-Processor22] WARN org.openbravo.erpCommon.ad_actionButton.CopyFromInvoice - Rollback in transaction | |||||||
| Tags | 2.40 MP1 candidate | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0009065) svnbot (viewer) 2008-09-18 10:32 |
Repository: openbravo Revision: 7441 Author: huehner Date: 2008-09-18 10:32:20 +0200 (Thu, 18 Sep 2008) Fixed 5060 Remove two non-mandatory fk-fields which where filled with constant '' from insert statement. --- U branches/r2.40/src/org/openbravo/erpCommon/ad_actionButton/CopyFromInvoice_data.xsql --- https://dev.openbravo.com/websvn/openbravo/?rev=7441&sc=1 [^] |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2008-09-16 11:34 | cromero | New Issue | |
| 2008-09-16 11:34 | cromero | Assigned To | => shuehner |
| 2008-09-16 11:34 | cromero | Status | new => scheduled |
| 2008-09-18 10:32 | svnbot | Checkin | |
| 2008-09-18 10:32 | svnbot | Note Added: 0009065 | |
| 2008-09-18 10:32 | svnbot | Status | scheduled => resolved |
| 2008-09-18 10:32 | svnbot | Resolution | open => fixed |
| 2008-09-18 10:32 | svnbot | svn_revision | => 7441 |
| 2008-09-29 18:39 | cromero | Tag Attached: 2.40 MP1 candidate | |
| 2008-12-09 11:21 | krishna | Regression testing | => No |
| 2008-12-09 11:21 | krishna | Status | resolved => closed |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |