Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.
For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email firstname.lastname@example.org.
The newsletter subscription confirmation transactional email index was at “32”. When I modified in the database to change this index to “2”, then the issues is solved. I thought this index can be anything as we would use the template name when setting in configuration tab under newsletter section.