Yes, you have to reingest your data after restarting your file manager after deleting the catalog. Then try the query tool
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 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:47 PM To: Chris Mattmann <chris.a.mattm...@jpl.nasa.gov> Cc: "dev@oodt.apache.org" <dev@oodt.apache.org>, Chris Mattmann <mattm...@apache.org> Subject: Re: RADiX filemgr-client script cannot delete product by id or name >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(XmlRpcClie >ntResponseProcessor.java:104) >at >org.apache.xmlrpc.XmlRpcClientResponseProcessor.decodeResponse(XmlRpcClien >tResponseProcessor.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(Xm >lRpcFileManagerClient.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(Xm >lRpcFileManagerClient.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.prope >>>r >>>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.prope >>>r >>>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 > > >
