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

다운로드

이 작업에는 Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License의 라이센스가 부여되었습니다.  Twitter™ 및 Facebook 게시물은 Creative Commons 약관을 적용받지 않습니다.

법적 고지 사항   |   온라인 개인 정보 보호 정책