Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0047671 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Retail Modules] Web POS | major | always | 2021-09-10 12:23 | 2021-09-10 12:35 | |||
| Reporter | prakashmurugesan88 | View Status | public | |||||
| Assigned To | prakashmurugesan88 | |||||||
| Priority | normal | Resolution | fixed | Fixed in Version | RR21Q4 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | |||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| Review Assigned To | marvintm | |||||||
| Regression level | ||||||||
| Regression date | 2021-08-16 | |||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/commit/6cf75dd592aba8967cc00ad0c1adadcc3ee848ef#118d8739ba276df2646719d10c7744f7869da9bd_118_128 [^] | |||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0047671: Multipricelist tests are failing in high volume | |||||||
| Description | Multipricelist tests are failing in high volume https://builds.openbravo.com/view/retail-highvol/job/ret-highvol-pgsql/330/ [^] Log has following error, 2021-09-09 19:57:26,116 [http-9] ERROR org.openbravo.mobile.core.process.ProcessHQLQuery - org.openbravo.retail.posterminal.master.ProductPrice: Error when generating query: select ppp.id as id, ppp.id as m_productprice_id, plv.priceList.id as m_pricelist_id, ppp.product.id as m_product_id, ppp.listPrice as pricelist, ppp.standardPrice as pricestd, ppp.priceLimit as pricelimit, plv.validFromDate as validFromDate, ppp.active as active from OBRETCO_Prol_Product as pli, PricingProductPrice ppp left join ppp.priceListVersion as plv where pli.product.id = ppp.product.id and pli.obretcoProductlist.id = :productListId and plv.active = true and exists ( select 1 from PricingPriceListVersion plv, BusinessPartner bp where plv.priceList.id = bp.priceList.id and ( (bp.client.id in ('39363B0921BB4293B48383844325E84C', '0')) and (bp.active = 'Y') ) and ( bp.organization.id in (:valueEqArray2 )) and plv.active = true and plv.validFromDate = ( select max(plv2.validFromDate) from PricingPriceListVersion as plv2 where plv.priceList.id = plv2.priceList.id and plv2.validFromDate <= :validFromDate group by plv2.priceList.id ) and plv.priceList.id <> (:priceList) and plv.id = ppp.priceListVersion.id and bp.customer='Y' ) and ( (ppp.product.id=:valueEqId0 ) AND (plv.priceList.id=:valueEqId1 ) ) and 1=1 and ( pli.organization.id in (:valueEqArray2 )) and ( (pli.client.id in ('39363B0921BB4293B48383844325E84C', '0')) and (pli.active = 'Y') ) and ( (pli.active = 'Y') and (plv.priceList.active = 'Y') and (ppp.active = 'Y') ) and 1=1 order by ppp.id asc (could not extract ResultSet) org.hibernate.exception.GenericJDBCException: could not extract ResultSet | |||||||
| Steps To Reproduce | Test failing in highvolume, https://builds.openbravo.com/view/retail-highvol/job/ret-highvol-pgsql/330/ [^] | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0131699) prakashmurugesan88 (developer) 2021-09-10 12:32 |
Created Merge Request, https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/merge_requests/571 [^] |
|
(0131700) hgbot (developer) 2021-09-10 12:35 |
Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal [^] Changeset: 043a2000e26a51e9dec955c10de0c3c058753e8a Author: Prakash M <prakash@qualiantech.com> Date: 2021-09-10T15:59:03+05:30 URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/commit/043a2000e26a51e9dec955c10de0c3c058753e8a [^] Fixed BUG-47671: Removed bp readableClientCriteria validation in ProductPrice * As it creates performance regression in HighVolume --- M src/org/openbravo/retail/posterminal/master/ProductPrice.java --- |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2021-09-10 12:23 | prakashmurugesan88 | New Issue | |
| 2021-09-10 12:23 | prakashmurugesan88 | Assigned To | => prakashmurugesan88 |
| 2021-09-10 12:23 | prakashmurugesan88 | Regression date | => 2021-08-16 |
| 2021-09-10 12:23 | prakashmurugesan88 | Regression introduced by commit | => https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/commit/6cf75dd592aba8967cc00ad0c1adadcc3ee848ef#118d8739ba276df2646719d10c7744f7869da9bd_118_128 [^] |
| 2021-09-10 12:23 | prakashmurugesan88 | Triggers an Emergency Pack | => No |
| 2021-09-10 12:27 | prakashmurugesan88 | Status | new => scheduled |
| 2021-09-10 12:32 | prakashmurugesan88 | Note Added: 0131699 | |
| 2021-09-10 12:35 | hgbot | Resolution | open => fixed |
| 2021-09-10 12:35 | hgbot | Status | scheduled => resolved |
| 2021-09-10 12:35 | hgbot | Fixed in Version | => RR21Q4 |
| 2021-09-10 12:35 | hgbot | Note Added: 0131700 | |
| 2021-09-10 12:35 | marvintm | Review Assigned To | => marvintm |
| 2021-09-10 12:35 | marvintm | Status | resolved => closed |
| 2021-10-18 11:53 | ranjith_qualiantech_com | Relationship added | related to 0047262 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |