[13:47:00.0670192] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":77612730,"dt_importado":"2026-03-12T13:24:59.947","nom_cliente":"DEMANDA BBB","ddd":12,"num_telefone":312312312,"num_documento":"48108212855","dt_servico":"2026-03-12T13:24:59.947","nom_plano":"TIM BLACK 1.0","SerialId":385020,"imei":357709570311118,"valor_aparelho":3999.00,"val_entrada_dinh":3889.00,"val_entrada_bol":null,"val_entrada_vouc":110.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":"4000.00","nom_tipo_negociacao":"","vl_pre_tabela":7999.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":"04015030","dt_operacao":"2026-03-12T13:48:08.86","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"306373","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":110.00,"SERVICE_ID":null,"NOME_CAMPANHA":"CAMPANHA 1|CAMPANHA 2","VALOR_VOUCHER":"50.00|60.00","database_name":"DTS39_TIM_FACELL_RN_QA","tipo":"Venda","idpedido_origem":306373,"retorno_json":"[{\"cod_importacao\":77612730,\"imei\":\"357709570311118\",\"num_telefone\":312312312,\"erro\":\"sem erro, importado com sucesso.\"}]"}]:
System.Data.SqlClient.SqlException (0x80131904): Erro ao converter tipo de dados nvarchar em numeric.
   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 266
ClientConnectionId:686c422f-8c95-41da-9dc2-8326f6af1d2a
Error Number:8114,State:5,Class:16
[13:48:36.5083322] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":77612746,"dt_importado":"2026-03-12T13:24:59.947","nom_cliente":"DEMANDA BBB","ddd":12,"num_telefone":312312312,"num_documento":"48108212855","dt_servico":"2026-03-12T13:24:59.947","nom_plano":"TIM BLACK 1.0","SerialId":385020,"imei":357709570311118,"valor_aparelho":3999.00,"val_entrada_dinh":3889.00,"val_entrada_bol":null,"val_entrada_vouc":110.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":"4000.00","nom_tipo_negociacao":"","vl_pre_tabela":7999.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":"04015030","dt_operacao":"2026-03-12T13:49:45.623","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"306373","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":110.00,"SERVICE_ID":null,"NOME_CAMPANHA":"CAMPANHA 1|CAMPANHA 2","VALOR_VOUCHER":"50.00|60.00","database_name":"DTS39_TIM_FACELL_RN_QA","tipo":"Venda","idpedido_origem":306373,"retorno_json":"[{\"cod_importacao\":77612746,\"imei\":\"357709570311118\",\"num_telefone\":312312312,\"erro\":\"sem erro, importado com sucesso.\"}]"}]:
System.Data.SqlClient.SqlException (0x80131904): Erro ao converter tipo de dados nvarchar em numeric.
   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 266
ClientConnectionId:4590e835-bde7-4009-8c13-415b604fac13
Error Number:8114,State:5,Class:16