[OODT-384] File manager queries not returning expected results unless each product-type has an ingested file and throws exceptions for '*' occurrence in the sql query

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Won't Fix
• Affects Version/s: 0.3, 0.4
• Fix Version/s: 1.1
• Component/s: file manager
• Assignee: Unassigned
• Reporter: Sheryl John
• Created: 23/Feb/12 07:32
• Updated: 17/Jul/17 18:02
• Resolved: 17/Jul/17 18:02

Description

Sean Hardman queried the File Manager using the query_tool( on 0.3 and 0.4-SNAPSHOT) and -sqlQuery options(on 0.4-SNAPSHOT) and found that the query_tool will throw an exception unless there is a product ingested for each product type listed in the policy.

The filemgr was queried as follows:
% ./filemgr-client --url http://localhost:9000 --operation --sqlQuery
-query "SELECT * FROM *"

Generates the following on the client side:

Feb 21, 2012 9:32:29 AM
org.apache.oodt.cas.filemgr.system.XmlRpcFileManagerClient <init>
INFO: Loading File Manager Configuration Properties from:
[../etc/filemgr.properties]
org.apache.xmlrpc.XmlRpcException: java.lang.Exception:
org.apache.oodt.cas.filemgr.structs.exceptions.CatalogException: Failed to
perform complex query : null
...

And generates the following on the server side:

Feb 21, 2012 9:32:29 AM
org.apache.oodt.cas.filemgr.repository.XMLRepositoryManager
getProductTypeByName
WARNING: XMLRepositoryManager: Unable to find product type: [convert_map
filemgr filemgr-client migrate_xml_policy query_tool], returning null
java.lang.NullPointerException
...

It also looks like the query does not read '*' in a query like "SELECT * FROM CatalogFile" and it throws the following:

Feb 22, 2012 2:36:52 PM org.apache.oodt.cas.filemgr.system.XmlRpcFileManager complexQuery
INFO: Query returned 2 results
org.apache.xmlrpc.XmlRpcException: org.apache.xmlrpc.XmlRpcException: null values not supported by XML-RPC
at org.apache.xmlrpc.XmlRpcClientResponseProcessor.decodeException(XmlRpcClientResponseProcessor.java:104)
at org.apache.xmlrpc.XmlRpcClientResponseProcessor.decodeResponse(XmlRpcClientResponseProcessor.java:71)

---

ERROR: Failed to perform sql query : sortBy 'null', outputFormat 'null', and delimiter '
', filterAlgor 'null', startDateTimeMetKey 'null', endDateTimeMetKey 'null', priorityMetKey 'null', null' : org.apache.xmlrpc.XmlRpcException: null values not supported by XML-RPC

The sql query returns expected results if elements are individually described like in "SELECT CAS.ProductName,Filename FROM CatalogFile"