Histórico da Página
Informações | ||
---|---|---|
| ||
Clientes Cloud, é necessário entrar em contato com o time de Cloud para que os procedimentos sejam realizados. |
Índice
Índice | ||||
---|---|---|---|---|
|
Objetivos
...
Problemas de lentidão no TOTVS Fluig Plataforma podem acontecer por diversos motivos, por isso, reunimos alguns métodos e ações que podem auxiliar o usuário administrador do ambiente a reduzir ou sanar a lentidão.
Pré-requisitos
...
- O ambiente do usuário deve estar de acordo com Servidores respeitando o Modelo de dimensionamento.
- O ambiente do usuário deve seguir Plataforma de acordo com os padrões descritos na da Matriz de portabilidade.
- O ambiente deve seguir Ambiente em consonância com os ciclos de Atualização da plataforma.
- Conferir outras Especificações Técnicas necessárias.
- Conhecimento prévio referente as documentações: Avaliação de lentidão na plataforma e Performance e análise do servidor.
...
01. Executar as consultas abaixo no banco de dados e enviar os resultados em prints ou formato .csv para a equipe de Suporte Fluig. Para isso, é necessária a abertura de um ticket no Portal do Cliente: na Central de Atendimento, através das opções: Nova Solicitação → Suporte Técnico.
Bloco de código | ||
---|---|---|
| ||
select COD_DATASET from serv_dataset where DSL_DATASET like '%FluigDS%'; select nr_documento, COD_EVENT from event_ficha where DSL_EVENT like '%FluigDS%'; select COD_EVENT from event_geral where DSL_EVENT like '%FluigDS%'; select event_proces.COD_DEF_PROCES, COD_EVENT from event_proces where DSL_EVENT like '%FluigDS%'; |
...
01. Os arquivos de instalação abaixo são os mais solicitados pela equipe Suporte Fluig. Caso seja necessário, realize a abertura de um ticket no Portal do Cliente, na Central de Atendimento, através das opções: Nova Solicitação → Suporte Técnico e anexe esses arquivos ao chamado, pois agilizará bastante . Essa ação agilizará todo o processo de atendimento:
...
- ERROR;
- ja esta sendo executado por;
- executou por;
- invokeFunction.servicetask64;
- invokeFunction.createDataset;
- Thread em execução (ex.: default task-39939).
04. Principais achados no server.log:
a) Sincronização de datasets levando mais tempo que o tolerável para finalizar as sincronizações. No exemplo, os datasets estão sincronizando por mais de 2500 segundos:
Bloco de código | ||||
---|---|---|---|---|
| ||||
2023-05-29 10:42:00,740 WARN com.fluig.monitoring.jschronos.JSChronos DatasetMetaListServiceBean.datasetSync executou por 2520 segundos 2023-05-29 10:42:00,740 INFO com.fluig.bpm.service.DatasetMetaListServiceBean Fim da sincronização do Dataset : dsFuncionario 2023-05-29 11:08:39,167 WARN com.fluig.monitoring.jschronos.JSChronos DatasetMetaListServiceBean.datasetSync executou por 2318 segundos 2023-05-29 11:08:39,168 INFO com.fluig.bpm.service.DatasetMetaListServiceBean Fim da sincronização do Dataset : dsEmpresas |
...
Bloco de código | ||||
---|---|---|---|---|
| ||||
2022-11-23 15:59:03,511 WARN [com.fluig.monitoring.jschronos.JSChronos] (JSChronos.CustomizationManagerImpl.invokeFunction.createDataset) CustomizationManagerImpl.invokeFunction.createDataset ja esta sendo executado por 2211 segundos params: [[[Ljava.lang.String;@268d1e17, null, null], Thread = default task-6727, datasetId = dsDatabase] 2.211 segundos 2022-11-24 08:51:22,088 WARN [com.fluig.monitoring.jschronos.JSChronos] (JSChronos.CustomizationManagerImpl.invokeFunction.createDataset) CustomizationManagerImpl.invokeFunction.createDataset ja esta sendo executado por 60 segundos params: [[[Ljava.lang.String;@7cec0760, [Lcom.totvs.technology.foundation.dataset.SearchConstraint;@64de871c, null], Thread = default task-35, datasetId = dsChecklistCRUD] 2023-02-14 09:17:47,722 WARN [com.fluig.monitoring.jschronos.JSChronos] (JSChronos.CustomizationManagerImpl.invokeFunction.createDataset) CustomizationManagerImpl.invokeFunction.createDataset ja esta sendo executado por 300 segundos params: [[null, [Lcom.totvs.technology.foundation.dataset.SearchConstraint;@67eb8082, null], Thread = default task-389, datasetId = ds_sql_update] 2023-02-14 09:17:56,587 WARN [com.fluig.monitoring.jschronos.JSChronos] (JSChronos.CustomizationManagerImpl.invokeFunction.servicetask64) CustomizationManagerImpl.invokeFunction.servicetask64 ja esta sendo executado por 120 segundos params: [[Process id = alteracao_de_preco, Process Version = 23, Process Current UserId = brunousuario.vieirauser], Thread = default task-413, datasetId = workflowColleagueRole] |
...
c) Os termos "invokeFunction.servicetask64"e "invokeFunction.createDataset",geralmente, possuem relação com datasets de Workflow (Processos):
Bloco de código | ||||
---|---|---|---|---|
| ||||
2023-02-14 08:39:38,114 WARN [com.fluig.monitoring.jschronos.JSChronos] (default task-323) CustomizationManagerImpl.invokeFunction.servicetask64 executou por 565 segundos 2023-02-14 08:39:38,114 WARN [com.fluig.monitoring.jschronos.JSChronos] (default task-323) params: [[Process id = alteracao_de_preco, Process Version = 23, Process Current UserId = brunousuario.vieirauser], Thread = default task-323, datasetId = workflowColleagueRole] |
d) O Busca pela thread em execução (default task-39):
Bloco de código | ||||
---|---|---|---|---|
| ||||
2023-05-29 09:2830:1653,971414 INFO [com.datasul.technology.webdesk.workflow.business.WorkflowBO] (default task-39) GetProcessDefinitionInfo! 2023-05-29 09:28:17,369 ERROR [com.datasul.technology.webdesk.workflow.assignment.FormFieldAssignment] (default task-39) Processo não possui formulário associado. 2023-05-29 09:28:17,377 INFO [com.datasul.technology.webdesk.workflow.business.ProcessHistoryBO] (default task-39) CompanyId: 0 - ProcessInstanceId: 0 2023-05-29 09:28:17,379 INFO [com.datasul.technology.webdesk.workflow.business.ProcessHistoryBO] (default task-39) CompanyId: 0 - ProcessInstanceId: 0 - status: 4 2023-05-29 09:28:19,014 WARN [org.hibernate.hql.internal.ast.QueryTranslatorImpl] (default task-39) HHH000104: firstResult/maxResults specified with collection fetch; applying in memory! 2023-05-29 09:28:23,512 WARN [com.fluig.monitoring.jschronos.JSChronos] (default task-39) PageServiceBean.findMenuPages executou por 4 segundos 2023-05-29 09:28:35,990 INFO [com.datasul.technology.webdesk.dataset.business.DatasetBO] (default task-39) Executando Dataset com ID ds_RMConsulta do tipo Avançado. 2023-05-29 09:28:35,990 INFO [com.datasul.technology.webdesk.dataset.business.DatasetBO] (default task-39) Builder rodando sem o mobile 2023-05-29 09:28:36,008 INFO [com.datasul.technology.webdesk.customization.ScriptingLog] (default task-39) uf-log | Chamada do DataSet ds_RMConsulta 2023-05-29 09:28:36,012 INFO [com.datasul.technology.webdesk.dataset.business.DatasetBO] (default task-39) Executando Dataset com ID ds_RMConecta do tipo Avançado. 2023-05-29 09:28:36,012 INFO [com.datasul.technology.webdesk.dataset.business.DatasetBO] (default task-39) Builder rodando sem o mobile 2023-05-29 09:28:36,037 INFO [org.apache.cxf.wsdl.service.factory.ReflectionServiceFactoryBean] (default task-39) Creating Service {http://www.totvs.com/}wsConsultaSQL from WSDL: http://peg54p-prd-ws.totvscloud.com.br:8083/wsConsultaSQL/MEX?wsdl 2023-05-29 09:28:36,053 WARNING [org.apache.cxf.wsdl.service.factory.ReflectionServiceFactoryBean] (default task-39) No method was found for the WSDL operation {http://www.totvs.com/}RealizarConsultaSQLContexto. 2023-05-29 09:28:36,059 INFO [org.apache.cxf.wsdl.service.factory.ReflectionServiceFactoryBean] (default task-39) Creating Service {http://www.totvs.com/}IwsConsultaSQLService from class com.totvs.IwsConsultaSQL 2023-05-29 09:28:36,065 INFO [com.datasul.technology.webdesk.customization.ScriptingLog] (default task-39) uf-log | Dados da chamada ao serviço wsConsultaSQL: 2023-05-29 09:28:36,065 INFO [com.datasul.technology.webdesk.customization.ScriptingLog] (default task-39) uf-log | CODSENTECA: TBC012.04 2023-05-29 09:28:36,065 INFO [com.datasul.technology.webdesk.customization.ScriptingLog] (default task-39) uf-log | CODCOLIGADA: 1 2023-05-29 09:28:36,065 INFO [com.datasul.technology.webdesk.customization.ScriptingLog] (default task-39) uf-log | APLICACAO: T 2023-05-29 09:28:36,065 INFO [com.datasul.technology.webdesk.customization.ScriptingLog] (default task-39) uf-log | PARAMETRO: CODIGO=12711;COLIGADA=1 2023-05-29 09:28:36,670 INFO [com.datasul.technology.webdesk.customization.ScriptingLog] (default task-39) uf-log | Chamada realizada com sucesso. 2023-05-29 09:28:36,670 INFO [com.datasul.technology.webdesk.customization.ScriptingLog] (default task-39) uf-log | Quantidade de registros retornados: 1 2023-05-29 09:28:37,950 INFO [com.datasul.technology.webdesk.dataset.business.DatasetBO] (default task-39) Executando Dataset com ID ds_RMConsulta do tipo Avançado. 2023-05-29 09:28:37,950 INFO [com.datasul.technology.webdesk.dataset.business.DatasetBO] (default task-39) Builder rodando sem o mobile 2023-05-29 09:28:37,966 INFO [com.datasul.technology.webdesk.customization.ScriptingLog] (default task-39) uf-log | Chamada do DataSet ds_RMConsulta 2023-05-29 09:28:37,970 INFO [com.datasul.technology.webdesk.dataset.business.DatasetBO] (default task-39) Executando Dataset com ID ds_RMConecta do tipo Avançado. 2023-05-29 09:28:37,970 INFO [com.datasul.technology.webdesk.dataset.business.DatasetBO] (default task-39) Builder rodando sem o mobile 2023-05-29 09:28:37,994 INFO [org.apache.cxf.wsdl.service.factory.ReflectionServiceFactoryBean] (default task-39) Creating Service {http://www.totvs.com/}wsConsultaSQL from WSDL: http://peg54p-prd-ws.totvscloud.com.br:8083/wsConsultaSQL/MEX?wsdl 2023-05-29 09:28:38,006 WARNING [org.apache.cxf.wsdl.service.factory.ReflectionServiceFactoryBean] (default task-39) No method was found for the WSDL operation {http://www.totvs.com/}RealizarConsultaSQLContexto. 2023-05-29 09:28:38,012 INFO [org.apache.cxf.wsdl.service.factory.ReflectionServiceFactoryBean] (default task-39) Creating Service {http://www.totvs.com/}IwsConsultaSQLService from class com.totvs.IwsConsultaSQL 2023-05-29 09:28:38,017 INFO [com.datasul.technology.webdesk.customization.ScriptingLog] (default task-39) uf-log | Dados da chamada ao serviço wsConsultaSQL: 2023-05-29 09:28:38,018 INFO [com.datasul.technology.webdesk.customization.ScriptingLog] (default task-39) uf-log | CODSENTECA: TBC012.06 2023-05-29 09:28:38,018 INFO [com.datasul.technology.webdesk.customization.ScriptingLog] (default task-39) uf-log | CODCOLIGADA: 1 2023-05-29 09:28:38,018 INFO [com.datasul.technology.webdesk.customization.ScriptingLog] (default task-39) uf-log | APLICACAO: T 2023-05-29 09:28:38,018 INFO [com.datasul.technology.webdesk.customization.ScriptingLog] (default task-39) uf-log | PARAMETRO: 2023-05-29 09:28:38,126 INFO [com.datasul.technology.webdesk.customization.ScriptingLog] (default task-39) uf-log | Chamada realizada com sucesso. 2023-05-29 09:28:38,127 INFO [com.datasul.technology.webdesk.customization.ScriptingLog] (default task-39) uf-log | Quantidade de registros retornados: 13 2023-05-29 09:28:45,285 INFO [com.datasul.technology.webdesk.dataset.business.DatasetBO] (default task-39) Executando Dataset com ID ds_RMConsulta do tipo Avançado. 2023-05-29 09:28:45,285 INFO [com.datasul.technology.webdesk.dataset.business.DatasetBO] (default task-39) Builder rodando sem o mobile 2023-05-29 09:28:45,333 INFO [com.datasul.technology.webdesk.customization.ScriptingLog] (default task-39) uf-log | Chamada do DataSet ds_RMConsulta 2023-05-29 09:28:45,347 INFO [com.datasul.technology.webdesk.dataset.business.DatasetBO] (default task-39) Executando Dataset com ID ds_RMConecta do tipo Avançado. 2023-05-29 09:28:45,347 INFO [com.datasul.technology.webdesk.dataset.business.DatasetBO] (default task-39) Builder rodando sem o mobile 2023-05-29 09:28:45,402 INFO [org.apache.cxf.wsdl.service.factory.ReflectionServiceFactoryBean] (default task-39) Creating Service {http://www.totvs.com/}wsConsultaSQL from WSDL: http://peg54p-prd-ws.totvscloud.com.br:8083/wsConsultaSQL/MEX?wsdl 2023-05-29 09:28:45,415 WARNING [org.apache.cxf.wsdl.service.factory.ReflectionServiceFactoryBean] (default task-39) No method was found for the WSDL operation {http://www.totvs.com/}RealizarConsultaSQLContexto. 2023-05-29 09:28:45,421 INFO [org.apache.cxf.wsdl.service.factory.ReflectionServiceFactoryBean] (default task-39) Creating Service {http://www.totvs.com/}IwsConsultaSQLService from class com.totvs.IwsConsultaSQL 2023-05-29 09:28:45,426 INFO [com.datasul.technology.webdesk.customization.ScriptingLog] (default task-39) uf-log | Dados da chamada ao serviço wsConsultaSQL: 2023-05-29 09:28:45,426 INFO [com.datasul.technology.webdesk.customization.ScriptingLog] (default task-39) uf-log | CODSENTECA: TBC012.02 2023-05-29 09:28:45,426 INFO [com.datasul.technology.webdesk.customization.ScriptingLog] (default task-39) uf-log | CODCOLIGADA: 1 2023-05-29 09:28:45,426 INFO [com.datasul.technology.webdesk.customization.ScriptingLog] (default task-39) uf-log | APLICACAO: T 2023-05-29 09:28:45,426 INFO [com.datasul.technology.webdesk.customization.ScriptingLog] (default task-39) uf-log | PARAMETRO: COLIGADA=1 2023-05-29 09:28:45,508 INFO [com.datasul.technology.webdesk.customization.ScriptingLog] (default task-39) uf-log | Chamada realizada com sucesso. 2023-05-29 09:28:45,509 INFO [com.datasul.technology.webdesk.customization.ScriptingLog] (default task-39) uf-log | Quantidade de registros retornados: 23 2023-05-29 09:28:49,542 INFO [com.datasul.technology.webdesk.dataset.business.DatasetBO] (default task-39) Executando Dataset com ID ds_RMConsulta do tipo Avançado. 2023-05-29 09:28:49,542 INFO [com.datasul.technology.webdesk.dataset.business.DatasetBO] (default task-39) Builder rodando sem o mobile 2023-05-29 09:28:49,602 INFO [com.datasul.technology.webdesk.customization.ScriptingLog] (default task-39) uf-log | Chamada do DataSet ds_RMConsulta 2023-05-29 09:28:49,618 INFO [com.datasul.technology.webdesk.dataset.business.DatasetBO] (default task-39) Executando Dataset com ID ds_RMConecta do tipo Avançado. 2023-05-29 09:28:49,618 INFO [com.datasul.technology.webdesk.dataset.business.DatasetBO] (default task-39) Builder rodando sem o mobile 2023-05-29 09:28:49,672 INFO [org.apache.cxf.wsdl.service.factory.ReflectionServiceFactoryBean] (default task-39) Creating Service {http://www.totvs.com/}wsConsultaSQL from WSDL: http://peg54p-prd-ws.totvscloud.com.br:8083/wsConsultaSQL/MEX?wsdl 2023-05-29 09:28:49,685 WARNING [org.apache.cxf.wsdl.service.factory.ReflectionServiceFactoryBean] (default task-39) No method was found for the WSDL operation {http://www.totvs.com/}RealizarConsultaSQLContexto. 2023-05-29 09:28:49,691 INFO [org.apache.cxf.wsdl.service.factory.ReflectionServiceFactoryBean] (default task-39) Creating Service {http://www.totvs.com/}IwsConsultaSQLService from class com.totvs.IwsConsultaSQL 2023-05-29 09:28:49,697 INFO [com.datasul.technology.webdesk.customization.ScriptingLog] (default task-39) uf-log | Dados da chamada ao serviço wsConsultaSQL: 2023-05-29 09:28:49,697 INFO [com.datasul.technology.webdesk.customization.ScriptingLog] (default task-39) uf-log | CODSENTECA: TBC012.02 2023-05-29 09:28:49,697 INFO [com.datasul.technology.webdesk.customization.ScriptingLog] (default task-39) uf-log | CODCOLIGADA: 1 2023-05-29 09:28:49,697 INFO [com.datasul.technology.webdesk.customization.ScriptingLog] (default task-39) uf-log | APLICACAO: T 2023-05-29 09:28:49,697 INFO [com.datasul.technology.webdesk.customization.ScriptingLog] (default task-39) uf-log | PARAMETRO: COLIGADA=1 2023-05-29 09:28:49,808 INFO [com.datasul.technology.webdesk.customization.ScriptingLog] (default task-39) uf-log | Chamada realizada com sucesso. 2023-05-29 09:28:49,808 INFO [com.datasul.technology.webdesk.customization.ScriptingLog] (default task-39) uf-log | Quantidade de registros retornados: 23 2023-05-29 09:28:52,435 INFO [com.datasul.technology.webdesk.dataset.business.DatasetBO] (default task-39) Executando Dataset com ID ds_RMConsulta do tipo Avançado. 2023-05-29 09:28:52,436 INFO [com.datasul.technology.webdesk.dataset.business.DatasetBO] (default task-39) Builder rodando sem o mobile 2023-05-29 09:28:52,481 INFO [com.datasul.technology.webdesk.customization.ScriptingLog] (default task-39) uf-log | Chamada do DataSet ds_RMConsulta 2023-05-29 09:28:52,494 INFO [com.datasul.technology.webdesk.dataset.business.DatasetBO] (default task-39) Executando Dataset com ID ds_RMConecta do tipo Avançado. 2023-05-29 09:28:52,494 INFO [com.datasul.technology.webdesk.dataset.business.DatasetBO] (default task-39) Builder rodando sem o mobile 2023-05-29 09:28:52,549 INFO [org.apache.cxf.wsdl.service.factory.ReflectionServiceFactoryBean] (default task-39) Creating Service {http://www.totvs.com/}wsConsultaSQL from WSDL: http://peg54p-prd-ws.totvscloud.com.br:8083/wsConsultaSQL/MEX?wsdl 2023-05-29 09:28:52,561 WARNING [org.apache.cxf.wsdl.service.factory.ReflectionServiceFactoryBean] (default task-39) No method was found for the WSDL operation {http://www.totvs.com/}RealizarConsultaSQLContexto. 2023-05-29 09:28:52,567 INFO [org.apache.cxf.wsdl.service.factory.ReflectionServiceFactoryBean] (default task-39) Creating Service {http://www.totvs.com/}IwsConsultaSQLService from class com.totvs.IwsConsultaSQL 2023-05-29 09:28:52,573 INFO [com.datasul.technology.webdesk.customization.ScriptingLog] (default task-39) uf-log | Dados da chamada ao serviço wsConsultaSQL: 2023-05-29 09:28:52,573 INFO [com.datasul.technology.webdesk.customization.ScriptingLog] (default task-39) uf-log | CODSENTECA: TBC012.13 2023-05-29 09:28:52,573 INFO [com.datasul.technology.webdesk.customization.ScriptingLog] (default task-39) uf-log | CODCOLIGADA: 1 2023-05-29 09:28:52,573 INFO [com.datasul.technology.webdesk.customization.ScriptingLog] (default task-39) uf-log | APLICACAO: T 2023-05-29 09:28:52,573 INFO [com.datasul.technology.webdesk.customization.ScriptingLog] (default task-39) uf-log | PARAMETRO: CODIGO=16;OPERACAO=03;COLIGADA=1 2023-05-29 09:28:53,450 INFO [com.datasul.technology.webdesk.customization.ScriptingLog] (default task-39) uf-log | Chamada realizada com sucesso. 2023-05-29 09:28:53,450 INFO [com.datasul.technology.webdesk.customization.ScriptingLog] (default task-39) uf-log | Quantidade de registros retornados: 26 2023-05-29 09:28:53,491 INFO [com.fluig.monitoring.jschronos.JSChronos] (default task-39) CustomizationManagerImpl.invokeFunction.createDataset executou por 1 segundo 2023-05-29 09:28:53,491 INFO [com.fluig.monitoring.jschronos.JSChronos] (default task-39) DatasetFactory.getDataset.ds_RMConsulta executou por 1 segundo 2023-05-29 09:29:00,484 INFO [com.datasul.technology.webdesk.dataset.business.DatasetBO] (default task-39) Executando Dataset com ID ds_RMConsulta do tipo Avançado. 2023-05-29 09:29:00,484 INFO [com.datasul.technology.webdesk.dataset.business.DatasetBO] (default task-39) Builder rodando sem o mobile 2023-05-29 09:29:00,531 INFO [com.datasul.technology.webdesk.customization.ScriptingLog] (default task-39) uf-log | Chamada do DataSet ds_RMConsulta 2023-05-29 09:29:00,546 INFO [com.datasul.technology.webdesk.dataset.business.DatasetBO] (default task-39) Executando Dataset com ID ds_RMConecta do tipo Avançado. 2023-05-29 09:29:00,546 INFO [com.datasul.technology.webdesk.dataset.business.DatasetBO] (default task-39) Builder rodando sem o mobile 2023-05-29 09:29:00,603 INFO [org.apache.cxf.wsdl.service.factory.ReflectionServiceFactoryBean] (default task-39) Creating Service {http://www.totvs.com/}wsConsultaSQL from WSDL: http://peg54p-prd-ws.totvscloud.com.br:8083/wsConsultaSQL/MEX?wsdl 2023-05-29 09:29:00,620 WARNING [org.apache.cxf.wsdl.service.factory.ReflectionServiceFactoryBean] (default task-39) No method was found for the WSDL operation {http://www.totvs.com/}RealizarConsultaSQLContexto. 2023-05-29 09:29:00,626 INFO [org.apache.cxf.wsdl.service.factory.ReflectionServiceFactoryBean] (default task-39) Creating Service {http://www.totvs.com/}IwsConsultaSQLService from class com.totvs.IwsConsultaSQL 2023-05-29 09:29:00,631 INFO [com.datasul.technology.webdesk.customization.ScriptingLog] (default task-39) uf-log | Dados da chamada ao serviço wsConsultaSQL: 2023-05-29 09:29:00,631 INFO [com.datasul.technology.webdesk.customization.ScriptingLog] (default task-39) uf-log | CODSENTECA: TBC012.13 2023-05-29 09:29:00,631 INFO [com.datasul.technology.webdesk.customization.ScriptingLog] (default task-39) uf-log | CODCOLIGADA: 1 2023-05-29 09:29:00,631 INFO [com.datasul.technology.webdesk.customization.ScriptingLog] (default task-39) uf-log | APLICACAO: T 2023-05-29 09:29:00,631 INFO [com.datasul.technology.webdesk.customization.ScriptingLog] (default task-39) uf-log | PARAMETRO: CODIGO=16;OPERACAO=03;COLIGADA=1 2023-05-29 09:29:01,102 INFO [com.datasul.technology.webdesk.customization.ScriptingLog] (default task-39) uf-log | Chamada realizada com sucesso. 2023-05-29 09:29:01,102 INFO [com.datasul.technology.webdesk.customization.ScriptingLog] (default task-39) uf-log | Quantidade de registros retornados: 26 2023-05-29 09:29:50,493 INFO [com.datasul.technology.webdesk.dataset.business.DatasetBO] (default task-39) Executando Dataset com ID ds_generic_rm_sql do tipo Avançado. 2023-05-29 09:29:50,493 INFO [com.datasul.technology.webdesk.dataset.business.DatasetBO] (default task-39) Builder rodando sem o mobile 2023-05-29 09:29:50,541 INFO [com.datasul.technology.webdesk.customization.ScriptingLog] (default task-39) @ds_generic_rm_sql diz: Inicio 2023-05-29 09:29:50,557 INFO [com.datasul.technology.webdesk.dataset.business.DatasetBO] (default task-39) Executando Dataset com ID dsConnector do tipo Avançado. 2023-05-29 09:29:50,557 INFO [com.datasul.technology.webdesk.dataset.business.DatasetBO] (default task-39) Builder rodando sem o mobile 2023-05-29 09:29:50,610 INFO [com.datasul.technology.webdesk.customization.ScriptingLog] (default task-39) @name: CODSENTENCA Value: TBC012.12 2023-05-29 09:29:50,610 INFO [com.datasul.technology.webdesk.customization.ScriptingLog] (default task-39) @name: CODCOLIGADA Value: 1 2023-05-29 09:29:50,610 INFO [com.datasul.technology.webdesk.customization.ScriptingLog] (default task-39) @name: CODAPLICACAO Value: T 2023-05-29 09:29:50,610 INFO [com.datasul.technology.webdesk.customization.ScriptingLog] (default task-39) @name: CODIGO Value: 36.04.02.0022 2023-05-29 09:29:50,610 INFO [com.datasul.technology.webdesk.customization.ScriptingLog] (default task-39) params: CODIGO=36.04.02.0022; 2023-05-29 09:29:50,610 INFO [com.datasul.technology.webdesk.customization.ScriptingLog] (default task-39) @name: TIPO Value: 03 2023-05-29 09:29:50,610 INFO [com.datasul.technology.webdesk.customization.ScriptingLog] (default task-39) params: CODIGO=36.04.02.0022;TIPO=03; 2023-05-29 09:29:50,610 INFO [com.datasul.technology.webdesk.customization.ScriptingLog] (default task-39) @name: COLIGADA Value: 1 2023-05-29 09:29:50,611 INFO [com.datasul.technology.webdesk.customization.ScriptingLog] (default task-39) params: CODIGO=36.04.02.0022;TIPO=03;COLIGADA=1; 2023-05-29 09:29:50,611 INFO [com.datasul.technology.webdesk.customization.ScriptingLog] (default task-39) @name: LOCAL Value: 127.11.003 2023-05-29 09:29:50,611 INFO [com.datasul.technology.webdesk.customization.ScriptingLog] (default task-39) params: CODIGO=36.04.02.0022;TIPO=03;COLIGADA=1;LOCAL=127.11.003; 2023-05-29 09:29:50,611 INFO [com.datasul.technology.webdesk.customization.ScriptingLog] (default task-39) @name: FILIAL Value: 16 2023-05-29 09:29:50,611 INFO [com.datasul.technology.webdesk.customization.ScriptingLog] (default task-39) params: CODIGO=36.04.02.0022;TIPO=03;COLIGADA=1;LOCAL=127.11.003;FILIAL=16; 2023-05-29 09:29:50,611 INFO [com.datasul.technology.webdesk.customization.ScriptingLog] (default task-39) PARAMS: CODIGO=36.04.02.0022;TIPO=03;COLIGADA=1;LOCAL=127.11.003;FILIAL=16; 2023-05-29 09:29:50,613 INFO [org.apache.cxf.wsdl.service.factory.ReflectionServiceFactoryBean] (default task-39) Creating Service {http://www.totvs.com.br/br/}wsConsultaSQL from WSDL: http://peg54p-prd-ws.totvscloud.com.br:8082/TOTVSBusinessConnect/wsConsultaSQL.asmx?wsdl 2023-05-29 09:29:51,026 INFO [com.datasul.technology.webdesk.customization.ScriptingLog] (default task-39) @ds_generic_rm_sql diz: XML retornada pelo RM: <NewDataSet> 2023-05-29 09:30:20,792 INFO [com.datasul.technology.webdesk.dataset.business.DatasetBO] (default task-39) Executando Dataset com ID ds_RMConsulta do tipo Avançado. 2023-05-29 09:30:20,793 INFO [com.datasul.technology.webdesk.dataset.business.DatasetBO] (default task-39) Builder rodando sem o mobile 2023-05-29 09:30:20,840 INFO [com.datasul.technology.webdesk.customization.ScriptingLog] (default task-39) uf-log | Chamada do DataSet ds_RMConsulta 2023-05-29 09:30:20,854 INFO [com.datasul.technology.webdesk.dataset.business.DatasetBO] (default task-39) Executando Dataset com ID ds_RMConecta do tipo Avançado. 2023-05-29 09:30:20,855 INFO [com.datasul.technology.webdesk.dataset.business.DatasetBO] (default task-39) Builder rodando sem o mobile 2023-05-29 09:30:20,906 INFO [org.apache.cxf.wsdl.service.factory.ReflectionServiceFactoryBean] (default task-39) Creating Service {http://www.totvs.com/}wsConsultaSQL from WSDL: http://peg54p-prd-ws.totvscloud.com.br:8083/wsConsultaSQL/MEX?wsdl 2023-05-29 09:30:20,919 WARNING [org.apache.cxf.wsdl.service.factory.ReflectionServiceFactoryBean] (default task-39) No method was found for the WSDL operation {http://www.totvs.com/}RealizarConsultaSQLContexto. 2023-05-29 09:30:20,925 INFO [org.apache.cxf.wsdl.service.factory.ReflectionServiceFactoryBean] (default task-39) Creating Service {http://www.totvs.com/}IwsConsultaSQLService from class com.totvs.IwsConsultaSQL 2023-05-29 09:30:20,931 INFO [com.datasul.technology.webdesk.customization.ScriptingLog] (default task-39) uf-log | Dados da chamada ao serviço wsConsultaSQL: 2023-05-29 09:30:20,931 INFO [com.datasul.technology.webdesk.customization.ScriptingLog] (default task-39) uf-log | CODSENTECA: TBC012.05 2023-05-29 09:30:20,931 INFO [com.datasul.technology.webdesk.customization.ScriptingLog] (default task-39) uf-log | CODCOLIGADA: 1 2023-05-29 09:30:20,931 INFO [com.datasul.technology.webdesk.customization.ScriptingLog] (default task-39) uf-log | APLICACAO: T 2023-05-29 09:30:20,931 INFO [com.datasul.technology.webdesk.customization.ScriptingLog] (default task-39) uf-log | PARAMETRO: COLIGADA=1 2023-05-29 09:30:21,647 INFO [com.datasul.technology.webdesk.customization.ScriptingLog] (default task-39) uf-log | Chamada realizada com sucesso. 2023-05-29 09:30:21,648 INFO [com.datasul.technology.webdesk.customization.ScriptingLog] (default task-39) uf-log | Quantidade de registros retornados: 3479 2023-05-29 09:30:53,414 WARN [com.fluigWARN [com.fluig.monitoring.jschronos.JSChronos] (default task-39) CustomizationManagerImpl.invokeFunction.createDataset executou por 32 segundos 2023-05-29 09:30:53,414 WARN [com.fluig.monitoring.jschronos.JSChronos] (default task-39) params: [[[Ljava.lang.String;@6c45e716, [Lcom.totvs.technology.foundation.dataset.SearchConstraint;@a1b6a73, null], Thread = default task-39, datasetId = ds_RMConsulta] 2023-05-29 09:30:53,437 WARN [com.fluig.monitoring.jschronos.JSChronos] (default task-39) DatasetFactory.getDataset.ds_RMConsulta executou por 32 segundos 2023-05-29 09:30:53,437 WARN [com.fluig.monitoring.jschronos.JSChronos] (default task-39) params: [[TBC012.05, 1, T], [FIELD_NAME=COLIGADA; INITIAL_VALUE=1; FINAL_VALUE=1; CONSTRAINT_TYPE=MUST; IS_LIKE_SEARCH=false; ], null] 2023-05-29 09:31:24,672 INFO [com.datasul.technology.webdesk.dataset.business.DatasetBO] (default task-39) Executando Dataset com ID ds_RMConsulta do tipo Avançado. 2023-05-29 09:31:24,672 INFO [com.datasul.technology.webdesk.dataset.business.DatasetBO] (default task-39) Builder rodando sem o mobile 2023-05-29 09:31:24,719 INFO [com.datasul.technology.webdesk.customization.ScriptingLog] (default task-39) uf-log | Chamada do DataSet ds_RMConsulta 2023-05-29 09:31:24,734 INFO [com.datasul.technology.webdesk.dataset.business.DatasetBO] (default task-39) Executando Dataset com ID ds_RMConecta do tipo Avançado. 2023-05-29 09:31:24,735 INFO [com.datasul.technology.webdesk.dataset.business.DatasetBO] (default task-39) Builder rodando sem o mobile 2023-05-29 09:31:24,786 INFO [org.apache.cxf.wsdl.service.factory.ReflectionServiceFactoryBean] (default task-39) Creating Service {http://www.totvs.com/}wsConsultaSQL from WSDL: http://peg54p-prd-ws.totvscloud.com.br:8083/wsConsultaSQL/MEX?wsdl 2023-05-29 09:31:24,800 WARNING [org.apache.cxf.wsdl.service.factory.ReflectionServiceFactoryBean] (default task-39) No method was found for the WSDL operation {http://www.totvs.com/}RealizarConsultaSQLContexto. 2023-05-29 09:31:24,805 INFO [org.apache.cxf.wsdl.service.factory.ReflectionServiceFactoryBean] (default task-39) Creating Service {http://www.totvs.com/}IwsConsultaSQLService from class com.totvs.IwsConsultaSQL 2023-05-29 09:31:24,812 INFO [com.datasul.technology.webdesk.customization.ScriptingLog] (default task-39) uf-log | Dados da chamada ao serviço wsConsultaSQL: 2023-05-29 09:31:24,812 INFO [com.datasul.technology.webdesk.customization.ScriptingLog] (default task-39) uf-log | CODSENTECA: TBC012.03 2023-05-29 09:31:24,812 INFO [com.datasul.technology.webdesk.customization.ScriptingLog] (default task-39) uf-log | CODCOLIGADA: 1 2023-05-29 09:31:24,812 INFO [com.datasul.technology.webdesk.customization.ScriptingLog] (default task-39) uf-log | APLICACAO: T 2023-05-29 09:31:24,812 INFO [com.datasul.technology.webdesk.customization.ScriptingLog] (default task-39) uf-log | PARAMETRO: 2023-05-29 09:31:24,922 INFO [com.datasul.technology.webdesk.customization.ScriptingLog] (default task-39) uf-log | Chamada realizada com sucesso. 2023-05-29 09:31:24,923 INFO [com.datasul.technology.webdesk.customization.ScriptingLog] (default task-39) uf-log | Quantidade de registros retornados: 57 |
...
02. O <max-pool-size> pode ser ajustado entre 50-200 nos datasources. É possível utilizar um <max-pool-size> menor, quando houver mais de um banco de dados no mesmo servidor.
Bloco de código | ||||
---|---|---|---|---|
| ||||
<datasources> <datasource jta="true" jndi-name="java:/jdbc/FluigDS" pool-name="FluigDS" enabled="true" use-java-context="false"> <connection-url>jdbc:mysql://localhost:3306/fluig_mysql?useSSL=false&nullDatabaseMeansCurrent=true</connection-url> <driver>mysqlDriver</driver> <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation> <pool> <min-pool-size>10</min-pool-size> <max-pool-size>100</max-pool-size> </pool> <security> <user-name>admin</user-name> <password>admin</password> </security> <validation> <valid-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.mysql.MySQLValidConnectionChecker"/> <validate-on-match>true</validate-on-match> <background-validation>false</background-validation> </validation> <statement> <share-prepared-statements>false</share-prepared-statements> </statement> </datasource> <datasource jta="false" jndi-name="java:/jdbc/FluigDSRO" pool-name="FluigDSRO" enabled="true" use-java-context="false"> <connection-url>jdbc:mysql://localhost:3306/fluig_mysql?useSSL=false&nullDatabaseMeansCurrent=true</connection-url> <driver>mysqlDriver</driver> <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation> <pool> <min-pool-size>5</min-pool-size> <max-pool-size>50</max-pool-size> </pool> <security> <user-name>admin</user-name> <password>admin</password> </security> <validation> <valid-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.mysql.MySQLValidConnectionChecker"/> <validate-on-match>true</validate-on-match> <background-validation>false</background-validation> </validation> <timeout> <blocking-timeout-millis>30000</blocking-timeout-millis> </timeout> <statement> <share-prepared-statements>false</share-prepared-statements> </statement> </datasource> <datasource jta="false" jndi-name="java:/jdbc/AppDS" pool-name="AppDS" enabled="true" use-java-context="false"> <connection-url>jdbc:mysql://localhost:3306/fluig_mysql?useSSL=false&nullDatabaseMeansCurrent=true</connection-url> <driver>mysqlDriver</driver> <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation> <pool> <min-pool-size>5</min-pool-size> <max-pool-size>150</max-pool-size> </pool> <security> <user-name>admin</user-name> <password>admin</password> </security> <validation> <valid-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.mysql.MySQLValidConnectionChecker"/> <validate-on-match>true</validate-on-match> <background-validation>false</background-validation> </validation> <timeout> <blocking-timeout-millis>30000</blocking-timeout-millis> </timeout> <statement> <share-prepared-statements>false</share-prepared-statements> </statement> </datasource> <drivers> <driver name="mysqlDriver" module="com.mysql"> <driver-class>com.mysql.jdbc.Driver</driver-class> </driver> </drivers> </datasources> |
...
01. O host.xml pode ser consultado em: <diretório de instalação do Fluig>\appserver\domain\configuration\host.xml.
02. Por padrão. O o tamanho de memória que o servidor consome pode ser alterado. Recomendamos utilizar os valores: vem ajustado em: max-size em ="4g e size em 2g." e size="2g, porém, é possível alterar esses valores:
Bloco de código | ||||
---|---|---|---|---|
| ||||
<server auto-start="true" group="fluig" name="fluig1"> <jvm name="default"> <heap max-size="4g8g" size="2g3g"/> <jvm-options> <option value="-Dfile.encoding=utf8"/> <option value="-XX:MaxMetaspaceSize=1024m"/> <option value="-Djavamelody.disabled=true"/> <!-- Debug <option value="-Xdebug"/> <option value="-Xrunjdwp:transport=dt_socket,address=8787,server=y,suspend=n"/> --> </jvm-options> </jvm> </server> |
03. O Fluig suporta até 16 GB de memória, sendo essa, uma limitação do JBoss. Caso o seu servidor de aplicação tenha mais de 16 GB de memória, recomendamos o uso de um cluster para distribuir os recursos.
Saiba mais em: Alta disponibilidade e Balanceamento de carga
04. Não é preciso alterar a quantidade inicial (mínima) de memória alocada (size="2g"), pois a plataforma alocará memória de acordo com a necessidade.
...
02. Customizações onerosas no diretório: <diretório de instalação do Fluig>\appserver\apps.
03. Carência de atualização da plataforma.. Plataforma desatualizada.
04. Problemas na Configuração HTTPS da plataforma.
05. Problemas na Configuração de Proxy Reverso.
06. Excesso de consultas em datasets, pois podem gerar estresse desnecessário ao banco de dados.