[12:37:01.4867316] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_ALEGRIATELECOM_SP - Pedido: $1025067 - Cancelamento: $False - Devolucao: $False - Sem TFP: $True: System.InvalidOperationException: The source contains no DataRows. at System.Data.DataTableExtensions.LoadTableFromEnumerable[T](IEnumerable`1 source, DataTable table, Nullable`1 options, FillErrorEventHandler errorHandler) at System.Data.DataTableExtensions.CopyToDataTable[T](IEnumerable`1 source) at wsCaixa.Banco.IntegracaoCaixaTim.EnviaDadosTimCentralizado(SqlConnection Conn, SqlTransaction Tran, String stNomeBase, Int64 idPedido, Boolean blCancelamento, Boolean blDevolucao, Boolean blSomenteItensSemTFP) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 145 [13:27:33.0412542] [TradeIn/Authorize] Não foi possível realizar autenticação devido um erro generico!: System.Data.SqlClient.SqlException (0x80131904): A consulta parametrizada '(@id bigint,@token nvarchar(40),@tokenRefresh nvarchar(4000),@va' espera o parâmetro '@tokenRefresh', que não foi fornecido. 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.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.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at wsCaixa.Integracoes.TradeIn.SalvarConfiguracao(IEnumerable`1 configuracoes) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\TradeIn.cs:line 731 at wsCaixa.Integracoes.TradeIn.TradeInIntegracao.Authorize() in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\TradeIn.cs:line 842 ClientConnectionId:51dc8ec0-bceb-490c-a59e-4404b4d27084 Error Number:8178,State:1,Class:16 [13:27:48.4664797] [TradeIn/Authorize] Não foi possível realizar autenticação devido um erro generico!: System.Data.SqlClient.SqlException (0x80131904): A consulta parametrizada '(@id bigint,@token nvarchar(40),@tokenRefresh nvarchar(4000),@va' espera o parâmetro '@tokenRefresh', que não foi fornecido. 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.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.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at wsCaixa.Integracoes.TradeIn.SalvarConfiguracao(IEnumerable`1 configuracoes) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\TradeIn.cs:line 731 at wsCaixa.Integracoes.TradeIn.TradeInIntegracao.Authorize() in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\TradeIn.cs:line 842 ClientConnectionId:97c7b4d8-354b-4491-a947-d6277a3330f8 Error Number:8178,State:1,Class:16 [13:28:04.6696036] [TradeIn/Authorize] Não foi possível realizar autenticação devido um erro generico!: System.Data.SqlClient.SqlException (0x80131904): A consulta parametrizada '(@id bigint,@token nvarchar(40),@tokenRefresh nvarchar(4000),@va' espera o parâmetro '@tokenRefresh', que não foi fornecido. 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.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.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at wsCaixa.Integracoes.TradeIn.SalvarConfiguracao(IEnumerable`1 configuracoes) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\TradeIn.cs:line 731 at wsCaixa.Integracoes.TradeIn.TradeInIntegracao.Authorize() in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\TradeIn.cs:line 842 ClientConnectionId:a7e27ef2-5ad2-472e-81bd-34ae035e5c76 Error Number:8178,State:1,Class:16 [13:28:15.0926157] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":75691607,"dt_importado":"2025-07-14T13:04:08.87","nom_cliente":"antonio jose da silva ","ddd":0,"num_telefone":0,"num_documento":"28369947468","dt_servico":"2025-07-14T13:04:08.87","nom_plano":"","SerialId":113,"imei":null,"valor_aparelho":15.00,"val_entrada_dinh":15.00,"val_entrada_bol":null,"val_entrada_vouc":null,"val_entrada_pix":null,"val_entrada_deb":null,"cod_aut_1":null,"qtde_parc_1":null,"vl_cartao_credito_1":null,"cod_aut_2":null,"qtde_parc_2":null,"vl_cartao_credito_2":null,"sit_fidelizacao":false,"vl_desconto":"0.00","nom_tipo_negociacao":"","vl_pre_tabela":0.00,"dt_sellin":"2025-07-03T00:00:00","dt_sellout":"2025-07-14T00:00:00","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"16","num_dsf":"102830","sit_cliente_novo":true,"sit_aparelho_tim":false,"cod_tm":"","dt_operacao":"2025-07-14T13:28:11.61","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"97","custcode_nivel_75":"NE80_NEN04I_NE0819_NE003","Serial_Acessorio":"","ICCID":"89550288000006602909","Fidelizacao":"NÃO","item_juros":"NÃO","promo_aparelho_acessorio":false,"vl_boost_fabricante":0.00,"vl_tradein":null,"database_name":"DTS39_TIM_SOLTECH_PE","tipo":"Venda","idpedido_origem":97,"retorno_json":"[{\"cod_importacao\":75691607,\"imei\":null,\"num_telefone\":0,\"erro\":\"sem erro, importado com sucesso.\"}]"}]: System.Data.SqlClient.SqlException (0x80131904): É necessário declarar a variável escalar "@ServiceID". É necessário declarar a variável escalar "@ServiceId". 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.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.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at wsCaixa.Banco.IntegracaoCaixaTim.SalvarDadosTimCentralizado(SqlConnection conn, SqlTransaction tran, DataRow dados, String stJsonEnvio, RetornoIntegracaoTim retorno) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 252 ClientConnectionId:bb696fa4-8a7e-4701-9d27-65d90f554f3d Error Number:137,State:2,Class:15 [13:28:21.0457423] [TradeIn/Authorize] Não foi possível realizar autenticação devido um erro generico!: System.Data.SqlClient.SqlException (0x80131904): A consulta parametrizada '(@id bigint,@token nvarchar(40),@tokenRefresh nvarchar(4000),@va' espera o parâmetro '@tokenRefresh', que não foi fornecido. 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.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.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at wsCaixa.Integracoes.TradeIn.SalvarConfiguracao(IEnumerable`1 configuracoes) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\TradeIn.cs:line 731 at wsCaixa.Integracoes.TradeIn.TradeInIntegracao.Authorize() in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\TradeIn.cs:line 842 ClientConnectionId:a7e27ef2-5ad2-472e-81bd-34ae035e5c76 Error Number:8178,State:1,Class:16 [13:29:51.0752309] [TradeIn/Authorize] Não foi possível realizar autenticação devido um erro generico!: System.Data.SqlClient.SqlException (0x80131904): A consulta parametrizada '(@id bigint,@token nvarchar(40),@tokenRefresh nvarchar(4000),@va' espera o parâmetro '@tokenRefresh', que não foi fornecido. 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.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.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at wsCaixa.Integracoes.TradeIn.SalvarConfiguracao(IEnumerable`1 configuracoes) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\TradeIn.cs:line 731 at wsCaixa.Integracoes.TradeIn.TradeInIntegracao.Authorize() in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\TradeIn.cs:line 842 ClientConnectionId:8e787cc3-da5a-42ba-8e2b-6fb344e55759 Error Number:8178,State:1,Class:16 [13:36:07.8475346] [TradeIn/Authorize] Não foi possível realizar autenticação devido um erro generico!: System.Data.SqlClient.SqlException (0x80131904): A consulta parametrizada '(@id bigint,@token nvarchar(40),@tokenRefresh nvarchar(4000),@va' espera o parâmetro '@tokenRefresh', que não foi fornecido. 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.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.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at wsCaixa.Integracoes.TradeIn.SalvarConfiguracao(IEnumerable`1 configuracoes) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\TradeIn.cs:line 731 at wsCaixa.Integracoes.TradeIn.TradeInIntegracao.Authorize() in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\TradeIn.cs:line 842 ClientConnectionId:6a8d11bc-788f-4359-90c6-cfe52fecc3ec Error Number:8178,State:1,Class:16 [14:53:41.9908684] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":75692949,"dt_importado":"2025-07-14T13:04:08.87","nom_cliente":"antonio jose da silva ","ddd":0,"num_telefone":0,"num_documento":"28369947468","dt_servico":"2025-07-14T13:04:08.87","nom_plano":"","SerialId":113,"imei":null,"valor_aparelho":15.00,"val_entrada_dinh":15.00,"val_entrada_bol":null,"val_entrada_vouc":null,"val_entrada_pix":null,"val_entrada_deb":null,"cod_aut_1":null,"qtde_parc_1":null,"vl_cartao_credito_1":null,"cod_aut_2":null,"qtde_parc_2":null,"vl_cartao_credito_2":null,"sit_fidelizacao":false,"vl_desconto":"0.00","nom_tipo_negociacao":"","vl_pre_tabela":0.00,"dt_sellin":"2025-07-03T00:00:00","dt_sellout":"2025-07-14T00:00:00","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"16","num_dsf":"102830","sit_cliente_novo":true,"sit_aparelho_tim":false,"cod_tm":"","dt_operacao":"2025-07-14T14:53:38.107","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"97","custcode_nivel_75":"NE80_NEN04I_NE0819_NE003","Serial_Acessorio":"","ICCID":"89550288000006602909","Fidelizacao":"NÃO","item_juros":"NÃO","promo_aparelho_acessorio":false,"vl_boost_fabricante":0.00,"vl_tradein":null,"database_name":"DTS39_TIM_SOLTECH_PE","tipo":"Venda","idpedido_origem":97,"retorno_json":"[{\"cod_importacao\":75692949,\"imei\":null,\"num_telefone\":0,\"erro\":\"sem erro, importado com sucesso.\"}]"}]: System.Data.SqlClient.SqlException (0x80131904): É necessário declarar a variável escalar "@ServiceID". É necessário declarar a variável escalar "@ServiceId". 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.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.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at wsCaixa.Banco.IntegracaoCaixaTim.SalvarDadosTimCentralizado(SqlConnection conn, SqlTransaction tran, DataRow dados, String stJsonEnvio, RetornoIntegracaoTim retorno) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 252 ClientConnectionId:0da65cc3-12d4-4b89-9747-5c6a27a14a24 Error Number:137,State:2,Class:15 [15:03:18.9781585] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":75693117,"dt_importado":"2025-07-14T15:00:58.56","nom_cliente":"rogerio arthur de souza e silva","ddd":0,"num_telefone":0,"num_documento":"10765734443","dt_servico":"2025-07-14T15:00:58.56","nom_plano":"","SerialId":127,"imei":null,"valor_aparelho":15.00,"val_entrada_dinh":15.00,"val_entrada_bol":null,"val_entrada_vouc":null,"val_entrada_pix":null,"val_entrada_deb":null,"cod_aut_1":null,"qtde_parc_1":null,"vl_cartao_credito_1":null,"cod_aut_2":null,"qtde_parc_2":null,"vl_cartao_credito_2":null,"sit_fidelizacao":false,"vl_desconto":"0.00","nom_tipo_negociacao":"","vl_pre_tabela":0.00,"dt_sellin":"2025-07-03T00:00:00","dt_sellout":"2025-07-14T00:00:00","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"558777","num_dsf":"102830","sit_cliente_novo":true,"sit_aparelho_tim":false,"cod_tm":"","dt_operacao":"2025-07-14T15:03:15.623","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"99","custcode_nivel_75":"NE80_NEN04I_NE0819_NE003","Serial_Acessorio":"","ICCID":"89550288000006603048","Fidelizacao":"NÃO","item_juros":"NÃO","promo_aparelho_acessorio":false,"vl_boost_fabricante":0.00,"vl_tradein":null,"database_name":"DTS39_TIM_SOLTECH_PE","tipo":"Venda","idpedido_origem":99,"retorno_json":"[{\"cod_importacao\":75693117,\"imei\":null,\"num_telefone\":0,\"erro\":\"sem erro, importado com sucesso.\"}]"}]: System.Data.SqlClient.SqlException (0x80131904): É necessário declarar a variável escalar "@ServiceID". É necessário declarar a variável escalar "@ServiceId". 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.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.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at wsCaixa.Banco.IntegracaoCaixaTim.SalvarDadosTimCentralizado(SqlConnection conn, SqlTransaction tran, DataRow dados, String stJsonEnvio, RetornoIntegracaoTim retorno) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 252 ClientConnectionId:9386eaa2-92ff-4a21-8186-4d8e20db59c5 Error Number:137,State:2,Class:15