Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0024653Openbravo ERP09. Financial managementpublic2013-09-02 12:032013-09-02 13:03
Reporterazabaleta 
Assigned Todmiguelez 
PrioritynormalSeverityminorReproducibilityalways
StatusnewResolutionopen 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0024653: c_Locfrom_Id,c_Locto_Id columns in fact_acct make the application go slower. Wrong AD reference definition.
DescriptionThe log shows
e280dd67 07:12:17 [ajp-8009-3] WARN org.openbravo.client.application.window.FormInitializationComponent - Warning: In the window Financial Account, in tab Accounting History the combo fields inpcLocfromId,inpcLoctoId contain more than 1000 entries, and this could cause bad performance in the application. Possible fixes include changing these columns from a combo into a Selector, or adding a validation to reduce the number of entries in the combo.
Steps To ReproduceRun Openbravo
Import 10.000 business partners with addresses
Proposed SolutionChange the column reference definition in Openbravo AD
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2013-09-02 12:03azabaletaNew Issue
2013-09-02 12:03azabaletaAssigned To => dmiguelez
2013-09-02 12:03azabaletaModules => Core
2013-09-02 12:03azabaletaTriggers an Emergency Pack => No
2013-09-02 13:03azabaletaNote Added: 0060861

Notes
(0060861)
azabaleta   
2013-09-02 13:03   
Also C_PROJECT_ID has same problem in FACT_ACCT table.

I would suggest going through all tables in "Tables and Columns" and change all C_PROJECT references to fix the whole potential problem instead of only in FACT_ACCT