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

View Revisions: Issue #38877 Back to Issue ]
Summary 0038877: incorrect query in TaxZone model
Revision 2018-07-03 09:06 by caristu
Steps To Reproduce 1. Using Hibernate 5.3 (https://code.openbravo.com/erp/devel/pi-hb53 [^])
2. Login in WebPOS
  -> ERROR:
     ....
     org.openbravo.mobile.core.process.ProcessHQLQuery - org.openbravo.retail.posterminal.master.TaxZone: Error when generating query: null (org.hibernate.hql.internal.ast.QuerySyntaxException: expecting EOF, found ')' near line 7, column 1330 [select financialMgmtTaxZone.id as id,
financialMgmtTaxZone.tax.id as tax,
financialMgmtTaxZone.fromCountry.id as fromCountry,
financialMgmtTaxZone.destinationCountry.id as destinationCountry,
financialMgmtTaxZone.fromRegion.id as fromRegion,
financialMgmtTaxZone.destinationRegion.id as destinationRegion,
financialMgmtTaxZone.active as active from FinancialMgmtTaxZone as financialMgmtTaxZone where ( (financialMgmtTaxZone.client.id in ('39363B0921BB4293B48383844325E84C', '0')) ) AND ( financialMgmtTaxZone.organization.id in (:valueEqArray0 )) AND ( financialMgmtTaxZone.updated> :valueDate1 ) and financialMgmtTaxZone.tax in (select financialMgmtTaxRate.id from FinancialMgmtTaxRate as financialMgmtTaxRate where financialMgmtTaxRate.salesPurchaseType in ('S', 'B') and (financialMgmtTaxRate.country.id = :fromCountryId or (financialMgmtTaxRate.country is null and (not exists (select z from FinancialMgmtTaxZone as z where z.tax = financialMgmtTaxRate)) or exists (select z from FinancialMgmtTaxZone as z where z.tax = financialMgmtTaxRate and z.fromCountry.id = :fromCountryId ) or exists (select z from FinancialMgmtTaxZone as z where z.tax = financialMgmtTaxRate and z.fromCountry is null)))and (financialMgmtTaxRate.region.id = :fromRegionId or (financialMgmtTaxRate.region is null and (not exists (select z from FinancialMgmtTaxZone as z where z.tax = financialMgmtTaxRate)) or exists (select z from FinancialMgmtTaxZone as z where z.tax = financialMgmtTaxRate and z.fromRegion.id = :fromRegionId ) or exists (select z from FinancialMgmtTaxZone as z where z.tax = financialMgmtTaxRate and z.fromRegion is null)))))and (financialMgmtTaxZone.fromCountry.id = :fromCountryId or financialMgmtTaxZone.fromCountry is null) and (financialMgmtTaxZone.fromRegion.id = :fromRegionId or financialMgmtTaxZone.fromRegion is null) order by financialMgmtTaxZone.id asc])
...
Revision 2018-07-03 09:06 by caristu
Steps To Reproduce 1. Using Hibernate 5.3 (https://code.openbravo.com/erp/devel/pi-hb53 [^] [^])
2. Login in WebPOS
  -> ERROR:
     ....
     org.openbravo.mobile.core.process.ProcessHQLQuery - org.openbravo.retail.posterminal.master.TaxZone: Error when generating query: null (org.hibernate.hql.internal.ast.QuerySyntaxException: expecting EOF, found ')' near line 7, column 1330 [select financialMgmtTaxZone.id as id,
financialMgmtTaxZone.tax.id as tax,
financialMgmtTaxZone.fromCountry.id as fromCountry,
financialMgmtTaxZone.destinationCountry.id as destinationCountry,
financialMgmtTaxZone.fromRegion.id as fromRegion,
financialMgmtTaxZone.destinationRegion.id as destinationRegion,
financialMgmtTaxZone.active as active from FinancialMgmtTaxZone as financialMgmtTaxZone where ( (financialMgmtTaxZone.client.id in ('39363B0921BB4293B48383844325E84C', '0')) ) AND ( financialMgmtTaxZone.organization.id in (:valueEqArray0 )) AND ( financialMgmtTaxZone.updated> :valueDate1 ) and financialMgmtTaxZone.tax in (select financialMgmtTaxRate.id from FinancialMgmtTaxRate as financialMgmtTaxRate where financialMgmtTaxRate.salesPurchaseType in ('S', 'B') and (financialMgmtTaxRate.country.id = :fromCountryId or (financialMgmtTaxRate.country is null and (not exists (select z from FinancialMgmtTaxZone as z where z.tax = financialMgmtTaxRate)) or exists (select z from FinancialMgmtTaxZone as z where z.tax = financialMgmtTaxRate and z.fromCountry.id = :fromCountryId ) or exists (select z from FinancialMgmtTaxZone as z where z.tax = financialMgmtTaxRate and z.fromCountry is null)))and (financialMgmtTaxRate.region.id = :fromRegionId or (financialMgmtTaxRate.region is null and (not exists (select z from FinancialMgmtTaxZone as z where z.tax = financialMgmtTaxRate)) or exists (select z from FinancialMgmtTaxZone as z where z.tax = financialMgmtTaxRate and z.fromRegion.id = :fromRegionId ) or exists (select z from FinancialMgmtTaxZone as z where z.tax = financialMgmtTaxRate and z.fromRegion is null)))))and (financialMgmtTaxZone.fromCountry.id = :fromCountryId or financialMgmtTaxZone.fromCountry is null) and (financialMgmtTaxZone.fromRegion.id = :fromRegionId or financialMgmtTaxZone.fromRegion is null) order by financialMgmtTaxZone.id asc])
...
Revision 2018-07-03 09:05 by caristu
Steps To Reproduce 1. Using Hibernate 5.3 (https://code.openbravo.com/erp/devel/pi-hb53 [^] [^])
2. Login in WebPOS
  -> ERROR:
     ....
     org.openbravo.mobile.core.process.ProcessHQLQuery - org.openbravo.retail.posterminal.master.TaxZone: Error when generating query: null (org.hibernate.hql.internal.ast.QuerySyntaxException: expecting EOF, found ')' near line 7, column 1330 [select financialMgmtTaxZone.id as id,
financialMgmtTaxZone.tax.id as tax,
financialMgmtTaxZone.fromCountry.id as fromCountry,
financialMgmtTaxZone.destinationCountry.id as destinationCountry,
financialMgmtTaxZone.fromRegion.id as fromRegion,
financialMgmtTaxZone.destinationRegion.id as destinationRegion,
financialMgmtTaxZone.active as active from FinancialMgmtTaxZone as financialMgmtTaxZone where ( (financialMgmtTaxZone.client.id in ('39363B0921BB4293B48383844325E84C', '0')) ) AND ( financialMgmtTaxZone.organization.id in (:valueEqArray0 )) AND ( financialMgmtTaxZone.updated> :valueDate1 ) and financialMgmtTaxZone.tax in (select financialMgmtTaxRate.id from FinancialMgmtTaxRate as financialMgmtTaxRate where financialMgmtTaxRate.salesPurchaseType in ('S', 'B') and (financialMgmtTaxRate.country.id = :fromCountryId or (financialMgmtTaxRate.country is null and (not exists (select z from FinancialMgmtTaxZone as z where z.tax = financialMgmtTaxRate)) or exists (select z from FinancialMgmtTaxZone as z where z.tax = financialMgmtTaxRate and z.fromCountry.id = :fromCountryId ) or exists (select z from FinancialMgmtTaxZone as z where z.tax = financialMgmtTaxRate and z.fromCountry is null)))and (financialMgmtTaxRate.region.id = :fromRegionId or (financialMgmtTaxRate.region is null and (not exists (select z from FinancialMgmtTaxZone as z where z.tax = financialMgmtTaxRate)) or exists (select z from FinancialMgmtTaxZone as z where z.tax = financialMgmtTaxRate and z.fromRegion.id = :fromRegionId ) or exists (select z from FinancialMgmtTaxZone as z where z.tax = financialMgmtTaxRate and z.fromRegion is null)))))and (financialMgmtTaxZone.fromCountry.id = :fromCountryId or financialMgmtTaxZone.fromCountry is null) and (financialMgmtTaxZone.fromRegion.id = :fromRegionId or financialMgmtTaxZone.fromRegion is null) order by financialMgmtTaxZone.id asc])
java.lang.IllegalArgumentException: org.hibernate.hql.internal.ast.QuerySyntaxException: expecting EOF, found ')' near line 7, column 1330 [select financialMgmtTaxZone.id as id,
financialMgmtTaxZone.tax.id as tax,
financialMgmtTaxZone.fromCountry.id as fromCountry,
financialMgmtTaxZone.destinationCountry.id as destinationCountry,
financialMgmtTaxZone.fromRegion.id as fromRegion,
financialMgmtTaxZone.destinationRegion.id as destinationRegion,
financialMgmtTaxZone.active as active from FinancialMgmtTaxZone as financialMgmtTaxZone where ( (financialMgmtTaxZone.client.id in ('39363B0921BB4293B48383844325E84C', '0')) ) AND ( financialMgmtTaxZone.organization.id in (:valueEqArray0 )) AND ( financialMgmtTaxZone.updated> :valueDate1 ) and financialMgmtTaxZone.tax in (select financialMgmtTaxRate.id from FinancialMgmtTaxRate as financialMgmtTaxRate where financialMgmtTaxRate.salesPurchaseType in ('S', 'B') and (financialMgmtTaxRate.country.id = :fromCountryId or (financialMgmtTaxRate.country is null and (not exists (select z from FinancialMgmtTaxZone as z where z.tax = financialMgmtTaxRate)) or exists (select z from FinancialMgmtTaxZone as z where z.tax = financialMgmtTaxRate and z.fromCountry.id = :fromCountryId ) or exists (select z from FinancialMgmtTaxZone as z where z.tax = financialMgmtTaxRate and z.fromCountry is null)))and (financialMgmtTaxRate.region.id = :fromRegionId or (financialMgmtTaxRate.region is null and (not exists (select z from FinancialMgmtTaxZone as z where z.tax = financialMgmtTaxRate)) or exists (select z from FinancialMgmtTaxZone as z where z.tax = financialMgmtTaxRate and z.fromRegion.id = :fromRegionId ) or exists (select z from FinancialMgmtTaxZone as z where z.tax = financialMgmtTaxRate and z.fromRegion is null)))))and (financialMgmtTaxZone.fromCountry.id = :fromCountryId or financialMgmtTaxZone.fromCountry is null) and (financialMgmtTaxZone.fromRegion.id = :fromRegionId or financialMgmtTaxZone.fromRegion is null) order by financialMgmtTaxZone.id asc]
...
Revision 2018-07-03 09:05 by caristu
Steps To Reproduce 1. Using Hibernate 5.3
2. Login in WebPOS
  -> ERROR:
     ....
     org.openbravo.mobile.core.process.ProcessHQLQuery - org.openbravo.retail.posterminal.master.TaxZone: Error when generating query: null (org.hibernate.hql.internal.ast.QuerySyntaxException: expecting EOF, found ')' near line 7, column 1330 [select financialMgmtTaxZone.id as id,
financialMgmtTaxZone.tax.id as tax,
financialMgmtTaxZone.fromCountry.id as fromCountry,
financialMgmtTaxZone.destinationCountry.id as destinationCountry,
financialMgmtTaxZone.fromRegion.id as fromRegion,
financialMgmtTaxZone.destinationRegion.id as destinationRegion,
financialMgmtTaxZone.active as active from FinancialMgmtTaxZone as financialMgmtTaxZone where ( (financialMgmtTaxZone.client.id in ('39363B0921BB4293B48383844325E84C', '0')) ) AND ( financialMgmtTaxZone.organization.id in (:valueEqArray0 )) AND ( financialMgmtTaxZone.updated> :valueDate1 ) and financialMgmtTaxZone.tax in (select financialMgmtTaxRate.id from FinancialMgmtTaxRate as financialMgmtTaxRate where financialMgmtTaxRate.salesPurchaseType in ('S', 'B') and (financialMgmtTaxRate.country.id = :fromCountryId or (financialMgmtTaxRate.country is null and (not exists (select z from FinancialMgmtTaxZone as z where z.tax = financialMgmtTaxRate)) or exists (select z from FinancialMgmtTaxZone as z where z.tax = financialMgmtTaxRate and z.fromCountry.id = :fromCountryId ) or exists (select z from FinancialMgmtTaxZone as z where z.tax = financialMgmtTaxRate and z.fromCountry is null)))and (financialMgmtTaxRate.region.id = :fromRegionId or (financialMgmtTaxRate.region is null and (not exists (select z from FinancialMgmtTaxZone as z where z.tax = financialMgmtTaxRate)) or exists (select z from FinancialMgmtTaxZone as z where z.tax = financialMgmtTaxRate and z.fromRegion.id = :fromRegionId ) or exists (select z from FinancialMgmtTaxZone as z where z.tax = financialMgmtTaxRate and z.fromRegion is null)))))and (financialMgmtTaxZone.fromCountry.id = :fromCountryId or financialMgmtTaxZone.fromCountry is null) and (financialMgmtTaxZone.fromRegion.id = :fromRegionId or financialMgmtTaxZone.fromRegion is null) order by financialMgmtTaxZone.id asc])
java.lang.IllegalArgumentException: org.hibernate.hql.internal.ast.QuerySyntaxException: expecting EOF, found ')' near line 7, column 1330 [select financialMgmtTaxZone.id as id,
financialMgmtTaxZone.tax.id as tax,
financialMgmtTaxZone.fromCountry.id as fromCountry,
financialMgmtTaxZone.destinationCountry.id as destinationCountry,
financialMgmtTaxZone.fromRegion.id as fromRegion,
financialMgmtTaxZone.destinationRegion.id as destinationRegion,
financialMgmtTaxZone.active as active from FinancialMgmtTaxZone as financialMgmtTaxZone where ( (financialMgmtTaxZone.client.id in ('39363B0921BB4293B48383844325E84C', '0')) ) AND ( financialMgmtTaxZone.organization.id in (:valueEqArray0 )) AND ( financialMgmtTaxZone.updated> :valueDate1 ) and financialMgmtTaxZone.tax in (select financialMgmtTaxRate.id from FinancialMgmtTaxRate as financialMgmtTaxRate where financialMgmtTaxRate.salesPurchaseType in ('S', 'B') and (financialMgmtTaxRate.country.id = :fromCountryId or (financialMgmtTaxRate.country is null and (not exists (select z from FinancialMgmtTaxZone as z where z.tax = financialMgmtTaxRate)) or exists (select z from FinancialMgmtTaxZone as z where z.tax = financialMgmtTaxRate and z.fromCountry.id = :fromCountryId ) or exists (select z from FinancialMgmtTaxZone as z where z.tax = financialMgmtTaxRate and z.fromCountry is null)))and (financialMgmtTaxRate.region.id = :fromRegionId or (financialMgmtTaxRate.region is null and (not exists (select z from FinancialMgmtTaxZone as z where z.tax = financialMgmtTaxRate)) or exists (select z from FinancialMgmtTaxZone as z where z.tax = financialMgmtTaxRate and z.fromRegion.id = :fromRegionId ) or exists (select z from FinancialMgmtTaxZone as z where z.tax = financialMgmtTaxRate and z.fromRegion is null)))))and (financialMgmtTaxZone.fromCountry.id = :fromCountryId or financialMgmtTaxZone.fromCountry is null) and (financialMgmtTaxZone.fromRegion.id = :fromRegionId or financialMgmtTaxZone.fromRegion is null) order by financialMgmtTaxZone.id asc]
...


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker