TIBCO Spotfire Automation Services Server Errors - "The 'Spotfire .HanaAdapter' data connector is not available." as it cannot find DLL files for the HANA data connector, even if they exist

TIBCO Spotfire Automation Services Server Errors - "The 'Spotfire .HanaAdapter' data connector is not available." as it cannot find DLL files for the HANA data connector, even if they exist

TIBCO Spotfire Automation Services Server throwing the error - "The 'Spotfire .HanaAdapter' data connector is not available." as it is not able to find the SAP HANA connector .dll files even when the corresponding SAP HANA .dll files are present inside the Bin folder of TIBCO Automation Services installation directory.

Symptoms:
Inside TIBCO Spotfire Automation log file(Spotfire.Dxp.Automation.log), below error message is logged -

The 'Spotfire .HanaAdapter' data connector is not available.
Reason: The connector has not been deployed.

Cause:
Entry for SAP HANA connector is wrong or missing inside the Addins.xml File. Make sure below entry is present inside Addins.xml file (<Installation directory>\Automation Services\x.x\webroot\bin) on Automation Server Machine -

<AddIn FullTypeName="Spotfire.Dxp.Data.Adapters.Hana.HanaAddIn, Spotfire.Dxp.Data.Adapters.Hana.AddIn"/>