Strange, it seems that Salesforce sends dates back in not just a single, but various formats. Usually we have seen the format "yyyy-MM-dd'T'HH:mm:ss.SSS" (Represented by SalesforceDataContext.SOQL_DATE_FORMAT_IN). In your case it seems it simply sent a date in the format yyyy-MM-dd. Do you happen to know what field this failed for, and what datatype it had? Maybe this is a simple case that we need to distinguish in a more detailed manner for e.g. DATE vs DATETIME vs TIMESTAMP types...
Anyways, the fix shouldn't be too hard. Simplest solution would be to simply make a "convertToDate(String)" method in SalesforceUtils and probe the incoming string to select a proper date format. 2013/8/1 Balendra Singh <[email protected]>: > While using metamodel in our project we found the following exception - > > In salesforce, if date value is provided then > SalesforceDataSet<http://eobjects.org/trac/wiki/SalesforceDataSet> is > throwing following exception while inserting this record to some other > database. > > *Stacktrace* > > Job execution FAILURE - Unable to parse date/time value: 2012-08-02 ( > IllegalStateException <http://eobjects.org/trac/wiki/IllegalStateException>) > - Exception stacktrace of failure condition: > java.lang.IllegalStateException<http://eobjects.org/trac/wiki/IllegalStateException>: > Unable to parse date/time value: 2012-08-02 at > org.eobjects.metamodel.salesforce.SalesforceDataSet<http://eobjects.org/trac/wiki/SalesforceDataSet>. > convert(SalesforceDataSet > <http://eobjects.org/trac/wiki/SalesforceDataSet>.java:119) > at > org.eobjects.metamodel.salesforce.SalesforceDataSet<http://eobjects.org/trac/wiki/SalesforceDataSet> > .getRow(SalesforceDataSet > <http://eobjects.org/trac/wiki/SalesforceDataSet>.java:98) > at org.eobjects.analyzer.job.runner. > RowProcessingPublisher<http://eobjects.org/trac/wiki/RowProcessingPublisher> > .processRows(RowProcessingPublisher<http://eobjects.org/trac/wiki/RowProcessingPublisher>.java:295) > at > org.eobjects.analyzer.job.tasks.RunRowProcessingPublisherTask?<http://eobjects.org/trac/wiki/RunRowProcessingPublisherTask> > .execute(RunRowProcessingPublisherTask?<http://eobjects.org/trac/wiki/RunRowProcessingPublisherTask> > .java:43) > > at > org.eobjects.analyzer.job.concurrent.TaskRunnable<http://eobjects.org/trac/wiki/TaskRunnable> > .run(TaskRunnable <http://eobjects.org/trac/wiki/TaskRunnable>.java:63) at > java.util.concurrent.ThreadPoolExecutor<http://eobjects.org/trac/wiki/ThreadPoolExecutor> > $Worker.runTask(ThreadPoolExecutor<http://eobjects.org/trac/wiki/ThreadPoolExecutor>.java:886) > at > java.util.concurrent.ThreadPoolExecutor<http://eobjects.org/trac/wiki/ThreadPoolExecutor> > $Worker.run(ThreadPoolExecutor?<http://eobjects.org/trac/wiki/ThreadPoolExecutor>.java:908) > at java.lang.Thread.run(Thread.java:662)
