Hi Yong, Thanks for a quick response, this information definately helps for debugging.
Thanks and regards, Parul V. Kudtarkar > Hi Parul, > > The logs directory in dist/logs/ is for web interface. There is no log > kept for MartConfigurator or MartRunner. To see which SQL failed, you can > redo the materialize for any source, when the materialize sql dialog pops > up, select the one failed in the job history listed in the left, then > expend the tree on the right, you can see the reason why it failed. Hope > this helps. > > Yong > > http://www.spbase.org > > On 11-06-15 3:29 PM, "[email protected]" <[email protected]> wrote: > >>Hi Yong,http://www.spbase.org >> >>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 >> >> > > -- Parul 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
