Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0012420Openbravo ERPA. Platformpublic2010-02-23 17:042010-03-16 00:00
Reporternetworkb 
Assigned Toshuehner 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS30OS Version
Product Versionmain 
Target Version2.50MP14Fixed in Version2.50MP14 
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
Summary0012420: The entries on the produt price tab on the pricelist list window are not showed on the grid if the table has a lot of rows.
DescriptionThe entries on the produt price tab on the pricelist list window are not showed on the grid if the table has a lot of rows.

You get the following error when loading the grid:
      
Error:
The data can be incomplete because the server not replayed at specified time. Check the connection with the server.

Steps To Reproduce-Import a lot of rows (we did with 260.000 entries) on thre product price table.
-Go to Master Data Management || Pricing || Price List || Price List >> Price List Version >> Product Price
-Click on the filter window and filter without fill any field.
You get the following error:
Error:
The data can be incomplete because the server not replayed at specified time. Check the connection with the server.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0011913 closed harikrishnan Deactivated products continue appearing in Price Lists Versions 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-02-23 17:04networkbNew Issue
2010-02-23 17:04networkbAssigned To => alostale
2010-02-23 17:17shuehnerAssigned Toalostale => shuehner
2010-02-23 17:28shuehnerRelationship addedrelated to 0011913
2010-02-23 18:40hgbotCheckin
2010-02-23 18:40hgbotNote Added: 0024758
2010-02-23 18:40hgbotStatusnew => resolved
2010-02-23 18:40hgbotResolutionopen => fixed
2010-02-23 18:40hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/efdbe4e296198f843a8477068952d6afa5aa57d3 [^]
2010-03-08 16:06jpabloaeTarget Version2.50MP13 => 2.50MP14
2010-03-12 22:39hudsonbotCheckin
2010-03-12 22:39hudsonbotNote Added: 0025310
2010-03-15 16:17marvintmNote Added: 0025482
2010-03-15 16:17marvintmStatusresolved => closed
2010-03-15 16:17marvintmFixed in Version => 2.50MP14
2010-03-16 00:00anonymoussf_bug_id0 => 2970933

Notes
(0024758)
hgbot   
2010-02-23 18:40   
Repository: erp/devel/pi
Changeset: efdbe4e296198f843a8477068952d6afa5aa57d3
Author: Stefan Hühner <stefan.huehner <at> openbravo.com>
Date: Tue Feb 23 18:42:24 2010 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/efdbe4e296198f843a8477068952d6afa5aa57d3 [^]

Fixed 12420: Optimize whereclause
to make grid view of product price tab faster with many products & prices

---
M src-db/database/sourcedata/AD_TAB.xml
---
(0025310)
hudsonbot   
2010-03-12 22:39   
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/efdbe4e29619 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/631c626866c1 [^]
Tests: http://builds.openbravo.com/view/devel-int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.16685.obx [^]
(0025482)
marvintm   
2010-03-15 16:17   
Tested that it works (the grid rows are shown, after a little bit of delay) on Postgre 8.4.