[16:53:30.5154094] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":77441352,"dt_importado":"2026-02-20T16:44:38.84","nom_cliente":"DEMANDA BBB","ddd":84,"num_telefone":998989898,"num_documento":"48108212855","dt_servico":"2026-02-20T16:44:38.84","nom_plano":"TIM BLACK","SerialId":380884,"imei":352283231091253,"valor_aparelho":769.00,"val_entrada_dinh":669.00,"val_entrada_bol":null,"val_entrada_vouc":100.00,"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":"530.00","nom_tipo_negociacao":"","vl_pre_tabela":1299.00,"dt_sellin":"2023-05-25T00:00:00","dt_sellout":null,"vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"","num_dsf":"46646","sit_cliente_novo":true,"sit_aparelho_tim":true,"cod_tm":"04015254","dt_operacao":"2026-02-20T16:54:24.273","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"306336","custcode_nivel_75":"RN20_MGBAII_PT2865_A013","Serial_Acessorio":"","ICCID":"","Fidelizacao":"NÃO","item_juros":"NÃO","promo_aparelho_acessorio":false,"vl_boost_fabricante":0.00,"vl_tradein":100.00,"SERVICE_ID":null,"database_name":"DTS39_TIM_FACELL_RN_QA","tipo":"Venda","idpedido_origem":306336,"retorno_json":"[{\"cod_importacao\":77441352,\"imei\":\"352283231091253\",\"num_telefone\":998989898,\"erro\":\"sem erro, importado com sucesso.\"}]"}]:
System.Data.SqlClient.SqlException (0x80131904): É necessário declarar a variável escalar "@NOME_CAMPANHA".
É necessário declarar a variável escalar "@NOME_CAMPANHA".
   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 WS CAIXA - QA\Banco\Integracoes.cs:line 261
ClientConnectionId:8b6cb549-2b09-489a-9fc5-94bc5f4bd072
Error Number:137,State:2,Class:15
[17:02:16.5873458] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":77441494,"dt_importado":"2026-02-20T16:44:38.84","nom_cliente":"DEMANDA BBB","ddd":84,"num_telefone":998989898,"num_documento":"48108212855","dt_servico":"2026-02-20T16:44:38.84","nom_plano":"TIM BLACK","SerialId":380884,"imei":352283231091253,"valor_aparelho":769.00,"val_entrada_dinh":669.00,"val_entrada_bol":null,"val_entrada_vouc":100.00,"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":"530.00","nom_tipo_negociacao":"","vl_pre_tabela":1299.00,"dt_sellin":"2023-05-25T00:00:00","dt_sellout":null,"vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"","num_dsf":"46646","sit_cliente_novo":true,"sit_aparelho_tim":true,"cod_tm":"04015254","dt_operacao":"2026-02-20T17:03:10.563","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"306336","custcode_nivel_75":"RN20_MGBAII_PT2865_A013","Serial_Acessorio":"","ICCID":"","Fidelizacao":"NÃO","item_juros":"NÃO","promo_aparelho_acessorio":false,"vl_boost_fabricante":0.00,"vl_tradein":100.00,"SERVICE_ID":null,"database_name":"DTS39_TIM_FACELL_RN_QA","tipo":"Venda","idpedido_origem":306336,"retorno_json":"[{\"cod_importacao\":77441494,\"imei\":\"352283231091253\",\"num_telefone\":998989898,\"erro\":\"sem erro, importado com sucesso.\"}]"}]:
System.Data.SqlClient.SqlException (0x80131904): É necessário declarar a variável escalar "@NOME_CAMPANHA".
É necessário declarar a variável escalar "@NOME_CAMPANHA".
   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 WS CAIXA - QA\Banco\Integracoes.cs:line 261
ClientConnectionId:8b6cb549-2b09-489a-9fc5-94bc5f4bd072
Error Number:137,State:2,Class:15
[17:03:52.0036152] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":77441516,"dt_importado":"2026-02-20T16:44:38.84","nom_cliente":"DEMANDA BBB","ddd":84,"num_telefone":998989898,"num_documento":"48108212855","dt_servico":"2026-02-20T16:44:38.84","nom_plano":"TIM BLACK","SerialId":380884,"imei":352283231091253,"valor_aparelho":769.00,"val_entrada_dinh":669.00,"val_entrada_bol":null,"val_entrada_vouc":100.00,"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":"530.00","nom_tipo_negociacao":"","vl_pre_tabela":1299.00,"dt_sellin":"2023-05-25T00:00:00","dt_sellout":null,"vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"","num_dsf":"46646","sit_cliente_novo":true,"sit_aparelho_tim":true,"cod_tm":"04015254","dt_operacao":"2026-02-20T17:04:46.03","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"306336","custcode_nivel_75":"RN20_MGBAII_PT2865_A013","Serial_Acessorio":"","ICCID":"","Fidelizacao":"NÃO","item_juros":"NÃO","promo_aparelho_acessorio":false,"vl_boost_fabricante":0.00,"vl_tradein":100.00,"SERVICE_ID":null,"database_name":"DTS39_TIM_FACELL_RN_QA","tipo":"Venda","idpedido_origem":306336,"retorno_json":"[{\"cod_importacao\":77441516,\"imei\":\"352283231091253\",\"num_telefone\":998989898,\"erro\":\"sem erro, importado com sucesso.\"}]"}]:
System.Data.SqlClient.SqlException (0x80131904): É necessário declarar a variável escalar "@NOME_CAMPANHA".
É necessário declarar a variável escalar "@NOME_CAMPANHA".
   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 WS CAIXA - QA\Banco\Integracoes.cs:line 261
ClientConnectionId:50d543f6-0da5-4a95-aba9-8ef62644b1d0
Error Number:137,State:2,Class:15
[17:04:24.0202018] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":77441524,"dt_importado":"2026-02-20T16:44:38.84","nom_cliente":"DEMANDA BBB","ddd":84,"num_telefone":998989898,"num_documento":"48108212855","dt_servico":"2026-02-20T16:44:38.84","nom_plano":"TIM BLACK","SerialId":380884,"imei":352283231091253,"valor_aparelho":769.00,"val_entrada_dinh":669.00,"val_entrada_bol":null,"val_entrada_vouc":100.00,"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":"530.00","nom_tipo_negociacao":"","vl_pre_tabela":1299.00,"dt_sellin":"2023-05-25T00:00:00","dt_sellout":null,"vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"","num_dsf":"46646","sit_cliente_novo":true,"sit_aparelho_tim":true,"cod_tm":"04015254","dt_operacao":"2026-02-20T17:05:18.027","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"306336","custcode_nivel_75":"RN20_MGBAII_PT2865_A013","Serial_Acessorio":"","ICCID":"","Fidelizacao":"NÃO","item_juros":"NÃO","promo_aparelho_acessorio":false,"vl_boost_fabricante":0.00,"vl_tradein":100.00,"SERVICE_ID":null,"database_name":"DTS39_TIM_FACELL_RN_QA","tipo":"Venda","idpedido_origem":306336,"retorno_json":"[{\"cod_importacao\":77441524,\"imei\":\"352283231091253\",\"num_telefone\":998989898,\"erro\":\"sem erro, importado com sucesso.\"}]"}]:
System.Data.SqlClient.SqlException (0x80131904): É necessário declarar a variável escalar "@NOME_CAMPANHA".
É necessário declarar a variável escalar "@NOME_CAMPANHA".
   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 WS CAIXA - QA\Banco\Integracoes.cs:line 261
ClientConnectionId:50d543f6-0da5-4a95-aba9-8ef62644b1d0
Error Number:137,State:2,Class:15
[17:04:42.9890093] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":77441526,"dt_importado":"2026-02-20T16:44:38.84","nom_cliente":"DEMANDA BBB","ddd":84,"num_telefone":998989898,"num_documento":"48108212855","dt_servico":"2026-02-20T16:44:38.84","nom_plano":"TIM BLACK","SerialId":380884,"imei":352283231091253,"valor_aparelho":769.00,"val_entrada_dinh":669.00,"val_entrada_bol":null,"val_entrada_vouc":100.00,"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":"530.00","nom_tipo_negociacao":"","vl_pre_tabela":1299.00,"dt_sellin":"2023-05-25T00:00:00","dt_sellout":null,"vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"","num_dsf":"46646","sit_cliente_novo":true,"sit_aparelho_tim":true,"cod_tm":"04015254","dt_operacao":"2026-02-20T17:05:36.983","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"306336","custcode_nivel_75":"RN20_MGBAII_PT2865_A013","Serial_Acessorio":"","ICCID":"","Fidelizacao":"NÃO","item_juros":"NÃO","promo_aparelho_acessorio":false,"vl_boost_fabricante":0.00,"vl_tradein":100.00,"SERVICE_ID":null,"database_name":"DTS39_TIM_FACELL_RN_QA","tipo":"Venda","idpedido_origem":306336,"retorno_json":"[{\"cod_importacao\":77441526,\"imei\":\"352283231091253\",\"num_telefone\":998989898,\"erro\":\"sem erro, importado com sucesso.\"}]"}]:
System.Data.SqlClient.SqlException (0x80131904): É necessário declarar a variável escalar "@NOME_CAMPANHA".
É necessário declarar a variável escalar "@NOME_CAMPANHA".
   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 WS CAIXA - QA\Banco\Integracoes.cs:line 261
ClientConnectionId:50d543f6-0da5-4a95-aba9-8ef62644b1d0
Error Number:137,State:2,Class:15
[17:04:58.5046066] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":77441531,"dt_importado":"2026-02-20T16:44:38.84","nom_cliente":"DEMANDA BBB","ddd":84,"num_telefone":998989898,"num_documento":"48108212855","dt_servico":"2026-02-20T16:44:38.84","nom_plano":"TIM BLACK","SerialId":380884,"imei":352283231091253,"valor_aparelho":769.00,"val_entrada_dinh":669.00,"val_entrada_bol":null,"val_entrada_vouc":100.00,"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":"530.00","nom_tipo_negociacao":"","vl_pre_tabela":1299.00,"dt_sellin":"2023-05-25T00:00:00","dt_sellout":null,"vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"","num_dsf":"46646","sit_cliente_novo":true,"sit_aparelho_tim":true,"cod_tm":"04015254","dt_operacao":"2026-02-20T17:05:52.517","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"306336","custcode_nivel_75":"RN20_MGBAII_PT2865_A013","Serial_Acessorio":"","ICCID":"","Fidelizacao":"NÃO","item_juros":"NÃO","promo_aparelho_acessorio":false,"vl_boost_fabricante":0.00,"vl_tradein":100.00,"SERVICE_ID":null,"database_name":"DTS39_TIM_FACELL_RN_QA","tipo":"Venda","idpedido_origem":306336,"retorno_json":"[{\"cod_importacao\":77441531,\"imei\":\"352283231091253\",\"num_telefone\":998989898,\"erro\":\"sem erro, importado com sucesso.\"}]"}]:
System.Data.SqlClient.SqlException (0x80131904): É necessário declarar a variável escalar "@NOME_CAMPANHA".
É necessário declarar a variável escalar "@NOME_CAMPANHA".
   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 WS CAIXA - QA\Banco\Integracoes.cs:line 261
ClientConnectionId:50d543f6-0da5-4a95-aba9-8ef62644b1d0
Error Number:137,State:2,Class:15
[17:05:12.7239101] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":77441535,"dt_importado":"2026-02-20T16:44:38.84","nom_cliente":"DEMANDA BBB","ddd":84,"num_telefone":998989898,"num_documento":"48108212855","dt_servico":"2026-02-20T16:44:38.84","nom_plano":"TIM BLACK","SerialId":380884,"imei":352283231091253,"valor_aparelho":769.00,"val_entrada_dinh":669.00,"val_entrada_bol":null,"val_entrada_vouc":100.00,"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":"530.00","nom_tipo_negociacao":"","vl_pre_tabela":1299.00,"dt_sellin":"2023-05-25T00:00:00","dt_sellout":null,"vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"","num_dsf":"46646","sit_cliente_novo":true,"sit_aparelho_tim":true,"cod_tm":"04015254","dt_operacao":"2026-02-20T17:06:06.72","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"306336","custcode_nivel_75":"RN20_MGBAII_PT2865_A013","Serial_Acessorio":"","ICCID":"","Fidelizacao":"NÃO","item_juros":"NÃO","promo_aparelho_acessorio":false,"vl_boost_fabricante":0.00,"vl_tradein":100.00,"SERVICE_ID":null,"database_name":"DTS39_TIM_FACELL_RN_QA","tipo":"Venda","idpedido_origem":306336,"retorno_json":"[{\"cod_importacao\":77441535,\"imei\":\"352283231091253\",\"num_telefone\":998989898,\"erro\":\"sem erro, importado com sucesso.\"}]"}]:
System.Data.SqlClient.SqlException (0x80131904): É necessário declarar a variável escalar "@NOME_CAMPANHA".
É necessário declarar a variável escalar "@NOME_CAMPANHA".
   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 WS CAIXA - QA\Banco\Integracoes.cs:line 261
ClientConnectionId:50d543f6-0da5-4a95-aba9-8ef62644b1d0
Error Number:137,State:2,Class:15
[17:05:25.8354533] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":77441537,"dt_importado":"2026-02-20T16:44:38.84","nom_cliente":"DEMANDA BBB","ddd":84,"num_telefone":998989898,"num_documento":"48108212855","dt_servico":"2026-02-20T16:44:38.84","nom_plano":"TIM BLACK","SerialId":380884,"imei":352283231091253,"valor_aparelho":769.00,"val_entrada_dinh":669.00,"val_entrada_bol":null,"val_entrada_vouc":100.00,"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":"530.00","nom_tipo_negociacao":"","vl_pre_tabela":1299.00,"dt_sellin":"2023-05-25T00:00:00","dt_sellout":null,"vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"","num_dsf":"46646","sit_cliente_novo":true,"sit_aparelho_tim":true,"cod_tm":"04015254","dt_operacao":"2026-02-20T17:06:19.83","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"306336","custcode_nivel_75":"RN20_MGBAII_PT2865_A013","Serial_Acessorio":"","ICCID":"","Fidelizacao":"NÃO","item_juros":"NÃO","promo_aparelho_acessorio":false,"vl_boost_fabricante":0.00,"vl_tradein":100.00,"SERVICE_ID":null,"database_name":"DTS39_TIM_FACELL_RN_QA","tipo":"Venda","idpedido_origem":306336,"retorno_json":"[{\"cod_importacao\":77441537,\"imei\":\"352283231091253\",\"num_telefone\":998989898,\"erro\":\"sem erro, importado com sucesso.\"}]"}]:
System.Data.SqlClient.SqlException (0x80131904): É necessário declarar a variável escalar "@NOME_CAMPANHA".
É necessário declarar a variável escalar "@NOME_CAMPANHA".
   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 WS CAIXA - QA\Banco\Integracoes.cs:line 261
ClientConnectionId:50d543f6-0da5-4a95-aba9-8ef62644b1d0
Error Number:137,State:2,Class:15
[17:06:12.1458390] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":77441552,"dt_importado":"2026-02-20T16:44:38.84","nom_cliente":"DEMANDA BBB","ddd":84,"num_telefone":998989898,"num_documento":"48108212855","dt_servico":"2026-02-20T16:44:38.84","nom_plano":"TIM BLACK","SerialId":380884,"imei":352283231091253,"valor_aparelho":769.00,"val_entrada_dinh":669.00,"val_entrada_bol":null,"val_entrada_vouc":100.00,"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":"530.00","nom_tipo_negociacao":"","vl_pre_tabela":1299.00,"dt_sellin":"2023-05-25T00:00:00","dt_sellout":null,"vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"","num_dsf":"46646","sit_cliente_novo":true,"sit_aparelho_tim":true,"cod_tm":"04015254","dt_operacao":"2026-02-20T17:07:06.147","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"306336","custcode_nivel_75":"RN20_MGBAII_PT2865_A013","Serial_Acessorio":"","ICCID":"","Fidelizacao":"NÃO","item_juros":"NÃO","promo_aparelho_acessorio":false,"vl_boost_fabricante":0.00,"vl_tradein":100.00,"SERVICE_ID":null,"database_name":"DTS39_TIM_FACELL_RN_QA","tipo":"Venda","idpedido_origem":306336,"retorno_json":"[{\"cod_importacao\":77441552,\"imei\":\"352283231091253\",\"num_telefone\":998989898,\"erro\":\"sem erro, importado com sucesso.\"}]"}]:
System.Data.SqlClient.SqlException (0x80131904): É necessário declarar a variável escalar "@NOME_CAMPANHA".
É necessário declarar a variável escalar "@NOME_CAMPANHA".
   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 WS CAIXA - QA\Banco\Integracoes.cs:line 261
ClientConnectionId:50d543f6-0da5-4a95-aba9-8ef62644b1d0
Error Number:137,State:2,Class:15
[17:09:40.3192815] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":77441622,"dt_importado":"2026-02-20T16:44:38.84","nom_cliente":"DEMANDA BBB","ddd":84,"num_telefone":998989898,"num_documento":"48108212855","dt_servico":"2026-02-20T16:44:38.84","nom_plano":"TIM BLACK","SerialId":380884,"imei":352283231091253,"valor_aparelho":769.00,"val_entrada_dinh":669.00,"val_entrada_bol":null,"val_entrada_vouc":100.00,"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":"530.00","nom_tipo_negociacao":"","vl_pre_tabela":1299.00,"dt_sellin":"2023-05-25T00:00:00","dt_sellout":"2026-02-20T17:09:16","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"24260207366109000196550000000002421009218711","num_dsf":"46646","sit_cliente_novo":true,"sit_aparelho_tim":true,"cod_tm":"04015254","dt_operacao":"2026-02-20T17:10:34.247","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"306336","custcode_nivel_75":"RN20_MGBAII_PT2865_A013","Serial_Acessorio":"","ICCID":"","Fidelizacao":"NÃO","item_juros":"NÃO","promo_aparelho_acessorio":false,"vl_boost_fabricante":0.00,"vl_tradein":100.00,"SERVICE_ID":null,"database_name":"DTS39_TIM_FACELL_RN_QA","tipo":"Venda","idpedido_origem":306336,"retorno_json":"[{\"cod_importacao\":77441622,\"imei\":\"352283231091253\",\"num_telefone\":998989898,\"erro\":\"sem erro, importado com sucesso.\"}]"}]:
System.Data.SqlClient.SqlException (0x80131904): É necessário declarar a variável escalar "@NOME_CAMPANHA".
É necessário declarar a variável escalar "@NOME_CAMPANHA".
   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 WS CAIXA - QA\Banco\Integracoes.cs:line 261
ClientConnectionId:50d543f6-0da5-4a95-aba9-8ef62644b1d0
Error Number:137,State:2,Class:15
[17:23:20.2635467] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":77441855,"dt_importado":"2026-02-20T17:22:18.467","nom_cliente":"SQUAD POS SMB","ddd":84,"num_telefone":998998989,"num_documento":"28631809241","dt_servico":"2026-02-20T17:22:18.467","nom_plano":"TIM PRÉ TOP","SerialId":384570,"imei":358958552611207,"valor_aparelho":927.00,"val_entrada_dinh":827.00,"val_entrada_bol":null,"val_entrada_vouc":100.00,"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":927.00,"dt_sellin":"2024-04-04T00:00:00","dt_sellout":null,"vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"","num_dsf":"46646","sit_cliente_novo":true,"sit_aparelho_tim":true,"cod_tm":"04016081","dt_operacao":"2026-02-20T17:24:14.17","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"306338","custcode_nivel_75":"RN20_MGBAII_PT2865_A013","Serial_Acessorio":"","ICCID":"","Fidelizacao":"NÃO","item_juros":"NÃO","promo_aparelho_acessorio":false,"vl_boost_fabricante":0.00,"vl_tradein":100.00,"SERVICE_ID":null,"database_name":"DTS39_TIM_FACELL_RN_QA","tipo":"Venda","idpedido_origem":306338,"retorno_json":"[{\"cod_importacao\":77441855,\"imei\":\"358958552611207\",\"num_telefone\":998998989,\"erro\":\"sem erro, importado com sucesso.\"}]"}]:
System.Data.SqlClient.SqlException (0x80131904): É necessário declarar a variável escalar "@NOME_CAMPANHA".
É necessário declarar a variável escalar "@NOME_CAMPANHA".
   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 WS CAIXA - QA\Banco\Integracoes.cs:line 261
