Unable to perform On-Demand function - An error occurred while making the HTTP request to https://AAAABBBBCCC.com/spotfire/ws/QueryManagerService. This could be due to the fact that the server certificate is not configured properly with HTTP.SYS in the HT

[Praveen Kumar Ramamoorthy]

Hi All, 

Does anyone face the below issue while performing the On-Demad? 

Error message: Could not read the selected data.

ImportException at Spotfire.Dxp.Data:
Failed to execute data query: An error occurred while making the HTTP request to https://AAAABBBBCCC.com/spotfire/ws/QueryManagerService. This could be due to the fact that the server certificate is not configured properly with HTTP.SYS in the HTTPS case. This could also be caused by a mismatch of the security binding between the client and the server. (HRESULT: 80131500)

Stack Trace:
   at Spotfire.Dxp.Data.DataFunctions.DataFunctionImpl.DataFunctionWorkItemState.ThrowIfExceptionOrInvalid()
   at Spotfire.Dxp.Data.AsyncImport.DataOnDemandLoadingView.<>c__DisplayClass2_0.<CreateFullView>b__0(BaseDataOnDemandImpl onDemand)
   at Spotfire.Dxp.Framework.DocumentModel.Snapshot`1.<>c__DisplayClass19_0.<ReadWithLimitationTarget>b__0()
   at Spotfire.Dxp.Framework.DocumentModel.ThreadTransactionInfo.EvaluateWithLimitationTarget(ILimitationTarget limitationTarget, Executor executor)
   at Spotfire.Dxp.Framework.DocumentModel.Snapshot`1.ReadWithLimitationTarget(ILimitationTarget limitationTarget, Action`1 action)
   at Spotfire.Dxp.Framework.DocumentModel.Snapshot`1.ReadWithGenerationSpan(Action`1 action, Action`1 invalidPropertyReadCallback)
   at Spotfire.Dxp.Framework.DocumentModel.Snapshot`1.Read(Action`1 action)
   at Spotfire.Dxp.Data.AsyncImport.DataOnDemandLoadingView.CreateFullView(Snapshot`1 onDemandSnapshot, PendingViewRequestsManager pendingViewRequestsManager)
   at Spotfire.Dxp.Framework.ApplicationModel.Progress.<>c__DisplayClass22_0.<Start>b__0()
   at Spotfire.Dxp.Framework.ApplicationModel.MonitorableProgress.Start[T](Func`1 action)
   at Spotfire.Dxp.Data.AsyncImport.BackgroundImportLoadingView.<>c__DisplayClass14_0.<StartLoading>b__2()

InformationModelException at Spotfire.Dxp.Data:
An error occurred while making the HTTP request to https://enterprisedevspotfire.wdc.com/spotfire/ws/QueryManagerService. This could be due to the fact that the server certificate is not configured properly with HTTP.SYS in the HTTPS case. This could also be caused by a mismatch of the security binding between the client and the server. (HRESULT: 80131500)

Stack Trace:
   at Spotfire.Dxp.Data.InformationModel.InternalInformationModelManager.OpenJob(InformationLinkElement informationLink, IList`1 parameters, Boolean isReferenced)
   at Spotfire.Dxp.Data.InformationModel.InternalInformationModelManager.<>c__DisplayClass64_0.<ExecuteInformationLink>b__0()
   at Spotfire.Dxp.Data.InformationModel.InternalInformationModelManager.ExecuteInformationLink(InformationLinkElement informationLink, IList`1 parameters, Boolean isReferenced, Boolean allowRetry)
   at Spotfire.Dxp.Data.Import.InformationLinkDataSourceConnection.ExecuteInformationLink()

InformationModelServiceException at Spotfire.Dxp.Services:
An error occurred while making the HTTP request to https://enterprisedevspotfire.wdc.com/spotfire/ws/QueryManagerService. This could be due to the fact that the server certificate is not configured properly with HTTP.SYS in the HTTPS case. This could also be caused by a mismatch of the security binding between the client and the server. (HRESULT: 80131509)

