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 On 11-06-15 3:29 PM, "[email protected]" <[email protected]> wrote: >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
