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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0009275
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 02. Master data managementmajoralways2009-06-01 19:132009-07-23 00:00
ReportermiruritaView Statuspublic 
Assigned Tosathiyan 
PriorityhighResolutionfixedFixed in Versionpi
StatusclosedFix in branchFixed in SCM revision27b9c6b0026b
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabasePostgreSQLJava version1.6.0_11
OS VersionrPath LinuxDatabase version8.3.5Ant version1.7.1
Product Version2.50MP1SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0009275: Import Order fails with new products

DescriptionIf you add in a imported order a product which doesn't exist in sample data (created by the user) the process of import orders fails.
Steps To Reproduce1) Create a new Product with search key: banana

2) Follow this test case:
http://wiki.openbravo.com/wiki/QA_test_plan_2.50/Test_cases [^]
with I_Orders.txt:
AA875875875RRTT,Pos Order,bellphone,banana,100,10.5,102

3) Go to Master Data Management -> Import Data -> Import Orders

4) Select corresponding order and press Import Orders button.
Tags250MP3releasecandidate, suresh
Attached Filespng file icon import file loader.png [^] (157,017 bytes) 2009-06-12 08:58


png file icon order processed.png [^] (157,247 bytes) 2009-06-12 08:58


png file icon importing error.png [^] (81,986 bytes) 2009-06-12 11:13


txt file icon errorLog.txt [^] (8,942 bytes) 2009-06-13 11:07 [Show Content]
? file icon ImportOrder.java [^] (41,103 bytes) 2009-06-14 23:41

- Relationships [ Relation Graph ] [ Dependency Graph ]
has duplicate defect 0009279 closedjonalegriaesarte Openbravo ERP Syncronization with Openbravo POS doesn't work correctly with non-sample products. 
blocks defect 00093542.40 closedadrianromero Java Client POS Import Order fails with new products and business partners 

-  Notes
(0017051)
rafaroda (developer)
2009-06-05 18:49

 Seems to be an UUID issue in the import orders process.

Please also try to crash it with the following I_Orders.txt:
AA875875875rrrRRTT,Pos Order,mycustomer,beer,100,10.5,102
Having first created a Business Partner with search key: mycustomer
(0017227)
sathiyan (reporter)
2009-06-12 08:47

 I am able to import and process the order. I guess the reporter might miss the constant value for any of the fields Organization or Warehouse. However I have attached screen shots for that.
(0017228)
sathiyan (reporter)
2009-06-12 08:57

 I am reopening this for the purpose of attach screen shots.
(0017229)
sathiyan (reporter)
2009-06-12 08:58

 Please refer the screen shots.
(0017237)
mirurita (developer)
2009-06-12 11:12

 The import file loader works for me and it creates the imported orders correctly (as is shown in your screenshots).

The problem is in the step 4) and 5) described in Steps to reproduce field.

3) Go to Master Data Management -> Import Data -> Import Orders

4) Select corresponding order and press Import Orders button.


After loading the imports (in Import File Loader) go to Master Data Management || Import Data || Import Orders.
Select the previously imported orders (open in edit mode).
Select POS Order in Document type jcombobox and press (in the bottom) the Import Orders button (Complete and process orders automatically checkbox selected).

When the process finish it shows an error.
(0017278)
bennyfake (reporter)
2009-06-13 11:08

 Hi, I got the similar case, please let me know if it is not. I input the data via Import Order interface and I got the same error message.

I attached the error log file for the reference. (errorLog.txt)

I found there had a error log :
ERROR org.openbravo.erpCommon.ad_process.ImportProcess - process - @CODE=@For input string: "90AA7116D53D41CE8761322BD25CC104"

90AA7116D53D41CE8761322BD25CC104 is the UUID code of my specific product id in m_product table.
(0017279)
icematrix3k (reporter)
2009-06-14 23:41
edited on: 2009-06-14 23:42

 I've attached the file with the fix, the import should work now.
(0017280)
sathiyan (reporter)
2009-06-15 07:24

 icematrix3k: You have changed some of the code here (taking business partner and location from different data class). You could justify the changes of those better. Can I reassign this bug to you?

Regards
Sathiyan.
(0017340)
rafaroda (developer)
2009-06-16 11:23
edited on: 2009-06-18 15:55

 Sathiyan, please first reproduce the issue then review the patch attached.

Thanks.
(0017432)
icematrix3k (reporter)
2009-06-18 20:14
edited on: 2009-06-18 20:27

 Sathiyan: Sure. Basically, it runs *Integer.parseInt()* on ID's, and since the change to UUID (varchar in database), the check fails, and hence the Import Process error.
(0017546)
hgbot (developer)
2009-06-23 14:23

 Repository: erp/devel/pi
Changeset: 27b9c6b0026bf4f46387a72c68faae0c2d9f431d
Author: Sathiyan Sivaprakasam <sathiyan.sivaprakasam <at> openbravo.com>
Date: Tue Jun 23 17:52:25 2009 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/27b9c6b0026bf4f46387a72c68faae0c2d9f431d [^]

Fixes Issue 9275: Import Order fails with new products.

---
M src/org/openbravo/erpCommon/ad_process/ImportOrder.java
---
(0017547)
sathiyan (reporter)
2009-06-23 14:30

 mirurita and bennyfake: I have fixed this issue. Please let me know if you have any other issue on this process. Price List is mandatory for any product (I hope you have added price list for banana product through price list tab). So please take care of it.

Thanks
Sathiyan.
(0018389)
waves (reporter)
2009-07-20 02:33

 We are facing similar issue. We updated ImportOrder.java with the new file but it is not working. Shoud we do something else to apply this patch?

thanks
(0018523)
sureshbabu (reporter)
2009-07-22 08:29

 Working fine after we select the price list manually

- Issue History
Date Modified Username Field Change
2009-06-01 19:13 mirurita New Issue
2009-06-01 19:13 mirurita Assigned To => rafaroda
2009-06-01 21:49 icematrix3k Issue Monitored: icematrix3k
2009-06-02 09:24 rafaroda Relationship added related to 0009279
2009-06-05 13:09 psarobe Status new => scheduled
2009-06-05 13:09 psarobe fix_in_branch => pi
2009-06-05 15:34 rafaroda Relationship replaced has duplicate 0009279
2009-06-05 18:14 mirurita Relationship added blocks 0009354
2009-06-05 18:49 rafaroda Note Added: 0017051
2009-06-05 18:49 rafaroda Assigned To rafaroda => sathiyan
2009-06-05 18:49 rafaroda Priority normal => high
2009-06-05 18:49 rafaroda fix_in_branch pi =>
2009-06-05 18:49 rafaroda Summary Imort Order fails with new products => Import Order fails with new products
2009-06-05 18:49 rafaroda Description Updated
2009-06-05 18:49 rafaroda Proposed Solution updated
2009-06-12 08:47 sathiyan Status scheduled => closed
2009-06-12 08:47 sathiyan Note Added: 0017227
2009-06-12 08:47 sathiyan Resolution open => unable to reproduce
2009-06-12 08:50 sathiyan Issue Monitored: sathiyan
2009-06-12 08:57 sathiyan Status closed => new
2009-06-12 08:57 sathiyan Resolution unable to reproduce => open
2009-06-12 08:57 sathiyan Note Added: 0017228
2009-06-12 08:58 sathiyan File Added: import file loader.png
2009-06-12 08:58 sathiyan File Added: order processed.png
2009-06-12 08:58 sathiyan Status new => closed
2009-06-12 08:58 sathiyan Note Added: 0017229
2009-06-12 11:12 mirurita Status closed => new
2009-06-12 11:12 mirurita Note Added: 0017237
2009-06-12 11:13 mirurita File Added: importing error.png
2009-06-13 11:07 bennyfake File Added: errorLog.txt
2009-06-13 11:08 bennyfake Note Added: 0017278
2009-06-13 11:09 bennyfake Issue Monitored: bennyfake
2009-06-14 23:41 icematrix3k File Added: ImportOrder.java
2009-06-14 23:41 icematrix3k Note Added: 0017279
2009-06-14 23:42 icematrix3k Note Edited: 0017279
2009-06-15 07:24 sathiyan Note Added: 0017280
2009-06-16 11:23 rafaroda Note Added: 0017340
2009-06-16 11:23 rafaroda Status new => scheduled
2009-06-18 15:55 rafaroda Note Edited: 0017340
2009-06-18 20:14 icematrix3k Note Added: 0017432
2009-06-18 20:27 icematrix3k Note Edited: 0017432
2009-06-23 14:23 hgbot Checkin
2009-06-23 14:23 hgbot Note Added: 0017546
2009-06-23 14:23 hgbot Status scheduled => resolved
2009-06-23 14:23 hgbot Resolution open => fixed
2009-06-23 14:23 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/27b9c6b0026bf4f46387a72c68faae0c2d9f431d [^]
2009-06-23 14:30 sathiyan Note Added: 0017547
2009-07-20 02:33 waves Note Added: 0018389
2009-07-21 16:24 psarobe Fixed in Version => 2.50MP3
2009-07-21 16:26 psarobe Tag Attached: 250MP3releasecandidate
2009-07-21 19:20 psarobe Tag Attached: suresh
2009-07-22 08:29 sureshbabu Status resolved => closed
2009-07-22 08:29 sureshbabu Note Added: 0018523
2009-07-22 08:29 sureshbabu Fixed in Version 2.50MP3 => pi
2009-07-23 00:00 anonymous sf_bug_id 0 => 2825598

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker