2024-03-19 18:32:05,847 [http-nio-127.0.0.1-8080-exec-18] ERROR org.hibernate.engine.jdbc.spi.SqlExceptionHelper - ERROR: canceling statement due to user request
2024-03-19 18:32:05,847 [http-nio-127.0.0.1-8080-exec-18] ERROR org.openbravo.mobile.core.process.ProcessHQLQuery - org.openbravo.retail.posterminal.master.DiscountFilterProduct: Error when generating que
ry:  select ap.id as id, 
ap.priceAdjustment.id as priceAdjustment, 
p.id as product, 
p.searchKey as searchKey, 
ap.obdiscIsGift as obdiscIsGift, 
ap.obdiscQty as obdiscQty, 
ap.obdiscGifqty as obdiscGifqty, 
concat(ap.priceAdjustment.name, ' - ', p.name) as _identifier, 
p.name as productIdentifier, 
case when ap.active = 'Y' and ap.priceAdjustment.active = 'Y' and p.active = 'Y' and coalesce(pl.active, 'Y') = 'Y' then true else false end as active, 
ap.priceAdjustmentType as priceAdjustmentType, 
ap.discount as discount, 
ap.discountAmount as discountAmount, 
ap.fixedPrice as fixedPrice, 
ap.startingDate as startingDate, 
ap.endingDate as endingDate  from PricingAdjustmentProduct ap inner join ap.product as p  inner join p.oBRETCOProlProductList pl with (pl.obretcoProductlist.id in ('78EFE7608CFD4E36904E18D8B16BCCED','7D05
FCBC3FCF4EB7A925796F42DF644B'))  where ( ap.updated> :valueDate1   OR   ap.priceAdjustment.updated> :valueDate1   OR   p.updated> :valueDate1   OR   pl.updated> :valueDate1 ) and exists (   select 1   fro
m PricingAdjustment p where p.client.id = '20AE5337AF18478688937D0C81F9B0F9' and ((includePriceLists='Y'   and not exists (select 1          from PricingAdjustmentPriceList pl        where active = true  
        and pl.priceAdjustment = p          and pl.priceList.id ='EFA748D5E4F24FC5AED0E37A3E2B3565'))    or (includePriceLists='N'   and  exists (select 1          from PricingAdjustmentPriceList pl      
  where active = true          and pl.priceAdjustment = p          and pl.priceList.id ='EFA748D5E4F24FC5AED0E37A3E2B3565'))     ) and ((p.includedProducts = 'Y' ) or (p.includedProducts = 'N' and (   exi
sts (select 1       from PricingAdjustmentProduct pap, OBRETCO_Prol_Product ppl       where pap.priceAdjustment = p       and pap.product.id = ppl.product.id       and ppl.active = true and pap.product.ac
tive = true       and ppl.obretcoProductlist.id ='7D05FCBC3FCF4EB7A925796F42DF644B')))   )  and ( p.organization.id in (:valueEqArray0 )) and ((p.includedOrganizations='Y'   and not exists (select 1      
    from PricingAdjustmentOrganization o        where active = true          and o.priceAdjustment = p          and o.startingDate is null           and o.endingDate is null           and o.organization.i
d ='E1C87396AF984963BC5B6DF4E7B5713D'))    or (p.includedOrganizations='N'   and  exists (select 1          from PricingAdjustmentOrganization o        where active = true          and o.priceAdjustment =
 p          and o.organization.id ='E1C87396AF984963BC5B6DF4E7B5713D'))     )  and (oBDISCCCurrency is null or      oBDISCCCurrency.id = '102')   and ap.priceAdjustment.id = p.id ) and 1=1 order by ap.id 
(could not extract ResultSet)
org.hibernate.QueryTimeoutException: could not extract ResultSet
        at org.hibernate.dialect.PostgreSQL81Dialect$4.convert(PostgreSQL81Dialect.java:510) ~[hibernate-core-5.6.15.Final.jar:5.6.15.Final]
        at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:37) ~[hibernate-core-5.6.15.Final.jar:5.6.15.Final]
        at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113) ~[hibernate-core-5.6.15.Final.jar:5.6.15.Final]
        at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99) ~[hibernate-core-5.6.15.Final.jar:5.6.15.Final]
        at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:67) ~[hibernate-core-5.6.15.Final.jar:5.6.15.Final]