Ticket #481 (closed defect: fixed)

Opened 1 year ago

Last modified 1 year ago

annotated.groovy fails with -s or -e options

Reported by: russ Assigned to: ebrown
Priority: high Milestone:
Component: topaz Version: 0.7
Keywords: Cc:
Blocking: Blocked By:

Description

annotated.groovy fails with an error if i try start or end options.

i've tried YYYY-MM-DDT00:00:00 format as well as YYYY-MM-DD format with the same result.

without -s and -e, works fine.

i've tried the 0.7 version as well as the version from r3905.

high priority as we've gone a few weeks now without sending this... 

[root@plosfail01 scripts]# /usr/local/topaz/bin/rungroovy /usr/local/topaz/scripts/annotated.groovy -F plosfed01.localdomain:9090 -M ploskow01.localdomain:9091 -s 2007-07-04 -e 2007-07-11
log4j:WARN No appenders could be found for logger (org.apache.axis.i18n.ProjectResourceBundle).
log4j:WARN Please initialize the log4j system properly.
Exception in thread "main" AxisFault
 faultCode: {http://schemas.xmlsoap.org/soap/envelope/}Server.userException
 faultSubcode:
 faultString: org.mulgara.query.QueryException: Couldn't build query
 faultActor:
 faultNode:
 faultDetail:
 {http://xml.apache.org/axis/}hostname:ploskow01.localdomain

org.mulgara.query.QueryException: Couldn't build query
 at org.apache.axis.message.SOAPFaultBuilder.createFault(SOAPFaultBuilder.java:222)
 at org.apache.axis.message.SOAPFaultBuilder.endElement(SOAPFaultBuilder.java:129)
 at org.apache.axis.encoding.DeserializationContext.endElement(DeserializationContext.java:1087)
 at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.endElement(AbstractSAXParser.java:633)
 at com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.scanEndElement(XMLNSDocumentScannerImpl.java:719)
 at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(XMLDocumentFragmentScannerImpl.java:1685)
 at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(XMLDocumentFragmentScannerImpl.java:368)
 at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:834)
 at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:764)
 at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.java:148)
 at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(AbstractSAXParser.java:1242)
 at javax.xml.parsers.SAXParser.parse(SAXParser.java:375)
 at org.apache.axis.encoding.DeserializationContext.parse(DeserializationContext.java:227)
 at org.apache.axis.SOAPPart.getAsSOAPEnvelope(SOAPPart.java:696)
 at org.apache.axis.Message.getSOAPEnvelope(Message.java:435)
 at org.apache.axis.transport.http.HTTPSender.readFromSocket(HTTPSender.java:796)
 at org.apache.axis.transport.http.HTTPSender.invoke(HTTPSender.java:144)
 at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)
 at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)
 at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)
 at org.apache.axis.client.AxisClient.invoke(AxisClient.java:165)
 at org.apache.axis.client.Call.invokeEngine(Call.java:2784)
 at org.apache.axis.client.Call.invoke(Call.java:2767)
 at org.apache.axis.client.Call.invoke(Call.java:2443)
 at org.apache.axis.client.Call.invoke(Call.java:2366)
 at org.apache.axis.client.Call.invoke(Call.java:1812)
 at org.topazproject.mulgara.itql.service.ItqlInterpreterBeanServicePortSoapBindingStub.executeQueryToString(ItqlInterpreterBeanServicePortSoapBindingStub.java:358)
 at org.topazproject.mulgara.itql.ItqlHelper.doQuery(ItqlHelper.java:291)
 at gjdk.org.topazproject.mulgara.itql.ItqlHelper_GroovyReflector.invoke(Unknown Source)
 at groovy.lang.MetaMethod.invoke(MetaMethod.java:115)
 at org.codehaus.groovy.runtime.MetaClassHelper.doMethodInvoke(MetaClassHelper.java:713)
 at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:560)
 at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:450)
 at org.codehaus.groovy.runtime.Invoker.invokeMethod(Invoker.java:119)
 at org.codehaus.groovy.runtime.InvokerHelper.invokeMethod(InvokerHelper.java:111)
 at org.codehaus.groovy.runtime.ScriptBytecodeAdapter.invokeMethodN(ScriptBytecodeAdapter.java:187)
 at annotated.run(annotated.groovy:86)
 at gjdk.annotated_GroovyReflector.invoke(Unknown Source)
 at groovy.lang.MetaMethod.invoke(MetaMethod.java:115)
 at org.codehaus.groovy.runtime.MetaClassHelper.doMethodInvoke(MetaClassHelper.java:713)
 at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:560)
 at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:450)
 at org.codehaus.groovy.runtime.Invoker.invokeMethod(Invoker.java:131)
 at org.codehaus.groovy.runtime.InvokerHelper.invokeMethod(InvokerHelper.java:111)
 at org.codehaus.groovy.runtime.InvokerHelper.runScript(InvokerHelper.java:408)
 at gjdk.org.codehaus.groovy.runtime.InvokerHelper_GroovyReflector.invoke(Unknown Source)
 at groovy.lang.MetaMethod.invoke(MetaMethod.java:115)
 at org.codehaus.groovy.runtime.MetaClassHelper.doMethodInvoke(MetaClassHelper.java:713)
 at groovy.lang.MetaClassImpl.invokeStaticMethod(MetaClassImpl.java:664)
 at org.codehaus.groovy.runtime.Invoker.invokeMethod(Invoker.java:111)
 at org.codehaus.groovy.runtime.InvokerHelper.invokeMethod(InvokerHelper.java:111)
 at org.codehaus.groovy.runtime.ScriptBytecodeAdapter.invokeMethodN(ScriptBytecodeAdapter.java:187)
 at annotated.main(annotated.groovy)
 at gjdk.annotated_GroovyReflector.invoke(Unknown Source)
 at groovy.lang.MetaMethod.invoke(MetaMethod.java:115)
 at org.codehaus.groovy.runtime.MetaClassHelper.doMethodInvoke(MetaClassHelper.java:713)
 at groovy.lang.MetaClassImpl.invokeStaticMethod(MetaClassImpl.java:664)
 at org.codehaus.groovy.runtime.Invoker.invokeMethod(Invoker.java:111)
 at org.codehaus.groovy.runtime.InvokerHelper.invokeMethod(InvokerHelper.java:111)
 at groovy.lang.GroovyShell.runMainOrTestOrRunnable(GroovyShell.java:319)
 at groovy.lang.GroovyShell.run(GroovyShell.java:244)
 at groovy.lang.GroovyShell.run(GroovyShell.java:173)
 at gjdk.groovy.lang.GroovyShell_GroovyReflector.invoke(Unknown Source)
 at groovy.lang.MetaMethod.invoke(MetaMethod.java:115)
 at org.codehaus.groovy.runtime.MetaClassHelper.doMethodInvoke(MetaClassHelper.java:713)
 at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:560)
 at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:450)
 at org.codehaus.groovy.runtime.Invoker.invokeMethod(Invoker.java:131)
 at org.codehaus.groovy.runtime.InvokerHelper.invokeMethod(InvokerHelper.java:111)
 at org.codehaus.groovy.runtime.ScriptBytecodeAdapter.invokeMethodN(ScriptBytecodeAdapter.java:187)
 at RunGroovy.run(RunGroovy.groovy:31)
 at gjdk.RunGroovy_GroovyReflector.invoke(Unknown Source)
 at groovy.lang.MetaMethod.invoke(MetaMethod.java:115)
 at org.codehaus.groovy.runtime.MetaClassHelper.doMethodInvoke(MetaClassHelper.java:713)
 at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:560)
 at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:450)
 at org.codehaus.groovy.runtime.Invoker.invokeMethod(Invoker.java:131)
 at org.codehaus.groovy.runtime.InvokerHelper.invokeMethod(InvokerHelper.java:111)
 at org.codehaus.groovy.runtime.InvokerHelper.runScript(InvokerHelper.java:408)
 at gjdk.org.codehaus.groovy.runtime.InvokerHelper_GroovyReflector.invoke(Unknown Source)
 at groovy.lang.MetaMethod.invoke(MetaMethod.java:115)
 at org.codehaus.groovy.runtime.MetaClassHelper.doMethodInvoke(MetaClassHelper.java:713)
 at groovy.lang.MetaClassImpl.invokeStaticMethod(MetaClassImpl.java:664)
 at org.codehaus.groovy.runtime.Invoker.invokeMethod(Invoker.java:111)
 at org.codehaus.groovy.runtime.InvokerHelper.invokeMethod(InvokerHelper.java:111)
 at org.codehaus.groovy.runtime.ScriptBytecodeAdapter.invokeMethodN(ScriptBytecodeAdapter.java:187)
 at RunGroovy.main(RunGroovy.groovy)

