Project:
| 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 |
 |