Hey Sean,
Try using the new SqlQuery action in 0.4 filemgr
-Brian
On Feb 20, 2012, at 6:30 PM, "Hardman, Sean H (388J)"
<sean.h.hard...@jpl.nasa.gov> wrote:
> I first noticed this behavior in release 0.3 and just reaffirmed it in a
> latest and greatest build of 0.4-SNAPSHOT. To the best of my knowledge, this
> was not the case in previous versions. When querying a File Manager instance
> with a Lucene Catalog on the back end, the query_tool will throw an exception
> unless there is a product ingested for each product type listed in the policy
> (see the stack trace below).
>
> I assume I am not the first person to notice this behavior. Is this worthy of
> a JIRA issue?
>
> Thanks,
> Sean
>
>
> bash-3.2$ ./query_tool --url ${FILEMGR_URL} --sql -query "SELECT * FROM *"
> Feb 20, 2012 5:52:26 PM org.apache.oodt.cas.filemgr.catalog.LuceneCatalog
> paginateQuery
> WARNING: Query: [q=] for Product Type: [urn:pds:CatalogObject] returned no
> results
> java.lang.NullPointerException
> at
> org.apache.oodt.cas.filemgr.system.XmlRpcFileManager.complexQuery(XmlRpcFileManager.java:602)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:597)
> at org.apache.xmlrpc.Invoker.execute(Invoker.java:130)
> at org.apache.xmlrpc.XmlRpcWorker.invokeHandler(XmlRpcWorker.java:84)
> at org.apache.xmlrpc.XmlRpcWorker.execute(XmlRpcWorker.java:146)
> at org.apache.xmlrpc.XmlRpcServer.execute(XmlRpcServer.java:139)
> at org.apache.xmlrpc.XmlRpcServer.execute(XmlRpcServer.java:125)
> at org.apache.xmlrpc.WebServer$Connection.run(WebServer.java:761)
> at org.apache.xmlrpc.WebServer$Runner.run(WebServer.java:642)
> at java.lang.Thread.run(Thread.java:680)
> 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:974)
> 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:980)
> at
> org.apache.oodt.cas.filemgr.tools.QueryTool.performSqlQuery(QueryTool.java:252)
> at org.apache.oodt.cas.filemgr.tools.QueryTool.main(QueryTool.java:242)
>
