Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0005539Openbravo ERPI. Performancepublic2008-10-15 16:262009-04-21 11:05
ReporterjacoboGiralt 
Assigned Toalostale 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS Version
Product Version2.40 
Target VersionFixed in Versionpi 
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
Summary0005539: Importing big amounts of bpartners crashes the application in every window.
DescriptionThe default business partner import process creates a row in AD_USER for each business partner as contact.
But having lots of users in AD_USER limits the performance of the application in every window because of the audit drop-down (createdby) to the extent of crashing it when executing utils.js.
Steps To Reproduce1. Import lots of business partners (client tried with 25000 but should happen with less)
2. Create a new row in any window
3. Application crashes
Proposed SolutionEliminate the createdby drop-down and substitute it for a filtered pop-up.

or

Change the default bpartner import so that it doesn't create the same number of users.
Additional Information
Tagsperformance2.40scrum, Sprint-3
Relationships
depends on backport 0005540 closed alostale Importing big amounts of bpartners crashes the application in every window. 
related to defect 0005862 closed alostale The change from combo-boxes to textfields for CreatedBy & UpdatedBy removes link for navigating to the User/Contect 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-10-15 16:26jacoboGiraltNew Issue
2008-10-15 16:26jacoboGiraltAssigned To => cromero
2008-10-15 16:26jacoboGiraltsf_bug_id0 => 2168622
2008-10-15 16:36cromeroSeveritycritical => major
2008-10-15 16:36cromeroCategory02. Master data management => I. Performance
2008-10-15 16:36cromeroStatusnew => scheduled
2008-10-15 16:36cromeroAssigned Tocromero => shuehner
2008-10-15 16:36cromerofix_in_branch => trunk
2008-10-15 16:50shuehnerAssigned Toshuehner => iperdomo
2008-10-24 19:20iperdomoAssigned Toiperdomo => alostale
2008-11-06 17:13shuehnerNote Added: 0010046
2008-11-06 17:16shuehnerStatusscheduled => resolved
2008-11-06 17:16shuehnerFixed in Version => trunk
2008-11-06 17:16shuehnersvn_revision => 9554
2008-11-06 17:16shuehnerResolutionopen => fixed
2008-11-06 17:16shuehnerNote Added: 0010049
2008-11-06 17:24shuehnerRelationship addedrelated to 0005862
2008-11-06 17:46shuehnerTag Attached: performance2.40scrum
2008-11-06 17:46shuehnerTag Attached: Sprint-3
2009-04-21 11:05psarobeStatusresolved => closed

Notes
(0010046)
shuehner   
2008-11-06 17:13   
This is fixed in trunk. But the commits got assigned to the wrong issue. Fixed by changing all references to CreatedBy & UpdatedBy to be normal textfields instead of combo-boxes. So the big number of imported customers is no problem anymore.
(0010049)
shuehner   
2008-11-06 17:16   
The commits to fix this got accidently assigned to issue 5620, repeating the commit messages here and close this issue.

Repository: openbravo
Revision: 9531
Author: alostale
Date: 2008-10-31 17:55:34 +0100 (Fri, 31 Oct 2008)

fixed bug 0005620: Don't show all the users in the audit info fields

---
U trunk/src-wad/src/org/openbravo/wad/Fields_data.xsql
U trunk/src-wad/src/org/openbravo/wad/Wad.java
U trunk/src-wad/src/org/openbravo/wad/WadUtility.java
U trunk/src-wad/src/org/openbravo/wad/datasource.xsqlxml

Repository: openbravo
Revision: 9532
Author: alostale
Date: 2008-10-31 17:58:05 +0100 (Fri, 31 Oct 2008)

fixed bug 0005620: Don't show all the users in the audit info fields (db function)

---
U trunk/src-db/database/model/functions/AD_TABLE_IMPORT.xml

Repository: openbravo
Revision: 9533
Author: alostale
Date: 2008-10-31 18:02:17 +0100 (Fri, 31 Oct 2008)

fixed bug 0005620: Don't show all the users in the audit info fields (db data)

---
U trunk/src-db/database/sourcedata/AD_COLUMN.xml

Repository: openbravo
Revision: 9550
Author: alostale
Date: 2008-11-03 09:28:49 +0100 (Mon, 03 Nov 2008)

fixed bug 0005620: Fixed warnings about not found columns when generating windows

---
U trunk/src-wad/src/org/openbravo/wad/WadUtility.java

Repository: openbravo
Revision: 9552
Author: alostale
Date: 2008-11-03 09:37:35 +0100 (Mon, 03 Nov 2008)

fixed bug 0005620: Fixed minor bugs with this issue

---
U trunk/src-wad/src/org/openbravo/wad/Fields_data.xsql
U trunk/src-wad/src/org/openbravo/wad/WadUtility.java

Repository: openbravo
Revision: 9554
Author: huehner
Date: 2008-11-03 09:48:16 +0100 (Mon, 03 Nov 2008)

Issue 5620
add missing 'as' to fix sql statement on postgres

---
U trunk/src-wad/src/org/openbravo/wad/Fields_data.xsql