Hi Jennifer and Luca,
Mead, Jennifer wrote:
Hi Syed
We have looked into tableconstraint and have made sure that we are entering the content__type portion of the table name.
Type in our case is dm. The filters display on the interface correctly, but when a query is run it gives an error (below).
Please check if the table contains the column tissue_desc_1016 ?
Also, please declare an attribute corresponding to the same filter field
having same internalName as your filter. Then 'Export' and reconfigure:
perl bin/configure -r conf/your_registry.xml --clean
restart apache and see if it works.
ERROR: caught BioMart::Exception::Configuration: Filter 'tissue_desc_1016' not
found in dataset databasename.datasetname
If you repeatedly get directed to this error page, there may be a problem with
your current session parameters. To clear your session and start with a clean
slate, please click the New button below.
Stacktrace:
Exception::Class::Base::throw
/home/jenny/biomart/biomart-perl/lib/BioMart/Registry.pm:541
BioMart::Registry::getFilter
/home/jenny/biomart/biomart-perl/lib/BioMart/Query.pm:1353
BioMart::Query::addFilter
/home/jenny/biomart/biomart-perl/lib/BioMart/Web.pm:824
BioMart::Web::prepare_martquery
/home/jenny/biomart/biomart-perl/lib/BioMart/Web.pm:2110
BioMart::Web::handle_request
/home/jenny/biomart/biomart-perl/cgi-bin/martview:96
(eval) /home/jenny/biomart/biomart-perl/cgi-bin/martview:95
ModPerl::ROOT::ModPerl::Registry::home_jenny_biomart_biomart_2dperl_cgi_2dbin_martview::handler
/usr/lib/perl5/ModPerl/RegistryCooker.pm:204
(eval) /usr/lib/perl5/ModPerl/RegistryCooker.pm:204
ModPerl::RegistryCooker::run /usr/lib/perl5/ModPerl/RegistryCooker.pm:170
ModPerl::RegistryCooker::default_handler /usr/lib/perl5/ModPerl/Registry.pm:31
ModPerl::Registry::handler -e:0
(eval) -e:0
Thanks
J+L
Ps no 'new' button appears below (there's one above?)
apologies for the misleading message, there is only one New button and
thats on top left corner.
let me know how you get on with this,
Syed
-----Original Message-----
From: Syed Haider [mailto:[email protected]]
Sent: 27 April 2009 13:12
To: Mead, Jennifer
Cc: [email protected]
Subject: Re: [mart-dev] error message on martview
Hi Jennifer and Luca,
Its possible to have filter on 'dm' tables. You need to check the
'tableConstraint' property in MartEditor for the said filter. This
should point to the dm table name instead of just main.
Hope this helps,
Syed
Mead, Jennifer wrote:
We have managed to get martview working now, so thank you for the
'...clean' command you mentioned earlier.
We have just a quick question regarding filters. Is it possible to have
filters for dm tables? Or can filters only be specified for the main
table? We tried to have a filter for a dm table and got an error message.
It was trying to find a field of the filter in the main table, when the
field is in the dm table - hence it failed.
Thanks
Jenny + Luca
