Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0012420
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformmajoralways2010-02-23 17:042010-03-16 00:00
ReporternetworkbView Statuspublic 
Assigned Toshuehner 
PriorityurgentResolutionfixedFixed in Version2.50MP14
StatusclosedFix in branchFixed in SCM revisionefdbe4e29619
ProjectionnoneETAnoneTarget Version2.50MP14
OSLinux 64 bitDatabasePostgreSQLJava version
OS VersionDatabase versionAnt version
Product VersionmainSCM revision 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0012420: 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.
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 0011913 closedharikrishnan Deactivated products continue appearing in Price Lists Versions 

-  Notes
(0024758)
hgbot (developer)
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 (viewer)
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 (viewer)
2010-03-15 16:17

 Tested that it works (the grid rows are shown, after a little bit of delay) on Postgre 8.4.

- Issue History
Date Modified Username Field Change
2010-02-23 17:04 networkb New Issue
2010-02-23 17:04 networkb Assigned To => alostale
2010-02-23 17:04 networkb OBNetwork customer => Yes
2010-02-23 17:17 shuehner Assigned To alostale => shuehner
2010-02-23 17:28 shuehner Relationship added related to 0011913
2010-02-23 18:40 hgbot Checkin
2010-02-23 18:40 hgbot Note Added: 0024758
2010-02-23 18:40 hgbot Status new => resolved
2010-02-23 18:40 hgbot Resolution open => fixed
2010-02-23 18:40 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/efdbe4e296198f843a8477068952d6afa5aa57d3 [^]
2010-03-08 16:06 jpabloae Target Version 2.50MP13 => 2.50MP14
2010-03-12 22:39 hudsonbot Checkin
2010-03-12 22:39 hudsonbot Note Added: 0025310
2010-03-15 16:17 marvintm Note Added: 0025482
2010-03-15 16:17 marvintm Status resolved => closed
2010-03-15 16:17 marvintm Fixed in Version => 2.50MP14
2010-03-16 00:00 anonymous sf_bug_id 0 => 2970933

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker