Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0016308 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 02. Master data management | major | always | 2011-03-15 14:41 | 2011-03-17 00:00 | |||
| Reporter | adrianromero | View Status | public | |||||
| Assigned To | adrianromero | |||||||
| Priority | urgent | Resolution | fixed | Fixed in Version | 3.0RC6 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | 84d59a44cabd | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | PostgreSQL | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | pi | 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 | 0016308: When importing POS orders and in some special conditions some orders are created to one order in the temporal table (i_order) | |||||||
| Description | When importing POS orders and in some special conditions some orders are created to one order in the temporal table (i_order). It could happen that data are not sorted correctly and if there are two lines for the same order, another order could appear between these lines and two orders are generated to the same order. For example: Order1 Documentno: 1 Order2 Documentno: 2 Order2 Documentno: 2 Order1 Documentno: 1 | |||||||
| Steps To Reproduce | - Master Data Management || Import Data || Import Orders - Import 1000 lines (500 different orders) - Some orders are created to one POS order in table i_order (we can provide a database to reproduce the problem) | |||||||
| Proposed Solution | The problem is in method selectNotImported in src/org/openbravo/erpCommon/ad_process/ImportOrder_data.xsql. Actually the order by is: Order by dateordered, documentno,.... and i think that it should be: Order by ad_client_id, documentno, dateordered,.... | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0034889) hgbot (developer) 2011-03-15 14:48 |
Repository: erp/devel/pi Changeset: 84d59a44cabdbf7185bfaa47487e95c728b97926 Author: Adrián Romero <adrianromero <at> openbravo.com> Date: Tue Mar 15 14:47:00 2011 +0100 URL: http://code.openbravo.com/erp/devel/pi/rev/84d59a44cabdbf7185bfaa47487e95c728b97926 [^] Fixes issue 0016308: When importing POS orders and in some special conditions some orders are created to one order in the temporal table (i_order) It has been modified the order of fields in the ORDER BY clause to order first by document number. --- M src/org/openbravo/erpCommon/ad_process/ImportOrder_data.xsql --- |
|
(0034890) adrianromero (manager) 2011-03-15 14:48 |
* Testing the issue Follow the steps to test and verify that now only two orders are created instead of three. Verify also that the related issue 11926 works as expected. * Areas affected No other areas affected. Just the Import orders process has been modified. |
|
(0034968) jonalegriaesarte (reporter) 2011-03-16 19:11 |
Verified |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2011-03-15 14:41 | adrianromero | New Issue | |
| 2011-03-15 14:41 | adrianromero | Assigned To | => adrianromero |
| 2011-03-15 14:41 | adrianromero | Modules | => Core |
| 2011-03-15 14:41 | adrianromero | Issue generated from | 0015984 |
| 2011-03-15 14:41 | adrianromero | Relationship added | blocks 0015984 |
| 2011-03-15 14:48 | hgbot | Checkin | |
| 2011-03-15 14:48 | hgbot | Note Added: 0034889 | |
| 2011-03-15 14:48 | hgbot | Status | new => resolved |
| 2011-03-15 14:48 | hgbot | Resolution | open => fixed |
| 2011-03-15 14:48 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/84d59a44cabdbf7185bfaa47487e95c728b97926 [^] |
| 2011-03-15 14:48 | adrianromero | Note Added: 0034890 | |
| 2011-03-16 19:11 | jonalegriaesarte | Note Added: 0034968 | |
| 2011-03-16 19:11 | jonalegriaesarte | Status | resolved => closed |
| 2011-03-16 19:11 | jonalegriaesarte | Fixed in Version | => 3.0RC6 |
| 2011-03-17 00:00 | anonymous | sf_bug_id | 0 => 3217699 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |