1622714 - Error "java.lang.IllegalArgumentException:Timestamp format must be yyyy-mm-dd hh:mm:ss[.fffffffff]" occurs when using Crystal Reports to retrieve data from Java Bean

SAP Knowledge Base Article - Public

1622714 - Error "java.lang.IllegalArgumentException:Timestamp format must be yyyy-mm-dd hh:mm:ss[.fffffffff]" occurs when using Crystal Reports to retrieve data from Java Bean

Symptom

Error occurs when using Crystal Reports to retrieve data from Java Bean as:

Failed to retrieve data from the database.
Details: java.lang.IllegalArgumentException:Timestamp format must be yyyy-mm-dd hh:mm:ss[.fffffffff]

Environment

  • SAP BusinessObjects Crystal Reports (CR) 2008
  • Java Development Kit (JDK) 1.6.xx

Reproducing the Issue

  1. Follow the below SAP Knowledge Base Article (KBA) to create a Crystal reports which will use and pass a Timestamp type parameter to Java Bean data source:
  2. Refresh the CR document and pick up a value from the calendar to pass the parameter.
  3. Error occurs: Failed to retrieve data from the database. Details: java.lang.IllegalArgumentException:Timestamp format must be yyyy-mm-dd hh:mm:ss[.fffffffff].

Cause

The Crystal Reports 2008 uses JDK1.6.xx.

Resolution

Change the JDK to 1.5.xx in the CRConfig.xml.

  1. Edit {Crystal Reports 2008 Install Home}\Common\4.0\java\CRConfig.xml.
  2. Find tag named <JavaDir>.
  3. Change the value to JDK 1.5.xx path.

Keywords

CR,yyyy-mm-dd,hh:mm:ss,[.fffffffff] , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem

Product

Crystal Reports 2008 V0