Sintoma

Ocorria o erro demonstrado abaixo ao utilizar o campo Data Fiscal como filtro de pesquisa da nota fiscal detalhada referenciada, em ambiente SQL.

Server stack trace:

   em System.ServiceModel.Channels.ServiceChannel.ThrowIfFaultUnderstood(Message reply, MessageFault fault, String action, MessageVersion version, FaultConverter faultConverter)

   em System.ServiceModel.Channels.ServiceChannel.HandleReply(ProxyOperationRuntime operation, ProxyRpc& rpc)

   em System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout)

   em System.ServiceModel.Channels.ServiceChannelProxy.InvokeService(IMethodCallMessage methodCall, ProxyOperationRuntime operation)

   em System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message)

Exception rethrown at [0]:

   em Procwork.Software.Framework.Windows.Forms.Desktop.PWApplication.IsSessionException[T](Exception ex, Delegate doit, Object[] args)

   em Procwork.Software.Framework.Windows.Classes.Components.ClientRemoteConnection.Open()

   em Procwork.Software.Framework.Windows.Classes.Components.ClientRemoteConnection.Open(Boolean fillDefaultDataSet, String tableName)

   em Procwork.Software.Framework.Windows.Classes.Components.ClientRemoteConnection.Open(Boolean fillDefaultDataSet)

   em Procwork.Software.Basic.PUB.Windows.NFReferenciadaPUB.NFReferenciadaPUBView.btnPesquisa_Click(Object sender, EventArgs e) na c:\Sonda\201308\Main\SIT.BASIC\Modules\PUB\Clients\NFReferenciadaPUB\NFReferenciadaPUBView.cs:linha 94

   em System.Windows.Forms.Control.OnClick(EventArgs e)

   em Procwork.Software.Framework.Windows.Classes.Components.pwButton.OnClick(EventArgs e)

   em System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)

   em System.Windows.Forms.Control.WndProc(Message& m)

   em System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

Solução

Tratamento realizado na Tela Nota Fiscal Detalhada para que não ocorra erro ao associar a nota detalhada referenciada, utilizando o campo Data Fiscal como filtro de pesquisa, em ambiente SQL.

A seguir, apresenta-se um exemplo: