0047671: Multipricelist tests are failing in high volume

Openbravo Issue Tracking System - Retail Modules

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0047671

Retail Modules

Web POS

public

2021-09-10 12:23

2021-09-10 12:35

Reporter

prakashmurugesan88

Assigned To

prakashmurugesan88

Priority

normal

Severity

major

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS Version

Product Version

Target Version

Fixed in Version

RR21Q4

Merge Request Status

Review Assigned To

marvintm

OBNetwork customer

Support ticket

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

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/ [^]

Proposed Solution

Additional Information