Software Público Brasileiro

Eduardo

Após a atualização 3.1.18b3 do Gerente e upload do Agente 3.1.18b2, ficamos com o ambiente inconsistente.
Envio abaixo os logs
Notei que os arquivos do agente 3.1.18b2 são bem menores. É assim mesmo? Está correto?
Nas estações onde ocorreu a atualização automática, o serviço parou e ao tentar iniciar manualmente exibe a mensagem da imagem em anexo.

Data Local/Rede Estação Sistema Operacional Nível Mensagem
1 07/10/2015 15:07 EMATER / Central 192.168.0.6 Microsoft Windows 7 Professional error [Error] {Cacic Daemon (Timer)} Falha na coleta: Error downloading https://cacic.emater.tche.br/cacic/app_dev.php/ws/neo/coleta - server replied: Internal Server Error
2 07/10/2015 15:07 EMATER / Central 192.168.0.6 Microsoft Windows 7 Professional error [Error] {Check Cacic} Falha ao excluir m?dulo antigochksys.exe da pasta tempor?ria.
3 07/10/2015 15:06 EMATER / Central 192.168.0.6 Microsoft Windows 7 Professional error [Error] {Check Cacic} Falha ao excluir m?dulo antigochksys.exe da pasta tempor?ria.
4 07/10/2015 15:05 EMATER / Central 192.168.0.6 Microsoft Windows 7 Professional error [Error] {Cacic Daemon (Timer)} Falha ao excluir m?dulo antigo chksys.exe da pasta tempor?ria.
5 07/10/2015 15:05 EMATER / Central 192.168.0.6 Microsoft Windows 7 Professional error [Error] {Cacic Daemon (Timer)} Falha ao enviar logs para o gerente: Arquivo de Log vazio ou inexistente.
6 07/10/2015 15:05 EMATER / Central 192.168.0.6 Microsoft Windows 7 Professional error [Error] {Cacic Daemon (Timer)} Falha na coleta: Error downloading https://cacic.emater.tche.br/cacic/app_dev.php/ws/neo/coleta - server replied: Internal Server Error
7 07/10/2015 15:00 EMATER / Central 192.168.0.6 Microsoft Windows 7 Professional error [Error] {Cacic Daemon (Timer)} Falha ao enviar logs para o gerente: Arquivo de Log vazio ou inexistente.
8 07/10/2015 15:00 EMATER / Central 192.168.0.6 Microsoft Windows 7 Professional error [Error] {Cacic Daemon (Timer)} Falha na coleta: Error downloading https://cacic.emater.tche.br/cacic/app_dev.php/ws/neo/coleta - server replied: Internal Server Error
9 07/10/2015 15:00 EMATER / Central 192.168.0.6 Microsoft Windows 7 Professional error [Error] {Cacic Daemon (Timer)} Problemas ao checkar m?dulos.
10 07/10/2015 15:00 EMATER / Central 192.168.0.6 Microsoft Windows 7 Professional error [Error] {CheckModules} #5 Problemas durante o download de install-cacic.exe
11 07/10/2015 15:12 EMATER / Central 192.168.0.6 Microsoft Windows 7 Professional error [Error] {Cacic Daemon (Timer)} Falha na coleta: Error downloading https://cacic.emater.tche.br/cacic/app_dev.php/ws/neo/coleta - server replied: Internal Server Error
12 07/10/2015 15:12 EMATER / Central 192.168.0.6 Microsoft Windows 7 Professional error [Error] {Check Cacic} Falha ao excluir m?dulo antigochksys.exe da pasta tempor?ria.
13 07/10/2015 15:11 EMATER / Central 192.168.0.6 Microsoft Windows 7 Professional error [Error] {Check Cacic} Falha ao excluir m?dulo antigochksys.exe da pasta tempor?ria.
14 07/10/2015 15:10 EMATER / Central 192.168.0.6 Microsoft Windows 7 Professional error [Error] {Check Cacic} Falha ao excluir m?dulo antigochksys.exe da pasta tempor?ria.
15 07/10/2015 15:09 EMATER / Central 192.168.0.6 Microsoft Windows 7 Professional error [Error] {Check Cacic} Falha ao excluir m?dulo antigochksys.exe da pasta tempor?ria.
16 07/10/2015 15:08 EMATER / Central 192.168.0.6 Microsoft Windows 7 Professional error [Error] {Check Cacic} Falha ao excluir m?dulo antigochksys.exe da pasta tempor?ria.
17 07/10/2015 15:07 EMATER / Central 192.168.0.6 Microsoft Windows 7 Professional error [Error] {Cacic Daemon (Timer)} Falha ao excluir m?dulo antigo chksys.exe da pasta tempor?ria.
18 07/10/2015 15:13 EMATER / Central 10.1.1.203 Microsoft Windows 7 Professional error [Error] {Cacic Daemon (Timer)} Falha na coleta: Error downloading https://cacic.emater.tche.br/cacic/app_dev.php/ws/neo/coleta - server replied: Internal Server Error
19 07/10/2015 15:08 EMATER / Central 10.1.1.203 Microsoft Windows 7 Professional error [Error] {Cacic Daemon (Timer)} Falha ao enviar logs para o gerente: Arquivo de Log vazio ou inexistente.
20 07/10/2015 15:08 EMATER / Central 10.1.1.203 Microsoft Windows 7 Professional error [Error] {Cacic Daemon (Timer)} Falha na coleta: Error downloading https://cacic.emater.tche.br/cacic/app_dev.php/ws/neo/coleta - server replied: Internal Server Error
21 07/10/2015 15:06 EMATER / Central 10.1.1.203 Microsoft Windows 7 Professional error [Error] {Cacic Daemon (Timer)} Falha ao enviar logs para o gerente: Arquivo de Log vazio ou inexistente.
22 07/10/2015 15:06 EMATER / Central 10.1.1.203 Microsoft Windows 7 Professional error [Error] {Cacic Daemon (Timer)} Falha na coleta: Error downloading https://cacic.emater.tche.br/cacic/app_dev.php/ws/neo/coleta - server replied: Internal Server Error
23 07/10/2015 15:01 EMATER / Central 10.1.1.203 Microsoft Windows 7 Professional error [Error] {Cacic Daemon (Timer)} Falha ao enviar logs para o gerente: Arquivo de Log vazio ou inexistente.
24 07/10/2015 15:01 EMATER / Central 10.1.1.203 Microsoft Windows 7 Professional error [Error] {Cacic Daemon (Timer)} Falha na coleta: Error downloading https://cacic.emater.tche.br/cacic/app_dev.php/ws/neo/coleta - server replied: Internal Server Error
25 07/10/2015 15:01 EMATER / Central 10.1.1.203 Microsoft Windows 7 Professional error [Error] {Check Cacic} Falha ao excluir m?dulo antigochksys.exe da pasta tempor?ria.
26 07/10/2015 15:01 EMATER / Central 10.1.1.203 Microsoft Windows 7 Professional error [Error] {Cacic Daemon (Timer)} Problemas ao checkar m?dulos.
27 07/10/2015 15:01 EMATER / Central 10.1.1.203 Microsoft Windows 7 Professional error [Error] {CheckModules} #5 Problemas durante o download de install-cacic.exe
28 07/10/2015 15:14 EMATER / Central 192.168.10.104 Microsoft Windows 7 Professional error [Error] {Cacic Daemon (Timer)} Falha na coleta: Error downloading https://cacic.emater.tche.br/cacic/app_dev.php/ws/neo/coleta - server replied: Internal Server Error
29 07/10/2015 15:09 EMATER / Central 192.168.10.104 Microsoft Windows 7 Professional error [Error] {Cacic Daemon (Timer)} Falha ao enviar logs para o gerente: Arquivo de Log vazio ou inexistente.
30 07/10/2015 15:09 EMATER / Central 192.168.10.104 Microsoft Windows 7 Professional error [Error] {Cacic Daemon (Timer)} Falha na coleta: Error downloading https://cacic.emater.tche.br/cacic/app_dev.php/ws/neo/coleta - server replied: Internal Server Error
31 07/10/2015 15:06 EMATER / Central 192.168.10.104 Microsoft Windows 7 Professional error [Error] {Check Cacic} Falha ao excluir m?dulo antigocacic-service.exe da pasta tempor?ria.
32 07/10/2015 15:06 EMATER / Central 192.168.10.104 Microsoft Windows 7 Professional error [Error] {Check Cacic} Falha ao parar servi?o. Info: Stop Service Failed: Desconhecido
33 07/10/2015 15:06 EMATER / Central 192.168.10.104 Microsoft Windows 7 Professional error [Error] {Check Cacic} Falha ao excluir m?dulo antigochksys.exe da pasta tempor?ria.
34 07/10/2015 15:06 EMATER / Central 192.168.10.104 Microsoft Windows 7 Professional error [Error] {Check Cacic} Falha ao excluir install-cacic.exe da pasta tempor?ria.
35 07/10/2015 15:01 EMATER / Central 192.168.10.104 Microsoft Windows 7 Professional error [Error] {Cacic Daemon (Timer)} Falha ao enviar logs para o gerente: Arquivo de Log vazio ou inexistente.
36 07/10/2015 15:01 EMATER / Central 192.168.10.104 Microsoft Windows 7 Professional error [Error] {Cacic Daemon (Timer)} Falha na coleta: Error downloading https://cacic.emater.tche.br/cacic/app_dev.php/ws/neo/coleta - server replied: Internal Server Error
37 07/10/2015 15:01 EMATER / Central 192.168.10.104 Microsoft Windows 7 Professional error [Error] {Cacic Daemon (Timer)} Problemas ao checkar m?dulos.


Date Message
October 7 16:06:33 9 Matched route "cacic_computador_detalhar". request.INFO
October 7 16:06:33 4 Uncaught PHP Exception Doctrine\DBAL\DBALException: "An exception occurred while executing 'SELECT p0_.display_name AS display_name0, p0_.display_version AS display_version1, p0_.url_info_about AS url_info_about2, p0_.publisher AS publisher3, c1_.id_computador_coleta AS id_computador_coleta4, c1_.te_class_property_value AS te_class_property_value5, c1_.dt_hr_inclusao AS dt_hr_inclusao6, c1_.ativo AS ativo7, c1_.dt_hr_exclusao AS dt_hr_exclusao8, c2_.id_class_property AS id_class_property9, c2_.nm_property_name AS nm_property_name10, c2_.pretty_name AS pretty_name11, c2_.te_property_description AS te_property_description12, c2_.nm_function_pre_db AS nm_function_pre_db13, c2_.nm_function_pos_db AS nm_function_pos_db14, c2_.ativo AS ativo15, c3_.id_class AS id_class16, c3_.nm_class_name AS nm_class_name17, c3_.te_class_description AS te_class_description18, c1_.id_computador AS id_computador19, c1_.id_class_property AS id_class_property20, c1_.id_class AS id_class21, c2_.id_class AS id_class22 FROM computador_coleta c1_ INNER JOIN class_property c2_ ON c1_.id_class_property = c2_.id_class_property INNER JOIN classe c3_ ON c2_.id_class = c3_.id_class INNER JOIN computador c4_ ON (c1_.id_computador = c4_.id_computador) LEFT JOIN proriedade_software p0_ ON ((c2_.id_class_property = p0_.id_class_property AND c1_.id_computador = p0_.id_computador)) WHERE c1_.id_computador = (?) ORDER BY c3_.nm_class_name ASC, c2_.nm_property_name ASC' with params [8]: SQLSTATE[42703]: Undefined column: 7 ERROR: column c1_.ativo does not exist LINE 1: ...ty_value5, c1_.dt_hr_inclusao AS dt_hr_inclusao6, c1_.ativo ... ^" at /srv/cacic/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 91 request.CRITICAL
October 7 16:06:33 10 Read existing security token from the session. security.DEBUG
October 7 16:06:33 10 Stored the security token in the session. security.DEBUG
October 7 16:06:33 10 User was reloaded from a user provider. security.DEBUG
October 7 16:06:33 10 No expression found; abstaining from voting. security.INFO
October 7 16:06:32 8 Uncaught PHP Exception Symfony\Component\HttpKernel\Exception\NotFoundHttpException: "No route found for "GET /relatorio/computador/undefinednotifications/get" (from "https://cacic.emater.tche.br/cacic/app.php/relatorio/computador/listar")" at /srv/cacic/app/cache/prod/classes.php line 2499 request.ERROR
October 7 16:02:43 1 Uncaught PHP Exception Symfony\Component\HttpKernel\Exception\NotFoundHttpException: "No route found for "GET /relatorio/so/detalhar/undefinednotifications/get" (from "https://cacic.emater.tche.br/cacic/app.php/relatorio/so/detalhar/1")" at /srv/cacic/app/cache/prod/classes.php line 2499 request.ERROR
October 7 16:02:31 1 Uncaught PHP Exception Symfony\Component\HttpKernel\Exception\NotFoundHttpException: "No route found for "GET /relatorio/so/detalhar/undefinednotifications/get" (from "https://cacic.emater.tche.br/cacic/app.php/relatorio/so/detalhar/2")" at /srv/cacic/app/cache/prod/classes.php line 2499 request.ERROR
October 7 15:49:53 1 Uncaught PHP Exception Doctrine\DBAL\DBALException: "An exception occurred while executing 'SELECT p0_.display_name AS display_name0, p0_.display_version AS display_version1, p0_.url_info_about AS url_info_about2, p0_.publisher AS publisher3, c1_.id_computador_coleta AS id_computador_coleta4, c1_.te_class_property_value AS te_class_property_value5, c1_.dt_hr_inclusao AS dt_hr_inclusao6, c1_.ativo AS ativo7, c1_.dt_hr_exclusao AS dt_hr_exclusao8, c2_.id_class_property AS id_class_property9, c2_.nm_property_name AS nm_property_name10, c2_.pretty_name AS pretty_name11, c2_.te_property_description AS te_property_description12, c2_.nm_function_pre_db AS nm_function_pre_db13, c2_.nm_function_pos_db AS nm_function_pos_db14, c2_.ativo AS ativo15, c3_.id_class AS id_class16, c3_.nm_class_name AS nm_class_name17, c3_.te_class_description AS te_class_description18, c1_.id_computador AS id_computador19, c1_.id_class_property AS id_class_property20, c1_.id_class AS id_class21, c2_.id_class AS id_class22 FROM computador_coleta c1_ INNER JOIN class_property c2_ ON c1_.id_class_property = c2_.id_class_property INNER JOIN classe c3_ ON c2_.id_class = c3_.id_class INNER JOIN computador c4_ ON (c1_.id_computador = c4_.id_computador) LEFT JOIN proriedade_software p0_ ON ((c2_.id_class_property = p0_.id_class_property AND c1_.id_computador = p0_.id_computador)) WHERE c1_.id_computador = (?) ORDER BY c3_.nm_class_name ASC, c2_.nm_property_name ASC' with params [58]: SQLSTATE[42703]: Undefined column: 7 ERROR: column c1_.ativo does not exist LINE 1: ...ty_value5, c1_.dt_hr_inclusao AS dt_hr_inclusao6, c1_.ativo ... ^" at /srv/cacic/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 91 request.CRITICAL
October 7 15:44:38 3 Uncaught PHP Exception Doctrine\DBAL\DBALException: "An exception occurred while executing 'SELECT p0_.display_name AS display_name0, p0_.display_version AS display_version1, p0_.url_info_about AS url_info_about2, p0_.publisher AS publisher3, c1_.id_computador_coleta AS id_computador_coleta4, c1_.te_class_property_value AS te_class_property_value5, c1_.dt_hr_inclusao AS dt_hr_inclusao6, c1_.ativo AS ativo7, c1_.dt_hr_exclusao AS dt_hr_exclusao8, c2_.id_class_property AS id_class_property9, c2_.nm_property_name AS nm_property_name10, c2_.pretty_name AS pretty_name11, c2_.te_property_description AS te_property_description12, c2_.nm_function_pre_db AS nm_function_pre_db13, c2_.nm_function_pos_db AS nm_function_pos_db14, c2_.ativo AS ativo15, c3_.id_class AS id_class16, c3_.nm_class_name AS nm_class_name17, c3_.te_class_description AS te_class_description18, c1_.id_computador AS id_computador19, c1_.id_class_property AS id_class_property20, c1_.id_class AS id_class21, c2_.id_class AS id_class22 FROM computador_coleta c1_ INNER JOIN class_property c2_ ON c1_.id_class_property = c2_.id_class_property INNER JOIN classe c3_ ON c2_.id_class = c3_.id_class INNER JOIN computador c4_ ON (c1_.id_computador = c4_.id_computador) LEFT JOIN proriedade_software p0_ ON ((c2_.id_class_property = p0_.id_class_property AND c1_.id_computador = p0_.id_computador)) WHERE c1_.id_computador = (?) ORDER BY c3_.nm_class_name ASC, c2_.nm_property_name ASC' with params [50]: SQLSTATE[42703]: Undefined column: 7 ERROR: column c1_.ativo does not exist LINE 1: ...ty_value5, c1_.dt_hr_inclusao AS dt_hr_inclusao6, c1_.ativo ... ^" at /srv/cacic/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 91 request.CRITICAL
October 7 15:21:39 1 Matched route "cacic_relatorio_software_aquisicoes". request.INFO
October 7 15:21:39 1 Uncaught PHP Exception Doctrine\DBAL\DBALException: "An exception occurred while executing ' SELECT sl.id_aquisicao, aq.nr_processo, aq.nm_proprietario, aq.nr_notafiscal, aq.dt_aquisicao, aq.nm_empresa, sl.id_tipo_licenca, t.te_tipo_licenca, sl.id_aquisicao_item, aqit.dt_vencimento_licenca, aqit.nm_aquisicao, aqit.qt_licenca, aqit.te_obs, count(DISTINCT sl.id_computador) as n_comp FROM software_licencas sl INNER JOIN aquisicao aq ON sl.id_aquisicao = aq.id_aquisicao INNER JOIN tipo_licenca t ON sl.id_tipo_licenca = t.id_tipo_licenca INNER JOIN aquisicao_item aqit ON aqit.id_aquisicao_item = sl.id_aquisicao_item WHERE ( sl.comp_ativo = TRUE or sl.comp_ativo IS NULL ) AND ( sl.prop_ativo = TRUE or sl.prop_ativo IS NULL ) AND sl.id_aquisicao_item = ( SELECT sl2.id_aquisicao_item FROM software_licencas sl2 WHERE sl2.id_computador = sl.id_computador AND sl2.id_aquisicao = sl.id_aquisicao ORDER BY sl2.data_coleta DESC LIMIT 1 ) GROUP BY sl.id_aquisicao, aq.nr_processo, aq.nm_proprietario, aq.nr_notafiscal, aq.dt_aquisicao, aq.nm_empresa, sl.id_tipo_licenca, sl.id_tipo_licenca, t.te_tipo_licenca, sl.id_aquisicao_item, aqit.dt_vencimento_licenca, aqit.nm_aquisicao, aqit.qt_licenca, aqit.te_obs ORDER BY sl.id_aquisicao ': SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "software_licencas" does not exist LINE 16: FROM software_licencas sl ^" at /srv/cacic/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 91 request.CRITICAL
October 7 15:04:05 1 Uncaught PHP Exception Doctrine\DBAL\DBALException: "An exception occurred while executing 'SELECT p0_.display_name AS display_name0, p0_.display_version AS display_version1, p0_.url_info_about AS url_info_about2, p0_.publisher AS publisher3, c1_.id_computador_coleta AS id_computador_coleta4, c1_.te_class_property_value AS te_class_property_value5, c1_.dt_hr_inclusao AS dt_hr_inclusao6, c1_.ativo AS ativo7, c1_.dt_hr_exclusao AS dt_hr_exclusao8, c2_.id_class_property AS id_class_property9, c2_.nm_property_name AS nm_property_name10, c2_.pretty_name AS pretty_name11, c2_.te_property_description AS te_property_description12, c2_.nm_function_pre_db AS nm_function_pre_db13, c2_.nm_function_pos_db AS nm_function_pos_db14, c2_.ativo AS ativo15, c3_.id_class AS id_class16, c3_.nm_class_name AS nm_class_name17, c3_.te_class_description AS te_class_description18, c1_.id_computador AS id_computador19, c1_.id_class_property AS id_class_property20, c1_.id_class AS id_class21, c2_.id_class AS id_class22 FROM computador_coleta c1_ INNER JOIN class_property c2_ ON c1_.id_class_property = c2_.id_class_property INNER JOIN classe c3_ ON c2_.id_class = c3_.id_class INNER JOIN computador c4_ ON (c1_.id_computador = c4_.id_computador) LEFT JOIN proriedade_software p0_ ON ((c2_.id_class_property = p0_.id_class_property AND c1_.id_computador = p0_.id_computador)) WHERE c1_.id_computador = (?) ORDER BY c3_.nm_class_name ASC, c2_.nm_property_name ASC' with params [52]: SQLSTATE[42703]: Undefined column: 7 ERROR: column c1_.ativo does not exist LINE 1: ...ty_value5, c1_.dt_hr_inclusao AS dt_hr_inclusao6, c1_.ativo ... ^" at /srv/cacic/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 91 request.CRITICAL
October 7 15:03:58 1 Uncaught PHP Exception Symfony\Component\HttpKernel\Exception\NotFoundHttpException: "No route found for "GET /relatorio/computador/undefinednotifications/get" (from "https://cacic.emater.tche.br/cacic/app.php/relatorio/computador/subredes")" at /srv/cacic/app/cache/prod/classes.php line 2499 request.ERROR
October 7 15:00:10 2 AUTH: Erro de autenticação. IP = 192.168.10.82 app.ERROR
October 7 15:00:10 1 Matched route "cacic_common_login". request.INFO

Éder,

Os erros que você relatou estão relacionados ao fato de que a atualização não foi concluída com sucesso. Você precisa conseguir rodar o schema:update sem erros.

Eduardo Santos
Programador

http://www.eduardosan.com
http://twitter.com/eduardosan


De: "Eder de Castro Roballo"
Para: cacic@listas.softwarepublico.gov.br
Enviadas: Quarta-feira, 7 de outubro de 2015 16:46:27
Assunto: [cacic] Status pós atualização 3.1.18b3

Eduardo

Após a atualização 3.1.18b3 do Gerente e upload do Agente 3.1.18b2, ficamos com o ambiente inconsistente.
Envio abaixo os logs
Notei que os arquivos do agente 3.1.18b2 são bem menores. É assim mesmo? Está correto?
Nas estações onde ocorreu a atualização automática, o serviço parou e ao tentar iniciar manualmente exibe a mensagem da imagem em anexo.

Data Local/Rede Estação Sistema Operacional Nível Mensagem
1 07/10/2015 15:07 EMATER / Central 192.168.0.6
Microsoft Windows 7 Professional error [Error] {Cacic Daemon (Timer)} Falha na coleta: Error downloading https://cacic.emater.tche.br/cacic/app_dev.php/ws/neo/coleta - server replied: Internal Server Error
2 07/10/2015 15:07 EMATER / Central 192.168.0.6
Microsoft Windows 7 Professional error [Error] {Check Cacic} Falha ao excluir m?dulo antigochksys.exe da pasta tempor?ria.
3 07/10/2015 15:06 EMATER / Central 192.168.0.6
Microsoft Windows 7 Professional error [Error] {Check Cacic} Falha ao excluir m?dulo antigochksys.exe da pasta tempor?ria.
4 07/10/2015 15:05 EMATER / Central 192.168.0.6
Microsoft Windows 7 Professional error [Error] {Cacic Daemon (Timer)} Falha ao excluir m?dulo antigo chksys.exe da pasta tempor?ria.
5 07/10/2015 15:05 EMATER / Central 192.168.0.6
Microsoft Windows 7 Professional error [Error] {Cacic Daemon (Timer)} Falha ao enviar logs para o gerente: Arquivo de Log vazio ou inexistente.
6 07/10/2015 15:05 EMATER / Central 192.168.0.6
Microsoft Windows 7 Professional error [Error] {Cacic Daemon (Timer)} Falha na coleta: Error downloading https://cacic.emater.tche.br/cacic/app_dev.php/ws/neo/coleta - server replied: Internal Server Error
7 07/10/2015 15:00 EMATER / Central 192.168.0.6
Microsoft Windows 7 Professional error [Error] {Cacic Daemon (Timer)} Falha ao enviar logs para o gerente: Arquivo de Log vazio ou inexistente.
8 07/10/2015 15:00 EMATER / Central 192.168.0.6
Microsoft Windows 7 Professional error [Error] {Cacic Daemon (Timer)} Falha na coleta: Error downloading https://cacic.emater.tche.br/cacic/app_dev.php/ws/neo/coleta - server replied: Internal Server Error
9 07/10/2015 15:00 EMATER / Central 192.168.0.6
Microsoft Windows 7 Professional error [Error] {Cacic Daemon (Timer)} Problemas ao checkar m?dulos.
10 07/10/2015 15:00 EMATER / Central 192.168.0.6
Microsoft Windows 7 Professional error [Error] {CheckModules} #5 Problemas durante o download de install-cacic.exe
11 07/10/2015 15:12 EMATER / Central 192.168.0.6
Microsoft Windows 7 Professional error [Error] {Cacic Daemon (Timer)} Falha na coleta: Error downloading https://cacic.emater.tche.br/cacic/app_dev.php/ws/neo/coleta - server replied: Internal Server Error
12 07/10/2015 15:12 EMATER / Central 192.168.0.6
Microsoft Windows 7 Professional error [Error] {Check Cacic} Falha ao excluir m?dulo antigochksys.exe da pasta tempor?ria.
13 07/10/2015 15:11 EMATER / Central 192.168.0.6
Microsoft Windows 7 Professional error [Error] {Check Cacic} Falha ao excluir m?dulo antigochksys.exe da pasta tempor?ria.
14 07/10/2015 15:10 EMATER / Central 192.168.0.6
Microsoft Windows 7 Professional error [Error] {Check Cacic} Falha ao excluir m?dulo antigochksys.exe da pasta tempor?ria.
15 07/10/2015 15:09 EMATER / Central 192.168.0.6
Microsoft Windows 7 Professional error [Error] {Check Cacic} Falha ao excluir m?dulo antigochksys.exe da pasta tempor?ria.
16 07/10/2015 15:08 EMATER / Central 192.168.0.6
Microsoft Windows 7 Professional error [Error] {Check Cacic} Falha ao excluir m?dulo antigochksys.exe da pasta tempor?ria.
17 07/10/2015 15:07 EMATER / Central 192.168.0.6
Microsoft Windows 7 Professional error [Error] {Cacic Daemon (Timer)} Falha ao excluir m?dulo antigo chksys.exe da pasta tempor?ria.
18 07/10/2015 15:13 EMATER / Central 10.1.1.203
Microsoft Windows 7 Professional error [Error] {Cacic Daemon (Timer)} Falha na coleta: Error downloading https://cacic.emater.tche.br/cacic/app_dev.php/ws/neo/coleta - server replied: Internal Server Error
19 07/10/2015 15:08 EMATER / Central 10.1.1.203
Microsoft Windows 7 Professional error [Error] {Cacic Daemon (Timer)} Falha ao enviar logs para o gerente: Arquivo de Log vazio ou inexistente.
20 07/10/2015 15:08 EMATER / Central 10.1.1.203
Microsoft Windows 7 Professional error [Error] {Cacic Daemon (Timer)} Falha na coleta: Error downloading https://cacic.emater.tche.br/cacic/app_dev.php/ws/neo/coleta - server replied: Internal Server Error
21 07/10/2015 15:06 EMATER / Central 10.1.1.203
Microsoft Windows 7 Professional error [Error] {Cacic Daemon (Timer)} Falha ao enviar logs para o gerente: Arquivo de Log vazio ou inexistente.
22 07/10/2015 15:06 EMATER / Central 10.1.1.203
Microsoft Windows 7 Professional error [Error] {Cacic Daemon (Timer)} Falha na coleta: Error downloading https://cacic.emater.tche.br/cacic/app_dev.php/ws/neo/coleta - server replied: Internal Server Error
23 07/10/2015 15:01 EMATER / Central 10.1.1.203
Microsoft Windows 7 Professional error [Error] {Cacic Daemon (Timer)} Falha ao enviar logs para o gerente: Arquivo de Log vazio ou inexistente.
24 07/10/2015 15:01 EMATER / Central 10.1.1.203
Microsoft Windows 7 Professional error [Error] {Cacic Daemon (Timer)} Falha na coleta: Error downloading https://cacic.emater.tche.br/cacic/app_dev.php/ws/neo/coleta - server replied: Internal Server Error
25 07/10/2015 15:01 EMATER / Central 10.1.1.203
Microsoft Windows 7 Professional error [Error] {Check Cacic} Falha ao excluir m?dulo antigochksys.exe da pasta tempor?ria.
26 07/10/2015 15:01 EMATER / Central 10.1.1.203
Microsoft Windows 7 Professional error [Error] {Cacic Daemon (Timer)} Problemas ao checkar m?dulos.
27 07/10/2015 15:01 EMATER / Central 10.1.1.203
Microsoft Windows 7 Professional error [Error] {CheckModules} #5 Problemas durante o download de install-cacic.exe
28 07/10/2015 15:14 EMATER / Central 192.168.10.104
Microsoft Windows 7 Professional error [Error] {Cacic Daemon (Timer)} Falha na coleta: Error downloading https://cacic.emater.tche.br/cacic/app_dev.php/ws/neo/coleta - server replied: Internal Server Error
29 07/10/2015 15:09 EMATER / Central 192.168.10.104
Microsoft Windows 7 Professional error [Error] {Cacic Daemon (Timer)} Falha ao enviar logs para o gerente: Arquivo de Log vazio ou inexistente.
30 07/10/2015 15:09 EMATER / Central 192.168.10.104
Microsoft Windows 7 Professional error [Error] {Cacic Daemon (Timer)} Falha na coleta: Error downloading https://cacic.emater.tche.br/cacic/app_dev.php/ws/neo/coleta - server replied: Internal Server Error
31 07/10/2015 15:06 EMATER / Central 192.168.10.104
Microsoft Windows 7 Professional error [Error] {Check Cacic} Falha ao excluir m?dulo antigocacic-service.exe da pasta tempor?ria.
32 07/10/2015 15:06 EMATER / Central 192.168.10.104
Microsoft Windows 7 Professional error [Error] {Check Cacic} Falha ao parar servi?o. Info: Stop Service Failed: Desconhecido
33 07/10/2015 15:06 EMATER / Central 192.168.10.104
Microsoft Windows 7 Professional error [Error] {Check Cacic} Falha ao excluir m?dulo antigochksys.exe da pasta tempor?ria.
34 07/10/2015 15:06 EMATER / Central 192.168.10.104
Microsoft Windows 7 Professional error [Error] {Check Cacic} Falha ao excluir install-cacic.exe da pasta tempor?ria.
35 07/10/2015 15:01 EMATER / Central 192.168.10.104
Microsoft Windows 7 Professional error [Error] {Cacic Daemon (Timer)} Falha ao enviar logs para o gerente: Arquivo de Log vazio ou inexistente.
36 07/10/2015 15:01 EMATER / Central 192.168.10.104
Microsoft Windows 7 Professional error [Error] {Cacic Daemon (Timer)} Falha na coleta: Error downloading https://cacic.emater.tche.br/cacic/app_dev.php/ws/neo/coleta - server replied: Internal Server Error
37 07/10/2015 15:01 EMATER / Central 192.168.10.104
Microsoft Windows 7 Professional error [Error] {Cacic Daemon (Timer)} Problemas ao checkar m?dulos.


Date
Message

October 7 16:06:33 9 Matched route "cacic_computador_detalhar".
request.INFO
October 7 16:06:33 4 Uncaught PHP Exception Doctrine\DBAL\DBALException: "An exception occurred while executing 'SELECT p0_.display_name AS display_name0, p0_.display_version AS display_version1, p0_.url_info_about AS url_info_about2, p0_.publisher AS publisher3, c1_.id_computador_coleta AS id_computador_coleta4, c1_.te_class_property_value AS te_class_property_value5, c1_.dt_hr_inclusao AS dt_hr_inclusao6, c1_.ativo AS ativo7, c1_.dt_hr_exclusao AS dt_hr_exclusao8, c2_.id_class_property AS id_class_property9, c2_.nm_property_name AS nm_property_name10, c2_.pretty_name AS pretty_name11, c2_.te_property_description AS te_property_description12, c2_.nm_function_pre_db AS nm_function_pre_db13, c2_.nm_function_pos_db AS nm_function_pos_db14, c2_.ativo AS ativo15, c3_.id_class AS id_class16, c3_.nm_class_name AS nm_class_name17, c3_.te_class_description AS te_class_description18, c1_.id_computador AS id_computador19, c1_.id_class_property AS id_class_property20, c1_.id_class AS id_class21, c2_.id_class AS id_class22 FROM computador_coleta c1_ INNER JOIN class_property c2_ ON c1_.id_class_property = c2_.id_class_property INNER JOIN classe c3_ ON c2_.id_class = c3_.id_class INNER JOIN computador c4_ ON (c1_.id_computador = c4_.id_computador) LEFT JOIN proriedade_software p0_ ON ((c2_.id_class_property = p0_.id_class_property AND c1_.id_computador = p0_.id_computador)) WHERE c1_.id_computador = (?) ORDER BY c3_.nm_class_name ASC, c2_.nm_property_name ASC' with params [8]: SQLSTATE[42703]: Undefined column: 7 ERROR: column c1_.ativo does not exist LINE 1: ...ty_value5, c1_.dt_hr_inclusao AS dt_hr_inclusao6, c1_.ativo ... ^" at /srv/cacic/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 91
request.CRITICAL
October 7 16:06:33 10 Read existing security token from the session.
security.DEBUG
October 7 16:06:33 10 Stored the security token in the session.
security.DEBUG
October 7 16:06:33 10 User was reloaded from a user provider.
security.DEBUG
October 7 16:06:33 10 No expression found; abstaining from voting.
security.INFO
October 7 16:06:32 8 Uncaught PHP Exception Symfony\Component\HttpKernel\Exception\NotFoundHttpException: "No route found for "GET /relatorio/computador/undefinednotifications/get" (from "https://cacic.emater.tche.br/cacic/app.php/relatorio/computador/listar")" at /srv/cacic/app/cache/prod/classes.php line 2499
request.ERROR
October 7 16:02:43 1 Uncaught PHP Exception Symfony\Component\HttpKernel\Exception\NotFoundHttpException: "No route found for "GET /relatorio/so/detalhar/undefinednotifications/get" (from "https://cacic.emater.tche.br/cacic/app.php/relatorio/so/detalhar/1")" at /srv/cacic/app/cache/prod/classes.php line 2499
request.ERROR
October 7 16:02:31 1 Uncaught PHP Exception Symfony\Component\HttpKernel\Exception\NotFoundHttpException: "No route found for "GET /relatorio/so/detalhar/undefinednotifications/get" (from "https://cacic.emater.tche.br/cacic/app.php/relatorio/so/detalhar/2")" at /srv/cacic/app/cache/prod/classes.php line 2499
request.ERROR
October 7 15:49:53 1 Uncaught PHP Exception Doctrine\DBAL\DBALException: "An exception occurred while executing 'SELECT p0_.display_name AS display_name0, p0_.display_version AS display_version1, p0_.url_info_about AS url_info_about2, p0_.publisher AS publisher3, c1_.id_computador_coleta AS id_computador_coleta4, c1_.te_class_property_value AS te_class_property_value5, c1_.dt_hr_inclusao AS dt_hr_inclusao6, c1_.ativo AS ativo7, c1_.dt_hr_exclusao AS dt_hr_exclusao8, c2_.id_class_property AS id_class_property9, c2_.nm_property_name AS nm_property_name10, c2_.pretty_name AS pretty_name11, c2_.te_property_description AS te_property_description12, c2_.nm_function_pre_db AS nm_function_pre_db13, c2_.nm_function_pos_db AS nm_function_pos_db14, c2_.ativo AS ativo15, c3_.id_class AS id_class16, c3_.nm_class_name AS nm_class_name17, c3_.te_class_description AS te_class_description18, c1_.id_computador AS id_computador19, c1_.id_class_property AS id_class_property20, c1_.id_class AS id_class21, c2_.id_class AS id_class22 FROM computador_coleta c1_ INNER JOIN class_property c2_ ON c1_.id_class_property = c2_.id_class_property INNER JOIN classe c3_ ON c2_.id_class = c3_.id_class INNER JOIN computador c4_ ON (c1_.id_computador = c4_.id_computador) LEFT JOIN proriedade_software p0_ ON ((c2_.id_class_property = p0_.id_class_property AND c1_.id_computador = p0_.id_computador)) WHERE c1_.id_computador = (?) ORDER BY c3_.nm_class_name ASC, c2_.nm_property_name ASC' with params [58]: SQLSTATE[42703]: Undefined column: 7 ERROR: column c1_.ativo does not exist LINE 1: ...ty_value5, c1_.dt_hr_inclusao AS dt_hr_inclusao6, c1_.ativo ... ^" at /srv/cacic/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 91
request.CRITICAL
October 7 15:44:38 3 Uncaught PHP Exception Doctrine\DBAL\DBALException: "An exception occurred while executing 'SELECT p0_.display_name AS display_name0, p0_.display_version AS display_version1, p0_.url_info_about AS url_info_about2, p0_.publisher AS publisher3, c1_.id_computador_coleta AS id_computador_coleta4, c1_.te_class_property_value AS te_class_property_value5, c1_.dt_hr_inclusao AS dt_hr_inclusao6, c1_.ativo AS ativo7, c1_.dt_hr_exclusao AS dt_hr_exclusao8, c2_.id_class_property AS id_class_property9, c2_.nm_property_name AS nm_property_name10, c2_.pretty_name AS pretty_name11, c2_.te_property_description AS te_property_description12, c2_.nm_function_pre_db AS nm_function_pre_db13, c2_.nm_function_pos_db AS nm_function_pos_db14, c2_.ativo AS ativo15, c3_.id_class AS id_class16, c3_.nm_class_name AS nm_class_name17, c3_.te_class_description AS te_class_description18, c1_.id_computador AS id_computador19, c1_.id_class_property AS id_class_property20, c1_.id_class AS id_class21, c2_.id_class AS id_class22 FROM computador_coleta c1_ INNER JOIN class_property c2_ ON c1_.id_class_property = c2_.id_class_property INNER JOIN classe c3_ ON c2_.id_class = c3_.id_class INNER JOIN computador c4_ ON (c1_.id_computador = c4_.id_computador) LEFT JOIN proriedade_software p0_ ON ((c2_.id_class_property = p0_.id_class_property AND c1_.id_computador = p0_.id_computador)) WHERE c1_.id_computador = (?) ORDER BY c3_.nm_class_name ASC, c2_.nm_property_name ASC' with params [50]: SQLSTATE[42703]: Undefined column: 7 ERROR: column c1_.ativo does not exist LINE 1: ...ty_value5, c1_.dt_hr_inclusao AS dt_hr_inclusao6, c1_.ativo ... ^" at /srv/cacic/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 91
request.CRITICAL
October 7 15:21:39 1 Matched route "cacic_relatorio_software_aquisicoes".
request.INFO
October 7 15:21:39 1 Uncaught PHP Exception Doctrine\DBAL\DBALException: "An exception occurred while executing ' SELECT sl.id_aquisicao, aq.nr_processo, aq.nm_proprietario, aq.nr_notafiscal, aq.dt_aquisicao, aq.nm_empresa, sl.id_tipo_licenca, t.te_tipo_licenca, sl.id_aquisicao_item, aqit.dt_vencimento_licenca, aqit.nm_aquisicao, aqit.qt_licenca, aqit.te_obs, count(DISTINCT sl.id_computador) as n_comp FROM software_licencas sl INNER JOIN aquisicao aq ON sl.id_aquisicao = aq.id_aquisicao INNER JOIN tipo_licenca t ON sl.id_tipo_licenca = t.id_tipo_licenca INNER JOIN aquisicao_item aqit ON aqit.id_aquisicao_item = sl.id_aquisicao_item WHERE ( sl.comp_ativo = TRUE or sl.comp_ativo IS NULL ) AND ( sl.prop_ativo = TRUE or sl.prop_ativo IS NULL ) AND sl.id_aquisicao_item = ( SELECT sl2.id_aquisicao_item FROM software_licencas sl2 WHERE sl2.id_computador = sl.id_computador AND sl2.id_aquisicao = sl.id_aquisicao ORDER BY sl2.data_coleta DESC LIMIT 1 ) GROUP BY sl.id_aquisicao, aq.nr_processo, aq.nm_proprietario, aq.nr_notafiscal, aq.dt_aquisicao, aq.nm_empresa, sl.id_tipo_licenca, sl.id_tipo_licenca, t.te_tipo_licenca, sl.id_aquisicao_item, aqit.dt_vencimento_licenca, aqit.nm_aquisicao, aqit.qt_licenca, aqit.te_obs ORDER BY sl.id_aquisicao ': SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "software_licencas" does not exist LINE 16: FROM software_licencas sl ^" at /srv/cacic/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 91
request.CRITICAL
October 7 15:04:05 1 Uncaught PHP Exception Doctrine\DBAL\DBALException: "An exception occurred while executing 'SELECT p0_.display_name AS display_name0, p0_.display_version AS display_version1, p0_.url_info_about AS url_info_about2, p0_.publisher AS publisher3, c1_.id_computador_coleta AS id_computador_coleta4, c1_.te_class_property_value AS te_class_property_value5, c1_.dt_hr_inclusao AS dt_hr_inclusao6, c1_.ativo AS ativo7, c1_.dt_hr_exclusao AS dt_hr_exclusao8, c2_.id_class_property AS id_class_property9, c2_.nm_property_name AS nm_property_name10, c2_.pretty_name AS pretty_name11, c2_.te_property_description AS te_property_description12, c2_.nm_function_pre_db AS nm_function_pre_db13, c2_.nm_function_pos_db AS nm_function_pos_db14, c2_.ativo AS ativo15, c3_.id_class AS id_class16, c3_.nm_class_name AS nm_class_name17, c3_.te_class_description AS te_class_description18, c1_.id_computador AS id_computador19, c1_.id_class_property AS id_class_property20, c1_.id_class AS id_class21, c2_.id_class AS id_class22 FROM computador_coleta c1_ INNER JOIN class_property c2_ ON c1_.id_class_property = c2_.id_class_property INNER JOIN classe c3_ ON c2_.id_class = c3_.id_class INNER JOIN computador c4_ ON (c1_.id_computador = c4_.id_computador) LEFT JOIN proriedade_software p0_ ON ((c2_.id_class_property = p0_.id_class_property AND c1_.id_computador = p0_.id_computador)) WHERE c1_.id_computador = (?) ORDER BY c3_.nm_class_name ASC, c2_.nm_property_name ASC' with params [52]: SQLSTATE[42703]: Undefined column: 7 ERROR: column c1_.ativo does not exist LINE 1: ...ty_value5, c1_.dt_hr_inclusao AS dt_hr_inclusao6, c1_.ativo ... ^" at /srv/cacic/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 91
request.CRITICAL
October 7 15:03:58 1 Uncaught PHP Exception Symfony\Component\HttpKernel\Exception\NotFoundHttpException: "No route found for "GET /relatorio/computador/undefinednotifications/get" (from "https://cacic.emater.tche.br/cacic/app.php/relatorio/computador/subredes")" at /srv/cacic/app/cache/prod/classes.php line 2499
request.ERROR
October 7 15:00:10 2 AUTH: Erro de autenticação. IP = 192.168.10.82
app.ERROR
October 7 15:00:10 1 Matched route "cacic_common_login".
request.INFO

_______________________________________________

Cacic mailing list
Cacic@listas.softwarepublico.gov.br
https://listas.softwarepublico.gov.br/mailman/cgi-bin/listinfo/cacic

Eduardo

E sobre o Agente 3.1.18b2?

Notei que os arquivos do agente 3.1.18b2 são bem menores. É assim mesmo? Está correto?
Nas estações onde ocorreu a atualização automática, o serviço parou e ao tentar iniciar manualmente exibe a mensagem da imagem em anexo.

Atenciosamente

Eder de Castro Roballo

Coordenador do Núcleo de Suporte
EMATER/RS-ASCAR
GTI - Escritório Central
skype: roballo-emater

----- Mensagem original -----

De: "Eduardo F. Santos"

Para: cacic@listas.softwarepublico.gov.br

Enviadas: Quinta-feira, 8 de outubro de 2015 7:47:24
Assunto: Re: [cacic] Status pós atualização 3.1.18b3

Éder,

Os erros que você relatou estão relacionados ao fato de que a atualização não foi concluída com sucesso. Você precisa conseguir rodar o schema:update sem erros.

Eduardo Santos
Programador

http://www.eduardosan.com
http://twitter.com/eduardosan

----- Mensagem original -----

De: "Eder de Castro Roballo"
Para: cacic@listas.softwarepublico.gov.br
Enviadas: Quarta-feira, 7 de outubro de 2015 16:46:27
Assunto: [cacic] Status pós atualização 3.1.18b3

Eduardo

Após a atualização 3.1.18b3 do Gerente e upload do Agente 3.1.18b2, ficamos com o ambiente inconsistente.
Envio abaixo os logs
Notei que os arquivos do agente 3.1.18b2 são bem menores. É assim mesmo? Está correto?
Nas estações onde ocorreu a atualização automática, o serviço parou e ao tentar iniciar manualmente exibe a mensagem da imagem em anexo.

Data Local/Rede Estação Sistema Operacional Nível Mensagem
1 07/10/2015 15:07 EMATER / Central 192.168.0.6 Microsoft Windows 7 Professional error [Error] {Cacic Daemon (Timer)} Falha na coleta: Error downloading https://cacic.emater.tche.br/cacic/app_dev.php/ws/neo/coleta - server replied: Internal Server Error
2 07/10/2015 15:07 EMATER / Central 192.168.0.6 Microsoft Windows 7 Professional error [Error] {Check Cacic} Falha ao excluir m?dulo antigochksys.exe da pasta tempor?ria.
3 07/10/2015 15:06 EMATER / Central 192.168.0.6 Microsoft Windows 7 Professional error [Error] {Check Cacic} Falha ao excluir m?dulo antigochksys.exe da pasta tempor?ria.
4 07/10/2015 15:05 EMATER / Central 192.168.0.6 Microsoft Windows 7 Professional error [Error] {Cacic Daemon (Timer)} Falha ao excluir m?dulo antigo chksys.exe da pasta tempor?ria.
5 07/10/2015 15:05 EMATER / Central 192.168.0.6 Microsoft Windows 7 Professional error [Error] {Cacic Daemon (Timer)} Falha ao enviar logs para o gerente: Arquivo de Log vazio ou inexistente.
6 07/10/2015 15:05 EMATER / Central 192.168.0.6 Microsoft Windows 7 Professional error [Error] {Cacic Daemon (Timer)} Falha na coleta: Error downloading https://cacic.emater.tche.br/cacic/app_dev.php/ws/neo/coleta - server replied: Internal Server Error
7 07/10/2015 15:00 EMATER / Central 192.168.0.6 Microsoft Windows 7 Professional error [Error] {Cacic Daemon (Timer)} Falha ao enviar logs para o gerente: Arquivo de Log vazio ou inexistente.
8 07/10/2015 15:00 EMATER / Central 192.168.0.6 Microsoft Windows 7 Professional error [Error] {Cacic Daemon (Timer)} Falha na coleta: Error downloading https://cacic.emater.tche.br/cacic/app_dev.php/ws/neo/coleta - server replied: Internal Server Error
9 07/10/2015 15:00 EMATER / Central 192.168.0.6 Microsoft Windows 7 Professional error [Error] {Cacic Daemon (Timer)} Problemas ao checkar m?dulos.
10 07/10/2015 15:00 EMATER / Central 192.168.0.6 Microsoft Windows 7 Professional error [Error] {CheckModules} #5 Problemas durante o download de install-cacic.exe
11 07/10/2015 15:12 EMATER / Central 192.168.0.6 Microsoft Windows 7 Professional error [Error] {Cacic Daemon (Timer)} Falha na coleta: Error downloading https://cacic.emater.tche.br/cacic/app_dev.php/ws/neo/coleta - server replied: Internal Server Error
12 07/10/2015 15:12 EMATER / Central 192.168.0.6 Microsoft Windows 7 Professional error [Error] {Check Cacic} Falha ao excluir m?dulo antigochksys.exe da pasta tempor?ria.
13 07/10/2015 15:11 EMATER / Central 192.168.0.6 Microsoft Windows 7 Professional error [Error] {Check Cacic} Falha ao excluir m?dulo antigochksys.exe da pasta tempor?ria.
14 07/10/2015 15:10 EMATER / Central 192.168.0.6 Microsoft Windows 7 Professional error [Error] {Check Cacic} Falha ao excluir m?dulo antigochksys.exe da pasta tempor?ria.
15 07/10/2015 15:09 EMATER / Central 192.168.0.6 Microsoft Windows 7 Professional error [Error] {Check Cacic} Falha ao excluir m?dulo antigochksys.exe da pasta tempor?ria.
16 07/10/2015 15:08 EMATER / Central 192.168.0.6 Microsoft Windows 7 Professional error [Error] {Check Cacic} Falha ao excluir m?dulo antigochksys.exe da pasta tempor?ria.
17 07/10/2015 15:07 EMATER / Central 192.168.0.6 Microsoft Windows 7 Professional error [Error] {Cacic Daemon (Timer)} Falha ao excluir m?dulo antigo chksys.exe da pasta tempor?ria.
18 07/10/2015 15:13 EMATER / Central 10.1.1.203 Microsoft Windows 7 Professional error [Error] {Cacic Daemon (Timer)} Falha na coleta: Error downloading https://cacic.emater.tche.br/cacic/app_dev.php/ws/neo/coleta - server replied: Internal Server Error
19 07/10/2015 15:08 EMATER / Central 10.1.1.203 Microsoft Windows 7 Professional error [Error] {Cacic Daemon (Timer)} Falha ao enviar logs para o gerente: Arquivo de Log vazio ou inexistente.
20 07/10/2015 15:08 EMATER / Central 10.1.1.203 Microsoft Windows 7 Professional error [Error] {Cacic Daemon (Timer)} Falha na coleta: Error downloading https://cacic.emater.tche.br/cacic/app_dev.php/ws/neo/coleta - server replied: Internal Server Error
21 07/10/2015 15:06 EMATER / Central 10.1.1.203 Microsoft Windows 7 Professional error [Error] {Cacic Daemon (Timer)} Falha ao enviar logs para o gerente: Arquivo de Log vazio ou inexistente.
22 07/10/2015 15:06 EMATER / Central 10.1.1.203 Microsoft Windows 7 Professional error [Error] {Cacic Daemon (Timer)} Falha na coleta: Error downloading https://cacic.emater.tche.br/cacic/app_dev.php/ws/neo/coleta - server replied: Internal Server Error
23 07/10/2015 15:01 EMATER / Central 10.1.1.203 Microsoft Windows 7 Professional error [Error] {Cacic Daemon (Timer)} Falha ao enviar logs para o gerente: Arquivo de Log vazio ou inexistente.
24 07/10/2015 15:01 EMATER / Central 10.1.1.203 Microsoft Windows 7 Professional error [Error] {Cacic Daemon (Timer)} Falha na coleta: Error downloading https://cacic.emater.tche.br/cacic/app_dev.php/ws/neo/coleta - server replied: Internal Server Error
25 07/10/2015 15:01 EMATER / Central 10.1.1.203 Microsoft Windows 7 Professional error [Error] {Check Cacic} Falha ao excluir m?dulo antigochksys.exe da pasta tempor?ria.
26 07/10/2015 15:01 EMATER / Central 10.1.1.203 Microsoft Windows 7 Professional error [Error] {Cacic Daemon (Timer)} Problemas ao checkar m?dulos.
27 07/10/2015 15:01 EMATER / Central 10.1.1.203 Microsoft Windows 7 Professional error [Error] {CheckModules} #5 Problemas durante o download de install-cacic.exe
28 07/10/2015 15:14 EMATER / Central 192.168.10.104 Microsoft Windows 7 Professional error [Error] {Cacic Daemon (Timer)} Falha na coleta: Error downloading https://cacic.emater.tche.br/cacic/app_dev.php/ws/neo/coleta - server replied: Internal Server Error
29 07/10/2015 15:09 EMATER / Central 192.168.10.104 Microsoft Windows 7 Professional error [Error] {Cacic Daemon (Timer)} Falha ao enviar logs para o gerente: Arquivo de Log vazio ou inexistente.
30 07/10/2015 15:09 EMATER / Central 192.168.10.104 Microsoft Windows 7 Professional error [Error] {Cacic Daemon (Timer)} Falha na coleta: Error downloading https://cacic.emater.tche.br/cacic/app_dev.php/ws/neo/coleta - server replied: Internal Server Error
31 07/10/2015 15:06 EMATER / Central 192.168.10.104 Microsoft Windows 7 Professional error [Error] {Check Cacic} Falha ao excluir m?dulo antigocacic-service.exe da pasta tempor?ria.
32 07/10/2015 15:06 EMATER / Central 192.168.10.104 Microsoft Windows 7 Professional error [Error] {Check Cacic} Falha ao parar servi?o. Info: Stop Service Failed: Desconhecido
33 07/10/2015 15:06 EMATER / Central 192.168.10.104 Microsoft Windows 7 Professional error [Error] {Check Cacic} Falha ao excluir m?dulo antigochksys.exe da pasta tempor?ria.
34 07/10/2015 15:06 EMATER / Central 192.168.10.104 Microsoft Windows 7 Professional error [Error] {Check Cacic} Falha ao excluir install-cacic.exe da pasta tempor?ria.
35 07/10/2015 15:01 EMATER / Central 192.168.10.104 Microsoft Windows 7 Professional error [Error] {Cacic Daemon (Timer)} Falha ao enviar logs para o gerente: Arquivo de Log vazio ou inexistente.
36 07/10/2015 15:01 EMATER / Central 192.168.10.104 Microsoft Windows 7 Professional error [Error] {Cacic Daemon (Timer)} Falha na coleta: Error downloading https://cacic.emater.tche.br/cacic/app_dev.php/ws/neo/coleta - server replied: Internal Server Error
37 07/10/2015 15:01 EMATER / Central 192.168.10.104 Microsoft Windows 7 Professional error [Error] {Cacic Daemon (Timer)} Problemas ao checkar m?dulos.


Date Message
October 7 16:06:33 9 Matched route "cacic_computador_detalhar". request.INFO
October 7 16:06:33 4 Uncaught PHP Exception Doctrine\DBAL\DBALException: "An exception occurred while executing 'SELECT p0_.display_name AS display_name0, p0_.display_version AS display_version1, p0_.url_info_about AS url_info_about2, p0_.publisher AS publisher3, c1_.id_computador_coleta AS id_computador_coleta4, c1_.te_class_property_value AS te_class_property_value5, c1_.dt_hr_inclusao AS dt_hr_inclusao6, c1_.ativo AS ativo7, c1_.dt_hr_exclusao AS dt_hr_exclusao8, c2_.id_class_property AS id_class_property9, c2_.nm_property_name AS nm_property_name10, c2_.pretty_name AS pretty_name11, c2_.te_property_description AS te_property_description12, c2_.nm_function_pre_db AS nm_function_pre_db13, c2_.nm_function_pos_db AS nm_function_pos_db14, c2_.ativo AS ativo15, c3_.id_class AS id_class16, c3_.nm_class_name AS nm_class_name17, c3_.te_class_description AS te_class_description18, c1_.id_computador AS id_computador19, c1_.id_class_property AS id_class_property20, c1_.id_class AS id_class21, c2_.id_class AS id_class22 FROM computador_coleta c1_ INNER JOIN class_property c2_ ON c1_.id_class_property = c2_.id_class_property INNER JOIN classe c3_ ON c2_.id_class = c3_.id_class INNER JOIN computador c4_ ON (c1_.id_computador = c4_.id_computador) LEFT JOIN proriedade_software p0_ ON ((c2_.id_class_property = p0_.id_class_property AND c1_.id_computador = p0_.id_computador)) WHERE c1_.id_computador = (?) ORDER BY c3_.nm_class_name ASC, c2_.nm_property_name ASC' with params [8]: SQLSTATE[42703]: Undefined column: 7 ERROR: column c1_.ativo does not exist LINE 1: ...ty_value5, c1_.dt_hr_inclusao AS dt_hr_inclusao6, c1_.ativo ... ^" at /srv/cacic/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 91 request.CRITICAL
October 7 16:06:33 10 Read existing security token from the session. security.DEBUG
October 7 16:06:33 10 Stored the security token in the session. security.DEBUG
October 7 16:06:33 10 User was reloaded from a user provider. security.DEBUG
October 7 16:06:33 10 No expression found; abstaining from voting. security.INFO
October 7 16:06:32 8 Uncaught PHP Exception Symfony\Component\HttpKernel\Exception\NotFoundHttpException: "No route found for "GET /relatorio/computador/undefinednotifications/get" (from "https://cacic.emater.tche.br/cacic/app.php/relatorio/computador/listar")" at /srv/cacic/app/cache/prod/classes.php line 2499 request.ERROR
October 7 16:02:43 1 Uncaught PHP Exception Symfony\Component\HttpKernel\Exception\NotFoundHttpException: "No route found for "GET /relatorio/so/detalhar/undefinednotifications/get" (from "https://cacic.emater.tche.br/cacic/app.php/relatorio/so/detalhar/1")" at /srv/cacic/app/cache/prod/classes.php line 2499 request.ERROR
October 7 16:02:31 1 Uncaught PHP Exception Symfony\Component\HttpKernel\Exception\NotFoundHttpException: "No route found for "GET /relatorio/so/detalhar/undefinednotifications/get" (from "https://cacic.emater.tche.br/cacic/app.php/relatorio/so/detalhar/2")" at /srv/cacic/app/cache/prod/classes.php line 2499 request.ERROR
October 7 15:49:53 1 Uncaught PHP Exception Doctrine\DBAL\DBALException: "An exception occurred while executing 'SELECT p0_.display_name AS display_name0, p0_.display_version AS display_version1, p0_.url_info_about AS url_info_about2, p0_.publisher AS publisher3, c1_.id_computador_coleta AS id_computador_coleta4, c1_.te_class_property_value AS te_class_property_value5, c1_.dt_hr_inclusao AS dt_hr_inclusao6, c1_.ativo AS ativo7, c1_.dt_hr_exclusao AS dt_hr_exclusao8, c2_.id_class_property AS id_class_property9, c2_.nm_property_name AS nm_property_name10, c2_.pretty_name AS pretty_name11, c2_.te_property_description AS te_property_description12, c2_.nm_function_pre_db AS nm_function_pre_db13, c2_.nm_function_pos_db AS nm_function_pos_db14, c2_.ativo AS ativo15, c3_.id_class AS id_class16, c3_.nm_class_name AS nm_class_name17, c3_.te_class_description AS te_class_description18, c1_.id_computador AS id_computador19, c1_.id_class_property AS id_class_property20, c1_.id_class AS id_class21, c2_.id_class AS id_class22 FROM computador_coleta c1_ INNER JOIN class_property c2_ ON c1_.id_class_property = c2_.id_class_property INNER JOIN classe c3_ ON c2_.id_class = c3_.id_class INNER JOIN computador c4_ ON (c1_.id_computador = c4_.id_computador) LEFT JOIN proriedade_software p0_ ON ((c2_.id_class_property = p0_.id_class_property AND c1_.id_computador = p0_.id_computador)) WHERE c1_.id_computador = (?) ORDER BY c3_.nm_class_name ASC, c2_.nm_property_name ASC' with params [58]: SQLSTATE[42703]: Undefined column: 7 ERROR: column c1_.ativo does not exist LINE 1: ...ty_value5, c1_.dt_hr_inclusao AS dt_hr_inclusao6, c1_.ativo ... ^" at /srv/cacic/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 91 request.CRITICAL
October 7 15:44:38 3 Uncaught PHP Exception Doctrine\DBAL\DBALException: "An exception occurred while executing 'SELECT p0_.display_name AS display_name0, p0_.display_version AS display_version1, p0_.url_info_about AS url_info_about2, p0_.publisher AS publisher3, c1_.id_computador_coleta AS id_computador_coleta4, c1_.te_class_property_value AS te_class_property_value5, c1_.dt_hr_inclusao AS dt_hr_inclusao6, c1_.ativo AS ativo7, c1_.dt_hr_exclusao AS dt_hr_exclusao8, c2_.id_class_property AS id_class_property9, c2_.nm_property_name AS nm_property_name10, c2_.pretty_name AS pretty_name11, c2_.te_property_description AS te_property_description12, c2_.nm_function_pre_db AS nm_function_pre_db13, c2_.nm_function_pos_db AS nm_function_pos_db14, c2_.ativo AS ativo15, c3_.id_class AS id_class16, c3_.nm_class_name AS nm_class_name17, c3_.te_class_description AS te_class_description18, c1_.id_computador AS id_computador19, c1_.id_class_property AS id_class_property20, c1_.id_class AS id_class21, c2_.id_class AS id_class22 FROM computador_coleta c1_ INNER JOIN class_property c2_ ON c1_.id_class_property = c2_.id_class_property INNER JOIN classe c3_ ON c2_.id_class = c3_.id_class INNER JOIN computador c4_ ON (c1_.id_computador = c4_.id_computador) LEFT JOIN proriedade_software p0_ ON ((c2_.id_class_property = p0_.id_class_property AND c1_.id_computador = p0_.id_computador)) WHERE c1_.id_computador = (?) ORDER BY c3_.nm_class_name ASC, c2_.nm_property_name ASC' with params [50]: SQLSTATE[42703]: Undefined column: 7 ERROR: column c1_.ativo does not exist LINE 1: ...ty_value5, c1_.dt_hr_inclusao AS dt_hr_inclusao6, c1_.ativo ... ^" at /srv/cacic/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 91 request.CRITICAL
October 7 15:21:39 1 Matched route "cacic_relatorio_software_aquisicoes". request.INFO
October 7 15:21:39 1 Uncaught PHP Exception Doctrine\DBAL\DBALException: "An exception occurred while executing ' SELECT sl.id_aquisicao, aq.nr_processo, aq.nm_proprietario, aq.nr_notafiscal, aq.dt_aquisicao, aq.nm_empresa, sl.id_tipo_licenca, t.te_tipo_licenca, sl.id_aquisicao_item, aqit.dt_vencimento_licenca, aqit.nm_aquisicao, aqit.qt_licenca, aqit.te_obs, count(DISTINCT sl.id_computador) as n_comp FROM software_licencas sl INNER JOIN aquisicao aq ON sl.id_aquisicao = aq.id_aquisicao INNER JOIN tipo_licenca t ON sl.id_tipo_licenca = t.id_tipo_licenca INNER JOIN aquisicao_item aqit ON aqit.id_aquisicao_item = sl.id_aquisicao_item WHERE ( sl.comp_ativo = TRUE or sl.comp_ativo IS NULL ) AND ( sl.prop_ativo = TRUE or sl.prop_ativo IS NULL ) AND sl.id_aquisicao_item = ( SELECT sl2.id_aquisicao_item FROM software_licencas sl2 WHERE sl2.id_computador = sl.id_computador AND sl2.id_aquisicao = sl.id_aquisicao ORDER BY sl2.data_coleta DESC LIMIT 1 ) GROUP BY sl.id_aquisicao, aq.nr_processo, aq.nm_proprietario, aq.nr_notafiscal, aq.dt_aquisicao, aq.nm_empresa, sl.id_tipo_licenca, sl.id_tipo_licenca, t.te_tipo_licenca, sl.id_aquisicao_item, aqit.dt_vencimento_licenca, aqit.nm_aquisicao, aqit.qt_licenca, aqit.te_obs ORDER BY sl.id_aquisicao ': SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "software_licencas" does not exist LINE 16: FROM software_licencas sl ^" at /srv/cacic/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 91 request.CRITICAL
October 7 15:04:05 1 Uncaught PHP Exception Doctrine\DBAL\DBALException: "An exception occurred while executing 'SELECT p0_.display_name AS display_name0, p0_.display_version AS display_version1, p0_.url_info_about AS url_info_about2, p0_.publisher AS publisher3, c1_.id_computador_coleta AS id_computador_coleta4, c1_.te_class_property_value AS te_class_property_value5, c1_.dt_hr_inclusao AS dt_hr_inclusao6, c1_.ativo AS ativo7, c1_.dt_hr_exclusao AS dt_hr_exclusao8, c2_.id_class_property AS id_class_property9, c2_.nm_property_name AS nm_property_name10, c2_.pretty_name AS pretty_name11, c2_.te_property_description AS te_property_description12, c2_.nm_function_pre_db AS nm_function_pre_db13, c2_.nm_function_pos_db AS nm_function_pos_db14, c2_.ativo AS ativo15, c3_.id_class AS id_class16, c3_.nm_class_name AS nm_class_name17, c3_.te_class_description AS te_class_description18, c1_.id_computador AS id_computador19, c1_.id_class_property AS id_class_property20, c1_.id_class AS id_class21, c2_.id_class AS id_class22 FROM computador_coleta c1_ INNER JOIN class_property c2_ ON c1_.id_class_property = c2_.id_class_property INNER JOIN classe c3_ ON c2_.id_class = c3_.id_class INNER JOIN computador c4_ ON (c1_.id_computador = c4_.id_computador) LEFT JOIN proriedade_software p0_ ON ((c2_.id_class_property = p0_.id_class_property AND c1_.id_computador = p0_.id_computador)) WHERE c1_.id_computador = (?) ORDER BY c3_.nm_class_name ASC, c2_.nm_property_name ASC' with params [52]: SQLSTATE[42703]: Undefined column: 7 ERROR: column c1_.ativo does not exist LINE 1: ...ty_value5, c1_.dt_hr_inclusao AS dt_hr_inclusao6, c1_.ativo ... ^" at /srv/cacic/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 91 request.CRITICAL
October 7 15:03:58 1 Uncaught PHP Exception Symfony\Component\HttpKernel\Exception\NotFoundHttpException: "No route found for "GET /relatorio/computador/undefinednotifications/get" (from "https://cacic.emater.tche.br/cacic/app.php/relatorio/computador/subredes")" at /srv/cacic/app/cache/prod/classes.php line 2499 request.ERROR
October 7 15:00:10 2 AUTH: Erro de autenticação. IP = 192.168.10.82 app.ERROR
October 7 15:00:10 1 Matched route "cacic_common_login". request.INFO

_______________________________________________
Cacic mailing list
Cacic@listas.softwarepublico.gov.br
https://listas.softwarepublico.gov.br/mailman/cgi-bin/listinfo/cacic

_______________________________________________
Cacic mailing list
Cacic@listas.softwarepublico.gov.br
https://listas.softwarepublico.gov.br/mailman/cgi-bin/listinfo/cacic

Éder,

Estamos detectando um erro na hora de parar o serviço nesse Agente. Provavelmente vai ser necessário rodar o próximo beta que estamos finalizando amanhã.

Eduardo Santos
Programador

http://www.eduardosan.com
http://twitter.com/eduardosan


De: "Eder de Castro Roballo"
Para: cacic@listas.softwarepublico.gov.br

Enviadas: Quinta-feira, 8 de outubro de 2015 8:42:04

Assunto: Re: [cacic] Status pós atualização 3.1.18b3

Eduardo

E sobre o Agente 3.1.18b2?
Notei que os arquivos do agente 3.1.18b2 são bem menores. É assim mesmo? Está correto?
Nas estações onde ocorreu a atualização automática, o serviço parou e ao tentar iniciar manualmente exibe a mensagem da imagem em anexo.


Atenciosamente

Eder de Castro Roballo
Coordenador do Núcleo de Suporte
EMATER/RS-ASCAR
GTI - Escritório Central
skype: roballo-emater


De: "Eduardo F. Santos"
Para: cacic@listas.softwarepublico.gov.br
Enviadas: Quinta-feira, 8 de outubro de 2015 7:47:24
Assunto: Re: [cacic] Status pós atualização 3.1.18b3

Éder,

Os erros que você relatou estão relacionados ao fato de que a atualização não foi concluída com sucesso. Você precisa conseguir rodar o schema:update sem erros.

Eduardo Santos
Programador

http://www.eduardosan.com
http://twitter.com/eduardosan


De: "Eder de Castro Roballo"
Para: cacic@listas.softwarepublico.gov.br
Enviadas: Quarta-feira, 7 de outubro de 2015 16:46:27
Assunto: [cacic] Status pós atualização 3.1.18b3

Eduardo

Após a atualização 3.1.18b3 do Gerente e upload do Agente 3.1.18b2, ficamos com o ambiente inconsistente.
Envio abaixo os logs
Notei que os arquivos do agente 3.1.18b2 são bem menores. É assim mesmo? Está correto?
Nas estações onde ocorreu a atualização automática, o serviço parou e ao tentar iniciar manualmente exibe a mensagem da imagem em anexo.

Data Local/Rede Estação Sistema Operacional Nível Mensagem
1 07/10/2015 15:07 EMATER / Central 192.168.0.6 Microsoft Windows 7 Professional error [Error] {Cacic Daemon (Timer)} Falha na coleta: Error downloading https://cacic.emater.tche.br/cacic/app_dev.php/ws/neo/coleta - server replied: Internal Server Error
2 07/10/2015 15:07 EMATER / Central 192.168.0.6 Microsoft Windows 7 Professional error [Error] {Check Cacic} Falha ao excluir m?dulo antigochksys.exe da pasta tempor?ria.
3 07/10/2015 15:06 EMATER / Central 192.168.0.6 Microsoft Windows 7 Professional error [Error] {Check Cacic} Falha ao excluir m?dulo antigochksys.exe da pasta tempor?ria.
4 07/10/2015 15:05 EMATER / Central 192.168.0.6 Microsoft Windows 7 Professional error [Error] {Cacic Daemon (Timer)} Falha ao excluir m?dulo antigo chksys.exe da pasta tempor?ria.
5 07/10/2015 15:05 EMATER / Central 192.168.0.6 Microsoft Windows 7 Professional error [Error] {Cacic Daemon (Timer)} Falha ao enviar logs para o gerente: Arquivo de Log vazio ou inexistente.
6 07/10/2015 15:05 EMATER / Central 192.168.0.6 Microsoft Windows 7 Professional error [Error] {Cacic Daemon (Timer)} Falha na coleta: Error downloading https://cacic.emater.tche.br/cacic/app_dev.php/ws/neo/coleta - server replied: Internal Server Error
7 07/10/2015 15:00 EMATER / Central 192.168.0.6 Microsoft Windows 7 Professional error [Error] {Cacic Daemon (Timer)} Falha ao enviar logs para o gerente: Arquivo de Log vazio ou inexistente.
8 07/10/2015 15:00 EMATER / Central 192.168.0.6 Microsoft Windows 7 Professional error [Error] {Cacic Daemon (Timer)} Falha na coleta: Error downloading https://cacic.emater.tche.br/cacic/app_dev.php/ws/neo/coleta - server replied: Internal Server Error
9 07/10/2015 15:00 EMATER / Central 192.168.0.6 Microsoft Windows 7 Professional error [Error] {Cacic Daemon (Timer)} Problemas ao checkar m?dulos.
10 07/10/2015 15:00 EMATER / Central 192.168.0.6 Microsoft Windows 7 Professional error [Error] {CheckModules} #5 Problemas durante o download de install-cacic.exe
11 07/10/2015 15:12 EMATER / Central 192.168.0.6 Microsoft Windows 7 Professional error [Error] {Cacic Daemon (Timer)} Falha na coleta: Error downloading https://cacic.emater.tche.br/cacic/app_dev.php/ws/neo/coleta - server replied: Internal Server Error
12 07/10/2015 15:12 EMATER / Central 192.168.0.6 Microsoft Windows 7 Professional error [Error] {Check Cacic} Falha ao excluir m?dulo antigochksys.exe da pasta tempor?ria.
13 07/10/2015 15:11 EMATER / Central 192.168.0.6 Microsoft Windows 7 Professional error [Error] {Check Cacic} Falha ao excluir m?dulo antigochksys.exe da pasta tempor?ria.
14 07/10/2015 15:10 EMATER / Central 192.168.0.6 Microsoft Windows 7 Professional error [Error] {Check Cacic} Falha ao excluir m?dulo antigochksys.exe da pasta tempor?ria.
15 07/10/2015 15:09 EMATER / Central 192.168.0.6 Microsoft Windows 7 Professional error [Error] {Check Cacic} Falha ao excluir m?dulo antigochksys.exe da pasta tempor?ria.
16 07/10/2015 15:08 EMATER / Central 192.168.0.6 Microsoft Windows 7 Professional error [Error] {Check Cacic} Falha ao excluir m?dulo antigochksys.exe da pasta tempor?ria.
17 07/10/2015 15:07 EMATER / Central 192.168.0.6 Microsoft Windows 7 Professional error [Error] {Cacic Daemon (Timer)} Falha ao excluir m?dulo antigo chksys.exe da pasta tempor?ria.
18 07/10/2015 15:13 EMATER / Central 10.1.1.203 Microsoft Windows 7 Professional error [Error] {Cacic Daemon (Timer)} Falha na coleta: Error downloading https://cacic.emater.tche.br/cacic/app_dev.php/ws/neo/coleta - server replied: Internal Server Error
19 07/10/2015 15:08 EMATER / Central 10.1.1.203 Microsoft Windows 7 Professional error [Error] {Cacic Daemon (Timer)} Falha ao enviar logs para o gerente: Arquivo de Log vazio ou inexistente.
20 07/10/2015 15:08 EMATER / Central 10.1.1.203 Microsoft Windows 7 Professional error [Error] {Cacic Daemon (Timer)} Falha na coleta: Error downloading https://cacic.emater.tche.br/cacic/app_dev.php/ws/neo/coleta - server replied: Internal Server Error
21 07/10/2015 15:06 EMATER / Central 10.1.1.203 Microsoft Windows 7 Professional error [Error] {Cacic Daemon (Timer)} Falha ao enviar logs para o gerente: Arquivo de Log vazio ou inexistente.
22 07/10/2015 15:06 EMATER / Central 10.1.1.203 Microsoft Windows 7 Professional error [Error] {Cacic Daemon (Timer)} Falha na coleta: Error downloading https://cacic.emater.tche.br/cacic/app_dev.php/ws/neo/coleta - server replied: Internal Server Error
23 07/10/2015 15:01 EMATER / Central 10.1.1.203 Microsoft Windows 7 Professional error [Error] {Cacic Daemon (Timer)} Falha ao enviar logs para o gerente: Arquivo de Log vazio ou inexistente.
24 07/10/2015 15:01 EMATER / Central 10.1.1.203 Microsoft Windows 7 Professional error [Error] {Cacic Daemon (Timer)} Falha na coleta: Error downloading https://cacic.emater.tche.br/cacic/app_dev.php/ws/neo/coleta - server replied: Internal Server Error
25 07/10/2015 15:01 EMATER / Central 10.1.1.203 Microsoft Windows 7 Professional error [Error] {Check Cacic} Falha ao excluir m?dulo antigochksys.exe da pasta tempor?ria.
26 07/10/2015 15:01 EMATER / Central 10.1.1.203 Microsoft Windows 7 Professional error [Error] {Cacic Daemon (Timer)} Problemas ao checkar m?dulos.
27 07/10/2015 15:01 EMATER / Central 10.1.1.203 Microsoft Windows 7 Professional error [Error] {CheckModules} #5 Problemas durante o download de install-cacic.exe
28 07/10/2015 15:14 EMATER / Central 192.168.10.104 Microsoft Windows 7 Professional error [Error] {Cacic Daemon (Timer)} Falha na coleta: Error downloading https://cacic.emater.tche.br/cacic/app_dev.php/ws/neo/coleta - server replied: Internal Server Error
29 07/10/2015 15:09 EMATER / Central 192.168.10.104 Microsoft Windows 7 Professional error [Error] {Cacic Daemon (Timer)} Falha ao enviar logs para o gerente: Arquivo de Log vazio ou inexistente.
30 07/10/2015 15:09 EMATER / Central 192.168.10.104 Microsoft Windows 7 Professional error [Error] {Cacic Daemon (Timer)} Falha na coleta: Error downloading https://cacic.emater.tche.br/cacic/app_dev.php/ws/neo/coleta - server replied: Internal Server Error
31 07/10/2015 15:06 EMATER / Central 192.168.10.104 Microsoft Windows 7 Professional error [Error] {Check Cacic} Falha ao excluir m?dulo antigocacic-service.exe da pasta tempor?ria.
32 07/10/2015 15:06 EMATER / Central 192.168.10.104 Microsoft Windows 7 Professional error [Error] {Check Cacic} Falha ao parar servi?o. Info: Stop Service Failed: Desconhecido
33 07/10/2015 15:06 EMATER / Central 192.168.10.104 Microsoft Windows 7 Professional error [Error] {Check Cacic} Falha ao excluir m?dulo antigochksys.exe da pasta tempor?ria.
34 07/10/2015 15:06 EMATER / Central 192.168.10.104 Microsoft Windows 7 Professional error [Error] {Check Cacic} Falha ao excluir install-cacic.exe da pasta tempor?ria.
35 07/10/2015 15:01 EMATER / Central 192.168.10.104 Microsoft Windows 7 Professional error [Error] {Cacic Daemon (Timer)} Falha ao enviar logs para o gerente: Arquivo de Log vazio ou inexistente.
36 07/10/2015 15:01 EMATER / Central 192.168.10.104 Microsoft Windows 7 Professional error [Error] {Cacic Daemon (Timer)} Falha na coleta: Error downloading https://cacic.emater.tche.br/cacic/app_dev.php/ws/neo/coleta - server replied: Internal Server Error
37 07/10/2015 15:01 EMATER / Central 192.168.10.104 Microsoft Windows 7 Professional error [Error] {Cacic Daemon (Timer)} Problemas ao checkar m?dulos.


Date Message
October 7 16:06:33 9 Matched route "cacic_computador_detalhar". request.INFO
October 7 16:06:33 4 Uncaught PHP Exception Doctrine\DBAL\DBALException: "An exception occurred while executing 'SELECT p0_.display_name AS display_name0, p0_.display_version AS display_version1, p0_.url_info_about AS url_info_about2, p0_.publisher AS publisher3, c1_.id_computador_coleta AS id_computador_coleta4, c1_.te_class_property_value AS te_class_property_value5, c1_.dt_hr_inclusao AS dt_hr_inclusao6, c1_.ativo AS ativo7, c1_.dt_hr_exclusao AS dt_hr_exclusao8, c2_.id_class_property AS id_class_property9, c2_.nm_property_name AS nm_property_name10, c2_.pretty_name AS pretty_name11, c2_.te_property_description AS te_property_description12, c2_.nm_function_pre_db AS nm_function_pre_db13, c2_.nm_function_pos_db AS nm_function_pos_db14, c2_.ativo AS ativo15, c3_.id_class AS id_class16, c3_.nm_class_name AS nm_class_name17, c3_.te_class_description AS te_class_description18, c1_.id_computador AS id_computador19, c1_.id_class_property AS id_class_property20, c1_.id_class AS id_class21, c2_.id_class AS id_class22 FROM computador_coleta c1_ INNER JOIN class_property c2_ ON c1_.id_class_property = c2_.id_class_property INNER JOIN classe c3_ ON c2_.id_class = c3_.id_class INNER JOIN computador c4_ ON (c1_.id_computador = c4_.id_computador) LEFT JOIN proriedade_software p0_ ON ((c2_.id_class_property = p0_.id_class_property AND c1_.id_computador = p0_.id_computador)) WHERE c1_.id_computador = (?) ORDER BY c3_.nm_class_name ASC, c2_.nm_property_name ASC' with params [8]: SQLSTATE[42703]: Undefined column: 7 ERROR: column c1_.ativo does not exist LINE 1: ...ty_value5, c1_.dt_hr_inclusao AS dt_hr_inclusao6, c1_.ativo ... ^" at /srv/cacic/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 91 request.CRITICAL
October 7 16:06:33 10 Read existing security token from the session. security.DEBUG
October 7 16:06:33 10 Stored the security token in the session. security.DEBUG
October 7 16:06:33 10 User was reloaded from a user provider. security.DEBUG
October 7 16:06:33 10 No expression found; abstaining from voting. security.INFO
October 7 16:06:32 8 Uncaught PHP Exception Symfony\Component\HttpKernel\Exception\NotFoundHttpException: "No route found for "GET /relatorio/computador/undefinednotifications/get" (from "https://cacic.emater.tche.br/cacic/app.php/relatorio/computador/listar")" at /srv/cacic/app/cache/prod/classes.php line 2499 request.ERROR
October 7 16:02:43 1 Uncaught PHP Exception Symfony\Component\HttpKernel\Exception\NotFoundHttpException: "No route found for "GET /relatorio/so/detalhar/undefinednotifications/get" (from "https://cacic.emater.tche.br/cacic/app.php/relatorio/so/detalhar/1")" at /srv/cacic/app/cache/prod/classes.php line 2499 request.ERROR
October 7 16:02:31 1 Uncaught PHP Exception Symfony\Component\HttpKernel\Exception\NotFoundHttpException: "No route found for "GET /relatorio/so/detalhar/undefinednotifications/get" (from "https://cacic.emater.tche.br/cacic/app.php/relatorio/so/detalhar/2")" at /srv/cacic/app/cache/prod/classes.php line 2499 request.ERROR
October 7 15:49:53 1 Uncaught PHP Exception Doctrine\DBAL\DBALException: "An exception occurred while executing 'SELECT p0_.display_name AS display_name0, p0_.display_version AS display_version1, p0_.url_info_about AS url_info_about2, p0_.publisher AS publisher3, c1_.id_computador_coleta AS id_computador_coleta4, c1_.te_class_property_value AS te_class_property_value5, c1_.dt_hr_inclusao AS dt_hr_inclusao6, c1_.ativo AS ativo7, c1_.dt_hr_exclusao AS dt_hr_exclusao8, c2_.id_class_property AS id_class_property9, c2_.nm_property_name AS nm_property_name10, c2_.pretty_name AS pretty_name11, c2_.te_property_description AS te_property_description12, c2_.nm_function_pre_db AS nm_function_pre_db13, c2_.nm_function_pos_db AS nm_function_pos_db14, c2_.ativo AS ativo15, c3_.id_class AS id_class16, c3_.nm_class_name AS nm_class_name17, c3_.te_class_description AS te_class_description18, c1_.id_computador AS id_computador19, c1_.id_class_property AS id_class_property20, c1_.id_class AS id_class21, c2_.id_class AS id_class22 FROM computador_coleta c1_ INNER JOIN class_property c2_ ON c1_.id_class_property = c2_.id_class_property INNER JOIN classe c3_ ON c2_.id_class = c3_.id_class INNER JOIN computador c4_ ON (c1_.id_computador = c4_.id_computador) LEFT JOIN proriedade_software p0_ ON ((c2_.id_class_property = p0_.id_class_property AND c1_.id_computador = p0_.id_computador)) WHERE c1_.id_computador = (?) ORDER BY c3_.nm_class_name ASC, c2_.nm_property_name ASC' with params [58]: SQLSTATE[42703]: Undefined column: 7 ERROR: column c1_.ativo does not exist LINE 1: ...ty_value5, c1_.dt_hr_inclusao AS dt_hr_inclusao6, c1_.ativo ... ^" at /srv/cacic/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 91 request.CRITICAL
October 7 15:44:38 3 Uncaught PHP Exception Doctrine\DBAL\DBALException: "An exception occurred while executing 'SELECT p0_.display_name AS display_name0, p0_.display_version AS display_version1, p0_.url_info_about AS url_info_about2, p0_.publisher AS publisher3, c1_.id_computador_coleta AS id_computador_coleta4, c1_.te_class_property_value AS te_class_property_value5, c1_.dt_hr_inclusao AS dt_hr_inclusao6, c1_.ativo AS ativo7, c1_.dt_hr_exclusao AS dt_hr_exclusao8, c2_.id_class_property AS id_class_property9, c2_.nm_property_name AS nm_property_name10, c2_.pretty_name AS pretty_name11, c2_.te_property_description AS te_property_description12, c2_.nm_function_pre_db AS nm_function_pre_db13, c2_.nm_function_pos_db AS nm_function_pos_db14, c2_.ativo AS ativo15, c3_.id_class AS id_class16, c3_.nm_class_name AS nm_class_name17, c3_.te_class_description AS te_class_description18, c1_.id_computador AS id_computador19, c1_.id_class_property AS id_class_property20, c1_.id_class AS id_class21, c2_.id_class AS id_class22 FROM computador_coleta c1_ INNER JOIN class_property c2_ ON c1_.id_class_property = c2_.id_class_property INNER JOIN classe c3_ ON c2_.id_class = c3_.id_class INNER JOIN computador c4_ ON (c1_.id_computador = c4_.id_computador) LEFT JOIN proriedade_software p0_ ON ((c2_.id_class_property = p0_.id_class_property AND c1_.id_computador = p0_.id_computador)) WHERE c1_.id_computador = (?) ORDER BY c3_.nm_class_name ASC, c2_.nm_property_name ASC' with params [50]: SQLSTATE[42703]: Undefined column: 7 ERROR: column c1_.ativo does not exist LINE 1: ...ty_value5, c1_.dt_hr_inclusao AS dt_hr_inclusao6, c1_.ativo ... ^" at /srv/cacic/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 91 request.CRITICAL
October 7 15:21:39 1 Matched route "cacic_relatorio_software_aquisicoes". request.INFO
October 7 15:21:39 1 Uncaught PHP Exception Doctrine\DBAL\DBALException: "An exception occurred while executing ' SELECT sl.id_aquisicao, aq.nr_processo, aq.nm_proprietario, aq.nr_notafiscal, aq.dt_aquisicao, aq.nm_empresa, sl.id_tipo_licenca, t.te_tipo_licenca, sl.id_aquisicao_item, aqit.dt_vencimento_licenca, aqit.nm_aquisicao, aqit.qt_licenca, aqit.te_obs, count(DISTINCT sl.id_computador) as n_comp FROM software_licencas sl INNER JOIN aquisicao aq ON sl.id_aquisicao = aq.id_aquisicao INNER JOIN tipo_licenca t ON sl.id_tipo_licenca = t.id_tipo_licenca INNER JOIN aquisicao_item aqit ON aqit.id_aquisicao_item = sl.id_aquisicao_item WHERE ( sl.comp_ativo = TRUE or sl.comp_ativo IS NULL ) AND ( sl.prop_ativo = TRUE or sl.prop_ativo IS NULL ) AND sl.id_aquisicao_item = ( SELECT sl2.id_aquisicao_item FROM software_licencas sl2 WHERE sl2.id_computador = sl.id_computador AND sl2.id_aquisicao = sl.id_aquisicao ORDER BY sl2.data_coleta DESC LIMIT 1 ) GROUP BY sl.id_aquisicao, aq.nr_processo, aq.nm_proprietario, aq.nr_notafiscal, aq.dt_aquisicao, aq.nm_empresa, sl.id_tipo_licenca, sl.id_tipo_licenca, t.te_tipo_licenca, sl.id_aquisicao_item, aqit.dt_vencimento_licenca, aqit.nm_aquisicao, aqit.qt_licenca, aqit.te_obs ORDER BY sl.id_aquisicao ': SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "software_licencas" does not exist LINE 16: FROM software_licencas sl ^" at /srv/cacic/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 91 request.CRITICAL
October 7 15:04:05 1 Uncaught PHP Exception Doctrine\DBAL\DBALException: "An exception occurred while executing 'SELECT p0_.display_name AS display_name0, p0_.display_version AS display_version1, p0_.url_info_about AS url_info_about2, p0_.publisher AS publisher3, c1_.id_computador_coleta AS id_computador_coleta4, c1_.te_class_property_value AS te_class_property_value5, c1_.dt_hr_inclusao AS dt_hr_inclusao6, c1_.ativo AS ativo7, c1_.dt_hr_exclusao AS dt_hr_exclusao8, c2_.id_class_property AS id_class_property9, c2_.nm_property_name AS nm_property_name10, c2_.pretty_name AS pretty_name11, c2_.te_property_description AS te_property_description12, c2_.nm_function_pre_db AS nm_function_pre_db13, c2_.nm_function_pos_db AS nm_function_pos_db14, c2_.ativo AS ativo15, c3_.id_class AS id_class16, c3_.nm_class_name AS nm_class_name17, c3_.te_class_description AS te_class_description18, c1_.id_computador AS id_computador19, c1_.id_class_property AS id_class_property20, c1_.id_class AS id_class21, c2_.id_class AS id_class22 FROM computador_coleta c1_ INNER JOIN class_property c2_ ON c1_.id_class_property = c2_.id_class_property INNER JOIN classe c3_ ON c2_.id_class = c3_.id_class INNER JOIN computador c4_ ON (c1_.id_computador = c4_.id_computador) LEFT JOIN proriedade_software p0_ ON ((c2_.id_class_property = p0_.id_class_property AND c1_.id_computador = p0_.id_computador)) WHERE c1_.id_computador = (?) ORDER BY c3_.nm_class_name ASC, c2_.nm_property_name ASC' with params [52]: SQLSTATE[42703]: Undefined column: 7 ERROR: column c1_.ativo does not exist LINE 1: ...ty_value5, c1_.dt_hr_inclusao AS dt_hr_inclusao6, c1_.ativo ... ^" at /srv/cacic/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 91 request.CRITICAL
October 7 15:03:58 1 Uncaught PHP Exception Symfony\Component\HttpKernel\Exception\NotFoundHttpException: "No route found for "GET /relatorio/computador/undefinednotifications/get" (from "https://cacic.emater.tche.br/cacic/app.php/relatorio/computador/subredes")" at /srv/cacic/app/cache/prod/classes.php line 2499 request.ERROR
October 7 15:00:10 2 AUTH: Erro de autenticação. IP = 192.168.10.82 app.ERROR
October 7 15:00:10 1 Matched route "cacic_common_login". request.INFO

_______________________________________________
Cacic mailing list
Cacic@listas.softwarepublico.gov.br
https://listas.softwarepublico.gov.br/mailman/cgi-bin/listinfo/cacic

_______________________________________________
Cacic mailing list
Cacic@listas.softwarepublico.gov.br
https://listas.softwarepublico.gov.br/mailman/cgi-bin/listinfo/cacic


_______________________________________________
Cacic mailing list
Cacic@listas.softwarepublico.gov.br
https://listas.softwarepublico.gov.br/mailman/cgi-bin/listinfo/cacic