Re: [Virtuoso-users] Virtuoso 22018 Error SR126: Can't convert to numeric

HI Lorena, What is the version of Virtuoso in use (run virtuoso-t -?) ? The error indicates the SUM(?ov) is larger than the size of a numeric type, thus you could try casting it to an "xsd:double" which allows a larger size, as follows: SELECT?time ?sex ?geo (sum(xsd:double(?ov)) as ?sum_o

[Virtuoso-users] Virtuoso 22018 Error SR126: Can't convert to numeric

Hi: when running this query on a graph with 49.263.252 triples I receive an "Virtuoso 22018 Error SR126: Can't convert to numeric" error message. SELECT ?time ?sex ?geo (sum(?ov) as ?sum_ov) FROM WHERE { ?o qb:dataSet dt:migr_asyappctzm . ?o sdmx-dim