[10:39:56.0405510] [TradeIn/Authorize] Não foi possível se conectar à Dimo: [SecureChannelFailure:Continue]: wsCaixa.Utils.Net.HttpException: Ocorreu um erro ao tentar se comunicar com o servidor ---> System.Net.Http.HttpRequestException: An error occurred while sending the request. ---> System.Net.WebException: The request was aborted: Could not create SSL/TLS secure channel. at System.Net.HttpWebRequest.EndGetRequestStream(IAsyncResult asyncResult, TransportContext& context) at System.Net.Http.HttpClientHandler.GetRequestStreamCallback(IAsyncResult ar) --- End of inner exception stack trace --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at wsCaixa.Utils.Net.HttpLoggingHandler.d__1.MoveNext() in E:\jenkins\workspace\DATASYS WS CAIXA - QA\Extras\Net.cs:line 235 --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at wsCaixa.Utils.Net.Http.ReadResult[T](HttpRequestMessage request, Boolean direct, JsonSerializerSettings settings, HttpClient client) in E:\jenkins\workspace\DATASYS WS CAIXA - QA\Extras\Net.cs:line 116 --- End of inner exception stack trace --- at wsCaixa.Utils.Net.Http.ReadResult[T](HttpRequestMessage request, Boolean direct, JsonSerializerSettings settings, HttpClient client) in E:\jenkins\workspace\DATASYS WS CAIXA - QA\Extras\Net.cs:line 154 at wsCaixa.Integracoes.TradeIn.DimoFinanciamento.DimoAPI.GetToken(String url, DimoTokenRequest tokenRequest) in E:\jenkins\workspace\DATASYS WS CAIXA - QA\Banco\TradeIn.cs:line 1794 at wsCaixa.Integracoes.TradeIn.DimoFinanciamento.PopulateToken(Boolean onlyRefresh) in E:\jenkins\workspace\DATASYS WS CAIXA - QA\Banco\TradeIn.cs:line 1709 at wsCaixa.Integracoes.TradeIn.TradeInIntegracao.Authorize() in E:\jenkins\workspace\DATASYS WS CAIXA - QA\Banco\TradeIn.cs:line 1205 [10:43:13.6739641] [TradeIn/Authorize] Não foi possível se conectar à Dimo: [SecureChannelFailure:Continue]: wsCaixa.Utils.Net.HttpException: Ocorreu um erro ao tentar se comunicar com o servidor ---> System.Net.Http.HttpRequestException: An error occurred while sending the request. ---> System.Net.WebException: The request was aborted: Could not create SSL/TLS secure channel. at System.Net.HttpWebRequest.EndGetRequestStream(IAsyncResult asyncResult, TransportContext& context) at System.Net.Http.HttpClientHandler.GetRequestStreamCallback(IAsyncResult ar) --- End of inner exception stack trace --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at wsCaixa.Utils.Net.HttpLoggingHandler.d__1.MoveNext() in E:\jenkins\workspace\DATASYS WS CAIXA - QA\Extras\Net.cs:line 235 --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at wsCaixa.Utils.Net.Http.ReadResult[T](HttpRequestMessage request, Boolean direct, JsonSerializerSettings settings, HttpClient client) in E:\jenkins\workspace\DATASYS WS CAIXA - QA\Extras\Net.cs:line 116 --- End of inner exception stack trace --- at wsCaixa.Utils.Net.Http.ReadResult[T](HttpRequestMessage request, Boolean direct, JsonSerializerSettings settings, HttpClient client) in E:\jenkins\workspace\DATASYS WS CAIXA - QA\Extras\Net.cs:line 154 at wsCaixa.Integracoes.TradeIn.DimoFinanciamento.DimoAPI.GetToken(String url, DimoTokenRequest tokenRequest) in E:\jenkins\workspace\DATASYS WS CAIXA - QA\Banco\TradeIn.cs:line 1794 at wsCaixa.Integracoes.TradeIn.DimoFinanciamento.PopulateToken(Boolean onlyRefresh) in E:\jenkins\workspace\DATASYS WS CAIXA - QA\Banco\TradeIn.cs:line 1709 at wsCaixa.Integracoes.TradeIn.TradeInIntegracao.Authorize() in E:\jenkins\workspace\DATASYS WS CAIXA - QA\Banco\TradeIn.cs:line 1205 [10:46:01.4772763] [TradeIn/Authorize] Não foi possível se conectar à Dimo: [SecureChannelFailure:Continue]: wsCaixa.Utils.Net.HttpException: Ocorreu um erro ao tentar se comunicar com o servidor ---> System.Net.Http.HttpRequestException: An error occurred while sending the request. ---> System.Net.WebException: The request was aborted: Could not create SSL/TLS secure channel. at System.Net.HttpWebRequest.EndGetRequestStream(IAsyncResult asyncResult, TransportContext& context) at System.Net.Http.HttpClientHandler.GetRequestStreamCallback(IAsyncResult ar) --- End of inner exception stack trace --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at wsCaixa.Utils.Net.HttpLoggingHandler.d__1.MoveNext() in E:\jenkins\workspace\DATASYS WS CAIXA - QA\Extras\Net.cs:line 235 --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at wsCaixa.Utils.Net.Http.ReadResult[T](HttpRequestMessage request, Boolean direct, JsonSerializerSettings settings, HttpClient client) in E:\jenkins\workspace\DATASYS WS CAIXA - QA\Extras\Net.cs:line 116 --- End of inner exception stack trace --- at wsCaixa.Utils.Net.Http.ReadResult[T](HttpRequestMessage request, Boolean direct, JsonSerializerSettings settings, HttpClient client) in E:\jenkins\workspace\DATASYS WS CAIXA - QA\Extras\Net.cs:line 154 at wsCaixa.Integracoes.TradeIn.DimoFinanciamento.DimoAPI.GetToken(String url, DimoTokenRequest tokenRequest) in E:\jenkins\workspace\DATASYS WS CAIXA - QA\Banco\TradeIn.cs:line 1794 at wsCaixa.Integracoes.TradeIn.DimoFinanciamento.PopulateToken(Boolean onlyRefresh) in E:\jenkins\workspace\DATASYS WS CAIXA - QA\Banco\TradeIn.cs:line 1709 at wsCaixa.Integracoes.TradeIn.TradeInIntegracao.Authorize() in E:\jenkins\workspace\DATASYS WS CAIXA - QA\Banco\TradeIn.cs:line 1205 [10:46:17.6087545] [TradeIn/Authorize] Não foi possível se conectar à Dimo: [SecureChannelFailure:Continue]: wsCaixa.Utils.Net.HttpException: Ocorreu um erro ao tentar se comunicar com o servidor ---> System.Net.Http.HttpRequestException: An error occurred while sending the request. ---> System.Net.WebException: The request was aborted: Could not create SSL/TLS secure channel. at System.Net.HttpWebRequest.EndGetRequestStream(IAsyncResult asyncResult, TransportContext& context) at System.Net.Http.HttpClientHandler.GetRequestStreamCallback(IAsyncResult ar) --- End of inner exception stack trace --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at wsCaixa.Utils.Net.HttpLoggingHandler.d__1.MoveNext() in E:\jenkins\workspace\DATASYS WS CAIXA - QA\Extras\Net.cs:line 235 --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at wsCaixa.Utils.Net.Http.ReadResult[T](HttpRequestMessage request, Boolean direct, JsonSerializerSettings settings, HttpClient client) in E:\jenkins\workspace\DATASYS WS CAIXA - QA\Extras\Net.cs:line 116 --- End of inner exception stack trace --- at wsCaixa.Utils.Net.Http.ReadResult[T](HttpRequestMessage request, Boolean direct, JsonSerializerSettings settings, HttpClient client) in E:\jenkins\workspace\DATASYS WS CAIXA - QA\Extras\Net.cs:line 154 at wsCaixa.Integracoes.TradeIn.DimoFinanciamento.DimoAPI.GetToken(String url, DimoTokenRequest tokenRequest) in E:\jenkins\workspace\DATASYS WS CAIXA - QA\Banco\TradeIn.cs:line 1794 at wsCaixa.Integracoes.TradeIn.DimoFinanciamento.PopulateToken(Boolean onlyRefresh) in E:\jenkins\workspace\DATASYS WS CAIXA - QA\Banco\TradeIn.cs:line 1709 at wsCaixa.Integracoes.TradeIn.TradeInIntegracao.Authorize() in E:\jenkins\workspace\DATASYS WS CAIXA - QA\Banco\TradeIn.cs:line 1205 [10:46:25.0944071] [TradeIn/Authorize] Não foi possível se conectar à Dimo: [SecureChannelFailure:Continue]: wsCaixa.Utils.Net.HttpException: Ocorreu um erro ao tentar se comunicar com o servidor ---> System.Net.Http.HttpRequestException: An error occurred while sending the request. ---> System.Net.WebException: The request was aborted: Could not create SSL/TLS secure channel. at System.Net.HttpWebRequest.EndGetRequestStream(IAsyncResult asyncResult, TransportContext& context) at System.Net.Http.HttpClientHandler.GetRequestStreamCallback(IAsyncResult ar) --- End of inner exception stack trace --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at wsCaixa.Utils.Net.HttpLoggingHandler.d__1.MoveNext() in E:\jenkins\workspace\DATASYS WS CAIXA - QA\Extras\Net.cs:line 235 --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at wsCaixa.Utils.Net.Http.ReadResult[T](HttpRequestMessage request, Boolean direct, JsonSerializerSettings settings, HttpClient client) in E:\jenkins\workspace\DATASYS WS CAIXA - QA\Extras\Net.cs:line 116 --- End of inner exception stack trace --- at wsCaixa.Utils.Net.Http.ReadResult[T](HttpRequestMessage request, Boolean direct, JsonSerializerSettings settings, HttpClient client) in E:\jenkins\workspace\DATASYS WS CAIXA - QA\Extras\Net.cs:line 154 at wsCaixa.Integracoes.TradeIn.DimoFinanciamento.DimoAPI.GetToken(String url, DimoTokenRequest tokenRequest) in E:\jenkins\workspace\DATASYS WS CAIXA - QA\Banco\TradeIn.cs:line 1794 at wsCaixa.Integracoes.TradeIn.DimoFinanciamento.PopulateToken(Boolean onlyRefresh) in E:\jenkins\workspace\DATASYS WS CAIXA - QA\Banco\TradeIn.cs:line 1709 at wsCaixa.Integracoes.TradeIn.TradeInIntegracao.Authorize() in E:\jenkins\workspace\DATASYS WS CAIXA - QA\Banco\TradeIn.cs:line 1205 [10:46:32.6751007] [TradeIn/Authorize] Não foi possível se conectar à Dimo: [SecureChannelFailure:Continue]: wsCaixa.Utils.Net.HttpException: Ocorreu um erro ao tentar se comunicar com o servidor ---> System.Net.Http.HttpRequestException: An error occurred while sending the request. ---> System.Net.WebException: The request was aborted: Could not create SSL/TLS secure channel. at System.Net.HttpWebRequest.EndGetRequestStream(IAsyncResult asyncResult, TransportContext& context) at System.Net.Http.HttpClientHandler.GetRequestStreamCallback(IAsyncResult ar) --- End of inner exception stack trace --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at wsCaixa.Utils.Net.HttpLoggingHandler.d__1.MoveNext() in E:\jenkins\workspace\DATASYS WS CAIXA - QA\Extras\Net.cs:line 235 --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at wsCaixa.Utils.Net.Http.ReadResult[T](HttpRequestMessage request, Boolean direct, JsonSerializerSettings settings, HttpClient client) in E:\jenkins\workspace\DATASYS WS CAIXA - QA\Extras\Net.cs:line 116 --- End of inner exception stack trace --- at wsCaixa.Utils.Net.Http.ReadResult[T](HttpRequestMessage request, Boolean direct, JsonSerializerSettings settings, HttpClient client) in E:\jenkins\workspace\DATASYS WS CAIXA - QA\Extras\Net.cs:line 154 at wsCaixa.Integracoes.TradeIn.DimoFinanciamento.DimoAPI.GetToken(String url, DimoTokenRequest tokenRequest) in E:\jenkins\workspace\DATASYS WS CAIXA - QA\Banco\TradeIn.cs:line 1794 at wsCaixa.Integracoes.TradeIn.DimoFinanciamento.PopulateToken(Boolean onlyRefresh) in E:\jenkins\workspace\DATASYS WS CAIXA - QA\Banco\TradeIn.cs:line 1709 at wsCaixa.Integracoes.TradeIn.TradeInIntegracao.Authorize() in E:\jenkins\workspace\DATASYS WS CAIXA - QA\Banco\TradeIn.cs:line 1205 [10:46:41.3313019] [TradeIn/Authorize] Não foi possível se conectar à Dimo: [SecureChannelFailure:Continue]: wsCaixa.Utils.Net.HttpException: Ocorreu um erro ao tentar se comunicar com o servidor ---> System.Net.Http.HttpRequestException: An error occurred while sending the request. ---> System.Net.WebException: The request was aborted: Could not create SSL/TLS secure channel. at System.Net.HttpWebRequest.EndGetRequestStream(IAsyncResult asyncResult, TransportContext& context) at System.Net.Http.HttpClientHandler.GetRequestStreamCallback(IAsyncResult ar) --- End of inner exception stack trace --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at wsCaixa.Utils.Net.HttpLoggingHandler.d__1.MoveNext() in E:\jenkins\workspace\DATASYS WS CAIXA - QA\Extras\Net.cs:line 235 --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at wsCaixa.Utils.Net.Http.ReadResult[T](HttpRequestMessage request, Boolean direct, JsonSerializerSettings settings, HttpClient client) in E:\jenkins\workspace\DATASYS WS CAIXA - QA\Extras\Net.cs:line 116 --- End of inner exception stack trace --- at wsCaixa.Utils.Net.Http.ReadResult[T](HttpRequestMessage request, Boolean direct, JsonSerializerSettings settings, HttpClient client) in E:\jenkins\workspace\DATASYS WS CAIXA - QA\Extras\Net.cs:line 154 at wsCaixa.Integracoes.TradeIn.DimoFinanciamento.DimoAPI.GetToken(String url, DimoTokenRequest tokenRequest) in E:\jenkins\workspace\DATASYS WS CAIXA - QA\Banco\TradeIn.cs:line 1794 at wsCaixa.Integracoes.TradeIn.DimoFinanciamento.PopulateToken(Boolean onlyRefresh) in E:\jenkins\workspace\DATASYS WS CAIXA - QA\Banco\TradeIn.cs:line 1709 at wsCaixa.Integracoes.TradeIn.TradeInIntegracao.Authorize() in E:\jenkins\workspace\DATASYS WS CAIXA - QA\Banco\TradeIn.cs:line 1205 [10:46:49.2844383] [TradeIn/Authorize] Não foi possível se conectar à Dimo: [SecureChannelFailure:Continue]: wsCaixa.Utils.Net.HttpException: Ocorreu um erro ao tentar se comunicar com o servidor ---> System.Net.Http.HttpRequestException: An error occurred while sending the request. ---> System.Net.WebException: The request was aborted: Could not create SSL/TLS secure channel. at System.Net.HttpWebRequest.EndGetRequestStream(IAsyncResult asyncResult, TransportContext& context) at System.Net.Http.HttpClientHandler.GetRequestStreamCallback(IAsyncResult ar) --- End of inner exception stack trace --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at wsCaixa.Utils.Net.HttpLoggingHandler.d__1.MoveNext() in E:\jenkins\workspace\DATASYS WS CAIXA - QA\Extras\Net.cs:line 235 --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at wsCaixa.Utils.Net.Http.ReadResult[T](HttpRequestMessage request, Boolean direct, JsonSerializerSettings settings, HttpClient client) in E:\jenkins\workspace\DATASYS WS CAIXA - QA\Extras\Net.cs:line 116 --- End of inner exception stack trace --- at wsCaixa.Utils.Net.Http.ReadResult[T](HttpRequestMessage request, Boolean direct, JsonSerializerSettings settings, HttpClient client) in E:\jenkins\workspace\DATASYS WS CAIXA - QA\Extras\Net.cs:line 154 at wsCaixa.Integracoes.TradeIn.DimoFinanciamento.DimoAPI.GetToken(String url, DimoTokenRequest tokenRequest) in E:\jenkins\workspace\DATASYS WS CAIXA - QA\Banco\TradeIn.cs:line 1794 at wsCaixa.Integracoes.TradeIn.DimoFinanciamento.PopulateToken(Boolean onlyRefresh) in E:\jenkins\workspace\DATASYS WS CAIXA - QA\Banco\TradeIn.cs:line 1709 at wsCaixa.Integracoes.TradeIn.TradeInIntegracao.Authorize() in E:\jenkins\workspace\DATASYS WS CAIXA - QA\Banco\TradeIn.cs:line 1205 [10:58:24.7048802] [ConsultaVouchersCPF] DIMO: System.Data.SqlClient.SqlException (0x80131904): 'ifnull' não é um nome da função interna reconhecido. Sintaxe incorreta próxima a ')'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader() at wsCaixa.Integracoes.TradeIn.LerConteudo[T](SqlCommand cmd, Func`2 converter) in E:\jenkins\workspace\DATASYS WS CAIXA - QA\Banco\TradeIn.cs:line 587 at wsCaixa.Integracoes.TradeIn.ConsultaExistentesUsados(SqlConnection connection, IList`1 orders, Int64 idConfig, Boolean paraGerar) in E:\jenkins\workspace\DATASYS WS CAIXA - QA\Banco\TradeIn.cs:line 665 at wsCaixa.Integracoes.TradeIn.ConsultaVouchersCPF(String stDatabase, Int32 tbFiliais_Id, Nullable`1 idConfig, String cpf, Boolean gerar, Boolean registroAuto, Decimal valorTotalPedido, List`1 itensVenda) in E:\jenkins\workspace\DATASYS WS CAIXA - QA\Banco\TradeIn.cs:line 369 ClientConnectionId:e0182088-46d0-4273-b0f9-360072f7d905 Error Number:195,State:10,Class:15 [10:58:33.2831016] [ConsultaVouchersCPF] DIMO: System.Data.SqlClient.SqlException (0x80131904): 'ifnull' não é um nome da função interna reconhecido. Sintaxe incorreta próxima a ')'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader() at wsCaixa.Integracoes.TradeIn.LerConteudo[T](SqlCommand cmd, Func`2 converter) in E:\jenkins\workspace\DATASYS WS CAIXA - QA\Banco\TradeIn.cs:line 587 at wsCaixa.Integracoes.TradeIn.ConsultaExistentesUsados(SqlConnection connection, IList`1 orders, Int64 idConfig, Boolean paraGerar) in E:\jenkins\workspace\DATASYS WS CAIXA - QA\Banco\TradeIn.cs:line 665 at wsCaixa.Integracoes.TradeIn.ConsultaVouchersCPF(String stDatabase, Int32 tbFiliais_Id, Nullable`1 idConfig, String cpf, Boolean gerar, Boolean registroAuto, Decimal valorTotalPedido, List`1 itensVenda) in E:\jenkins\workspace\DATASYS WS CAIXA - QA\Banco\TradeIn.cs:line 369 ClientConnectionId:e0182088-46d0-4273-b0f9-360072f7d905 Error Number:195,State:10,Class:15 [10:58:41.9741237] [ConsultaVouchersCPF] DIMO: System.Data.SqlClient.SqlException (0x80131904): 'ifnull' não é um nome da função interna reconhecido. Sintaxe incorreta próxima a ')'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader() at wsCaixa.Integracoes.TradeIn.LerConteudo[T](SqlCommand cmd, Func`2 converter) in E:\jenkins\workspace\DATASYS WS CAIXA - QA\Banco\TradeIn.cs:line 587 at wsCaixa.Integracoes.TradeIn.ConsultaExistentesUsados(SqlConnection connection, IList`1 orders, Int64 idConfig, Boolean paraGerar) in E:\jenkins\workspace\DATASYS WS CAIXA - QA\Banco\TradeIn.cs:line 665 at wsCaixa.Integracoes.TradeIn.ConsultaVouchersCPF(String stDatabase, Int32 tbFiliais_Id, Nullable`1 idConfig, String cpf, Boolean gerar, Boolean registroAuto, Decimal valorTotalPedido, List`1 itensVenda) in E:\jenkins\workspace\DATASYS WS CAIXA - QA\Banco\TradeIn.cs:line 369 ClientConnectionId:e0182088-46d0-4273-b0f9-360072f7d905 Error Number:195,State:10,Class:15