Support Portal

Welcome, Guest Login

Support Center

Microsoft SQL Server Agent Jobs may Fail due to Subsystem Path Inconsistency

Last Updated: Jul 18, 2017 11:00AM PDT

Applies to...

  • DxEnterprise 15.0
  • DxEnterprise 15.5
  • DxEnterprise 16.0
  • DxEnterprise 17.0 for Windows
  • DxConsole
  • Microsoft SQL Server

Summary

Microsoft SQL Server Agent jobs may fail due to path inconsistency within the MSDB subsystem table between cluster nodes.

Information

This problem is typically caused by installing Microsoft SQL Server Shared Components to different paths across the cluster members. So once an instance fails over to another node where the shared components were installed to an alternate location, the paths defined within the MSDB subsystem table are no longer valid for that node.

One common error you will see is the syspolicy_purge_history job failing because "PowerShell subsystem failed to load".

Resolution

The following script will update the usp_reset_subsystem_path stored procedure. You can download the script here (remove the .txt off of the end of the filename after downloading it):

https://clients.dh2i.com/Downloads/DxEnterprise/hotfix/usp_reset_subsystem/

You will need to run this script on each of your active instances. You will also need to replace the resetsubsystem.sql file in the DH2i bin directory on every node (%ProgramFiles%\DH2i\bin). This will ensure that any new instances that are virtualized will get the updated stored procedure automatically.

The instance subsystem table will be updated automatically on the next rehost or failover, but if you’d like to fix the subsystem table immediately on a given instance, then after deploying the update script you will need to execute the following:

EXEC master..usp_reset_subsystem_path

Contact Us

support.desk@dh2i.com
http://assets1.desk.com/
false
desk
Loading
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
about
false
Invalid characters found
/customer/en/portal/articles/autocomplete