Error SERVICE -> unexpected variable name 'stubvar14'

[JervenBolleman]

DB.DBA.SPARQL_REXEC('http://wwwdev.ebi.ac.uk/rdf/services/ensembl/sparql/', ...) has received result with unexpected variable name 'stubvar14'

I am trying to connect a service query between the UniProt sparql endpoint and the Ensembl endpoint. Both virtuoso instances 7+

DB.DBA.SPARQL_REXEC('http://wwwdev.ebi.ac.uk/rdf/services/ensembl/sparql/', ...) has received result with unexpected variable name 'stubvar14'

PREFIX core:<http://purl.uniprot.org/core/> 
PREFIX keywords:<http://purl.uniprot.org/keywords/> 
PREFIX uniprotkb:<http://purl.uniprot.org/uniprot/> 
PREFIX taxon:<http://purl.uniprot.org/taxonomy/> 
PREFIX ec:<http://purl.uniprot.org/enzyme/> 
PREFIX rdf:<http://www.w3.org/1999/02/22-rdf-syntax-ns#> 
PREFIX rdfs:<http://www.w3.org/2000/01/rdf-schema#> 
PREFIX skos:<http://www.w3.org/2004/02/skos/core#> 
PREFIX owl:<http://www.w3.org/2002/07/owl#> 
PREFIX bibo:<http://purl.org/ontology/bibo/> 
PREFIX dc:<http://purl.org/dc/terms/> 
PREFIX xsd:<http://www.w3.org/2001/XMLSchema#> 
PREFIX faldo:<http://biohackathon.org/resource/faldo#> 
PREFIX obo: <http://purl.obolibrary.org/obo/>
PREFIX ensembl: <http://rdf.ebi.ac.uk/resource/ensembl/>
PREFIX ensembltranscript: <http://rdf.ebi.ac.uk/resource/ensembl.transcript/>
PREFIX ensemblexon: <http://rdf.ebi.ac.uk/resource/ensembl.exon/>
PREFIX ensemblprotein: <http://rdf.ebi.ac.uk/resource/ensembl.protein/>
PREFIX ensemblterms: <http://rdf.ebi.ac.uk/terms/ensembl/>

select ?protein ?xref ?thing {
  BIND(<http://purl.uniprot.org/uniprot/P05067> AS ?protein)
  ?protein rdfs:seeAlso ?dr .
  ?dr core:database <http://purl.uniprot.org/database/Ensembl> .
  BIND (iri(concat("http://rdf.ebi.ac.uk/resource/ensembl.transcript/",substr(str(?dr), 33))) as ?transcript)
  SERVICE <http://wwwdev.ebi.ac.uk/rdf/services/ensembl/sparql/>{
  ?transcript obo:SO_translates_to ?peptide .
  ?peptide a ensemblterms:protein .
  }
}

[HughWilliams]

@JervenBolleman: Running the query against our LOD server with uniprot load I get a different error:

