issue with ENSEMBL GENES 59 (SANGER UK) mart, Homo sapiens gene (GRCh37) dataset

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

issue with ENSEMBL GENES 59 (SANGER UK) mart, Homo sapiens gene (GRCh37) dataset

Leandro Hermida-2
Dear BioMart Central Portal,

Very sorry if this is not the right place to send issues with the
BioMart Central Portal, my apologies.

There seems to be a problem with the ENSEMBL GENES 59 (SANGER UK)
mart, Homo sapiens gene (GRCh37) dataset, when you select Ensembl
Protein ID as an attribute and filter "Limit to genes... with
Affymetrix Microarray hg u 133 a ID(s)" or "...with Affymetrix
Microarray hg u133a ID(s)" you get the error:

Serious Error: Error during query execution: Unknown column
'main.eFG_AFFY_HG_U133A_2_bool' in 'where clause'
ERROR: caught BioMart::Exception::Database: Error during query
execution: Unknown column 'main.eFG_AFFY_HG_U133A_2_bool' in 'where
clause'

best,
Leandro
Reply | Threaded
Open this post in threaded view
|

Re: issue with ENSEMBL GENES 59 (SANGER UK) mart, Homo sapiens gene (GRCh37) dataset

Syed Haider
Hi Leandro,

the exception suggests that the boolean column doesnt exist, its a data
bug, hence cc'ing Ensmebl helpdesk.

Best,
Syed



On 25/10/2010 09:55, Leandro Hermida wrote:

> Dear BioMart Central Portal,
>
> Very sorry if this is not the right place to send issues with the
> BioMart Central Portal, my apologies.
>
> There seems to be a problem with the ENSEMBL GENES 59 (SANGER UK)
> mart, Homo sapiens gene (GRCh37) dataset, when you select Ensembl
> Protein ID as an attribute and filter "Limit to genes... with
> Affymetrix Microarray hg u 133 a ID(s)" or "...with Affymetrix
> Microarray hg u133a ID(s)" you get the error:
>
> Serious Error: Error during query execution: Unknown column
> 'main.eFG_AFFY_HG_U133A_2_bool' in 'where clause'
> ERROR: caught BioMart::Exception::Database: Error during query
> execution: Unknown column 'main.eFG_AFFY_HG_U133A_2_bool' in 'where
> clause'
>
> best,
> Leandro