<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#ffffff">
Hi, Scott:<br>
<br>
Thank you for sending the information. <br>
<br>
The reason there is an additional transformation step on server side
when you query the server from Kepler is that Kepler uses ecogrid
web service and ecogrid will transform the ecogrid query to metacat
query. When you use web page to query metacat, it uses metacata
query directly. <br>
<br>
The subtle difference results in different behaviors. There was a
bug in xslt style sheet which transforms the ecogrid query to
metadata query. It was fixed in the early of this year. However, I
looked the log information and found you didn't install a version of
metacat which contains the fix code. You may install the metacat
from the metacat svn trunk (or, Ben, do you have a better
suggestion?) and i think the issue will be gone. Please let me know
if a new installation of metacat will fix the problem.<br>
<br>
Thanks,<br>
<br>
Jing<br>
<br>
On 05/05/2011 09:00 PM, Scott Zimmer wrote:
<blockquote
cite="mid:BANLkTik-AyvmNBT7K0rR=+BpH7yqUt=F6w@mail.gmail.com"
type="cite">Hi Jing: <br>
<br>
I appreciate your help. I've restarted our DB and it should be up
and running again. Below are the log file from performing the
search inside Kepler followed by the log file from performing the
search via a browser. The main difference I see is that the query
from inside Kepler seems to be doing a transformation and then
performing an squery instead of a query. I don't really
understand much more of the information in the log file. Any
insight you have would be appreciated...<br>
<br>
Scott<br>
<br>
<p class="MsoNormal"><span style="font-size: 8pt;">knb
20110506-01:30:54: [WARN]:
start authenticated query method in grid service
[org.ecoinformatics.ecogrid.metacat.authenticatedqueryservice.impl.MetacatAuthenticatedQueryServiceImpl]</span></p>
<p class="MsoNormal"><span style="font-size: 8pt;">knb
20110506-01:30:54: [WARN]:
before transforming query
[org.ecoinformatics.ecogrid.metacat.authenticatedqueryservice.impl.MetacatAuthenticatedQueryServiceImpl]</span></p>
<p class="MsoNormal"><span style="font-size: 8pt;">knb
20110506-01:30:54: [</span><span style="font-size: 8pt;">INFO</span><span
style="font-size: 8pt;">]: parsed the ecogrid query xml
[org.ecoinformatics.ecogrid.metacat.authenticatedqueryservice.impl.EcogridQueryToMetacatQueryTransformer]</span></p>
<p class="MsoNormal"><span style="font-size: 8pt;">knb
20110506-01:30:54: [</span><span style="font-size: 8pt;">INFO</span><span
style="font-size: 8pt;">]: transforming xml node...[query:
null]
[org.ecoinformatics.ecogrid.metacat.authenticatedqueryservice.impl.EcogridQueryToMetacatQueryTransformer]</span></p>
<p class="MsoNormal"><span style="font-size: 8pt;">knb
20110506-01:30:54: [</span><span style="font-size: 8pt;">INFO</span><span
style="font-size: 8pt;">]: transformer is:
org.apache.xalan.transformer.TransformerImpl@307b37df
[org.ecoinformatics.ecogrid.metacat.authenticatedqueryservice.impl.EcogridQueryToMetacatQueryTransformer]</span></p>
<p class="MsoNormal"><span style="font-size: 8pt;">knb
20110506-01:30:54: [</span><span style="font-size: 8pt;">INFO</span><span
style="font-size: 8pt;">]: query: <?xml version="1.0"
encoding="iso-8859-1"?><pathquery
version="1.2"><meta_file_id>test.1.1</meta_file_id><querytitle>kepler
query</querytitle><returndoctype><a
moz-do-not-send="true"
href="http://www.kepler-project.org/kar-2.1.0"
target="_blank">http://www.kepler-project.org/kar-2.1.0</a></returndoctype><returndoctype><a
moz-do-not-send="true"
href="http://www.kepler-project.org/kar-2.0.0"
target="_blank">http://www.kepler-project.org/kar-2.0.0</a></returndoctype><returnfield>/entity/@name</returnfield><querygroup
operator="INTERSECT"><queryterm
searchmode="contains"
casesensitive="false"><value>%twittergraph%</value><pathexpr>/</pathexpr></queryterm></querygroup></pathquery>
[org.ecoinformatics.ecogrid.metacat.authenticatedqueryservice.impl.EcogridQueryToMetacatQueryTransformer]</span></p>
<p class="MsoNormal"><span style="font-size: 8pt;">knb
20110506-01:30:54: [</span><span style="font-size: 8pt;">INFO</span><span
style="font-size: 8pt;">]: transformed the ecogrid query xml
to pathquery xml
[org.ecoinformatics.ecogrid.metacat.authenticatedqueryservice.impl.EcogridQueryToMetacatQueryTransformer]</span></p>
<p class="MsoNormal"><span style="font-size: 8pt;">knb
20110506-01:30:54: [WARN]:
after transforming query
[org.ecoinformatics.ecogrid.metacat.authenticatedqueryservice.impl.MetacatAuthenticatedQueryServiceImpl]</span></p>
<p class="MsoNormal"><span style="font-size: 8pt;">knb
20110506-01:30:54: [</span><span style="font-size: 8pt;">INFO</span><span
style="font-size: 8pt;">]: MetaCatServlet.handleGetOrPost -
Action is: squery
[edu.ucsb.nceas.metacat.MetaCatServlet]</span></p>
<p class="MsoNormal"><span style="font-size: 8pt;">knb
20110506-01:30:54: [</span><span style="font-size: 8pt;">INFO</span><span
style="font-size: 8pt;">]: MetaCatServlet.handleGetOrPost -
The user is : public
[edu.ucsb.nceas.metacat.MetaCatServlet]</span></p>
<p class="MsoNormal"><span style="font-size: 8pt;">knb
20110506-01:30:54: [</span><span style="font-size: 8pt;">INFO</span><span
style="font-size: 8pt;">]: DBQuery.findDocuments - SESSIONID:
0 [edu.ucsb.nceas.metacat.DBQuery]</span></p>
<p class="MsoNormal"><span style="font-size: 8pt;">knb
20110506-01:30:54: [</span><span style="font-size: 8pt;">INFO</span><span
style="font-size: 8pt;">]: DBQuery.findDocuments - xmlquery:
<?xml version="1.0"
encoding="iso-8859-1"?><pathquery
version="1.2"><meta_file_id>test.1.1</meta_file_id><querytitle>kepler
query</querytitle><returndoctype><a
moz-do-not-send="true"
href="http://www.kepler-project.org/kar-2.1.0"
target="_blank">http://www.kepler-project.org/kar-2.1.0</a></returndoctype><returndoctype><a
moz-do-not-send="true"
href="http://www.kepler-project.org/kar-2.0.0"
target="_blank">http://www.kepler-project.org/kar-2.0.0</a></returndoctype><returnfield>/entity/@name</returnfield><querygroup
operator="INTERSECT"><queryterm
searchmode="contains"
casesensitive="false"><value>%twittergraph%</value><pathexpr>/</pathexpr></queryterm></querygroup></pathquery>
[edu.ucsb.nceas.metacat.DBQuery]</span></p>
<p class="MsoNormal"><span style="font-size: 8pt;">knb
20110506-01:30:54: [</span><span style="font-size: 8pt;">INFO</span><span
style="font-size: 8pt;">]: DBQuery.findDocuments - qformat:
xml [edu.ucsb.nceas.metacat.DBQuery]</span></p>
<p class="MsoNormal"><span style="font-size: 8pt;">knb
20110506-01:30:54: [</span><span style="font-size: 8pt;">INFO</span><span
style="font-size: 8pt;">]:
QuerySpecification.handleReturnField - there are no attributes
in the
XPATH statement [edu.ucsb.nceas.metacat.QuerySpecification]</span></p>
<p class="MsoNormal"><span style="font-size: 8pt;">knb
20110506-01:30:54: [</span><span style="font-size: 8pt;">INFO</span><span
style="font-size: 8pt;">]: In QueryGroup.printSQL.. found a
QueryGroup: (SELECT DISTINCT docid
FROM xml_nodes WHERE UPPER(nodedata) LIKE '%%TWITTERGRAPH%%' </span><span
style="font-size: 8pt;">AND</span><span style="font-size:
8pt;"> parentnodeid IN (SELECT nodeid FROM xml_index WHERE
path LIKE '/')
)<span> </span>[edu.ucsb.nceas.metacat.QueryGroup]</span></p>
<p class="MsoNormal"><span style="font-size: 8pt;">knb
20110506-01:30:54: [</span><span style="font-size: 8pt;">INFO</span><span
style="font-size: 8pt;">]: In QueryGroup.printSQL.. final
query returned is: ((SELECT DISTINCT
docid FROM xml_nodes WHERE UPPER(nodedata) LIKE
'%%TWITTERGRAPH%%' </span><span style="font-size: 8pt;">AND</span><span
style="font-size: 8pt;"> parentnodeid IN (SELECT nodeid FROM
xml_index WHERE path LIKE '/') ) )
[edu.ucsb.nceas.metacat.QueryGroup]</span></p>
<p class="MsoNormal"><span style="font-size: 8pt;">knb
20110506-01:30:54: [</span><span style="font-size: 8pt;">INFO</span><span
style="font-size: 8pt;">]: QuerySpecification.printSQL - Query
: ((SELECT DISTINCT docid FROM
xml_nodes WHERE UPPER(nodedata) LIKE '%%TWITTERGRAPH%%' </span><span
style="font-size: 8pt;">AND</span><span style="font-size:
8pt;"> parentnodeid IN (SELECT nodeid FROM xml_index WHERE
path LIKE '/') ) )
[edu.ucsb.nceas.metacat.QuerySpecification]</span></p>
<p class="MsoNormal"><span style="font-size: 8pt;">knb
20110506-01:30:54: [</span><span style="font-size: 8pt;">INFO</span><span
style="font-size: 8pt;">]: QuerySpecification.printSQL -
percentage number: 0
[edu.ucsb.nceas.metacat.QuerySpecification]</span></p>
<p class="MsoNormal"><span style="font-size: 8pt;">knb
20110506-01:30:54: [</span><span style="font-size: 8pt;">INFO</span><span
style="font-size: 8pt;">]: QuerySpecification.createOwerQuery
- OwnerQuery: null
[edu.ucsb.nceas.metacat.QuerySpecification]</span></p>
<p class="MsoNormal"><span style="font-size: 8pt;">knb
20110506-01:30:54: [</span><span style="font-size: 8pt;">INFO</span><span
style="font-size: 8pt;">]:
QuerySpecification.constructAllowString - allow string is:
(lower(principal_name) = 'public') </span><span
style="font-size: 8pt;">AND</span><span style="font-size:
8pt;"> perm_type = 'allow' </span><span style="font-size:
8pt;">AND</span><span style="font-size: 8pt;"> permission
> 3 [edu.ucsb.nceas.metacat.QuerySpecification]</span></p>
<p class="MsoNormal"><span style="font-size: 8pt;">knb
20110506-01:30:54: [</span><span style="font-size: 8pt;">INFO</span><span
style="font-size: 8pt;">]:
QuerySpecification.createAllowRuleQuery - allow query is:
SELECT
docid from xml_access WHERE( (lower(principal_name) =
'public') </span><span style="font-size: 8pt;">AND</span><span
style="font-size: 8pt;"> perm_type = 'allow' </span><span
style="font-size: 8pt;">AND</span><span style="font-size:
8pt;"> permission
> 3) [edu.ucsb.nceas.metacat.QuerySpecification]</span></p>
<p class="MsoNormal"><span style="font-size: 8pt;">knb
20110506-01:30:54: [</span><span style="font-size: 8pt;">INFO</span><span
style="font-size: 8pt;">]:
QuerySpecification.constructDenyString - deny string is:
(lower(principal_name) = 'public') </span><span
style="font-size: 8pt;">AND</span><span style="font-size:
8pt;"> perm_type = 'deny' </span><span style="font-size:
8pt;">AND</span><span style="font-size: 8pt;"> perm_order
='allowFirst' </span><span style="font-size: 8pt;">AND</span><span
style="font-size: 8pt;"> permission > 3
[edu.ucsb.nceas.metacat.QuerySpecification]</span></p>
<p class="MsoNormal"><span style="font-size: 8pt;">knb
20110506-01:30:54: [</span><span style="font-size: 8pt;">INFO</span><span
style="font-size: 8pt;">]:
QuerySpecification.createDenyRuleQuery - denyquery is: SELECT
docid
from xml_access WHERE( (lower(principal_name) = 'public') </span><span
style="font-size: 8pt;">AND</span><span style="font-size:
8pt;"> perm_type = 'deny' </span><span style="font-size:
8pt;">AND</span><span style="font-size: 8pt;"> perm_order
='allowFirst' </span><span style="font-size: 8pt;">AND</span><span
style="font-size: 8pt;"> permission > 3)<span>
</span>[edu.ucsb.nceas.metacat.QuerySpecification]</span></p>
<p class="MsoNormal"><span style="font-size: 8pt;">knb
20110506-01:30:54: [</span><span style="font-size: 8pt;">INFO</span><span
style="font-size: 8pt;">]: QuerySpecification.getAccessQuery -
access query is:<span> </span></span><span style="font-size:
8pt;">AND</span><span style="font-size: 8pt;"> (docid IN
(SELECT docid from xml_access WHERE( (lower(principal_name) =
'public') </span><span style="font-size: 8pt;">AND</span><span
style="font-size: 8pt;"> perm_type = 'allow' </span><span
style="font-size: 8pt;">AND</span><span style="font-size:
8pt;"> permission > 3)) </span><span style="font-size:
8pt;">AND</span><span style="font-size: 8pt;"> docid NOT IN
(SELECT docid from xml_access WHERE( (lower(principal_name) =
'public') </span><span style="font-size: 8pt;">AND</span><span
style="font-size: 8pt;"> perm_type = 'deny' </span><span
style="font-size: 8pt;">AND</span><span style="font-size:
8pt;"> perm_order ='allowFirst' </span><span
style="font-size: 8pt;">AND</span><span style="font-size:
8pt;"> permission > 3) ))
[edu.ucsb.nceas.metacat.QuerySpecification]</span></p>
<p class="MsoNormal"><span style="font-size: 8pt;">knb
20110506-01:30:54: [</span><span style="font-size: 8pt;">INFO</span><span
style="font-size: 8pt;">]: DBQuery.getResultXMLFromCache - Get
query from cache
[edu.ucsb.nceas.metacat.DBQuery]</span></p>
<p class="MsoNormal"><span style="font-size: 8pt;"> </span></p>
<p class="MsoNormal"><br>
</p>
<p class="MsoNormal"><br>
</p>
<p class="MsoNormal"><br>
</p>
<p class="MsoNormal">
</p>
<p class="MsoNormal"><span style="font-size: 8pt;">knb
20110506-00:58:46: [</span><span style="font-size: 8pt;">INFO</span><span
style="font-size: 8pt;">]: MetaCatServlet.handleGetOrPost -
Action is: query [edu.ucsb.nceas.metacat.MetaCatServlet]</span></p>
<p class="MsoNormal"><span style="font-size: 8pt;">knb
20110506-00:58:46: [</span><span style="font-size: 8pt;">INFO</span><span
style="font-size: 8pt;">]: MetaCatServlet.handleGetOrPost -
The user is : public [edu.ucsb.nceas.metacat.MetaCatServlet]</span></p>
<p class="MsoNormal"><span style="font-size: 8pt;">knb
20110506-00:58:46: [</span><span style="font-size: 8pt;">INFO</span><span
style="font-size: 8pt;">]: DBQuery.findDocuments - SESSIONID:
0 [edu.ucsb.nceas.metacat.DBQuery]</span></p>
<p class="MsoNormal"><span style="font-size: 8pt;">knb
20110506-00:58:46: [</span><span style="font-size: 8pt;">INFO</span><span
style="font-size: 8pt;">]: DBQuery.findDocuments - xmlquery:
<?xml version="1.0"?></span></p>
<p class="MsoNormal"><span style="font-size: 8pt;"><pathquery
version="1.2"></span></p>
<p class="MsoNormal"><span style="font-size: 8pt;"><returndoctype><a
moz-do-not-send="true"
href="http://www.kepler-project.org/kar-2.0.0"
target="_blank">http://www.kepler-project.org/kar-2.0.0</a></returndoctype><returndoctype><a
moz-do-not-send="true"
href="http://www.kepler-project.org/kar-2.1.0"
target="_blank">http://www.kepler-project.org/kar-2.1.0</a></returndoctype><returnfield>karFileName</returnfield><returnfield>karEntry/karEntryXML/entity/@name</returnfield><returnfield>mainAttributes/lsid</returnfield><returnfield>karEntry/karEntryXML/entity/property[@name='author']/configure</returnfield><returnfield>karEntry/karEntryXML/entity/property[@name='KeplerDocumentation']/property[@name='version']/configure</returnfield><returnfield>karEntry/karEntryXML/entity/property[@name='KeplerDocumentation']/property[@name='description']/configure</returnfield><returnfield>karEntry/karEntryXML/entity/property[@name='KeplerDocumentation']/property[@name='userLevelDocumentation']/configure</returnfield><querygroup
operator="INTERSECT"><queryterm
casesensitive="false"
searchmode="contains"><value>rssgraph</value></queryterm></querygroup></pathquery>
[edu.ucsb.nceas.metacat.DBQuery]</span></p>
<p class="MsoNormal"><span style="font-size: 8pt;">knb
20110506-00:58:46: [</span><span style="font-size: 8pt;">INFO</span><span
style="font-size: 8pt;">]: DBQuery.findDocuments - qformat:
kepler [edu.ucsb.nceas.metacat.DBQuery]</span></p>
<p class="MsoNormal"><span style="font-size: 8pt;">knb
20110506-00:58:46: [</span><span style="font-size: 8pt;">INFO</span><span
style="font-size: 8pt;">]:
QuerySpecification.handleReturnField - there are no attributes
in the
XPATH statement [edu.ucsb.nceas.metacat.QuerySpecification]</span></p>
<p class="MsoNormal"><span style="font-size: 8pt;">knb
20110506-00:58:46: [</span><span style="font-size: 8pt;">INFO</span><span
style="font-size: 8pt;">]:
QuerySpecification.handleReturnField - there are no attributes
in the
XPATH statement [edu.ucsb.nceas.metacat.QuerySpecification]</span></p>
<p class="MsoNormal"><span style="font-size: 8pt;">knb
20110506-00:58:46: [</span><span style="font-size: 8pt;">INFO</span><span
style="font-size: 8pt;">]:
QuerySpecification.handleReturnField - there are no attributes
in the
XPATH statement [edu.ucsb.nceas.metacat.QuerySpecification]</span></p>
<p class="MsoNormal"><span style="font-size: 8pt;">knb
20110506-00:58:46: [</span><span style="font-size: 8pt;">INFO</span><span
style="font-size: 8pt;">]:
QuerySpecification.handleReturnField - there are no attributes
in the
XPATH statement [edu.ucsb.nceas.metacat.QuerySpecification]</span></p>
<p class="MsoNormal"><span style="font-size: 8pt;">knb
20110506-00:58:46: [</span><span style="font-size: 8pt;">INFO</span><span
style="font-size: 8pt;">]:
QuerySpecification.handleReturnField - there are no attributes
in the
XPATH statement [edu.ucsb.nceas.metacat.QuerySpecification]</span></p>
<p class="MsoNormal"><span style="font-size: 8pt;">knb
20110506-00:58:46: [</span><span style="font-size: 8pt;">INFO</span><span
style="font-size: 8pt;">]:
QuerySpecification.handleReturnField - there are no attributes
in the
XPATH statement [edu.ucsb.nceas.metacat.QuerySpecification]</span></p>
<p class="MsoNormal"><span style="font-size: 8pt;">knb
20110506-00:58:46: [</span><span style="font-size: 8pt;">INFO</span><span
style="font-size: 8pt;">]:
QuerySpecification.handleReturnField - there are no attributes
in the
XPATH statement [edu.ucsb.nceas.metacat.QuerySpecification]</span></p>
<p class="MsoNormal"><span style="font-size: 8pt;">knb
20110506-00:58:46: [</span><span style="font-size: 8pt;">INFO</span><span
style="font-size: 8pt;">]: In QueryGroup.printSQL.. found a
QueryGroup: (SELECT DISTINCT docid
FROM xml_nodes WHERE UPPER(nodedata) LIKE '%RSSGRAPH%' )<span>
</span>[edu.ucsb.nceas.metacat.QueryGroup]</span></p>
<p class="MsoNormal"><span style="font-size: 8pt;">knb
20110506-00:58:46: [</span><span style="font-size: 8pt;">INFO</span><span
style="font-size: 8pt;">]: In QueryGroup.printSQL.. final
query returned is: ((SELECT DISTINCT
docid FROM xml_nodes WHERE UPPER(nodedata) LIKE '%RSSGRAPH%' )
) [edu.ucsb.nceas.metacat.QueryGroup]</span></p>
<p class="MsoNormal"><span style="font-size: 8pt;">knb
20110506-00:58:46: [</span><span style="font-size: 8pt;">INFO</span><span
style="font-size: 8pt;">]: QuerySpecification.printSQL - Query
: ((SELECT DISTINCT docid FROM
xml_nodes WHERE UPPER(nodedata) LIKE '%RSSGRAPH%' ) )
[edu.ucsb.nceas.metacat.QuerySpecification]</span></p>
<p class="MsoNormal"><span style="font-size: 8pt;">knb
20110506-00:58:46: [</span><span style="font-size: 8pt;">INFO</span><span
style="font-size: 8pt;">]: QuerySpecification.printSQL -
percentage number: 0
[edu.ucsb.nceas.metacat.QuerySpecification]</span></p>
<p class="MsoNormal"><span style="font-size: 8pt;">knb
20110506-00:58:46: [</span><span style="font-size: 8pt;">INFO</span><span
style="font-size: 8pt;">]: QuerySpecification.createOwerQuery
- OwnerQuery: null [edu.ucsb.nceas.metacat.QuerySpecification]</span></p>
<p class="MsoNormal"><span style="font-size: 8pt;">knb
20110506-00:58:46: [</span><span style="font-size: 8pt;">INFO</span><span
style="font-size: 8pt;">]:
QuerySpecification.constructAllowString - allow string is:
(lower(principal_name)
= 'public') </span><span style="font-size: 8pt;">AND</span><span
style="font-size: 8pt;"> perm_type = 'allow' </span><span
style="font-size: 8pt;">AND</span><span style="font-size:
8pt;"> permission > 3
[edu.ucsb.nceas.metacat.QuerySpecification]</span></p>
<p class="MsoNormal"><span style="font-size: 8pt;">knb
20110506-00:58:46: [</span><span style="font-size: 8pt;">INFO</span><span
style="font-size: 8pt;">]:
QuerySpecification.createAllowRuleQuery - allow query is:
SELECT
docid from xml_access WHERE( (lower(principal_name) =
'public') </span><span style="font-size: 8pt;">AND</span><span
style="font-size: 8pt;"> perm_type = 'allow' </span><span
style="font-size: 8pt;">AND</span><span style="font-size:
8pt;"> permission >
3) [edu.ucsb.nceas.metacat.QuerySpecification]</span></p>
<p class="MsoNormal"><span style="font-size: 8pt;">knb
20110506-00:58:46: [</span><span style="font-size: 8pt;">INFO</span><span
style="font-size: 8pt;">]:
QuerySpecification.constructDenyString - deny string is:
(lower(principal_name)
= 'public') </span><span style="font-size: 8pt;">AND</span><span
style="font-size: 8pt;"> perm_type = 'deny' </span><span
style="font-size: 8pt;">AND</span><span style="font-size:
8pt;"> perm_order ='allowFirst' </span><span
style="font-size: 8pt;">AND</span><span style="font-size:
8pt;"> permission > 3
[edu.ucsb.nceas.metacat.QuerySpecification]</span></p>
<p class="MsoNormal"><span style="font-size: 8pt;">knb
20110506-00:58:46: [</span><span style="font-size: 8pt;">INFO</span><span
style="font-size: 8pt;">]:
QuerySpecification.createDenyRuleQuery - denyquery is: SELECT
docid
from xml_access WHERE( (lower(principal_name) = 'public') </span><span
style="font-size: 8pt;">AND</span><span style="font-size:
8pt;"> perm_type = 'deny' </span><span style="font-size:
8pt;">AND</span><span style="font-size: 8pt;"> perm_order
='allowFirst' </span><span style="font-size: 8pt;">AND</span><span
style="font-size: 8pt;"> permission > 3)<span> </span>[edu.ucsb.nceas.metacat.QuerySpecification]</span></p>
<p class="MsoNormal"><span style="font-size: 8pt;">knb
20110506-00:58:46: [</span><span style="font-size: 8pt;">INFO</span><span
style="font-size: 8pt;">]: QuerySpecification.getAccessQuery -
access query is:<span> </span></span><span style="font-size:
8pt;">AND</span><span style="font-size: 8pt;"> (docid IN
(SELECT docid from xml_access WHERE( (lower(principal_name) =
'public') </span><span style="font-size: 8pt;">AND</span><span
style="font-size: 8pt;"> perm_type = 'allow' </span><span
style="font-size: 8pt;">AND</span><span style="font-size:
8pt;"> permission > 3)) </span><span style="font-size:
8pt;">AND</span><span style="font-size: 8pt;"> docid NOT IN
(SELECT docid from xml_access WHERE( (lower(principal_name) =
'public') </span><span style="font-size: 8pt;">AND</span><span
style="font-size: 8pt;"> perm_type = 'deny' </span><span
style="font-size: 8pt;">AND</span><span style="font-size:
8pt;"> perm_order ='allowFirst' </span><span
style="font-size: 8pt;">AND</span><span style="font-size:
8pt;"> permission > 3) ))
[edu.ucsb.nceas.metacat.QuerySpecification]</span></p>
<p class="MsoNormal"><span style="font-size: 8pt;">knb
20110506-00:58:46: [</span><span style="font-size: 8pt;">INFO</span><span
style="font-size: 8pt;">]: DBQuery.findResultDoclist - real
result: 5439.341 [edu.ucsb.nceas.metacat.DBQuery]</span></p>
<p class="MsoNormal"><span style="font-size: 8pt;">knb
20110506-00:58:46: [</span><span style="font-size: 8pt;">INFO</span><span
style="font-size: 8pt;">]: DBQuery.getXmlReturnfieldsTableId -
ReturnField Query:SELECT
returnfield_id, usage_count FROM xml_returnfield WHERE
returnfield_string LIKE ?
[edu.ucsb.nceas.metacat.DBQuery]</span></p>
<p class="MsoNormal"><span style="font-size: 8pt;">knb
20110506-00:58:46: [</span><span style="font-size: 8pt;">INFO</span><span
style="font-size: 8pt;">]: DBQuery.getXmlReturnfieldsTableId -
ReturnField Table Update:UPDATE
xml_returnfield SET usage_count ='81' WHERE returnfield_id
='2' [edu.ucsb.nceas.metacat.DBQuery]</span></p>
<p class="MsoNormal"><span style="font-size: 8pt;">knb
20110506-00:58:46: [</span><span style="font-size: 8pt;">INFO</span><span
style="font-size: 8pt;">]: DBQuery.handleSubsetResult - size
of partOfDoclist before
docidsInQueryresultTable(): 1 [edu.ucsb.nceas.metacat.DBQuery]</span></p>
<p class="MsoNormal"><span style="font-size: 8pt;">knb
20110506-00:58:46: [</span><span style="font-size: 8pt;">INFO</span><span
style="font-size: 8pt;">]: DBQuery.docidsInQueryresultTable -
Query to get docids from xml_queryresult:select
docid, queryresult_string from xml_queryresult where
returnfield_id = 2 and
docid in ('5439.341') [edu.ucsb.nceas.metacat.DBQuery]</span></p>
<p class="MsoNormal"><span style="font-size: 8pt;">knb
20110506-00:58:46: [</span><span style="font-size: 8pt;">INFO</span><span
style="font-size: 8pt;">]: DBQuery.handleSubsetResult - size
of partOfDoclist after
docidsInQueryresultTable(): 0 [edu.ucsb.nceas.metacat.DBQuery]</span></p>
<p class="MsoNormal"><span style="font-size: 8pt;">knb
20110506-00:58:46: [</span><span style="font-size: 8pt;">INFO</span><span
style="font-size: 8pt;">]: DBTransform.getStyleSystemId -
Trying style-set file:
/usr/share/tomcat5.5/webapps/knb/style/skins/kepler/kepler.xml
[edu.ucsb.nceas.metacat.DBTransform]</span></p>
<p class="MsoNormal"><span style="font-size: 8pt;">knb
20110506-00:58:47: [</span><span style="font-size: 8pt;">INFO</span><span
style="font-size: 8pt;">]: DBTransform.getStyleSystemId -
style system id is: <a moz-do-not-send="true"
href="http://50.17.219.137:8080/knb/style/skins/kepler/resultset.xsl"
target="_blank">http://50.17.219.137:8080/knb/style/skins/kepler/resultset.xsl</a>
[edu.ucsb.nceas.metacat.DBTransform]</span></p>
<p class="MsoNormal"><span style="font-size: 8pt;">SystemId
Unknown; Line #294; Column
#36; A location step was expected following the '/' or '//'
token.</span></p>
<p class="MsoNormal"><span style="font-size: 8pt;">SystemId
Unknown; Line #303; Column
#39; A location step was expected following the '/' or '//'
token.</span></p>
<p class="MsoNormal"><span style="font-size: 8pt;">SystemId
Unknown; Line #312; Column
#36; A location step was expected following the '/' or '//'
token.</span></p>
<p class="MsoNormal"><span style="font-size: 8pt;">knb
20110506-00:58:47: [</span><span style="font-size: 8pt;">INFO</span><span
style="font-size: 8pt;">]: DBTransform.doTransform - qformat:
kepler [edu.ucsb.nceas.metacat.DBTransform]</span></p>
<p class="MsoNormal"><span style="font-size: 8pt;">knb
20110506-00:58:47: [</span><span style="font-size: 8pt;">INFO</span><span
style="font-size: 8pt;">]: DBTransform.doTransform - param:
pagestart -- 0 [edu.ucsb.nceas.metacat.DBTransform]</span></p>
<p class="MsoNormal"><span style="font-size: 8pt;">knb
20110506-00:58:47: [</span><span style="font-size: 8pt;">INFO</span><span
style="font-size: 8pt;">]: DBTransform.doTransform - param:
anyfield -- rssgraph [edu.ucsb.nceas.metacat.DBTransform]</span></p>
<p class="MsoNormal"><span style="font-size: 8pt;">knb
20110506-00:58:47: [</span><span style="font-size: 8pt;">INFO</span><span
style="font-size: 8pt;">]: DBTransform.doTransform - param:
operator -- INTERSECT [edu.ucsb.nceas.metacat.DBTransform]</span></p>
<p class="MsoNormal"><span style="font-size: 8pt;">knb
20110506-00:58:47: [</span><span style="font-size: 8pt;">INFO</span><span
style="font-size: 8pt;">]: DBTransform.doTransform - param:
qformat -- kepler [edu.ucsb.nceas.metacat.DBTransform]</span></p>
<p class="MsoNormal"><span style="font-size: 8pt;">knb
20110506-00:58:47: [</span><span style="font-size: 8pt;">INFO</span><span
style="font-size: 8pt;">]: DBTransform.doTransform - param:
returnfield -- karFileName
[edu.ucsb.nceas.metacat.DBTransform]</span></p>
<p class="MsoNormal"><span style="font-size: 8pt;">knb
20110506-00:58:47: [</span><span style="font-size: 8pt;">INFO</span><span
style="font-size: 8pt;">]: DBTransform.doTransform - param:
action -- query [edu.ucsb.nceas.metacat.DBTransform]</span></p>
<p class="MsoNormal"><span style="font-size: 8pt;">knb
20110506-00:58:47: [</span><span style="font-size: 8pt;">INFO</span><span
style="font-size: 8pt;">]: DBTransform.doTransform - param:
pagesize -- 10 [edu.ucsb.nceas.metacat.DBTransform]</span></p>
<p class="MsoNormal"><span style="font-size: 8pt;">knb
20110506-00:58:47: [</span><span style="font-size: 8pt;">INFO</span><span
style="font-size: 8pt;">]: DBTransform.doTransform - param:
returndoctype -- <a moz-do-not-send="true"
href="http://www.kepler-project.org/kar-2.0.0"
target="_blank">http://www.kepler-project.org/kar-2.0.0</a>
[edu.ucsb.nceas.metacat.DBTransform]</span></p>
<p class="MsoNormal"><span style="font-size: 8pt;">knb
20110506-00:58:47: [</span><span style="font-size: 8pt;">INFO</span><span
style="font-size: 8pt;">]: DBTransform.doTransform - param:
enableediting -- false [edu.ucsb.nceas.metacat.DBTransform]</span></p>
<p class="MsoNormal"><span style="font-size: 8pt;">knb
20110506-00:58:47: [</span><span style="font-size: 8pt;">INFO</span><span
style="font-size: 8pt;">]: DBTransform.doTransform - param:
query -- <?xml version="1.0"?></span></p>
<p class="MsoNormal"><span style="font-size: 8pt;"><pathquery
version="1.2"></span></p>
<p class="MsoNormal"><span style="font-size: 8pt;"><returndoctype><a
moz-do-not-send="true"
href="http://www.kepler-project.org/kar-2.0.0"
target="_blank">http://www.kepler-project.org/kar-2.0.0</a></returndoctype><returndoctype><a
moz-do-not-send="true"
href="http://www.kepler-project.org/kar-2.1.0"
target="_blank">http://www.kepler-project.org/kar-2.1.0</a></returndoctype><returnfield>karFileName</returnfield><returnfield>karEntry/karEntryXML/entity/@name</returnfield><returnfield>mainAttributes/lsid</returnfield><returnfield>karEntry/karEntryXML/entity/property[@name='author']/configure</returnfield><returnfield>karEntry/karEntryXML/entity/property[@name='KeplerDocumentation']/property[@name='version']/configure</returnfield><returnfield>karEntry/karEntryXML/entity/property[@name='KeplerDocumentation']/property[@name='description']/configure</returnfield><returnfield>karEntry/karEntryXML/entity/property[@name='KeplerDocumentation']/property[@name='userLevelDocumentation']/configure</returnfield><querygroup
operator="INTERSECT"><queryterm
casesensitive="false"
searchmode="contains"><value>rssgraph</value></queryterm></querygroup></pathquery>
[edu.ucsb.nceas.metacat.DBTransform]</span></p>
<br>
<br>
<div class="gmail_quote">On Thu, May 5, 2011 at 5:28 PM, tao <span
dir="ltr"><<a moz-do-not-send="true"
href="mailto:tao@nceas.ucsb.edu">tao@nceas.ucsb.edu</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt
0.8ex; border-left: 1px solid rgb(204, 204, 204);
padding-left: 1ex;">
Hi, Soctt:<br>
<br>
I looked at the configurations and they look good to me. I
tried to access the server but got a timeout response.<br>
<br>
When you do a search on both kepler and web site, can you
monitor the tomcat log file? To compare the difference on the
output might give us some idea why there is no return on
kepler search. In order to get more information from tomcat
log file, you may change the default level from WARN to INFO
in tomcat log4j property file.<br>
<br>
Thanks,<br>
<br>
Jing<br>
<br>
Scott Zimmer wrote:<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt
0.8ex; border-left: 1px solid rgb(204, 204, 204);
padding-left: 1ex;">
<div class="im">
I have set up a private knb repository to store KAR files.
I am able to successfully authenticate and upload KAR
files to the repository. I can also search for KAR files
from a web browser, but I get no returns when I search for
the KAR files from within Kepler. I am able to
authenticate to the repository, but no search results are
returned. I can successfully search the Kepler-Dev
repository. I've included the repository related entries
from my configuration.xml files. I left the registry path
set to the ecogrid one because I did not see an easy way
to set that up myself. I would appreciate any insight you
have into why I get no search results inside Kepler from
the repository---Scott<br>
<br>
<repository><br>
<name><br>
optensity<br>
</name><br>
<repository><br>
</div>
<a moz-do-not-send="true"
href="http://50.17.219.137:8080" target="_blank">50.17.219.137:8080</a>
<<a moz-do-not-send="true"
href="http://50.17.219.137:8080" target="_blank">http://50.17.219.137:8080</a>>
<div>
<div class="h5"><br>
</repository><br>
<putpath><br>
/knb/services/PutService<br>
</putpath><br>
<authprotocol><br>
http<br>
</authprotocol><br>
<authdomain><br>
OPTENSITY<br>
</authdomain><br>
<lsidpath><br>
/knb/services/IdentifierService<br>
</lsidpath><br>
<querypath><br>
/knb/services/QueryService<br>
</querypath><br>
<authenticatedquerypath><br>
/knb/services/AuthenticatedQueryService<br>
</authenticatedquerypath><br>
<authorizationPath><br>
/knb/services/AuthorizationService<br>
</authorizationPath><br>
<registrypath><br>
<a moz-do-not-send="true"
href="http://ecogrid.ecoinformatics.org/registry/services/RegistryService"
target="_blank">http://ecogrid.ecoinformatics.org/registry/services/RegistryService</a><br>
</registrypath><br>
<registryauth><br>
<a moz-do-not-send="true"
href="http://50.17.219.137:8080/knb/services/AuthenticationService"
target="_blank">http://50.17.219.137:8080/knb/services/AuthenticationService</a><br>
</registryauth><br>
<class><br>
org.kepler.objectmanager.repository.EcogridRepository<br>
</class><br>
<lsidAuthority><br>
</div>
</div>
<a moz-do-not-send="true"
href="http://kepler-dev.nceas.ucsb.edu" target="_blank">kepler-dev.nceas.ucsb.edu</a>
<<a moz-do-not-send="true"
href="http://kepler-dev.nceas.ucsb.edu" target="_blank">http://kepler-dev.nceas.ucsb.edu</a>>
<div class="im"><br>
</lsidAuthority><br>
<searchRepository><br>
true<br>
</searchRepository><br>
</repository><br>
<br>
<service><br>
<domain>OPTENSITY</domain><br>
<serviceOperation>ldap</serviceOperation><br>
<serviceURL><a moz-do-not-send="true"
href="http://50.17.219.137:8080/knb/services/AuthenticationService"
target="_blank">http://50.17.219.137:8080/knb/services/AuthenticationService</a></serviceURL><br>
<serviceClass>org.kepler.authentication.LDAPAuthenticationService</serviceClass><br>
<username>uid=kepler,o=unaffiliated,dc=ecoinformatics,dc=org</username><br>
<password>kepler</password><br>
</service><br>
<br>
Scott<br>
-- <br>
Scott Zimmer<br>
Optensity, Inc.<br>
512-299-7218<br>
</div>
------------------------------------------------------------------------<br>
<br>
_______________________________________________<br>
Kepler-dev mailing list<br>
<a moz-do-not-send="true"
href="mailto:Kepler-dev@kepler-project.org"
target="_blank">Kepler-dev@kepler-project.org</a><br>
<a moz-do-not-send="true"
href="http://lists.nceas.ucsb.edu/kepler/mailman/listinfo/kepler-dev"
target="_blank">http://lists.nceas.ucsb.edu/kepler/mailman/listinfo/kepler-dev</a><br>
<br>
</blockquote>
<br>
</blockquote>
</div>
<br>
<br clear="all">
<br>
-- <br>
Scott Zimmer<br>
Optensity, Inc.<br>
512-299-7218<br>
</blockquote>
<br>
</body>
</html>