KM: SPI for SQL Server generates "ERROR: Cannot set paths."

SPI for SQL Server monitoring SQL 2012 on Windows x64 managed node

Even though the SPI hotfix for SQL 2012 support has been installed already (https://softwaresupport.hp.com/group/softwaresupport/search-result/-/facetsearch/document/LID/QCCR1A135838), the SPI collector generates the following error:

# dbspicam.bat -v -dERROR:   Cannot set paths.

The following workaround fixed the issue

Change the %ovagentdir%\bin\instrumentation\dbspicam.bat script from:

…
244    if %DBSPI_SQL_VERSION% == "2000"  (
245       (set DBMSSEXE="dbspimss.exe") )
246    if %DBSPI_SQL_VERSION% == "2005"  (
247       (set DBMSSEXE="dbspims9.exe") )
248    if %DBSPI_SQL_VERSION% == "2008"  (
249       (set DBMSSEXE="dbspims9.exe") )
250
251    %DBMSSEXE% %PARM% %INCLUDE_OPTION% %MSSQL_SRV%
…
To:
…
244    if %DBSPI_SQL_VERSION% == "2000"  (
245       (set DBMSSEXE="dbspimss.exe") )
246    if %DBSPI_SQL_VERSION% == "2005"  (
247       (set DBMSSEXE="dbspims9.exe") )
248    if %DBSPI_SQL_VERSION% == "2008"  (
249       (set DBMSSEXE="dbspims9.exe") )  
250    if %DBSPI_SQL_VERSION% == "2012"  (
251       (set DBMSSEXE="dbspims9.exe") )
252 

253 %DBMSSEXE% %PARM% %INCLUDE_OPTION% %MSSQL_SRV%