Dear Junjun and community, I have added a virtual mart(data is stored in a postgres database, I call this database biomart_build with default postgres schema, i.e. public) to data sources. I also manipualte the mart using martviwer to hide few tables which I may not require. Here are the steps I follow in order to materialize this virtual mart,
1) I have mart runner script running from the directory in which I have installed biomart: $./dist/scripts/martrunner.sh 9005 ./dist/scripts/martrunner.sh 9005 Starting MartRunner please wait .... ...martrunner started. 2)Right click on virtual mart and click materialize. Since this is a postgres database the target database is same as the orginal source( i.e. biomart_build7). The target schema is public, host name: localhost, host port 9005(I have ensured this port is available), database server name: name of my server and finally database port: port number on which postgres runs. However when I click generate SQL on terminal I get message saving data defination language(DDL) to Mart Runner. In the martrunner window which pops I click startjob and within few minutes the job status indicates failed. There are no error logs generated. Is there any step that I am not doing the right way? Is the target schema same as the default postgres database schema(public)? Please let me know if you need further information to resolve this query. Thanks and regards, Parul V. Kudtarkar -- Parul V. Kudtarkar Scientific Programmer Center for Computational Regulatory Genomics Beckman Institute, California Institute of Technology _______________________________________________ Users mailing list [email protected] https://lists.biomart.org/mailman/listinfo/users
