[16:58:02.9324157] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":75684296,"dt_importado":"2025-07-12T12:33:05.317","nom_cliente":"mitilene alcina alves da silva lira","ddd":0,"num_telefone":0,"num_documento":"10907364446","dt_servico":"2025-07-12T12:33:05.317","nom_plano":"","SerialId":158,"imei":null,"valor_aparelho":15.00,"val_entrada_dinh":null,"val_entrada_bol":null,"val_entrada_vouc":null,"val_entrada_pix":null,"val_entrada_deb":null,"cod_aut_1":0,"qtde_parc_1":1,"vl_cartao_credito_1":15.00,"cod_aut_2":null,"qtde_parc_2":null,"vl_cartao_credito_2":null,"sit_fidelizacao":false,"vl_desconto":"0.00","nom_tipo_negociacao":"rebate","vl_pre_tabela":0.00,"dt_sellin":"2025-07-03T00:00:00","dt_sellout":"2025-07-12T00:00:00","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"145238","num_dsf":"102830","sit_cliente_novo":true,"sit_aparelho_tim":false,"cod_tm":"","dt_operacao":"2025-07-12T16:58:01.963","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"79","custcode_nivel_75":"NE80_NEN04I_NE0819_NE003","Serial_Acessorio":"","ICCID":"89550288000006603352","Fidelizacao":"NÃO","item_juros":"NÃO","promo_aparelho_acessorio":false,"vl_boost_fabricante":0.00,"vl_tradein":null,"database_name":"DTS39_TIM_SOLTECH_PE","tipo":"Venda","idpedido_origem":79,"retorno_json":"[{\"cod_importacao\":75684296,\"imei\":null,\"num_telefone\":0,\"erro\":\"sem erro, importado com sucesso.\"}]"}]:
System.Data.SqlClient.SqlException (0x80131904): É necessário declarar a variável escalar "@ServiceID".
É necessário declarar a variável escalar "@ServiceId".
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at wsCaixa.Banco.IntegracaoCaixaTim.SalvarDadosTimCentralizado(SqlConnection conn, SqlTransaction tran, DataRow dados, String stJsonEnvio, RetornoIntegracaoTim retorno) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 252
ClientConnectionId:4320edc4-f913-438c-a8ca-64cb04d114cd
Error Number:137,State:2,Class:15
[17:43:26.9876300] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":75684641,"dt_importado":"2025-07-12T17:17:22.347","nom_cliente":"shirley lima ","ddd":0,"num_telefone":0,"num_documento":"10189404485","dt_servico":"2025-07-12T17:17:22.347","nom_plano":"","SerialId":null,"imei":null,"valor_aparelho":49.99,"val_entrada_dinh":null,"val_entrada_bol":null,"val_entrada_vouc":null,"val_entrada_pix":null,"val_entrada_deb":null,"cod_aut_1":0,"qtde_parc_1":1,"vl_cartao_credito_1":49.99,"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":null,"dt_sellout":"2025-07-12T00:00:00","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"33566","num_dsf":"102830","sit_cliente_novo":true,"sit_aparelho_tim":false,"cod_tm":"","dt_operacao":"2025-07-12T17:43:25.767","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":49.99,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"83","custcode_nivel_75":"NE80_NEN04I_NE0819_NE003","Serial_Acessorio":"","ICCID":"","Fidelizacao":"NÃO","item_juros":"NÃO","promo_aparelho_acessorio":false,"vl_boost_fabricante":0.00,"vl_tradein":null,"database_name":"DTS39_TIM_SOLTECH_PE","tipo":"Venda","idpedido_origem":83,"retorno_json":"[{\"cod_importacao\":75684641,\"imei\":null,\"num_telefone\":0,\"erro\":\"sem erro, importado com sucesso.\"}]"}]:
System.Data.SqlClient.SqlException (0x80131904): É necessário declarar a variável escalar "@ServiceID".
É necessário declarar a variável escalar "@ServiceId".
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at wsCaixa.Banco.IntegracaoCaixaTim.SalvarDadosTimCentralizado(SqlConnection conn, SqlTransaction tran, DataRow dados, String stJsonEnvio, RetornoIntegracaoTim retorno) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 252
ClientConnectionId:012b9768-06ef-4e6e-b128-9d4c76fd113c
Error Number:137,State:2,Class:15
[20:48:25.1013611] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":75685876,"dt_importado":"2025-07-12T17:02:58.12","nom_cliente":"marcelo jose da silva ","ddd":0,"num_telefone":0,"num_documento":"05540561430","dt_servico":"2025-07-12T17:02:58.12","nom_plano":"","SerialId":null,"imei":null,"valor_aparelho":150.00,"val_entrada_dinh":null,"val_entrada_bol":null,"val_entrada_vouc":null,"val_entrada_pix":null,"val_entrada_deb":null,"cod_aut_1":0,"qtde_parc_1":1,"vl_cartao_credito_1":150.00,"cod_aut_2":null,"qtde_parc_2":null,"vl_cartao_credito_2":null,"sit_fidelizacao":false,"vl_desconto":"0.00","nom_tipo_negociacao":"rebate","vl_pre_tabela":0.00,"dt_sellin":null,"dt_sellout":"2025-07-12T00:00:00","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"216445","num_dsf":"102830","sit_cliente_novo":true,"sit_aparelho_tim":false,"cod_tm":"","dt_operacao":"2025-07-12T20:48:22.89","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":199.99,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"82","custcode_nivel_75":"NE80_NEN04I_NE0819_NE003","Serial_Acessorio":"","ICCID":"","Fidelizacao":"NÃO","item_juros":"NÃO","promo_aparelho_acessorio":false,"vl_boost_fabricante":0.00,"vl_tradein":null,"database_name":"DTS39_TIM_SOLTECH_PE","tipo":"Venda","idpedido_origem":82,"retorno_json":"[{\"cod_importacao\":75685876,\"imei\":null,\"num_telefone\":0,\"erro\":\"sem erro, importado com sucesso.\"}]"}]:
System.Data.SqlClient.SqlException (0x80131904): É necessário declarar a variável escalar "@ServiceID".
É necessário declarar a variável escalar "@ServiceId".
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at wsCaixa.Banco.IntegracaoCaixaTim.SalvarDadosTimCentralizado(SqlConnection conn, SqlTransaction tran, DataRow dados, String stJsonEnvio, RetornoIntegracaoTim retorno) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 252
ClientConnectionId:9549e97e-db4d-4c1f-8c83-31e0cefa7e84
Error Number:137,State:2,Class:15
[20:51:46.3813546] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":75685888,"dt_importado":"2025-07-12T18:04:31.65","nom_cliente":"shirley lima ","ddd":0,"num_telefone":0,"num_documento":"10189404485","dt_servico":"2025-07-12T18:04:31.65","nom_plano":"","SerialId":null,"imei":null,"valor_aparelho":99.99,"val_entrada_dinh":null,"val_entrada_bol":null,"val_entrada_vouc":null,"val_entrada_pix":null,"val_entrada_deb":null,"cod_aut_1":0,"qtde_parc_1":1,"vl_cartao_credito_1":99.99,"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":null,"dt_sellout":"2025-07-12T00:00:00","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"656","num_dsf":"102830","sit_cliente_novo":true,"sit_aparelho_tim":false,"cod_tm":"","dt_operacao":"2025-07-12T20:51:43.97","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":99.99,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"84","custcode_nivel_75":"NE80_NEN04I_NE0819_NE003","Serial_Acessorio":"","ICCID":"","Fidelizacao":"NÃO","item_juros":"NÃO","promo_aparelho_acessorio":false,"vl_boost_fabricante":0.00,"vl_tradein":null,"database_name":"DTS39_TIM_SOLTECH_PE","tipo":"Venda","idpedido_origem":84,"retorno_json":"[{\"cod_importacao\":75685888,\"imei\":null,\"num_telefone\":0,\"erro\":\"sem erro, importado com sucesso.\"}]"}]:
System.Data.SqlClient.SqlException (0x80131904): É necessário declarar a variável escalar "@ServiceID".
É necessário declarar a variável escalar "@ServiceId".
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at wsCaixa.Banco.IntegracaoCaixaTim.SalvarDadosTimCentralizado(SqlConnection conn, SqlTransaction tran, DataRow dados, String stJsonEnvio, RetornoIntegracaoTim retorno) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 252
ClientConnectionId:9549e97e-db4d-4c1f-8c83-31e0cefa7e84
Error Number:137,State:2,Class:15
[21:08:13.4885607] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":75685951,"dt_importado":"2025-07-12T20:54:12.397","nom_cliente":"shirley lima ","ddd":0,"num_telefone":0,"num_documento":"10189404485","dt_servico":"2025-07-12T20:54:12.397","nom_plano":"","SerialId":null,"imei":null,"valor_aparelho":49.99,"val_entrada_dinh":null,"val_entrada_bol":null,"val_entrada_vouc":null,"val_entrada_pix":null,"val_entrada_deb":null,"cod_aut_1":0,"qtde_parc_1":1,"vl_cartao_credito_1":49.99,"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":null,"dt_sellout":"2025-07-12T00:00:00","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"54352","num_dsf":"102830","sit_cliente_novo":true,"sit_aparelho_tim":false,"cod_tm":"","dt_operacao":"2025-07-12T21:08:11.023","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":49.99,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"86","custcode_nivel_75":"NE80_NEN04I_NE0819_NE003","Serial_Acessorio":"","ICCID":"","Fidelizacao":"NÃO","item_juros":"NÃO","promo_aparelho_acessorio":false,"vl_boost_fabricante":0.00,"vl_tradein":null,"database_name":"DTS39_TIM_SOLTECH_PE","tipo":"Venda","idpedido_origem":86,"retorno_json":"[{\"cod_importacao\":75685951,\"imei\":null,\"num_telefone\":0,\"erro\":\"sem erro, importado com sucesso.\"}]"}]:
System.Data.SqlClient.SqlException (0x80131904): É necessário declarar a variável escalar "@ServiceID".
É necessário declarar a variável escalar "@ServiceId".
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at wsCaixa.Banco.IntegracaoCaixaTim.SalvarDadosTimCentralizado(SqlConnection conn, SqlTransaction tran, DataRow dados, String stJsonEnvio, RetornoIntegracaoTim retorno) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 252
ClientConnectionId:a778a974-c11c-4c51-a20a-16ce0f62a4aa
Error Number:137,State:2,Class:15