Index: lams_tool_daco/src/java/org/lamsfoundation/lams/tool/daco/dbupdates/Patch20161122.java =================================================================== diff -u -rfe70379f2d207e34ed00a5bf48d1a63165bf54f6 -r8e22f3560a35479be00d191525b7d58dabb8d94d --- lams_tool_daco/src/java/org/lamsfoundation/lams/tool/daco/dbupdates/Patch20161122.java (.../Patch20161122.java) (revision fe70379f2d207e34ed00a5bf48d1a63165bf54f6) +++ lams_tool_daco/src/java/org/lamsfoundation/lams/tool/daco/dbupdates/Patch20161122.java (.../Patch20161122.java) (revision 8e22f3560a35479be00d191525b7d58dabb8d94d) @@ -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));