CQ5.2.X: ValueFormatException in error.log

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

Download

 Adobe

Get help faster and easier

New user?

Adobe MAX 2024

Adobe MAX

The Creativity Conference

Oct 14–16 Miami Beach and online

Adobe MAX 2024

Adobe MAX

The Creativity Conference

Oct 14–16 Miami Beach and online