After analyzing what I found is, download code of Magento gives 404 not found code for the downloadable product with space in filename. After removing the space from filename and updating via above SQLs fixed my issue.