ClientConnectionId:555530ce-9019-4197-8325-3c4c3df70fbf
Error Number:137,State:2,Class:15
[17:23:49.5136897] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":77441867,"dt_importado":"2026-02-20T17:22:18.467","nom_cliente":"SQUAD POS SMB","ddd":84,"num_telefone":998998989,"num_documento":"28631809241","dt_servico":"2026-02-20T17:22:18.467","nom_plano":"TIM PRÉ TOP","SerialId":384570,"imei":358958552611207,"valor_aparelho":927.00,"val_entrada_dinh":827.00,"val_entrada_bol":null,"val_entrada_vouc":100.00,"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":927.00,"dt_sellin":"2024-04-04T00:00:00","dt_sellout":null,"vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"","num_dsf":"46646","sit_cliente_novo":true,"sit_aparelho_tim":true,"cod_tm":"04016081","dt_operacao":"2026-02-20T17:24:43.257","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"306338","custcode_nivel_75":"RN20_MGBAII_PT2865_A013","Serial_Acessorio":"","ICCID":"","Fidelizacao":"NÃO","item_juros":"NÃO","promo_aparelho_acessorio":false,"vl_boost_fabricante":0.00,"vl_tradein":100.00,"SERVICE_ID":null,"database_name":"DTS39_TIM_FACELL_RN_QA","tipo":"Venda","idpedido_origem":306338,"retorno_json":"[{\"cod_importacao\":77441867,\"imei\":\"358958552611207\",\"num_telefone\":998998989,\"erro\":\"sem erro, importado com sucesso.\"}]"}]:
System.Data.SqlClient.SqlException (0x80131904): É necessário declarar a variável escalar "@NOME_CAMPANHA".
É necessário declarar a variável escalar "@NOME_CAMPANHA".
   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 WS CAIXA - QA\Banco\Integracoes.cs:line 261
ClientConnectionId:6e6c1ea1-7db2-40dc-94a0-f2cdda7eb7a9
Error Number:137,State:2,Class:15
[17:24:03.9358366] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":77441871,"dt_importado":"2026-02-20T17:22:18.467","nom_cliente":"SQUAD POS SMB","ddd":84,"num_telefone":998998989,"num_documento":"28631809241","dt_servico":"2026-02-20T17:22:18.467","nom_plano":"TIM PRÉ TOP","SerialId":384570,"imei":358958552611207,"valor_aparelho":927.00,"val_entrada_dinh":827.00,"val_entrada_bol":null,"val_entrada_vouc":100.00,"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":927.00,"dt_sellin":"2024-04-04T00:00:00","dt_sellout":null,"vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"","num_dsf":"46646","sit_cliente_novo":true,"sit_aparelho_tim":true,"cod_tm":"04016081","dt_operacao":"2026-02-20T17:24:57.86","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"306338","custcode_nivel_75":"RN20_MGBAII_PT2865_A013","Serial_Acessorio":"","ICCID":"","Fidelizacao":"NÃO","item_juros":"NÃO","promo_aparelho_acessorio":false,"vl_boost_fabricante":0.00,"vl_tradein":100.00,"SERVICE_ID":null,"database_name":"DTS39_TIM_FACELL_RN_QA","tipo":"Venda","idpedido_origem":306338,"retorno_json":"[{\"cod_importacao\":77441871,\"imei\":\"358958552611207\",\"num_telefone\":998998989,\"erro\":\"sem erro, importado com sucesso.\"}]"}]:
System.Data.SqlClient.SqlException (0x80131904): É necessário declarar a variável escalar "@NOME_CAMPANHA".
É necessário declarar a variável escalar "@NOME_CAMPANHA".
   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 WS CAIXA - QA\Banco\Integracoes.cs:line 261
ClientConnectionId:6e6c1ea1-7db2-40dc-94a0-f2cdda7eb7a9
Error Number:137,State:2,Class:15
[17:24:24.2321407] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":77441876,"dt_importado":"2026-02-20T17:22:18.467","nom_cliente":"SQUAD POS SMB","ddd":84,"num_telefone":998998989,"num_documento":"28631809241","dt_servico":"2026-02-20T17:22:18.467","nom_plano":"TIM PRÉ TOP","SerialId":384570,"imei":358958552611207,"valor_aparelho":927.00,"val_entrada_dinh":827.00,"val_entrada_bol":null,"val_entrada_vouc":100.00,"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":927.00,"dt_sellin":"2024-04-04T00:00:00","dt_sellout":null,"vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"","num_dsf":"46646","sit_cliente_novo":true,"sit_aparelho_tim":true,"cod_tm":"04016081","dt_operacao":"2026-02-20T17:25:18.12","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"306338","custcode_nivel_75":"RN20_MGBAII_PT2865_A013","Serial_Acessorio":"","ICCID":"","Fidelizacao":"NÃO","item_juros":"NÃO","promo_aparelho_acessorio":false,"vl_boost_fabricante":0.00,"vl_tradein":100.00,"SERVICE_ID":null,"database_name":"DTS39_TIM_FACELL_RN_QA","tipo":"Venda","idpedido_origem":306338,"retorno_json":"[{\"cod_importacao\":77441876,\"imei\":\"358958552611207\",\"num_telefone\":998998989,\"erro\":\"sem erro, importado com sucesso.\"}]"}]:
System.Data.SqlClient.SqlException (0x80131904): É necessário declarar a variável escalar "@NOME_CAMPANHA".
É necessário declarar a variável escalar "@NOME_CAMPANHA".
   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 WS CAIXA - QA\Banco\Integracoes.cs:line 261
ClientConnectionId:6e6c1ea1-7db2-40dc-94a0-f2cdda7eb7a9
Error Number:137,State:2,Class:15
[17:26:06.5142720] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":77441898,"dt_importado":"2026-02-20T17:22:18.467","nom_cliente":"SQUAD POS SMB","ddd":84,"num_telefone":998998989,"num_documento":"28631809241","dt_servico":"2026-02-20T17:22:18.467","nom_plano":"TIM PRÉ TOP","SerialId":384570,"imei":358958552611207,"valor_aparelho":927.00,"val_entrada_dinh":827.00,"val_entrada_bol":null,"val_entrada_vouc":100.00,"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":927.00,"dt_sellin":"2024-04-04T00:00:00","dt_sellout":null,"vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"","num_dsf":"46646","sit_cliente_novo":true,"sit_aparelho_tim":true,"cod_tm":"04016081","dt_operacao":"2026-02-20T17:27:00.42","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"306338","custcode_nivel_75":"RN20_MGBAII_PT2865_A013","Serial_Acessorio":"","ICCID":"","Fidelizacao":"NÃO","item_juros":"NÃO","promo_aparelho_acessorio":false,"vl_boost_fabricante":0.00,"vl_tradein":100.00,"SERVICE_ID":null,"database_name":"DTS39_TIM_FACELL_RN_QA","tipo":"Venda","idpedido_origem":306338,"retorno_json":"[{\"cod_importacao\":77441898,\"imei\":\"358958552611207\",\"num_telefone\":998998989,\"erro\":\"sem erro, importado com sucesso.\"}]"}]:
System.Data.SqlClient.SqlException (0x80131904): É necessário declarar a variável escalar "@NOME_CAMPANHA".
É necessário declarar a variável escalar "@NOME_CAMPANHA".
   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 WS CAIXA - QA\Banco\Integracoes.cs:line 261
ClientConnectionId:6e6c1ea1-7db2-40dc-94a0-f2cdda7eb7a9
Error Number:137,State:2,Class:15
[17:26:29.6709935] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":77441905,"dt_importado":"2026-02-20T17:22:18.467","nom_cliente":"SQUAD POS SMB","ddd":84,"num_telefone":998998989,"num_documento":"28631809241","dt_servico":"2026-02-20T17:22:18.467","nom_plano":"TIM PRÉ TOP","SerialId":384570,"imei":358958552611207,"valor_aparelho":927.00,"val_entrada_dinh":827.00,"val_entrada_bol":null,"val_entrada_vouc":100.00,"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":927.00,"dt_sellin":"2024-04-04T00:00:00","dt_sellout":null,"vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"","num_dsf":"46646","sit_cliente_novo":true,"sit_aparelho_tim":true,"cod_tm":"04016081","dt_operacao":"2026-02-20T17:27:23.617","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"306338","custcode_nivel_75":"RN20_MGBAII_PT2865_A013","Serial_Acessorio":"","ICCID":"","Fidelizacao":"NÃO","item_juros":"NÃO","promo_aparelho_acessorio":false,"vl_boost_fabricante":0.00,"vl_tradein":100.00,"SERVICE_ID":null,"database_name":"DTS39_TIM_FACELL_RN_QA","tipo":"Venda","idpedido_origem":306338,"retorno_json":"[{\"cod_importacao\":77441905,\"imei\":\"358958552611207\",\"num_telefone\":998998989,\"erro\":\"sem erro, importado com sucesso.\"}]"}]:
System.Data.SqlClient.SqlException (0x80131904): É necessário declarar a variável escalar "@NOME_CAMPANHA".
É necessário declarar a variável escalar "@NOME_CAMPANHA".
   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 WS CAIXA - QA\Banco\Integracoes.cs:line 261
ClientConnectionId:6e6c1ea1-7db2-40dc-94a0-f2cdda7eb7a9
Error Number:137,State:2,Class:15
[17:27:11.5000776] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":77441918,"dt_importado":"2026-02-20T17:22:18.467","nom_cliente":"SQUAD POS SMB","ddd":84,"num_telefone":998998989,"num_documento":"28631809241","dt_servico":"2026-02-20T17:22:18.467","nom_plano":"TIM PRÉ TOP","SerialId":384570,"imei":358958552611207,"valor_aparelho":927.00,"val_entrada_dinh":827.00,"val_entrada_bol":null,"val_entrada_vouc":100.00,"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":927.00,"dt_sellin":"2024-04-04T00:00:00","dt_sellout":null,"vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"","num_dsf":"46646","sit_cliente_novo":true,"sit_aparelho_tim":true,"cod_tm":"04016081","dt_operacao":"2026-02-20T17:28:05.407","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"306338","custcode_nivel_75":"RN20_MGBAII_PT2865_A013","Serial_Acessorio":"","ICCID":"","Fidelizacao":"NÃO","item_juros":"NÃO","promo_aparelho_acessorio":false,"vl_boost_fabricante":0.00,"vl_tradein":100.00,"SERVICE_ID":null,"database_name":"DTS39_TIM_FACELL_RN_QA","tipo":"Venda","idpedido_origem":306338,"retorno_json":"[{\"cod_importacao\":77441918,\"imei\":\"358958552611207\",\"num_telefone\":998998989,\"erro\":\"sem erro, importado com sucesso.\"}]"}]:
System.Data.SqlClient.SqlException (0x80131904): É necessário declarar a variável escalar "@NOME_CAMPANHA".
É necessário declarar a variável escalar "@NOME_CAMPANHA".
   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 WS CAIXA - QA\Banco\Integracoes.cs:line 261
ClientConnectionId:6e6c1ea1-7db2-40dc-94a0-f2cdda7eb7a9
Error Number:137,State:2,Class:15
[17:27:38.8337786] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":77441926,"dt_importado":"2026-02-20T17:22:18.467","nom_cliente":"SQUAD POS SMB","ddd":84,"num_telefone":998998989,"num_documento":"28631809241","dt_servico":"2026-02-20T17:22:18.467","nom_plano":"TIM PRÉ TOP","SerialId":384570,"imei":358958552611207,"valor_aparelho":927.00,"val_entrada_dinh":827.00,"val_entrada_bol":null,"val_entrada_vouc":100.00,"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":927.00,"dt_sellin":"2024-04-04T00:00:00","dt_sellout":null,"vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"","num_dsf":"46646","sit_cliente_novo":true,"sit_aparelho_tim":true,"cod_tm":"04016081","dt_operacao":"2026-02-20T17:28:32.63","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"306338","custcode_nivel_75":"RN20_MGBAII_PT2865_A013","Serial_Acessorio":"","ICCID":"","Fidelizacao":"NÃO","item_juros":"NÃO","promo_aparelho_acessorio":false,"vl_boost_fabricante":0.00,"vl_tradein":100.00,"SERVICE_ID":null,"database_name":"DTS39_TIM_FACELL_RN_QA","tipo":"Venda","idpedido_origem":306338,"retorno_json":"[{\"cod_importacao\":77441926,\"imei\":\"358958552611207\",\"num_telefone\":998998989,\"erro\":\"sem erro, importado com sucesso.\"}]"}]:
System.Data.SqlClient.SqlException (0x80131904): É necessário declarar a variável escalar "@NOME_CAMPANHA".
É necessário declarar a variável escalar "@NOME_CAMPANHA".
   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 WS CAIXA - QA\Banco\Integracoes.cs:line 261
ClientConnectionId:6e6c1ea1-7db2-40dc-94a0-f2cdda7eb7a9
Error Number:137,State:2,Class:15
[17:29:09.6569749] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":77441967,"dt_importado":"2026-02-20T17:22:18.467","nom_cliente":"SQUAD POS SMB","ddd":84,"num_telefone":998998989,"num_documento":"28631809241","dt_servico":"2026-02-20T17:22:18.467","nom_plano":"TIM PRÉ TOP","SerialId":384570,"imei":358958552611207,"valor_aparelho":927.00,"val_entrada_dinh":827.00,"val_entrada_bol":null,"val_entrada_vouc":100.00,"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":927.00,"dt_sellin":"2024-04-04T00:00:00","dt_sellout":"2026-02-20T17:29:03","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"24260207366109000196550000000002431009218727","num_dsf":"46646","sit_cliente_novo":true,"sit_aparelho_tim":true,"cod_tm":"04016081","dt_operacao":"2026-02-20T17:30:03.56","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"306338","custcode_nivel_75":"RN20_MGBAII_PT2865_A013","Serial_Acessorio":"","ICCID":"","Fidelizacao":"NÃO","item_juros":"NÃO","promo_aparelho_acessorio":false,"vl_boost_fabricante":0.00,"vl_tradein":100.00,"SERVICE_ID":null,"database_name":"DTS39_TIM_FACELL_RN_QA","tipo":"Venda","idpedido_origem":306338,"retorno_json":"[{\"cod_importacao\":77441967,\"imei\":\"358958552611207\",\"num_telefone\":998998989,\"erro\":\"sem erro, importado com sucesso.\"}]"}]:
System.Data.SqlClient.SqlException (0x80131904): É necessário declarar a variável escalar "@NOME_CAMPANHA".
É necessário declarar a variável escalar "@NOME_CAMPANHA".
   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 WS CAIXA - QA\Banco\Integracoes.cs:line 261
ClientConnectionId:6e6c1ea1-7db2-40dc-94a0-f2cdda7eb7a9
Error Number:137,State:2,Class:15
[17:44:01.8225765] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":77442236,"dt_importado":"2026-02-20T17:41:18.083","nom_cliente":"TESTE TESTANDO","ddd":84,"num_telefone":999999999,"num_documento":"07615534950","dt_servico":"2026-02-20T17:41:18.083","nom_plano":"TIM CONTROLE","SerialId":384572,"imei":358958552611209,"valor_aparelho":927.00,"val_entrada_dinh":827.00,"val_entrada_bol":null,"val_entrada_vouc":100.00,"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":927.00,"dt_sellin":"2024-04-04T00:00:00","dt_sellout":null,"vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"","num_dsf":"46646","sit_cliente_novo":true,"sit_aparelho_tim":true,"cod_tm":"04016081","dt_operacao":"2026-02-20T17:44:55.61","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"306339","custcode_nivel_75":"RN20_MGBAII_PT2865_A013","Serial_Acessorio":"","ICCID":"","Fidelizacao":"NÃO","item_juros":"NÃO","promo_aparelho_acessorio":false,"vl_boost_fabricante":0.00,"vl_tradein":100.00,"SERVICE_ID":null,"database_name":"DTS39_TIM_FACELL_RN_QA","tipo":"Venda","idpedido_origem":306339,"retorno_json":"[{\"cod_importacao\":77442236,\"imei\":\"358958552611209\",\"num_telefone\":999999999,\"erro\":\"sem erro, importado com sucesso.\"}]"}]:
System.Data.SqlClient.SqlException (0x80131904): É necessário declarar a variável escalar "@NOME_CAMPANHA".
É necessário declarar a variável escalar "@NOME_CAMPANHA".
   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 WS CAIXA - QA\Banco\Integracoes.cs:line 261
ClientConnectionId:14d54911-1f40-4848-ab92-a763d63a9a4a
Error Number:137,State:2,Class:15
[17:44:20.1950886] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":77442241,"dt_importado":"2026-02-20T17:41:18.083","nom_cliente":"TESTE TESTANDO","ddd":84,"num_telefone":999999999,"num_documento":"07615534950","dt_servico":"2026-02-20T17:41:18.083","nom_plano":"TIM CONTROLE","SerialId":384572,"imei":358958552611209,"valor_aparelho":927.00,"val_entrada_dinh":827.00,"val_entrada_bol":null,"val_entrada_vouc":100.00,"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":927.00,"dt_sellin":"2024-04-04T00:00:00","dt_sellout":null,"vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"","num_dsf":"46646","sit_cliente_novo":true,"sit_aparelho_tim":true,"cod_tm":"04016081","dt_operacao":"2026-02-20T17:45:14.06","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"306339","custcode_nivel_75":"RN20_MGBAII_PT2865_A013","Serial_Acessorio":"","ICCID":"","Fidelizacao":"NÃO","item_juros":"NÃO","promo_aparelho_acessorio":false,"vl_boost_fabricante":0.00,"vl_tradein":100.00,"SERVICE_ID":null,"database_name":"DTS39_TIM_FACELL_RN_QA","tipo":"Venda","idpedido_origem":306339,"retorno_json":"[{\"cod_importacao\":77442241,\"imei\":\"358958552611209\",\"num_telefone\":999999999,\"erro\":\"sem erro, importado com sucesso.\"}]"}]:
System.Data.SqlClient.SqlException (0x80131904): É necessário declarar a variável escalar "@NOME_CAMPANHA".
É necessário declarar a variável escalar "@NOME_CAMPANHA".
   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 WS CAIXA - QA\Banco\Integracoes.cs:line 261
ClientConnectionId:9a13d6f8-9534-4818-8b1c-d5de16bf7118
Error Number:137,State:2,Class:15
[17:45:19.7485437] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":77442262,"dt_importado":"2026-02-20T17:41:18.083","nom_cliente":"TESTE TESTANDO","ddd":84,"num_telefone":999999999,"num_documento":"07615534950","dt_servico":"2026-02-20T17:41:18.083","nom_plano":"TIM CONTROLE","SerialId":384572,"imei":358958552611209,"valor_aparelho":927.00,"val_entrada_dinh":827.00,"val_entrada_bol":null,"val_entrada_vouc":100.00,"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":927.00,"dt_sellin":"2024-04-04T00:00:00","dt_sellout":null,"vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"","num_dsf":"46646","sit_cliente_novo":true,"sit_aparelho_tim":true,"cod_tm":"04016081","dt_operacao":"2026-02-20T17:46:13.62","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"306339","custcode_nivel_75":"RN20_MGBAII_PT2865_A013","Serial_Acessorio":"","ICCID":"","Fidelizacao":"NÃO","item_juros":"NÃO","promo_aparelho_acessorio":false,"vl_boost_fabricante":0.00,"vl_tradein":100.00,"SERVICE_ID":null,"database_name":"DTS39_TIM_FACELL_RN_QA","tipo":"Venda","idpedido_origem":306339,"retorno_json":"[{\"cod_importacao\":77442262,\"imei\":\"358958552611209\",\"num_telefone\":999999999,\"erro\":\"sem erro, importado com sucesso.\"}]"}]:
System.Data.SqlClient.SqlException (0x80131904): É necessário declarar a variável escalar "@NOME_CAMPANHA".
É necessário declarar a variável escalar "@NOME_CAMPANHA".
   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 WS CAIXA - QA\Banco\Integracoes.cs:line 261
ClientConnectionId:9a13d6f8-9534-4818-8b1c-d5de16bf7118
Error Number:137,State:2,Class:15