Hi Yong, Thanks for the information. How may I find the reason/error message for this failed SQL. Nothing is written to the error logs directory in dist/logs/
Thanks and regards, Parul > 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 > > -- 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
