2024-02-12 15:05:18,835 [http-nio-127.0.0.1-8080-exec-79] ERROR org.openbravo.mobile.core.process.ProcessHQLQuery - org.openbravo.retail.posterminal.master.BPLocation: Error when generating query: select bploc.id as id, bp.id as bpartner, COALESCE(bplocAddress.addressLine1, bplocAddress.postalCode, bplocAddress.cityName, bploc.name) as name, COALESCE(bplocAddress.addressLine2,'') as name2, bplocAddress.postalCode as postalCode, bplocAddress.cityName as cityName, bplocAddress.country.name as countryName, bplocAddress.country.id as countryId, bploc.invoiceToAddress as isBillTo, bploc.shipToAddress as isShipTo, bploc.defaultShipToAddress as defaultShipTo, bploc.defaultInvoiceToAddress as defaultInvoiceTo, COALESCE(bplocRegion.name,'') as regionName, COALESCE(bplocRegion.id,'') as regionId, bploc.creationDate as creationDate, bploc.updated as updated, COALESCE(bplocAddress.addressLine1 || CASE WHEN bplocAddress.addressLine2 IS NOT NULL THEN ' ' END || bplocAddress.addressLine2, bplocAddress.addressLine1, bplocAddress.addressLine2, bplocAddress.postalCode, bplocAddress.cityName) as _identifier, (case when bploc.active = 'Y' and bp.active = 'Y' then true else false end) as active, now() as loaded from BusinessPartnerLocation AS bploc join bploc.businessPartner AS bp left join bploc.locationAddress AS bplocAddress left join bplocAddress.region AS bplocRegion where ( (bp.id=:valueEqS0 ) AND (bploc.invoiceToAddress=:valueEqS1 ) ) AND bp.customer = true AND bp.priceList IS NOT NULL AND (( (bploc.active = 'Y') AND (bp.active = 'Y') ) ) and ( (bploc.client.id in ('39363B0921BB4293B48383844325E84C', '0')) ) AND ( bploc.organization.id in (:valueEqArray2 )) and 1=1 ORDER BY bploc.updated desc (class java.lang.String cannot be cast to class java.lang.Boolean (java.lang.String and java.lang.Boolean are in module java.base of loader 'bootstrap')) java.lang.ClassCastException: class java.lang.String cannot be cast to class java.lang.Boolean (java.lang.String and java.lang.Boolean are in module java.base of loader 'bootstrap') at org.hibernate.type.descriptor.java.BooleanTypeDescriptor.unwrap(BooleanTypeDescriptor.java:19) ~[hibernate-core-5.6.15.Final.jar:5.6.15.Final] at org.hibernate.type.descriptor.sql.VarcharTypeDescriptor$1.doBind(VarcharTypeDescriptor.java:46) ~[hibernate-core-5.6.15.Final.jar:5.6.15.Final] at org.hibernate.type.descriptor.sql.BasicBinder.bind(BasicBinder.java:73) ~[hibernate-core-5.6.15.Final.jar:5.6.15.Final] at org.hibernate.type.AbstractStandardBasicType.nullSafeSet(AbstractStandardBasicType.java:276) ~[hibernate-core-5.6.15.Final.jar:5.6.15.Final] at org.hibernate.type.AbstractStandardBasicType.nullSafeSet(AbstractStandardBasicType.java:271) ~[hibernate-core-5.6.15.Final.jar:5.6.15.Final] at org.hibernate.param.NamedParameterSpecification.bind(NamedParameterSpecification.java:53) ~[hibernate-core-5.6.15.Final.jar:5.6.15.Final] at org.hibernate.loader.hql.QueryLoader.bindParameterValues(QueryLoader.java:682) ~[hibernate-core-5.6.15.Final.jar:5.6.15.Final] at org.hibernate.loader.Loader.bindPreparedStatement(Loader.java:2150) ~[hibernate-core-5.6.15.Final.jar:5.6.15.Final] at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:2127) ~[hibernate-core-5.6.15.Final.jar:5.6.15.Final] at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:2059) ~[hibernate-core-5.6.15.Final.jar:5.6.15.Final] at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:2037) ~[hibernate-core-5.6.15.Final.jar:5.6.15.Final] at org.hibernate.loader.Loader.scroll(Loader.java:2945) ~[hibernate-core-5.6.15.Final.jar:5.6.15.Final]