Dimension Automation Error

When trying to execute a dimension load in BPMConnect that is in a distributed server environment ( both an application server and a data server), you receive a BPC MakeDim error message that points to the event log on the server: 

Event Name: OnError Message: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Net.WebException: Unable to connect to the remote server ---> System.Net.Sockets.SocketException: No connection could be made because the target machine actively refused it 172.17.1.33:80 at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress) at System.Net.ServicePoint.ConnectSocketInternal(Boolean connectFailure, Socket s4, Socket s6, Socket& socket, IPAddress& address, ConnectSocketState state, IAsyncResult asyncResult, Int32 timeout, Exception& exception) --- End of inner exception stack trace --- at System.Net.HttpWebRequest.GetRequestStream(TransportContext& context) at System.Net.HttpWebRequest.GetRequestStream() at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) at ST_29ef108738db499f88a855e12f43f5d0.vbproj.BPC_APPSERVER.MbrProcessWrapper.ProcessDimensionSuccess(String AppSet, String Dimension) at ST_29ef108738db499f88a855e12f43f5d0.vbproj.ScriptMain.Main() 

The solution to this issue is to identify the SSIS Package Store on the app server in BPM Connect Config Builder: 

1. Open Config Builder 

2. Select Surface Area 

3. Select the "Advanced" link in the "Staging Environment" portion of the Surface Area. 

4. Select "Y" if the server environment is distributed. 

5. Enter the Server Name in the provided space 

6. Select the "Save" button.