Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0006539Openbravo ERP02. Master data managementpublic2008-12-14 22:122009-01-19 10:41
Reporterjreymol 
Assigned Torafaroda 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionduplicate 
PlatformOS20OS VersionrPath Linux
Product Version2.50alpha-r4 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0006539: I cannot import Products
DescriptionWhen trying Test Case ID 1014 I click on button Import Product and get a red error:

      
No products could be imported
Products not imported: 9; Product inserted: 0; Product updated: 0; ProductPO inserted: 0; ProductPO updated: 0

In openbravo.log I see:

21:02:04 [ajp-8009-5] ERROR org.openbravo.erpCommon.ad_process.ImportProductData - SQL error in query: INSERT INTO M_Product (M_Product_ID, AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy, Value,Name,Description,DocumentNote,Help, UPC,SKU,C_UOM_ID,IsSummary,M_Product_Category_ID,C_TaxCategory_ID, ProductType, Classification, Volume, Weight, ShelfWidth,ShelfHeight, ShelfDepth, UnitsPerPallet, Discontinued, DiscontinuedBy, ImageURL,DescriptionURL) SELECT ?, AD_Client_ID,AD_Org_ID,'Y',now(),CreatedBy,now(),UpdatedBy, Value,Name,Description,DocumentNote,Help, UPC,SKU,C_UOM_ID,'N',M_Product_Category_ID,? , ProductType, Classification, Volume, Weight, ShelfWidth,ShelfHeight, ShelfDepth, UnitsPerPallet, Discontinued, DiscontinuedBy, ImageURL,DescriptionURL FROM I_Product WHERE I_Product_ID=?Exception:org.postgresql.util.PSQLException: ERROR: null value in column "c_taxcategory_id" violates not-null constraint

nine times

Maybe this is just a consequence of having failed to import taxes
Steps To Reproduce
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
duplicate of defect 0006925 closed Dowid It is not possible to import products on a new client because of a mssing default 
has duplicate defect 0006433 closed rafaroda Test Case ID 1014 Cannot import product 
Attached Filespng Screen001.png (103,249) 2009-01-12 17:53
https://issues.openbravo.com/file_download.php?file_id=629&type=bug
png

png Screen002.png (131,153) 2009-01-12 17:54
https://issues.openbravo.com/file_download.php?file_id=630&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2008-12-14 22:12jreymolNew Issue
2008-12-14 22:12jreymolAssigned To => rafaroda
2008-12-14 22:12jreymolsf_bug_id0 => 2429398
2008-12-18 18:21rafarodaRelationship addedhas duplicate 0006433
2009-01-07 20:12psarobeRegression testing => No
2009-01-07 20:12psarobeStatusnew => closed
2009-01-07 20:12psarobeNote Added: 0011965
2009-01-07 20:12psarobeResolutionopen => no change required
2009-01-12 17:53jreymolStatusclosed => new
2009-01-12 17:53jreymolResolutionno change required => open
2009-01-12 17:53jreymolNote Added: 0012120
2009-01-12 17:53jreymolFile Added: Screen001.png
2009-01-12 17:54jreymolFile Added: Screen002.png
2009-01-12 18:04jreymolNote Added: 0012121
2009-01-15 17:55rafarodaRelationship addedrelated to 0006925
2009-01-19 10:37psarobeRelationship replacedduplicate of 0006925
2009-01-19 10:37psarobeStatusnew => closed
2009-01-19 10:37psarobeNote Added: 0012302
2009-01-19 10:37psarobeDuplicate ID0 => 6925
2009-01-19 10:37psarobeResolutionopen => duplicate
2009-01-19 10:41jreymolNote Added: 0012305

Notes
(0011965)
psarobe   
2009-01-07 20:12   
Hi jreymol,

It didn't work for you because it looks like that previously import taxes didn't work. We have tested again and it works fine. Thanks a lot for your feedback
(0012120)
jreymol   
2009-01-12 17:53   
With alpha-r6 I've been able to import taxes but this issue float up again.

In Master Data Management || Import Data || Import Products || Import Product I cannot see a field to put tax category nor tax rate to product
(0012121)
jreymol   
2009-01-12 18:04   
I created Import Loader Format for products following Test Case ID 1004.

To import products I used file: http://wiki.openbravo.com/wiki/images/c/cd/I_Products.txt [^]
(0012302)
psarobe   
2009-01-19 10:37   
Hi jreymol,

We close this bug as duplicate although we know you were the first person to report it. But the bug 0006925 goes deeper in the solution. Hope it does not bother you

Thanks again
(0012305)
jreymol   
2009-01-19 10:41   
Hi psarobe,

Of course going deeper into a solution doesn't bother me at all :-)

Good Work!
Congratulations!