Alright, the problem (as stated in subject line) while activating site feature (in my case re-usable workflow) threw this error message.
Just opened up SharePoint Manager and look for the problem creating feature in site’s Web Feature list. Right click, Activate. Eureka! 🙂
Hope someone get help from this.