Hi Syed, Restarting Apache worked! So thank you. One of our underlying problems was the httd.pid file, which was an issue when stopping and restarting Apache, hence the delay in this reply :-) J + L
-----Original Message----- From: Syed Haider [mailto:[email protected]] Sent: 27 April 2009 14:57 To: Mead, Jennifer; BioMart mart-dev Subject: Re: [mart-dev] error message on martview 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 >> >> >>