http://lod.openlinksw.com/sparql?default-graph-uri=http%3A%2F%2Funiprot.org&qtxt=PREFIX+core%3A%3Chttp%3A%2F%2Fpurl.uniprot.org%2Fcore%2F%3E+%0D%0APREFIX+keywords%3A%3Chttp%3A%2F%2Fpurl.uniprot.org%2Fkeywords%2F%3E+%0D%0APREFIX+uniprotkb%3A%3Chttp%3A%2F%2Fpurl.uniprot.org%2Funiprot%2F%3E+%0D%0APREFIX+taxon%3A%3Chttp%3A%2F%2Fpurl.uniprot.org%2Ftaxonomy%2F%3E+%0D%0APREFIX+ec%3A%3Chttp%3A%2F%2Fpurl.uniprot.org%2Fenzyme%2F%3E+%0D%0APREFIX+rdf%3A%3Chttp%3A%2F%2Fwww.w3.org%2F1999%2F02%2F22-rdf-syntax-ns%23%3E+%0D%0APREFIX+rdfs%3A%3Chttp%3A%2F%2Fwww.w3.org%2F2000%2F01%2Frdf-schema%23%3E+%0D%0APREFIX+skos%3A%3Chttp%3A%2F%2Fwww.w3.org%2F2004%2F02%2Fskos%2Fcore%23%3E+%0D%0APREFIX+owl%3A%3Chttp%3A%2F%2Fwww.w3.org%2F2002%2F07%2Fowl%23%3E+%0D%0APREFIX+bibo%3A%3Chttp%3A%2F%2Fpurl.org%2Fontology%2Fbibo%2F%3E+%0D%0APREFIX+dc%3A%3Chttp%3A%2F%2Fpurl.org%2Fdc%2Fterms%2F%3E+%0D%0APREFIX+xsd%3A%3Chttp%3A%2F%2Fwww.w3.org%2F2001%2FXMLSchema%23%3E+%0D%0APREFIX+faldo%3A%3Chttp%3A%2F%2Fbiohackathon.org%2Fresource%2Ffaldo%23%3E+%0D%0APREFIX+obo%3A+%3Chttp%3A%2F%2Fpurl.obolibrary.org%2Fobo%2F%3E%0D%0APREFIX+ensembl%3A+%3Chttp%3A%2F%2Frdf.ebi.ac.uk%2Fresource%2Fensembl%2F%3E%0D%0APREFIX+ensembltranscript%3A+%3Chttp%3A%2F%2Frdf.ebi.ac.uk%2Fresource%2Fensembl.transcript%2F%3E%0D%0APREFIX+ensemblexon%3A+%3Chttp%3A%2F%2Frdf.ebi.ac.uk%2Fresource%2Fensembl.exon%2F%3E%0D%0APREFIX+ensemblprotein%3A+%3Chttp%3A%2F%2Frdf.ebi.ac.uk%2Fresource%2Fensembl.protein%2F%3E%0D%0APREFIX+ensemblterms%3A+%3Chttp%3A%2F%2Frdf.ebi.ac.uk%2Fterms%2Fensembl%2F%3E%0D%0A%0D%0Aselect+%3Fprotein+%3Fxref+%3Fthing+%7B%0D%0A++BIND%28%3Chttp%3A%2F%2Fpurl.uniprot.org%2Funiprot%2FP05067%3E+AS+%3Fprotein%29%0D%0A++%3Fprotein+rdfs%3AseeAlso+%3Fdr+.%0D%0A++%3Fdr+core%3Adatabase+%3Chttp%3A%2F%2Fpurl.uniprot.org%2Fdatabase%2FEnsembl%3E+.%0D%0A++BIND+%28iri%28concat%28%22http%3A%2F%2Frdf.ebi.ac.uk%2Fresource%2Fensembl.transcript%2F%22%2Csubstr%28str%28%3Fdr%29%2C+33%29%29%29+as+%3Ftranscript%29%0D%0A++SERVICE+%3Chttp%3A%2F%2Fwwwdev.ebi.ac.uk%2Frdf%2Fservices%2Fensembl%2Fsparql%2F%3E%7B%0D%0A++%3Ftranscript+obo%3ASO_translates_to+%3Fpeptide+.%0D%0A++%3Fpeptide+a+ensemblterms%3Aprotein+.%0D%0A++%7D%0D%0A%7D&should-sponge=&format=text%2Fhtml&CXML_redir_for_subjs=121&CXML_redir_for_hrefs=&timeout=30000&debug=on

Virtuoso 37000 Error SP031: SPARQL compiler: The list of return values contains '*' but the pattern does not contain variables

What is the Virtuoso version being use by your Uniport installation atm ? On LOD we are running:

SQL> status('');
REPORT
VARCHAR
_______________________________________________________________________________

OpenLink Virtuoso VDB Server
Version 07.20.3215-pthreads for Linux as of Feb  3 2016 

[HughWilliams]

@JervenBolleman: Actually scratch what I said as need to uncheck "strict checking of void variables" to get around that error, after which I then got the error reported:

Virtuoso RDFZZ Error DB.DBA.SPARQL_REXEC('http://wwwdev.ebi.ac.uk/rdf/services/ensembl/sparql/', ...) has received result with unexpected variable name 'stubvar14'