SSIS scheduled processes fail after SP8 through load balancer

After applying SP8, SSIS scheduled jobs are failing with an error:

Error Code: 0  Error Source= Business process invoke step failed  Error Description: <html><head><title>Object moved</title></head><body>  <h2>Object moved to <a href="http://website/bbAppFx/BusinessProcessInvoke.ashx?DatabaseName=BBInfinity&BusinessProcessID=XXXXX&ParameterSetID=XXXXX&Culture=en-US&UICulture=en-US">here</a>.</h2>  </body></html>      Error on Line 32.  The step failed

Download and install the latest patch which contains all fixes from previous patches. If you are running an older version, download and install the latest version and then the patch. 

Workaround: Edit the SQL job in Management Studio and change the service URL on the BusinessProcessInvoke step to match the case of the Virtual Directory for BBAppFX. 

Steps to Duplicate

To duplicate, you must be:

  • on CRM SP8
  • have mixed-case virtual directories in IIS 
  • use a load balancer that handles SSL offloading 

Environment

 Blackbaud CRM
 4.0
 4.0
 4.0.163.34

Was this article helpful?