Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0014056Openbravo ERP07. Sales managementpublic2010-07-27 09:342010-12-16 22:15
Reporternetworkb 
Assigned Toharikrishnan 
PriorityhighSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.40MP16 
Target Version2.50MP22Fixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0014056: Error when we try copy 1039 lines
DescriptionORA-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
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-07-27 09:34networkbNew Issue
2010-07-27 09:34networkbAssigned To => adrianromero
2010-07-27 09:36networkbversion2.50MP20 => 2.40MP16
2010-08-10 09:13adrianromeroStatusnew => scheduled
2010-08-10 09:13adrianromerofix_in_branch => pi
2010-08-11 13:57harikrishnanAssigned Toadrianromero => harikrishnan
2010-08-11 14:00hgbotCheckin
2010-08-11 14:00hgbotNote Added: 0029891
2010-08-11 14:00hgbotStatusscheduled => resolved
2010-08-11 14:00hgbotResolutionopen => fixed
2010-08-11 14:00hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/4d417ee08780113c5e97ee9bb5cf1f5a0babd6f7 [^]
2010-08-11 14:01harikrishnanNote Added: 0029892
2010-08-12 21:12hudsonbotCheckin
2010-08-12 21:12hudsonbotNote Added: 0029926
2010-08-15 20:10sureshbabuNote Added: 0029966
2010-08-19 13:57hgbotCheckin
2010-08-19 13:57hgbotNote Added: 0030154
2010-08-19 13:57hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/4d417ee08780113c5e97ee9bb5cf1f5a0babd6f7 [^] => http://code.openbravo.com/erp/devel/pi/rev/18ec4b4bf2294c6cfa3ca53416f6285e2c21db56 [^]
2010-08-21 00:06hudsonbotCheckin
2010-08-21 00:06hudsonbotNote Added: 0030201
2010-12-14 18:29psarobeStatusresolved => closed
2010-12-16 22:15anonymoussf_bug_id0 => 3138777

Notes
(0029891)
hgbot   
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   
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   
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   
2010-08-15 20:10   
@Hari, can you pass the query to insert more then 1000 records, which you used for testing
(0030154)
hgbot   
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   
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 [^]