Dependency Graph

Change History

07/11/07 17:03:42 changed by ebrown

  • owner changed from pradeep to ebrown.
  • status changed from new to assigned.

Please re-run it with -v. I just want to verify the output.

07/11/07 17:49:12 changed by russ

no problem! 

[root@plosfail01 tmp]# /usr/local/topaz/bin/rungroovy /usr/local/topaz/scripts/annotated.groovy -F plosfed01.localdomain:9090 -M ploskow01.localdomain:9091 -s 2007-07-04 -e 2007-07-11 -v
Mulgara URI: http://ploskow01.localdomain:9091/mulgara-service/services/ItqlBeanService
Fedora URI: http://plosfed01.localdomain:9090/fedora/get
log4j:WARN No appenders could be found for logger (org.apache.axis.i18n.ProjectResourceBundle).
log4j:WARN Please initialize the log4j system properly.
Query:
  select $article
    subquery(select $article $title from <local:///topazproject#ri>
             where $article <dc:title> $title)
    count(select $ann from <local:///topazproject#ri>
          where $ann <rdf:type> <a:Annotation>
            and $ann <a:annotates> $article
            and $ann <a:created> $created
             and $created <topaz:ge> '2007-07-04' in <local:///topazproject#str> and $created <topaz:le> '2007-07-11' in <local:///topazproject#str>
     minus $ann <rdf:type> <topaz:RatingSummaryAnnotation>)
    from <local:///topazproject#ri>
    where $s <rdf:type> <a:Annotation>
      and $s <a:annotates> $article
      and $s <a:created> $created
      and $article <rdf:type> <topaz:Article>
       and $created <topaz:ge> '2007-07-04' in <local:///topazproject#str> and $created <topaz:le> '2007-07-11' in <local:///topazproject#str>

07/11/07 23:10:37 changed by ebrown

  • status changed from assigned to closed.
  • resolution set to fixed.

fixed in [3158]. For 0.7, just copy annotated.groovy from head.

07/12/07 11:09:58 changed by russ

sorry to keep this one open.

now it's not counting ratings at all - or doing something weird generally for articles with ratings.

for example, if i run with a start date of 2007-07-04, it reports 1 new annotations for the sandbox article. however, there are 7 new ratings and 3 new comments/annotations. 

[root@plosfail01 tmp]# /usr/local/topaz/bin/rungroovy /usr/local/topaz/scripts/annotated.groovy -F plosfed01.localdomain:9090 -M ploskow01.localdomain:9091 -s 2007-07-04 | grep 0000000
log4j:WARN No appenders could be found for logger (org.apache.axis.i18n.ProjectResourceBundle).
log4j:WARN Please initialize the log4j system properly.
info:doi/10.1371/journal.pone.0000000   PLoS ONE Sandbox: A Place to Learn and Play     webmaster@plos.org      1.0

07/12/07 11:10:03 changed by russ

  • status changed from closed to reopened.
  • resolution deleted.

07/12/07 12:01:59 changed by ebrown

Interesting is that the date format seems to be different for annotations and ratings... 

itql> select $ann $date $type from <local:///topazproject#ri> where $ann <http://www.w3.org/2000/10/annotation-ns#annotates> <info:doi/10.1371/journal.pone.0000000> and $ann <http://www.w3.org/2000/10/annotation-ns#created> $date and $ann <rdf:type> $type;
select $ann $date $type from <local:///topazproject#ri> where $ann <http://www.w3.org/2000/10/annotation-ns#annotates> <info:doi/10.1371/journal.pone.0000000> and $ann <http://www.w3.org/2000/10/annotation-ns#created> $date and $ann <rdf:type> $type;
ann                                                                date                      type
------------------------------------------------------------------ ------------------------- -----------------------------------------------------
<info:doi/10.1371/annotation/532>                                  '2007-04-25T01:02:20Z'    <http://www.w3.org/2000/10/annotationType#Annotation>
<info:doi/10.1371/annotation/532>                                  '2007-04-25T01:02:20Z'    <http://www.w3.org/2000/10/annotation-ns#Annotation>
<info:doi/10.1371/annotation/535>                                  '2007-04-25T19:31:19Z'    <http://www.w3.org/2000/10/annotationType#Annotation>
<info:doi/10.1371/annotation/535>                                  '2007-04-25T19:31:19Z'    <http://www.w3.org/2000/10/annotation-ns#Annotation>
<info:doi/10.1371/annotation/551>                                  '2007-05-01T17:22:05Z'    <http://www.w3.org/2000/10/annotationType#Annotation>
<info:doi/10.1371/annotation/551>                                  '2007-05-01T17:22:05Z'    <http://www.w3.org/2000/10/annotation-ns#Annotation>
<info:doi/10.1371/annotation/586>                                  '2007-05-11T15:35:12Z'    <http://www.w3.org/2000/10/annotationType#Annotation>
<info:doi/10.1371/annotation/586>                                  '2007-05-11T15:35:12Z'    <http://www.w3.org/2000/10/annotation-ns#Annotation>
<info:doi/10.1371/annotation/588>                                  '2007-05-14T13:18:22Z'    <http://www.w3.org/2000/10/annotationType#Annotation>
<info:doi/10.1371/annotation/588>                                  '2007-05-14T13:18:22Z'    <http://www.w3.org/2000/10/annotation-ns#Annotation>
<info:doi/10.1371/annotation/590>                                  '2007-05-15T10:13:02Z'    <http://www.w3.org/2000/10/annotationType#Annotation>
<info:doi/10.1371/annotation/590>                                  '2007-05-15T10:13:02Z'    <http://www.w3.org/2000/10/annotation-ns#Annotation>
<info:doi/10.1371/annotation/616>                                  '2007-05-18T20:53:18Z'    <http://www.w3.org/2000/10/annotationType#Annotation>
<info:doi/10.1371/annotation/616>                                  '2007-05-18T20:53:18Z'    <http://www.w3.org/2000/10/annotation-ns#Annotation>
<info:doi/10.1371/annotation/617>                                  '2007-05-19T10:05:24Z'    <http://www.w3.org/2000/10/annotationType#Annotation>
<info:doi/10.1371/annotation/617>                                  '2007-05-19T10:05:24Z'    <http://www.w3.org/2000/10/annotation-ns#Annotation>
<info:doi/10.1371/annotation/618>                                  '2007-05-19T10:15:24Z'    <http://www.w3.org/2000/10/annotationType#Annotation>
<info:doi/10.1371/annotation/618>                                  '2007-05-19T10:15:24Z'    <http://www.w3.org/2000/10/annotation-ns#Annotation>
<info:doi/10.1371/annotation/619>                                  '2007-05-19T10:16:31Z'    <http://www.w3.org/2000/10/annotationType#Annotation>
<info:doi/10.1371/annotation/619>                                  '2007-05-19T10:16:31Z'    <http://www.w3.org/2000/10/annotation-ns#Annotation>
<info:doi/10.1371/annotation/650>                                  '2007-06-01T16:51:40Z'    <http://www.w3.org/2000/10/annotationType#Annotation>
<info:doi/10.1371/annotation/650>                                  '2007-06-01T16:51:40Z'    <http://www.w3.org/2000/10/annotation-ns#Annotation>
<info:doi/10.1371/annotation/678>                                  '2007-06-12T00:32:32Z'    <http://www.w3.org/2000/10/annotationType#Annotation>
<info:doi/10.1371/annotation/678>                                  '2007-06-12T00:32:32Z'    <http://www.w3.org/2000/10/annotation-ns#Annotation>
<info:doi/10.1371/annotation/679>                                  '2007-06-12T09:00:16Z'    <http://www.w3.org/2000/10/annotationType#Annotation>
<info:doi/10.1371/annotation/679>                                  '2007-06-12T09:00:16Z'    <http://www.w3.org/2000/10/annotation-ns#Annotation>
<info:doi/10.1371/annotation/689>                                  '2007-06-13T22:46:33Z'    <http://www.w3.org/2000/10/annotationType#Annotation>
<info:doi/10.1371/annotation/689>                                  '2007-06-13T22:46:33Z'    <http://www.w3.org/2000/10/annotation-ns#Annotation>
<info:doi/10.1371/annotation/699>                                  '2007-06-20T09:38:54Z'    <http://www.w3.org/2000/10/annotationType#Annotation>
<info:doi/10.1371/annotation/699>                                  '2007-06-20T09:38:54Z'    <http://www.w3.org/2000/10/annotation-ns#Annotation>
<info:doi/10.1371/annotation/704>                                  '2007-06-21T14:16:55Z'    <http://www.w3.org/2000/10/annotationType#Annotation>
<info:doi/10.1371/annotation/704>                                  '2007-06-21T14:16:55Z'    <http://www.w3.org/2000/10/annotation-ns#Annotation>
<info:doi/10.1371/annotation/710>                                  '2007-06-24T09:20:09Z'    <http://www.w3.org/2000/10/annotationType#Annotation>
<info:doi/10.1371/annotation/710>                                  '2007-06-24T09:20:09Z'    <http://www.w3.org/2000/10/annotation-ns#Annotation>
<info:doi/10.1371/annotation/727>                                  '2007-06-28T17:26:37Z'    <http://www.w3.org/2000/10/annotationType#Annotation>
<info:doi/10.1371/annotation/727>                                  '2007-06-28T17:26:37Z'    <http://www.w3.org/2000/10/annotation-ns#Annotation>
<info:doi/10.1371/annotation/747>                                  '2007-07-06T16:13:40Z'    <http://www.w3.org/2000/10/annotationType#Annotation>
<info:doi/10.1371/annotation/747>                                  '2007-07-06T16:13:40Z'    <http://www.w3.org/2000/10/annotation-ns#Annotation>
<info:doi/10.1371/annotation/68bb8db8-2e6c-489d-ba49-90960654f8cd> '2007-07-11T16:31:32.806' <http://www.w3.org/2000/10/annotation-ns#Annotation>
<info:doi/10.1371/annotation/68bb8db8-2e6c-489d-ba49-90960654f8cd> '2007-07-11T16:31:32.806' <topaz:RatingSummaryAnnotation>
<info:doi/10.1371/annotation/68b8f08c-7e0c-46b3-b2ab-54c0de19ad18> '2007-07-09T21:28:05.648' <http://www.w3.org/2000/10/annotation-ns#Annotation>
<info:doi/10.1371/annotation/68b8f08c-7e0c-46b3-b2ab-54c0de19ad18> '2007-07-09T21:28:05.648' <topaz:RatingsAnnotation>
<info:doi/10.1371/annotation/2518ed4a-2e6d-49a9-b242-86b5acca0eb8> '2007-07-10T00:20:52.141' <http://www.w3.org/2000/10/annotation-ns#Annotation>
<info:doi/10.1371/annotation/2518ed4a-2e6d-49a9-b242-86b5acca0eb8> '2007-07-10T00:20:52.141' <topaz:RatingsAnnotation>
<info:doi/10.1371/annotation/efc5d876-6e20-418c-81f3-7803e93c1f49> '2007-07-10T00:24:07.844' <http://www.w3.org/2000/10/annotation-ns#Annotation>
<info:doi/10.1371/annotation/efc5d876-6e20-418c-81f3-7803e93c1f49> '2007-07-10T00:24:07.844' <topaz:RatingsAnnotation>
<info:doi/10.1371/annotation/0aa465cd-b927-4d56-9041-b1e77f2ad412> '2007-07-10T09:46:22.961' <http://www.w3.org/2000/10/annotation-ns#Annotation>
<info:doi/10.1371/annotation/0aa465cd-b927-4d56-9041-b1e77f2ad412> '2007-07-10T09:46:22.961' <topaz:RatingsAnnotation>
<info:doi/10.1371/annotation/dec87698-5190-460a-9402-b28012119bbe> '2007-07-10T12:15:26.72'  <http://www.w3.org/2000/10/annotation-ns#Annotation>
<info:doi/10.1371/annotation/dec87698-5190-460a-9402-b28012119bbe> '2007-07-10T12:15:26.72'  <topaz:RatingsAnnotation>
<info:doi/10.1371/annotation/b45de1b9-56ae-43c6-a722-6a2b5da84bf3> '2007-07-11T08:29:06.324' <http://www.w3.org/2000/10/annotation-ns#Annotation>
<info:doi/10.1371/annotation/b45de1b9-56ae-43c6-a722-6a2b5da84bf3> '2007-07-11T08:29:06.324' <topaz:RatingsAnnotation>
<info:doi/10.1371/annotation/6570fffa-590d-4588-87df-9924b0eff953> '2007-07-11T16:31:32.806' <http://www.w3.org/2000/10/annotation-ns#Annotation>
<info:doi/10.1371/annotation/6570fffa-590d-4588-87df-9924b0eff953> '2007-07-11T16:31:32.806' <topaz:RatingsAnnotation>
<info:doi/10.1371/annotation/77584ef6-1a55-467d-9a33-0c7fcb45374c> '2007-07-11T18:54:52.588' <http://www.w3.org/2000/10/annotation-ns#Annotation>
<info:doi/10.1371/annotation/77584ef6-1a55-467d-9a33-0c7fcb45374c> '2007-07-11T18:54:52.588' <http://www.w3.org/2000/10/annotationType#Comment>
<info:doi/10.1371/annotation/45d474d7-9190-4c45-9e5c-5c9dc83d443a> '2007-07-11T23:16:55.285' <http://www.w3.org/2000/10/annotation-ns#Annotation>
<info:doi/10.1371/annotation/45d474d7-9190-4c45-9e5c-5c9dc83d443a> '2007-07-11T23:16:55.285' <http://www.w3.org/2000/10/annotationType#Comment>
58 rows
itql> select $date from <local:///topazproject#ri> where <info:doi/10.1371/annotation/747> <http://www.w3.org/2000/10/annotation-ns#created> $date;
select $date from <local:///topazproject#ri> where <info:doi/10.1371/annotation/747> <http://www.w3.org/2000/10/annotation-ns#created> $date;
<answer>
  <query>
    <variables>
      <date/>
    </variables>
    <solution>
      <date>
        2007-07-06T16:13:40Z
      </date>
    </solution>
  </query>
