Wednesday, May 14, 2014

oracle.stellent.ridc.protocol.ServiceException: Unable to retrieve search results. Unable to parse date

ISSUE:
oracle.stellent.ridc.protocol.ServiceException: Unable to retrieve search results. Unable to parse date '10/11/11 12:00 AM'.
     at oracle.stellent.ridc.protocol.ServiceResponse.getResponseAsBinder(ServiceResponse.java:135)
     at oracle.stellent.ridc.protocol.ServiceResponse.getResponseAsBinder(ServiceResponse.java:107)

Solution:
 
To resolve this issue we have to change date format to yyyy-MM-dd hh:mm:ss

 SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd hh:mm:ss");
String lastModifiedFromDate=sdf.format(lastDate);
            if (lastModifiedFromDate!= null) {
                if ("".equalsIgnoreCase(queryString))
                    queryString= queryString+ "xmodifiedDate>=`" + lastModifiedFromDate + "`";
                else
                    queryString =queryString + "<AND>" + "xmodifiedDate>=`" + lastModifiedFromDate +"`";
            }