Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0014056 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 07. Sales management | minor | always | 2010-07-27 09:34 | 2010-12-16 22:15 | |||
| Reporter | networkb | View Status | public | |||||
| Assigned To | harikrishnan | |||||||
| Priority | high | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | pi | Fixed in SCM revision | 18ec4b4bf229 | |||
| Projection | none | ETA | none | Target Version | 2.50MP22 | |||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | 2.40MP16 | SCM revision | ||||||
| Merge Request Status | ||||||||
| Review Assigned To | ||||||||
| OBNetwork customer | OBPS | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0014056: Error when we try copy 1039 lines | |||||||
| Description | ORA-01795: el número máximo de expresiones en una lista es 1000 This error appears when we try copy 1039 lines using 'Copy Lines From' button. In Oracle | |||||||
| Steps To Reproduce | - Go to Sales Management || Transactions || Goods Shipment - Create a new record (BP: McGiver)with 1039 lines - Complete it. - Go to Sales Management || Transactions || Sales Invoice - BP: McGiver - 'Copy Lines from' - Select the good shipment created. - Realize that the error appears | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0029891) hgbot (developer) 2010-08-11 14:00 |
Repository: erp/devel/pi Changeset: 4d417ee08780113c5e97ee9bb5cf1f5a0babd6f7 Author: Harikrishnan Raja <harikrishnan.raja <at> openbravo.com> Date: Wed Aug 11 17:29:11 2010 +0530 URL: http://code.openbravo.com/erp/devel/pi/rev/4d417ee08780113c5e97ee9bb5cf1f5a0babd6f7 [^] Fixes Issue 14056: Error when we try copy 1039 lines. --- M src/org/openbravo/erpCommon/ad_actionButton/CreateFrom.java --- |
|
(0029892) harikrishnan (viewer) 2010-08-11 14:01 |
Steps to test: These are the places that this issue should be verified.Check "Create Lines From " Button on these places *Procurement Management || Transactions || Goods Receipt || Header *Procurement Management || Transactions || Purchase Invoice || Header *Sales Management || Transactions || Goods Shipment || Header *Sales Management || Transactions || Sales Invoice || Header *Financial Management || Receivables & Payables || Transactions || Bank Statement || Header *Financial Management || Receivables & Payables || Transactions || Remittance || Header *Financial Management || Receivables & Payables || Transactions || Payment Status Management || Header *Financial Management || Receivables & Payables || Transactions || Settlement || Settlement . Check with more than 1000 records in the lines. Root Cause: *Oracle wont allow more than 1000 records in the IN clause.Hence in that scenario we have to pass less records to this IN clause. Impact: *The impact above mentioned modules,but they are tested well. |
|
(0029926) hudsonbot (viewer) 2010-08-12 21:12 |
A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated: Changeset: http://code.openbravo.com/erp/devel/main/rev/4d417ee08780 [^] Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/dd00ba1c00c6 [^] Tests: http://builds.openbravo.com/view/int/ [^] OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.18116.obx [^] |
|
(0029966) sureshbabu (viewer) 2010-08-15 20:10 |
@Hari, can you pass the query to insert more then 1000 records, which you used for testing |
|
(0030154) hgbot (developer) 2010-08-19 13:57 |
Repository: erp/devel/pi Changeset: 18ec4b4bf2294c6cfa3ca53416f6285e2c21db56 Author: Harikrishnan Raja <harikrishnan.raja <at> openbravo.com> Date: Thu Aug 19 17:27:51 2010 +0530 URL: http://code.openbravo.com/erp/devel/pi/rev/18ec4b4bf2294c6cfa3ca53416f6285e2c21db56 [^] Fixes Issue 14056: Changes done in the code review --- M src/org/openbravo/erpCommon/ad_actionButton/CreateFrom.java --- |
|
(0030201) hudsonbot (viewer) 2010-08-21 00:06 |
A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated: Changeset: http://code.openbravo.com/erp/devel/main/rev/18ec4b4bf229 [^] Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/eedf97667060 [^] Tests: http://builds.openbravo.com/view/int/ [^] OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.18194.obx [^] |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2010-07-27 09:34 | networkb | New Issue | |
| 2010-07-27 09:34 | networkb | Assigned To | => adrianromero |
| 2010-07-27 09:34 | networkb | OBNetwork customer | => Yes |
| 2010-07-27 09:36 | networkb | version | 2.50MP20 => 2.40MP16 |
| 2010-08-10 09:13 | adrianromero | Status | new => scheduled |
| 2010-08-10 09:13 | adrianromero | fix_in_branch | => pi |
| 2010-08-11 13:57 | harikrishnan | Assigned To | adrianromero => harikrishnan |
| 2010-08-11 14:00 | hgbot | Checkin | |
| 2010-08-11 14:00 | hgbot | Note Added: 0029891 | |
| 2010-08-11 14:00 | hgbot | Status | scheduled => resolved |
| 2010-08-11 14:00 | hgbot | Resolution | open => fixed |
| 2010-08-11 14:00 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/4d417ee08780113c5e97ee9bb5cf1f5a0babd6f7 [^] |
| 2010-08-11 14:01 | harikrishnan | Note Added: 0029892 | |
| 2010-08-12 21:12 | hudsonbot | Checkin | |
| 2010-08-12 21:12 | hudsonbot | Note Added: 0029926 | |
| 2010-08-15 20:10 | sureshbabu | Note Added: 0029966 | |
| 2010-08-19 13:57 | hgbot | Checkin | |
| 2010-08-19 13:57 | hgbot | Note Added: 0030154 | |
| 2010-08-19 13:57 | hgbot | Fixed in SCM revision | http://code.openbravo.com/erp/devel/pi/rev/4d417ee08780113c5e97ee9bb5cf1f5a0babd6f7 [^] => http://code.openbravo.com/erp/devel/pi/rev/18ec4b4bf2294c6cfa3ca53416f6285e2c21db56 [^] |
| 2010-08-21 00:06 | hudsonbot | Checkin | |
| 2010-08-21 00:06 | hudsonbot | Note Added: 0030201 | |
| 2010-12-14 18:29 | psarobe | Status | resolved => closed |
| 2010-12-16 22:15 | anonymous | sf_bug_id | 0 => 3138777 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |