I wrote an application with 7.2.4 and It worked fine so far. But now I get an exception when I try to run the reports. I am using postgres DB and the report exception is:
An error occurred while loading data for band [bk] and query [bk]. Report name [Betriebskosten] An error occurred while loading data for data set [bk] Der in SQL für eine Instanz von com.haulmont.cuba.core.sys.persistence.PostgresUUID zu verwendende Datentyp kann nicht abgeleitet werden. Benutzen Sie 'setObject()' mit einem expliziten Typ, um ihn festzulegen. Query: SELECT credit as "credit", month_ as "month", total_payments as "totalPayments", total_demand as "demand", heating_costs as "realHeating", result_operating_costs as "realOperating", cold_water_costs as "realColdWater", warm_water_costs as "realWarmWater", costs.year_ as "year", costs.total_costs as "totalOperating", contract.name as "contractName", contract.distribution as "dist", contract.iban as "ibanContract", apartment.square_meter as "sqm", apartment.name as "apartment", adr.street as "street", adr.zip_code as "zipCode", adr.street_no as "streetNo", adr.city as "city", invoice.additional_costs_id as "costsId" FROM public.facility_utility_invoice invoice JOIN facility_additional_costs costs on invoice.additional_costs_id = costs.id JOIN facility_contract contract on invoice.contract_id = contract.id JOIN facility_apartment apartment on contract.apartment_id = apartment.id JOIN facility_apartment_house house on house.id = apartment.apartment_house_id JOIN facility_address adr on adr.id = house.address_id where invoice.id = ? Parameters: [dd3e264c-1d7b-bf5f-ab90-49f5650152f6]
For me the message means that i have to use a type conversion somewhere. But I have no glue where the source of the error is. Is it a DB problem (i updated postgres but I did not change the schema). Any ideas would be helpful.