</answer>
itql> select $date from <local:///topazproject#ri> where <info:doi/10.1371/annotation/68bb8db8-2e6c-489d-ba49-90960654f8cd> <http://www.w3.org/2000/10/annotation-ns#created> $date;
select $date from <local:///topazproject#ri> where <info:doi/10.1371/annotation/68bb8db8-2e6c-489d-ba49-90960654f8cd> <http://www.w3.org/2000/10/annotation-ns#created> $date;
<answer>
  <query>
    <variables>
      <date/>
    </variables>
    <solution>
      <date datatype="http://www.w3.org/2001/XMLSchema#dateTime">
        2007-07-11T16:31:32.806
      </date>
    </solution>
  </query>
</answer>

So, somebody decided to get smart with dates for ratings and <topaz:ge> resolver is not working properly.

I'm not sure what the fix is for this at the moment. I can try a few things, but I'll probably ask others first.

Hm. Is there something to get you data now given ratings are a new thing? How about 3 queries:

  • (1) Do it without dates. This will give you a proper ratings + annotations total.
  • (2) Do it before the date you want. This will give you annotations before that date.
  • (1) - (2) should give you all the ratings plus any annotations after the date you used in (2). Note that I only use > and < in comparisons, not <= or >=, so keep that in mind.

Sorry it is so difficult.... just trying to help.

07/12/07 12:12:35 changed by ebrown

Actually, this is impacting both annotations and ratings created via the otm.

07/12/07 12:25:38 changed by ebrown

Don't waste your time on the hack I suggested. I think I have a solution.

07/12/07 12:39:43 changed by ebrown

  • status changed from reopened to closed.
  • resolution set to fixed.

(In [3164]) fixes #481 support <a:created> data model change with otm using <xsd:dateTime> instead of string

Migration script clearly needs to handle these types of things as well (re #70) - however these are on annotations, not ingested articles.

07/12/07 12:42:22 changed by ebrown

Okay, I've already copied head over to /home/topazdev. And it gives the following result which I think is accurate:

info:doi/10.1371/journal.pone.0000000 PLoS ONE Sandbox: A Place to Learn and Play webmaster@plos.org 10.0

08/07/07 16:25:51 changed by

  • milestone deleted.

Milestone Bugs deleted