I don't have much experience with Expect.pm, but given what I've read above, your command is redirecting output to a file, and it seems that Expect is never seeing the prompt it's expecting because that's been redirected to the file.
my $exp = Expect->spawn("/usr/bin/python /opt/vtools/Scripts/reportcon
+solidator.py /opt/vtools/Healthcheck/$dDate > /opt/vtools/HealthRepor
+t.out") or die "Cannot spawn \n";
spawn id(3): Does `'
pattern #1: -re `Do you want to unpack these archive files for proce
+ssing? [Y/N]: '? No.