Dear Prof. Mattmann, Now the ./query-tool sql query does work too. -_-!
$ ./query-tool --url http://localhost:9000 --sql -query "SELECT * FROM GenericFile" org.apache.xmlrpc.XmlRpcException: java.lang.Exception: org.apache.oodt.cas.filemgr.structs.exceptions.CatalogException: Failed to perform complex query : null at org.apache.xmlrpc.XmlRpcClientResponseProcessor.decodeException(XmlRpcClientResponseProcessor.java:104) at org.apache.xmlrpc.XmlRpcClientResponseProcessor.decodeResponse(XmlRpcClientResponseProcessor.java:71) at org.apache.xmlrpc.XmlRpcClientWorker.execute(XmlRpcClientWorker.java:73) at org.apache.xmlrpc.XmlRpcClient.execute(XmlRpcClient.java:194) at org.apache.xmlrpc.XmlRpcClient.execute(XmlRpcClient.java:185) at org.apache.xmlrpc.XmlRpcClient.execute(XmlRpcClient.java:178) at org.apache.oodt.cas.filemgr.system.XmlRpcFileManagerClient.complexQuery(XmlRpcFileManagerClient.java:1003) at org.apache.oodt.cas.filemgr.tools.QueryTool.performSqlQuery(QueryTool.java:252) at org.apache.oodt.cas.filemgr.tools.QueryTool.main(QueryTool.java:242) Exception in thread "main" org.apache.oodt.cas.filemgr.structs.exceptions.CatalogException: java.lang.Exception: org.apache.oodt.cas.filemgr.structs.exceptions.CatalogException: Failed to perform complex query : null at org.apache.oodt.cas.filemgr.system.XmlRpcFileManagerClient.complexQuery(XmlRpcFileManagerClient.java:1009) at org.apache.oodt.cas.filemgr.tools.QueryTool.performSqlQuery(QueryTool.java:252) at org.apache.oodt.cas.filemgr.tools.QueryTool.main(QueryTool.java:242) Best, Mengying (Angela) Wang On Sat, Nov 1, 2014 at 1:09 PM, Mattmann, Chris A (3980) < chris.a.mattm...@jpl.nasa.gov> wrote: > Can you please remove your FILEMGR_HOME/catalog (or your > RADIX_HOME/data/catalog) > directory, restart file manager, and then try again? > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > Chris Mattmann, Ph.D. > Chief Architect > Instrument Software and Science Data Systems Section (398) > NASA Jet Propulsion Laboratory Pasadena, CA 91109 USA > Office: 168-519, Mailstop: 168-527 > Email: chris.a.mattm...@nasa.gov > WWW: http://sunset.usc.edu/~mattmann/ > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > Adjunct Associate Professor, Computer Science Department > University of Southern California, Los Angeles, CA 90089 USA > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > > > > > > > -----Original Message----- > From: MengYing Wang <mengyingwa...@gmail.com> > Date: Saturday, November 1, 2014 at 1:03 PM > To: "dev@oodt.apache.org" <dev@oodt.apache.org> > Cc: Chris Mattmann <mattm...@apache.org> > Subject: Re: RADiX filemgr-client script cannot delete product by id or > name > > >Dear Prof. Mattmann, > > > > > >Thank you for your help! Actually, I have set the FILEMGR_URL. Below are > >the variables that I have set: > > > > > >export OODT_HOME="/Users/AngelaWang/Documents/programs/oodt-0.7" > >export > >CRAWLER_HOME="/Users/AngelaWang/Documents/programs/oodt-0.7/crawler" > >export > >FILEMGR_HOME="/Users/AngelaWang/Documents/programs/oodt-0.7/filemgr" > >export > >WORKFLOW_HOME="/Users/AngelaWang/Documents/programs/oodt-0.7/workflow" > >export PGE_ROOT="/Users/AngelaWang/Documents/programs/oodt-0.7/pge" > >export WORKFLOW_URL="http://localhost:9200"; > >export FILEMGR_URL="http://localhost:9000"; > > > > > > > >Best, > >Mengying (Angela) Wang > > > > > >On Sat, Nov 1, 2014 at 10:46 AM, Mattmann, Chris A (3980) > ><chris.a.mattm...@jpl.nasa.gov> wrote: > > > >This is an environment variable issue - your FILEMGR_URL is not set. > >Can you check it Angela? > > > >Cheers, > >Chris > > > > > >++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > >Chris Mattmann, Ph.D. > >Chief Architect > >Instrument Software and Science Data Systems Section (398) > >NASA Jet Propulsion Laboratory Pasadena, CA 91109 USA > >Office: 168-519, Mailstop: 168-527 > >Email: chris.a.mattm...@nasa.gov > >WWW: http://sunset.usc.edu/~mattmann/ > >++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > >Adjunct Associate Professor, Computer Science Department > >University of Southern California, Los Angeles, CA 90089 USA > >++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > > > > > > > > > > > > > >-----Original Message----- > >From: MengYing Wang <mengyingwa...@gmail.com> > >Reply-To: "dev@oodt.apache.org" <dev@oodt.apache.org> > >Date: Thursday, October 30, 2014 at 3:02 PM > >To: "dev@oodt.apache.org" <dev@oodt.apache.org> > >Subject: RADiX filemgr-client script cannot delete product by id or name > > > >>Hey everyone, > >> > >>I am trying to delete some product in the OODT File Manager with its > >>product id or name. However, the system raises > >>"java.lang.IllegalArgumentException: URI is not absolute" error. Please > >>help me! Thank you! > >> > >>My commands are: > >> > >>./filemgr-client --op --dbyid --productId > >>2b0e7582-6077-11e4-ac24-8d456d2e5b9b --url > >http://localhost:9000 <http://localhost:9000> > >> > >>./filemgr-client -op --deleteProductByName --productName > >>concatenatedOutputFile-2014-10-30T20:56:02.189Z.txt --url > >>http://localhost:9000 > >> > >>The logs of the file manager is: > >>...... > >> > >>Oct 30, 2014 2:56:21 PM > >>org.springframework.beans.factory.support.AbstractBeanFactory doGetBean > >> > >>FINE: Returning cached instance of singleton bean 'sqlQuery' > >> > >>Oct 30, 2014 2:56:21 PM > >>org.apache.oodt.cas.filemgr.system.XmlRpcFileManagerClient <init> > >> > >>INFO: Loading File Manager Configuration Properties from: > >>[/Users/AngelaWang/Documents/programs/oodt-0.7/filemgr/etc/filemgr.proper > >>t > >>ies] > >> > >>Oct 30, 2014 2:56:21 PM > >>org.apache.oodt.cas.filemgr.system.XmlRpcFileManagerClient <init> > >> > >>INFO: Loading File Manager Configuration Properties from: > >>[/Users/AngelaWang/Documents/programs/oodt-0.7/filemgr/etc/filemgr.proper > >>t > >>ies] > >> > > > > > >>ERROR: Failed to delete product > >>'org.apache.oodt.cas.filemgr.structs.Product@5433d17' : > >>java.lang.Exception: java.lang.IllegalArgumentException: URI is not > >>absolute > >> > >>-- > >>Best, > >>Mengying (Angela) Wang > > > > > > > > > > > > > > > > > > > > > >-- > >Best, > >Mengying (Angela) Wang > > > > > > > > -- Best, Mengying (Angela) Wang
