Hi Parul, It is not recommended to generate the materialized mart in the same schema as the source. If you use 'public' as the schema for source, it is better to ues another schema for the target.
If the materialize failed, the SQL that failed will be highlighted in red color. Hope this helps. Yong On 11-06-15 2:25 PM, "[email protected]" <[email protected]> wrote: > 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 _______________________________________________ Users mailing list [email protected] https://lists.biomart.org/mailman/listinfo/users
