Datahub ETL error at installation-The path for 'ISServerExec.exe' cannot be found.

Owned by Conor McCann
Last updated: Jun 24, 2020 by Daniel Stuart-KellyVersion comment
2 min read

Problem

Environment:
iQSonar 3.6r5
Windows 2008 server, with SQL 2012 Standard Edition SP3
Expected Behaviour:
datahub importer to import without error
Actual Behaviour:
Error message The path for 'ISServerExec.exe' cannot be found during deloy of ETLs
Repro:
We are installing the ETLS
No usable issue stored in the context, unable to resolve filename 'Deploy ETL 1.png'
Next
No usable issue stored in the context, unable to resolve filename 'Deploy ETL 2.png'
Next & Install
No usable issue stored in the context, unable to resolve filename 'Deploy ETL 3.png'
Full Error:

Error - [2016-12-05 11:44:52] Failed: The path for 'ISServerExec.exe' cannot be found. The operation will now exit.
A .NET Framework error occurred during execution of user-defined routine or aggregate "deploy_project_internal": 
System.Data.SqlClient.SqlException: The path for 'ISServerExec.exe' cannot be found. The operation will now exit.
System.Data.SqlClient.SqlException: 
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQuerySmi(Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.ExecuteToPipe(SmiContext pipeContext)
   at Microsoft.SqlServer.Server.SqlPipe.ExecuteAndSend(SqlCommand command)
   at Microsoft.SqlServer.IntegrationServices.Server.ServerConnectionControl.RaiseError(SysMessageId messageId, SysMessageSeverity severity, Object[] args)
   at Microsoft.SqlServer.IntegrationServices.Server.ServerApi.DeployProjectInternal(SqlInt64 deployId, SqlInt64 versionId, SqlInt64 projectId, SqlString projectName)
.

Troubleshooting
a)Checked the Sql server config manager was
No usable issue stored in the context, unable to resolve filename 'TS 1.png'
b)Checked regedit->HKEY_LOCAL_MACHINE->SOFTWARE and under Microsoft Sql Server in SSIS make sure that DTSPath is correct


Solution

  1. You will need SQL installation media.
  2. Removed integrated services via the SQL Server Installation Server - Reboot the server
  3. Removed integrated services via the SQL Server Installation Server.
  4. Run the iQDathub integrated installer.
  5. I now am able to install the ETL packages but get an error message saying ETL Packages