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";
[download]

and

spawn id(3): Does `'
match:
  pattern #1: -re `Do you want to unpack these archive files for proce
+ssing? [Y/N]: '? No.
[download]