Stack Trace:
   at Spotfire.Dxp.Services.WcfSoapService`2.InvokeService[T](Func`1 serviceMethod, String customMethodNameForLogging)
   at Spotfire.Dxp.Data.InformationModel.InternalInformationModelManager.OpenJob(InformationLinkElement informationLink, IList`1 parameters, Boolean isReferenced)

CommunicationException at mscorlib:
An error occurred while making the HTTP request to https://enterprisedevspotfire.wdc.com/spotfire/ws/QueryManagerService. This could be due to the fact that the server certificate is not configured properly with HTTP.SYS in the HTTPS case. This could also be caused by a mismatch of the security binding between the client and the server. (HRESULT: 80131501)

Stack Trace:

Server stack trace: 
   at System.ServiceModel.Channels.HttpChannelUtilities.ProcessGetResponseWebException(WebException webException, HttpWebRequest request, HttpAbortReason abortReason)
   at System.ServiceModel.Channels.HttpChannelFactory`1.HttpRequestChannel.HttpChannelRequest.WaitForReply(TimeSpan timeout)
   at System.ServiceModel.Channels.RequestChannel.Request(Message message, TimeSpan timeout)
   at System.ServiceModel.Dispatcher.RequestChannelBinder.Request(Message message, TimeSpan timeout)
   at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout)
   at System.ServiceModel.Channels.ServiceChannelProxy.InvokeService(IMethodCallMessage methodCall, ProxyOperationRuntime operation)
   at System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message)

Exception rethrown at [0]: 
   at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
   at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
   at Spotfire.Dxp.Services.TssSoapServices.QueryManagerService.openJobEx(openJobEx request)
   at Spotfire.Dxp.Services.Data.InformationModel.QueryManagerService.<>c__DisplayClass5_0.<OpenJob>b__0()
   at Spotfire.Dxp.Services.WcfSoapService`2.InvokeService[T](Func`1 serviceMethod, String customMethodNameForLogging)

WebException at System:
The underlying connection was closed: An unexpected error occurred on a send. (HRESULT: 80131509)

Stack Trace:
   at System.Net.HttpWebRequest.GetResponse()
   at System.ServiceModel.Channels.HttpChannelFactory`1.HttpRequestChannel.HttpChannelRequest.WaitForReply(TimeSpan timeout)

IOException at System:
Unable to write data to the transport connection: An existing connection was forcibly closed by the remote host. (HRESULT: 80131620)

Stack Trace:
   at System.Net.Sockets.NetworkStream.MultipleWrite(BufferOffsetSize[] buffers)
   at System.Net.Security._SslStream.StartWriting(SplitWritesState splitWrite, SplitWriteAsyncProtocolRequest asyncRequest)
   at System.Net.Security._SslStream.ProcessWrite(BufferOffsetSize[] buffers, SplitWriteAsyncProtocolRequest asyncRequest)
   at System.Net.TlsStream.MultipleWrite(BufferOffsetSize[] buffers)
   at System.Net.Connection.Write(ScatterGatherBuffers writeBuffer)
   at System.Net.ConnectStream.ResubmitWrite(ConnectStream oldStream, Boolean suppressWrite)

SocketException at System:
An existing connection was forcibly closed by the remote host (HRESULT: 80004005)

Stack Trace:
   at System.Net.Sockets.Socket.MultipleSend(BufferOffsetSize[] buffers, SocketFlags socketFlags)
   at System.Net.Sockets.NetworkStream.MultipleWrite(BufferOffsetSize[] buffers)
 

[Niko Maresco]

hi Praveen,

i was looking through our support system for any other cases of this error and it appears you have an open ticket (02281634) for this issue. recommendation is to continue working with support with their suggested configuration changes.

for what it's worth, i did see other cases with a similar error, and it appears that increasing the batch size on the Data Source as Support suggested successfully resolved the issue.