Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0007885Openbravo ERP02. Master data managementpublic2009-02-28 15:172009-04-22 00:01
Reporterkenzo 
Assigned ToDowid 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionUbuntu 8.10
Product Version2.50beta 
Target VersionFixed in Version2.50 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0007885: Cannot Import products, gives a m_product_po_id NOT NULL Contraint Error
DescriptionWhen 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 ReproduceMake 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 SolutionReview insertProductPOImport SQL sentence inside ImportProduct_data.xsql to include UUID for m_product_po_id column.
Additional Information
TagsNo tags attached.
Relationships
related to feature request 0007890 closed pjuvara Review import products with prices functionality 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-02-28 15:17kenzoNew Issue
2009-02-28 15:17kenzoAssigned To => rafaroda
2009-03-02 07:48rafarodaPrioritynormal => high
2009-03-02 07:48rafarodaStatusnew => scheduled
2009-03-02 08:13rafarodaSteps to Reproduce Updated
2009-03-02 10:02rafarodaAssigned Torafaroda => Dowid
2009-03-02 10:03rafarodaRelationship addedrelated to 0007890
2009-03-02 17:52hgbotCheckin
2009-03-02 17:52hgbotNote Added: 0014236
2009-03-02 17:52hgbotStatusscheduled => resolved
2009-03-02 17:52hgbotResolutionopen => fixed
2009-03-02 17:52hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/79ce1c20b5d6fe66b2321b765ea1f8a0fd6bb511 [^]
2009-04-21 10:33psarobeStatusresolved => closed
2009-04-22 00:01anonymoussf_bug_id0 => 2778035

Notes
(0014236)
hgbot   
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
---