Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0005024 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 03. Procurement management | major | always | 2008-09-11 18:18 | 2008-12-03 14:20 | |||
| Reporter | villind | View Status | public | |||||
| Assigned To | shuehner | |||||||
| Priority | normal | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | pi | Fixed in SCM revision | 7442 | |||
| 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 | |||||
| Review Assigned To | ||||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0005024: 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 | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0009066) svnbot (reporter) 2008-09-18 10:33 |
Repository: openbravo Revision: 7442 Author: huehner Date: 2008-09-18 10:33:44 +0200 (Thu, 18 Sep 2008) Fixed 5024 Remove two non-mandatory fk-fields which where filled with '' from insert statement in addition remove some TO_NUMBER calls with are unneeded for (now uuid) id-fields --- U trunk/src/org/openbravo/erpCommon/ad_actionButton/CopyFromInvoice_data.xsql --- https://dev.openbravo.com/websvn/openbravo/?rev=7442&sc=1 [^] |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2008-09-11 18:18 | villind | New Issue | |
| 2008-09-11 18:18 | villind | Assigned To | => cromero |
| 2008-09-11 18:18 | villind | sf_bug_id | 0 => 2105943 |
| 2008-09-11 18:18 | villind | Regression testing | => No |
| 2008-09-16 11:34 | cromero | Status | new => scheduled |
| 2008-09-16 11:34 | cromero | Assigned To | cromero => shuehner |
| 2008-09-16 11:34 | cromero | fix_in_branch | => trunk |
| 2008-09-18 10:33 | svnbot | Checkin | |
| 2008-09-18 10:33 | svnbot | Note Added: 0009066 | |
| 2008-09-18 10:33 | svnbot | Status | scheduled => resolved |
| 2008-09-18 10:33 | svnbot | Resolution | open => fixed |
| 2008-09-18 10:33 | svnbot | svn_revision | => 7442 |
| 2008-12-03 14:20 | krishna | Status | resolved => closed |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |