[08:58:14.0919341] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_ALEGRIATELECOM_SP - Pedido: $1018973 - 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
[09:00:00.1652336] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_ALEGRIATELECOM_SP - Pedido: $1017999 - 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
[09:01:40.4792478] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_ALEGRIATELECOM_SP - Pedido: $1016698 - 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
[10:11:31.6436285] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_ALEGRIATELECOM_SP - Pedido: $1019438 - 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
[10:13:27.5450656] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_ALEGRIATELECOM_SP - Pedido: $1016782 - 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
[10:14:49.1163587] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_ALEGRIATELECOM_SP - Pedido: $1019946 - 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
[10:18:20.5096525] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_ALEGRIATELECOM_SP - Pedido: $1016719 - 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
[10:37:28.0151955] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_ALEGRIATELECOM_SP - Pedido: $1011355 - 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
[10:39:27.9983622] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_ALEGRIATELECOM_SP - Pedido: $1013998 - 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
[10:40:28.2182126] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_ALEGRIATELECOM_SP - Pedido: $1013998 - 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
[10:41:14.8175815] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_ALEGRIATELECOM_SP - Pedido: $1015105 - 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
[10:42:42.5228796] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_ALEGRIATELECOM_SP - Pedido: $1015105 - 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
[10:47:17.3488030] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_ALEGRIATELECOM_SP - Pedido: $1015105 - 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
[10:55:04.5562429] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_ALEGRIATELECOM_SP - Pedido: $1011167 - 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
[11:06:38.5467097] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_ALEGRIATELECOM_SP - Pedido: $1011365 - 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
[12:44:37.6918819] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":75656620,"dt_importado":"2025-07-09T12:32:50.72","nom_cliente":"jose de castro feitosa sobrinho","ddd":0,"num_telefone":0,"num_documento":"08087533470","dt_servico":"2025-07-09T12:32:50.72","nom_plano":"","SerialId":160,"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-09T00:00:00","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"63","num_dsf":"102830","sit_cliente_novo":true,"sit_aparelho_tim":false,"cod_tm":"","dt_operacao":"2025-07-09T12:44:37.51","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"48","custcode_nivel_75":"NE80_NEN04I_NE0819_NE003","Serial_Acessorio":"","ICCID":"89550288000006603378","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":48,"retorno_json":"[{\"cod_importacao\":75656620,\"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:b14d3361-4b0f-4fde-8826-b92ca5d591e6
Error Number:137,State:2,Class:15
[17:31:49.0069134] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":75660391,"dt_importado":"2025-07-09T13:33:29.593","nom_cliente":"sergio roberto  freire da silva ","ddd":0,"num_telefone":0,"num_documento":"01070138436","dt_servico":"2025-07-09T13:33:29.593","nom_plano":"","SerialId":111,"imei":null,"valor_aparelho":15.00,"val_entrada_dinh":null,"val_entrada_bol":null,"val_entrada_vouc":null,"val_entrada_pix":null,"val_entrada_deb":null,"cod_aut_1":0,"qtde_parc_1":1,"vl_cartao_credito_1":15.00,"cod_aut_2":null,"qtde_parc_2":null,"vl_cartao_credito_2":null,"sit_fidelizacao":false,"vl_desconto":"0.00","nom_tipo_negociacao":"rebate","vl_pre_tabela":0.00,"dt_sellin":"2025-07-03T00:00:00","dt_sellout":"2025-07-09T00:00:00","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"67","num_dsf":"102830","sit_cliente_novo":true,"sit_aparelho_tim":false,"cod_tm":"","dt_operacao":"2025-07-09T17:31:47.267","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"50","custcode_nivel_75":"NE80_NEN04I_NE0819_NE003","Serial_Acessorio":"","ICCID":"89550288000006602883","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":50,"retorno_json":"[{\"cod_importacao\":75660391,\"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:5595a37d-cc06-4d65-8dc2-954055c42bf4
Error Number:137,State:2,Class:15
[19:23:53.0647438] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":75661581,"dt_importado":"2025-07-09T19:21:05.13","nom_cliente":"marcelo augusto pereira rodrigues ","ddd":0,"num_telefone":0,"num_documento":"02407177240","dt_servico":"2025-07-09T19:21:05.13","nom_plano":"","SerialId":159,"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-09T00:00:00","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"545","num_dsf":"102830","sit_cliente_novo":true,"sit_aparelho_tim":false,"cod_tm":"","dt_operacao":"2025-07-09T19:23:51.283","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"58","custcode_nivel_75":"NE80_NEN04I_NE0819_NE003","Serial_Acessorio":"","ICCID":"89550288000006603360","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":58,"retorno_json":"[{\"cod_importacao\":75661581,\"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:a48caf27-8fb7-4a70-9c4d-c2ee5b661246
Error Number:137,State:2,Class:15