Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0006539
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 02. Master data managementmajorhave not tried2008-12-14 22:122009-01-19 10:41
ReporterjreymolView Statuspublic 
Assigned Torafaroda 
PrioritynormalResolutionduplicateFixed in Version
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabasePostgreSQLJava version1.6.0_11
OS VersionrPath LinuxDatabase version8.3.5Ant version1.7.1
Product Version2.50alpha-r4SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0006539: 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
TagsNo tags attached.
Attached Filespng file icon Screen001.png [^] (103,249 bytes) 2009-01-12 17:53


png file icon Screen002.png [^] (131,153 bytes) 2009-01-12 17:54

- Relationships [ Relation Graph ] [ Dependency Graph ]
duplicate of defect 0006925 closedDowid It is not possible to import products on a new client because of a mssing default 
has duplicate defect 0006433 closedrafaroda Test Case ID 1014 Cannot import product 

-  Notes
(0011965)
psarobe (manager)
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 (reporter)
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 (reporter)
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 (manager)
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 (reporter)
2009-01-19 10:41

 Hi psarobe,

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

Good Work!
Congratulations!

- Issue History
Date Modified Username Field Change
2008-12-14 22:12 jreymol New Issue
2008-12-14 22:12 jreymol Assigned To => rafaroda
2008-12-14 22:12 jreymol sf_bug_id 0 => 2429398
2008-12-18 18:21 rafaroda Relationship added has duplicate 0006433
2009-01-07 20:12 psarobe Regression testing => No
2009-01-07 20:12 psarobe Status new => closed
2009-01-07 20:12 psarobe Note Added: 0011965
2009-01-07 20:12 psarobe Resolution open => no change required
2009-01-12 17:53 jreymol Status closed => new
2009-01-12 17:53 jreymol Resolution no change required => open
2009-01-12 17:53 jreymol Note Added: 0012120
2009-01-12 17:53 jreymol File Added: Screen001.png
2009-01-12 17:54 jreymol File Added: Screen002.png
2009-01-12 18:04 jreymol Note Added: 0012121
2009-01-15 17:55 rafaroda Relationship added related to 0006925
2009-01-19 10:37 psarobe Relationship replaced duplicate of 0006925
2009-01-19 10:37 psarobe Status new => closed
2009-01-19 10:37 psarobe Note Added: 0012302
2009-01-19 10:37 psarobe Duplicate ID 0 => 6925
2009-01-19 10:37 psarobe Resolution open => duplicate
2009-01-19 10:41 jreymol Note Added: 0012305

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker