Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0007885 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 02. Master data management | major | always | 2009-02-28 15:17 | 2009-04-22 00:01 | |||
| Reporter | kenzo | View Status | public | |||||
| Assigned To | Dowid | |||||||
| Priority | high | Resolution | fixed | Fixed in Version | 2.50 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | 79ce1c20b5d6 | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Linux 32 bit | Database | PostgreSQL | Java version | 1.6 | |||
| OS Version | Ubuntu 8.10 | Database version | 8.3 | Ant version | 1.71 | |||
| Product Version | 2.50beta | SCM revision | ||||||
| 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 | 0007885: Cannot Import products, gives a m_product_po_id NOT NULL Contraint Error | |||||||
| Description | When in last step to import products system gives this error: Insert Product_PO: javax.servlet.ServletException: @CODE=0@ERROR: null value in column "m_product_po_id" violates not-null constraint Used the same file and products imported fine in 2.40 Made sure there were no ' nor " in the csv file. | |||||||
| Steps To Reproduce | Make a new client, then make a import format file using the import file format window. Ensure you include the five mandatory fields. Then go to Import File Loader, Select the file, Select the new File Format Click OK, Make sure everything is ok. Click Process. Then go to the Import Product Window. Then click the Import Product Button. Then the red error box will appear with error: Insert Product_PO: javax.servlet.ServletException: @CODE=0@ERROR: null value in column "m_product_po_id" violates not-null constraint | |||||||
| Proposed Solution | Review insertProductPOImport SQL sentence inside ImportProduct_data.xsql to include UUID for m_product_po_id column. | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0014236) hgbot (developer) 2009-03-02 17:52 |
Repository: erp/devel/pi Changeset: 79ce1c20b5d6fe66b2321b765ea1f8a0fd6bb511 Author: David Abragimov <david.abragimov <at> opensuite.com> Date: Mon Mar 02 18:46:32 2009 +0200 URL: http://code.openbravo.com/erp/devel/pi/rev/79ce1c20b5d6fe66b2321b765ea1f8a0fd6bb511 [^] Bug fixed 0007885: Cannot Import products, gives a m_product_po_id NOT NULL Contraint Error --- M src/org/openbravo/erpCommon/ad_process/ImportProduct_data.xsql --- |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2009-02-28 15:17 | kenzo | New Issue | |
| 2009-02-28 15:17 | kenzo | Assigned To | => rafaroda |
| 2009-03-02 07:48 | rafaroda | Priority | normal => high |
| 2009-03-02 07:48 | rafaroda | Status | new => scheduled |
| 2009-03-02 08:13 | rafaroda | Steps to Reproduce Updated | |
| 2009-03-02 10:02 | rafaroda | Assigned To | rafaroda => Dowid |
| 2009-03-02 10:03 | rafaroda | Relationship added | related to 0007890 |
| 2009-03-02 17:52 | hgbot | Checkin | |
| 2009-03-02 17:52 | hgbot | Note Added: 0014236 | |
| 2009-03-02 17:52 | hgbot | Status | scheduled => resolved |
| 2009-03-02 17:52 | hgbot | Resolution | open => fixed |
| 2009-03-02 17:52 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/79ce1c20b5d6fe66b2321b765ea1f8a0fd6bb511 [^] |
| 2009-04-21 10:33 | psarobe | Status | resolved => closed |
| 2009-04-22 00:01 | anonymous | sf_bug_id | 0 => 2778035 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |