You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@oodt.apache.org by "Sheryl John (Created) (JIRA)" <ji...@apache.org> on 2012/02/23 08:33:48 UTC
[jira] [Created] (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
File manager queries not returning expected results unless each product-type has an ingested file and throws exceptions for '*' occurrence in the sql query
-----------------------------------------------------------------------------------------------------------------------------------------------------------
Key: OODT-384
URL: https://issues.apache.org/jira/browse/OODT-384
Project: OODT
Issue Type: Bug
Components: file manager
Affects Versions: 0.3, 0.4
Reporter: Sheryl John
Priority: Minor
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"
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (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
Posted by "Chris A. Mattmann (Updated) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OODT-384?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Chris A. Mattmann updated OODT-384:
-----------------------------------
Fix Version/s: (was: 0.4)
0.5
- push to 0.5
> File manager queries not returning expected results unless each product-type has an ingested file and throws exceptions for '*' occurrence in the sql query
> -----------------------------------------------------------------------------------------------------------------------------------------------------------
>
> Key: OODT-384
> URL: https://issues.apache.org/jira/browse/OODT-384
> Project: OODT
> Issue Type: Bug
> Components: file manager
> Affects Versions: 0.3, 0.4
> Reporter: Sheryl John
> Priority: Minor
> Fix For: 0.5
>
>
> 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"
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (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
Posted by "Sean Hardman (Commented) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OODT-384?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13214860#comment-13214860 ]
Sean Hardman commented on OODT-384:
-----------------------------------
For clarification, this scenario is reproducible (in 0.4-SNAPSHOT) with both the filemgr-client using the --sqlQuery option and the query_tool using the --sql option.
> File manager queries not returning expected results unless each product-type has an ingested file and throws exceptions for '*' occurrence in the sql query
> -----------------------------------------------------------------------------------------------------------------------------------------------------------
>
> Key: OODT-384
> URL: https://issues.apache.org/jira/browse/OODT-384
> Project: OODT
> Issue Type: Bug
> Components: file manager
> Affects Versions: 0.3, 0.4
> Reporter: Sheryl John
> Priority: Minor
>
> 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"
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (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
Posted by "Chris A. Mattmann (Updated) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OODT-384?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Chris A. Mattmann updated OODT-384:
-----------------------------------
- push out to 0.5
> File manager queries not returning expected results unless each product-type has an ingested file and throws exceptions for '*' occurrence in the sql query
> -----------------------------------------------------------------------------------------------------------------------------------------------------------
>
> Key: OODT-384
> URL: https://issues.apache.org/jira/browse/OODT-384
> Project: OODT
> Issue Type: Bug
> Components: file manager
> Affects Versions: 0.3, 0.4
> Reporter: Sheryl John
> Priority: Minor
> Fix For: 0.5
>
>
> 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"
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (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
Posted by "Chris A. Mattmann (Updated) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OODT-384?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Chris A. Mattmann updated OODT-384:
-----------------------------------
Fix Version/s: 0.4
- set fix version
> File manager queries not returning expected results unless each product-type has an ingested file and throws exceptions for '*' occurrence in the sql query
> -----------------------------------------------------------------------------------------------------------------------------------------------------------
>
> Key: OODT-384
> URL: https://issues.apache.org/jira/browse/OODT-384
> Project: OODT
> Issue Type: Bug
> Components: file manager
> Affects Versions: 0.3, 0.4
> Reporter: Sheryl John
> Priority: Minor
> Fix For: 0.4
>
>
> 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"
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira