Hi
my firm payed to have the QlikSalesForce Connector .
but we are having difficulty using it and Qlik has no Troubleshooting Guide.
I can login to salesforce webpage via the same user name and password.
if I use the salesforceDLL.Dll I can login to salesforce but the tables I download are empty Go Figure.
if I use the QVSalesForceConnector.exe 64 the one we paid for. I enter the same user name and password. i leave the security token empty , use Bulk API. Leave Proxy empty. because in IE Proxy settings its empty also.
if i test the connection i get error
EventID Date and Time Username Severity Message
000000 2020-06-09T17:43:00.364+02:00 domain\User1 Error System.Net.WebException: The underlying connection was closed: An unexpected error occurred on a send. ---> System.IO.IOException: Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. ---> System.Net.Sockets.SocketException: An existing connection was forcibly closed by the remote host at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size) --- End of inner exception stack trace --- at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size) at System.Net.FixedSizeReader.ReadPacket(Byte[] buffer, Int32 offset, Int32 count) at System.Net.Security.SslState.StartReceiveBlob(Byte[] buffer, AsyncProtocolRequest asyncRequest) at System.Net.Security.SslState.CheckCompletionBeforeNextReceive(ProtocolToken message, AsyncProtocolRequest asyncRequest) at System.Net.Security.SslState.ForceAuthentication(Boolean receiveFirst, Byte[] buffer, AsyncProtocolRequest asyncRequest) at System.Net.Security.SslState.ProcessAuthentication(LazyAsyncResult lazyResult) at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Net.TlsStream.ProcessAuthentication(LazyAsyncResult result) at System.Net.TlsStream.Write(Byte[] buffer, Int32 offset, Int32 size) at System.Net.PooledStream.Write(Byte[] buffer, Int32 offset, Int32 size) at System.Net.ConnectStream.WriteHeaders(Boolean async) --- End of inner exception stack trace --- at Qlik.Connectors.SFDC.SOAPService.UnzippedHttpWebResponse..ctor(WebRequest request) at Qlik.Connectors.SFDC.SOAPService.SforceService.GetWebResponse(WebRequest request) at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) at Qlik.Connectors.SFDC.SOAPService.SforceService.login(String username, String password) at Qlik.Connectors.SFDC.Core.SfdcHelper.Login(String user, String password, String url) at Qlik.Connectors.SFDC.SFDCConnectorSourceConnection.Connect(Boolean testConnectOnly) at Qlik.Connectors.SFDC.SFDCConnectorSourceConnection.TestConnect(String& message, String& detailMessage)
