Hi Renato, your problem is solved now. I have done a small 'Export' on your Mart, hope its ok.
The problem was that your Filter-> keyword had tableConstraint = KEYWORD__dm and Attribute-> keyword had tableConstraint = KEYWORD__DM points to the same tables but the difference in the case (__dm and __DM) fails 'eq' statement in perl code, subsequently the repetition of such tables names is compiled in SQL and ORACLE does not like this :) I have made both of them upper case now and exported too.. cheers syed On Mon, 2008-06-30 at 11:35 +0100, Renato Golin wrote: > Hi, > > I'm running biomart for uniprot at: > > http://sbornia.windows.ebi.ac.uk:9002/biomart/martview/ > > When you select Keyword as a filter (say "Complete Proteome") and count, > it's correct. When you select the results (without the keyword) it's > correct, but ty the time you actually select to see the keywords (in the > attributes) I get this weird SQL: > > SELECT main.name_1039, renato1.UNIPROT__KEYWORD__DM.keyword_1088 > FROM renato1.UNIPROT__KEYWORD__DM, renato1.UNIPROT__KEYWORD__dm, > renato1.UNIPROT__ENTRY__MAIN main > WHERE (UNIPROT__KEYWORD__dm.keyword_1088 = 'Complete proteome') > AND > main.dbentry_id_1039_key=renato1.UNIPROT__KEYWORD__DM.dbentry_id_1039_key > AND main.dbentry_id_1039_key=<*>UNIPROT__KEYWORD__dm.dbentry_id_1039_key > AND rowNum < 201 > > Note that the table "renato1.UNIPROT__KEYWORD__DM" appears twice on the > FROM and the match > "dbentry_id_1039_key=UNIPROT__KEYWORD__dm.dbentry_id_1039_key" appears > twice on the WHERE clause. > > > With that, I receive an "ORA-00918: column ambiguously defined" error. > > I've removed the duplicates and the query runs fine. Is there something > I'm doing wrong? > > cheers, > --renato > -- ====================================== Syed Haider. EMBL-European Bioinformatics Institute Wellcome Trust Genome Campus, Hinxton, Cambridge CB10 1SD, UK. ======================================
