[22:18:45.3403184] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":75090627,"dt_importado":"2025-04-26T22:07:37.69","nom_cliente":"ANDREA RAQUEL PATRICIA PIREA","ddd":15,"num_telefone":981116150,"num_documento":"15092079614","dt_servico":"2025-04-26T22:07:37.69","nom_plano":"TIM BLACK B 6.0","SerialId":384858,"imei":354188157054383,"valor_aparelho":7699.00,"val_entrada_dinh":null,"val_entrada_bol":null,"val_entrada_vouc":325.50,"val_entrada_pix":null,"val_entrada_deb":null,"cod_aut_1":0,"qtde_parc_1":8,"vl_cartao_credito_1":7383.50,"cod_aut_2":null,"qtde_parc_2":null,"vl_cartao_credito_2":null,"sit_fidelizacao":false,"vl_desconto":"800.00","nom_tipo_negociacao":"rebate","vl_pre_tabela":8499.00,"dt_sellin":"2021-01-20T00:00:00","dt_sellout":"2025-04-26T22:18:41","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"24250407366109000196550000000000951009214447","num_dsf":"23108","sit_cliente_novo":true,"sit_aparelho_tim":true,"cod_tm":"04016894","dt_operacao":"2025-04-26T22:18:31.007","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"305675","custcode_nivel_75":"RN20_MGBAII_PT2865_A013","Serial_Acessorio":"","ICCID":"","Fidelizacao":"SIM","item_juros":"NÃO","vl_boost_fabricante":800.00,"vl_tradein":325.50,"database_name":"DTS39_TIM_FACELL_RN_QA","tipo":"Venda","idpedido_origem":305675,"retorno_json":"[{\"cod_importacao\":75090627,\"imei\":\"354188157054383\",\"num_telefone\":981116150,\"erro\":\"sem erro, importado com sucesso.\"}]"},{"item":2,"cod_importacao":null,"dt_importado":"2025-04-26T22:07:37.69","nom_cliente":"ANDREA RAQUEL PATRICIA PIREA","ddd":15,"num_telefone":981116150,"num_documento":"15092079614","dt_servico":"2025-04-26T22:07:37.69","nom_plano":"TIM BLACK B 6.0","SerialId":384854,"imei":null,"valor_aparelho":10.00,"val_entrada_dinh":null,"val_entrada_bol":null,"val_entrada_vouc":325.50,"val_entrada_pix":null,"val_entrada_deb":null,"cod_aut_1":0,"qtde_parc_1":8,"vl_cartao_credito_1":7383.50,"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":"2021-01-20T00:00:00","dt_sellout":"2025-04-26T22:18:41","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"24250407366109000196550000000000951009214447","num_dsf":"23108","sit_cliente_novo":true,"sit_aparelho_tim":false,"cod_tm":"","dt_operacao":"2025-04-26T22:18:31.007","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"305675","custcode_nivel_75":"RN20_MGBAII_PT2865_A013","Serial_Acessorio":"","ICCID":"89550311000000986614","Fidelizacao":"SIM","item_juros":"NÃO","vl_boost_fabricante":0.00,"vl_tradein":325.50,"database_name":null,"tipo":null,"idpedido_origem":null,"retorno_json":null}]:
System.Data.SqlClient.SqlException (0x80131904): É necessário declarar a variável escalar "@promo_aparelho_acessorio".
É necessário declarar a variável escalar "@promo_aparelho_acessorio".
   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 251
ClientConnectionId:71f70aaf-2ec1-4bac-a54f-944d45dd4280
Error Number:137,State:2,Class:15
[22:18:45.6215695] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":75090627,"dt_importado":"2025-04-26T22:07:37.69","nom_cliente":"ANDREA RAQUEL PATRICIA PIREA","ddd":15,"num_telefone":981116150,"num_documento":"15092079614","dt_servico":"2025-04-26T22:07:37.69","nom_plano":"TIM BLACK B 6.0","SerialId":384858,"imei":354188157054383,"valor_aparelho":7699.00,"val_entrada_dinh":null,"val_entrada_bol":null,"val_entrada_vouc":325.50,"val_entrada_pix":null,"val_entrada_deb":null,"cod_aut_1":0,"qtde_parc_1":8,"vl_cartao_credito_1":7383.50,"cod_aut_2":null,"qtde_parc_2":null,"vl_cartao_credito_2":null,"sit_fidelizacao":false,"vl_desconto":"800.00","nom_tipo_negociacao":"rebate","vl_pre_tabela":8499.00,"dt_sellin":"2021-01-20T00:00:00","dt_sellout":"2025-04-26T22:18:41","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"24250407366109000196550000000000951009214447","num_dsf":"23108","sit_cliente_novo":true,"sit_aparelho_tim":true,"cod_tm":"04016894","dt_operacao":"2025-04-26T22:18:31.007","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"305675","custcode_nivel_75":"RN20_MGBAII_PT2865_A013","Serial_Acessorio":"","ICCID":"","Fidelizacao":"SIM","item_juros":"NÃO","vl_boost_fabricante":800.00,"vl_tradein":325.50,"database_name":"DTS39_TIM_FACELL_RN_QA","tipo":"Venda","idpedido_origem":305675,"retorno_json":"[{\"cod_importacao\":75090627,\"imei\":\"354188157054383\",\"num_telefone\":981116150,\"erro\":\"sem erro, importado com sucesso.\"}]"},{"item":2,"cod_importacao":75090628,"dt_importado":"2025-04-26T22:07:37.69","nom_cliente":"ANDREA RAQUEL PATRICIA PIREA","ddd":15,"num_telefone":981116150,"num_documento":"15092079614","dt_servico":"2025-04-26T22:07:37.69","nom_plano":"TIM BLACK B 6.0","SerialId":384854,"imei":null,"valor_aparelho":10.00,"val_entrada_dinh":null,"val_entrada_bol":null,"val_entrada_vouc":325.50,"val_entrada_pix":null,"val_entrada_deb":null,"cod_aut_1":0,"qtde_parc_1":8,"vl_cartao_credito_1":7383.50,"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":"2021-01-20T00:00:00","dt_sellout":"2025-04-26T22:18:41","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"24250407366109000196550000000000951009214447","num_dsf":"23108","sit_cliente_novo":true,"sit_aparelho_tim":false,"cod_tm":"","dt_operacao":"2025-04-26T22:18:31.007","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"305675","custcode_nivel_75":"RN20_MGBAII_PT2865_A013","Serial_Acessorio":"","ICCID":"89550311000000986614","Fidelizacao":"SIM","item_juros":"NÃO","vl_boost_fabricante":0.00,"vl_tradein":325.50,"database_name":"DTS39_TIM_FACELL_RN_QA","tipo":"Venda","idpedido_origem":305675,"retorno_json":"[{\"cod_importacao\":75090628,\"imei\":null,\"num_telefone\":981116150,\"erro\":\"sem erro, importado com sucesso.\"}]"}]:
System.Data.SqlClient.SqlException (0x80131904): É necessário declarar a variável escalar "@promo_aparelho_acessorio".
É necessário declarar a variável escalar "@promo_aparelho_acessorio".
   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 251
ClientConnectionId:71f70aaf-2ec1-4bac-a54f-944d45dd4280
Error Number:137,State:2,Class:15