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

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]

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

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:
• 1420614 - How to use a Java Bean as a datasource for Crystal Reports.
• Java Bean Connectivity document for information on creating a Java Bean and connecting to it in Crystal Reports.
• 1217404 - How to pass a parameter value to a 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].

The Crystal Reports 2008 uses JDK1.6.xx.

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.

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