Symptoms

ValueFormatExceptions show up in the crx-quickstart/logs/error.log file for author and/or publish:

2009.12.04 14:41:50.388 *INFO* [172.18.238.198 [1259966510248] GET /foo/bar.html HTTP/1.1]
    org.apache.sling.jcr.resource.internal.helper.jcr.JcrNodeResource setMetaData:
      Problem extracting metadata information for /content/apps/myapp/jcr:content/par/test_0
      javax.jcr.ValueFormatException: conversion to long failed: For input string:
          "2009-08-24T14:02:57.793-07:00": For input string: "2009-08-24T14:02:57.793-07:00"
	at org.apache.jackrabbit.value.BaseValue.getLong(BaseValue.java:148)
	at org.apache.jackrabbit.core.PropertyImpl.getLong(PropertyImpl.java:486)
	at org.apache.sling.jcr.resource.internal.helper.jcr.JcrNodeResource.setMetaData(JcrNodeResource.java:230)
	at org.apache.sling.jcr.resource.internal.helper.jcr.JcrNodeResource.<init>(JcrNodeResource.java:70)
	at org.apache.sling.jcr.resource.internal.helper.jcr.JcrNodeResourceIterator.seek(JcrNodeResourceIterator.java:91)
	at org.apache.sling.jcr.resource.internal.helper.jcr.JcrNodeResourceIterator.next(JcrNodeResourceIterator.java:76)
	at org.apache.sling.jcr.resource.internal.helper.jcr.JcrNodeResourceIterator.next(JcrNodeResourceIterator.java:38)
	at org.apache.sling.jcr.resource.internal.helper.ResourceProviderEntry$1.seek(ResourceProviderEntry.java:184)
	at org.apache.sling.jcr.resource.internal.helper.ResourceProviderEntry$1.next(ResourceProviderEntry.java:167)
	at org.apache.sling.jcr.resource.internal.helper.ResourceProviderEntry$1.next(ResourceProviderEntry.java:126)
	at com.day.cq.wcm.foundation.ParagraphSystem.collectParagraphs(ParagraphSystem.java:217)
	at com.day.cq.wcm.foundation.ParagraphSystem.initParas(ParagraphSystem.java:197)
	at com.day.cq.wcm.foundation.ParagraphSystem.paragraphs(ParagraphSystem.java:155)
	at org.apache.jsp.apps.pc_005fglobal.components.pcparsys.pcparsys_jsp._jspService(pcparsys_jsp.java:191)
	at org.apache.sling.scripting.jsp.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
        ...

Resolution

  1. install CRX hotfix pack 1.4.2.5 or greater (request this hotfix via a daycare ticket)
  2. install CQ5.2.1 hotfix 24366 (request this hotfix via a daycare ticket)
  3. run the attached Date type cleanup script fix_date_props.zip
  • To run the cleanup script script
    1. Install this package to your instance fix_date_props.zip
    2. Log into the instance as admin (Note for publish, to log in as admin you must go to http://<host>:<port>/bin/login.html?resource=/, after logging in then you have to change the URL in the address bar as it will not confirm that you are logged in).
    3. run the script http://<host>:<port>/etc/fixjcrlastmodified/fix.html. It will list all of the paths containing jcr:lastModified and jcr:created properties that are String type and it will change them to Date type as it lists them.
    4. After successfully running the script then you may safely delete the script from your server via CRX Content explorer. Log into CRX explorer and delete /etc/fixjcrlastmodified

Applies to

CQ 5.2.X

Last ned

Dette produktet er lisensiert i henhold til Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License  Innlegg på Twitter™ og Facebook dekkes ikke av Creative Commons-vilkår.

Juridiske merknader   |   Regler for personvern på nettet