It happened some how. The template was removed from the template folder and hence, the status was missing in SCVMM.
While trying to remove this template from SCVMM, Another error on dependent temporary template.
It says that this object is dependent on a temporary template. The easiest way to remove temporary template is using the below commandlet.
This will remove all temporary templates in one stretch !