Index: lams_tool_daco/src/java/org/lamsfoundation/lams/tool/daco/dbupdates/Patch20161122.java =================================================================== RCS file: /usr/local/cvsroot/lams_tool_daco/src/java/org/lamsfoundation/lams/tool/daco/dbupdates/Attic/Patch20161122.java,v diff -u -r1.1.2.2 -r1.1.2.3 --- lams_tool_daco/src/java/org/lamsfoundation/lams/tool/daco/dbupdates/Patch20161122.java 26 Nov 2016 16:31:38 -0000 1.1.2.2 +++ lams_tool_daco/src/java/org/lamsfoundation/lams/tool/daco/dbupdates/Patch20161122.java 4 Dec 2016 17:41:25 -0000 1.1.2.3 @@ -29,6 +29,7 @@ import java.text.SimpleDateFormat; import java.util.Date; +import org.apache.commons.lang.StringUtils; import org.lamsfoundation.lams.tool.daco.DacoConstants; import com.tacitknowledge.util.migration.MigrationContext; @@ -67,7 +68,11 @@ if (readQuery.execute()) { ResultSet rs = readQuery.getResultSet(); while (rs.next()) { - Date date = OLD_DATE_FORMAT.parse(rs.getString(2)); + String answer = rs.getString(2); + if (StringUtils.isBlank(answer)) { + continue; + } + Date date = OLD_DATE_FORMAT.parse(answer); String newFormat = DacoConstants.DEFAULT_DATE_FORMAT.format(date); updateQuery.setString(1, newFormat); updateQuery.setLong(2, rs.getLong(1));