On 17 Nov 2006, at 14:41, [EMAIL PROTECTED] wrote:
Hi,
Could anyone please explain why this error occured when I execute the
following MQL query. Also please let me know how could I solve the
problem.
Thanks.
--
Mamun
using Experiment get experiment_accession where ba_performer like
q(%Novartis%)
15-Nov-2006 17:23:20 org.ensembl.mart.lib.AttributeQueryRunner
executeQueryGeneric
INFO: SQL : SELECT main.experiment_accession, main.EXPERIMENT_ID_KEY
FROM
aemart.ae1__assay_performer__dm ,aemart.AE1__EXPERIMENT__MAIN main
WHERE
main.EXPERIMENT_ID_KEY >= -1 AND aemart.ae1__assay_performer__dm
.value
like? AND main.ASSAY_ID_KEY =aemart.ae1__assay_performer__dm
.ASSAY_ID_KEY ORDER BY main.EXPERIMENT_ID_KEY
15-Nov-2006 17:23:20 org.ensembl.mart.lib.AttributeQueryRunner
executeQueryGeneric
WARNING: ORA-00904: "MAIN"."ASSAY_ID_KEY": invalid identifier
org.ensembl.mart.lib.InvalidQueryException: ORA-00904:
"MAIN"."ASSAY_ID_KEY": invalid identifier
It seems that your sql did not get generated properly you seem to have
"value like? AND .." there which does not look correct to me. Probably
a bug
on our side. Which version of martj are you using?
a.
------------------------------------------------------------------------
-------
Arek Kasprzyk
EMBL-European Bioinformatics Institute.
Wellcome Trust Genome Campus, Hinxton,
Cambridge CB10 1SD, UK.
Tel: +44-(0)1223-494606
Fax: +44-(0)1223-494468
------------------------------------------------------------------------
-------
