Cacic - Configurador Automático e Coletor de Informações Computacionais

Participe

Repositório

Wiki

Ajuda

Membros

codebuilderspk

Ver todos(as)

Voltar a Cacic Suporte

Boa tarde,

Ao cadastrar uma sub-rede (a primeira na verdade) o erro abaixo ocorre. Alguém pode me ajudar?

An exception occurred while executing 'INSERT INTO rede (te_ip_rede, nm_rede, te_observacao, nm_pessoa_contato1, nm_pessoa_contato2, nu_telefone1, te_email_contato2, nu_telefone2, te_email_contato1, te_serv_cacic, te_serv_updates, te_path_serv_updates, nm_usuario_login_serv_updates, te_senha_login_serv_updates, nu_porta_serv_updates, te_mascara_rede, dt_verifica_updates, nm_usuario_login_serv_updates_gerente, te_senha_login_serv_updates_gerente, nu_limite_ftp, cs_permitir_desativar_srcacic, te_debugging, dt_debug, download_method, id_local, id_servidor_autenticacao) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params ["10.71.0.0", "sub-rede 01", "observa\u00e7\u00f5es 01", null, null, "", null, "", null, "servidor 01", "servidor 01", null, "ftpcacic", "suporte", "21", "255.255.255.0", null, "ftpcacic", "suporte", 100, null, null, null, null, 1, null]:

SQLSTATE[23502]: Not null violation: 7 ERRO: valor nulo na coluna "cs_permitir_desativar_srcacic" viola a restrição não-nula
500 Internal Server Error - DBALException
1 linked Exception:

    PDOException »

[2/2] DBALException: An exception occurred while executing 'INSERT INTO rede (te_ip_rede, nm_rede, te_observacao, nm_pessoa_contato1, nm_pessoa_contato2, nu_telefone1, te_email_contato2, nu_telefone2, te_email_contato1, te_serv_cacic, te_serv_updates, te_path_serv_updates, nm_usuario_login_serv_updates, te_senha_login_serv_updates, nu_porta_serv_updates, te_mascara_rede, dt_verifica_updates, nm_usuario_login_serv_updates_gerente, te_senha_login_serv_updates_gerente, nu_limite_ftp, cs_permitir_desativar_srcacic, te_debugging, dt_debug, download_method, id_local, id_servidor_autenticacao) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params ["10.71.0.0", "sub-rede 01", "observa\u00e7\u00f5es 01", null, null, "", null, "", null, "servidor 01", "servidor 01", null, "ftpcacic", "suporte", "21", "255.255.255.0", null, "ftpcacic", "suporte", 100, null, null, null, null, 1, null]:

SQLSTATE[23502]: Not null violation: 7 ERRO: valor nulo na coluna "cs_permitir_desativar_srcacic" viola a restrição não-nula +

    INFO - Matched route "cacic_subrede_cadastrar" (parameters: "_controller": "Cacic\CommonBundle\Controller\RedeController::cadastrarAction", "_route": "cacic_subrede_cadastrar")
    DEBUG - Read SecurityContext from the session
    DEBUG - Reloading user from user provider.
    DEBUG - SELECT t0.id_usuario AS id_usuario1, t0.id_usuario_ldap AS id_usuario_ldap2, t0.nm_usuario_acesso AS nm_usuario_acesso3, t0.nm_usuario_completo AS nm_usuario_completo4, t0.nm_usuario_completo_ldap AS nm_usuario_completo_ldap5, t0.te_senha AS te_senha6, t0.dt_log_in AS dt_log_in7, t0.te_emails_contato AS te_emails_contato8, t0.te_telefones_contato AS te_telefones_contato9, t0.api_key AS api_key10, t0.crypt_key AS crypt_key11, t0.is_active AS is_active12, t0.id_local AS id_local13, t0.id_servidor_autenticacao AS id_servidor_autenticacao14, t0.id_grupo_usuario AS id_grupo_usuario15 FROM usuario t0 WHERE t0.id_usuario = ?
    DEBUG - Username "admin" was reloaded from user provider.
    DEBUG - SELECT t0.id_grupo_usuario AS id_grupo_usuario1, t0.nm_grupo_usuarios AS nm_grupo_usuarios2, t0.te_grupo_usuarios AS te_grupo_usuarios3, t0.te_menu_grupo AS te_menu_grupo4, t0.te_descricao_grupo AS te_descricao_grupo5, t0.cs_nivel_administracao AS cs_nivel_administracao6, t0.role AS role7 FROM grupo_usuario t0 WHERE t0.id_grupo_usuario = ?
    INFO - No expression found; abstaining from voting.
    DEBUG - Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\ErrorsLoggerListener::injectLogger".
    DEBUG - Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\ErrorsLoggerListener::injectLogger".
    DEBUG - Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\ErrorsLoggerListener::injectLogger".
    DEBUG - Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure".
    DEBUG - Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelRequest".
    DEBUG - Notified event "kernel.request" to listener "Symfony\Bundle\FrameworkBundle\EventListener\SessionListener::onKernelRequest".
    DEBUG - Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest".
    DEBUG - Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest".
    DEBUG - Notified event "kernel.request" to listener "Symfony\Component\Security\Http\Firewall::onKernelRequest".
    DEBUG - Notified event "kernel.request" to listener "Symfony\Bundle\AsseticBundle\EventListener\RequestListener::onKernelRequest".
    DEBUG - Notified event "kernel.request" to listener "Knp\Bundle\PaginatorBundle\Subscriber\SlidingPaginationSubscriber::onKernelRequest".
    DEBUG - Notified event "kernel.request" to listener "Knp\Bundle\MenuBundle\EventListener\VoterInitializerListener::onKernelRequest".
    DEBUG - Notified event "kernel.controller" to listener "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController".
    DEBUG - Notified event "kernel.controller" to listener "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController".
    DEBUG - Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\ControllerListener::onKernelController".
    DEBUG - Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\ParamConverterListener::onKernelController".
    DEBUG - Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\TemplateListener::onKernelController".
    DEBUG - SELECT t0.id_local AS id_local1, t0.nm_local AS nm_local2, t0.sg_local AS sg_local3, t0.te_observacao AS te_observacao4, t0.te_debugging AS te_debugging5, t0.dt_debug AS dt_debug6 FROM local t0
    DEBUG - SELECT t0.id_rede AS id_rede1, t0.te_ip_rede AS te_ip_rede2, t0.nm_rede AS nm_rede3, t0.te_observacao AS te_observacao4, t0.nm_pessoa_contato1 AS nm_pessoa_contato15, t0.nm_pessoa_contato2 AS nm_pessoa_contato26, t0.nu_telefone1 AS nu_telefone17, t0.te_email_contato2 AS te_email_contato28, t0.nu_telefone2 AS nu_telefone29, t0.te_email_contato1 AS te_email_contato110, t0.te_serv_cacic AS te_serv_cacic11, t0.te_serv_updates AS te_serv_updates12, t0.te_path_serv_updates AS te_path_serv_updates13, t0.nm_usuario_login_serv_updates AS nm_usuario_login_serv_updates14, t0.te_senha_login_serv_updates AS te_senha_login_serv_updates15, t0.nu_porta_serv_updates AS nu_porta_serv_updates16, t0.te_mascara_rede AS te_mascara_rede17, t0.dt_verifica_updates AS dt_verifica_updates18, t0.nm_usuario_login_serv_updates_gerente AS nm_usuario_login_serv_updates_gerente19, t0.te_senha_login_serv_updates_gerente AS te_senha_login_serv_updates_gerente20, t0.nu_limite_ftp AS nu_limite_ftp21, t0.cs_permitir_desativar_srcacic AS cs_permitir_desativar_srcacic22, t0.te_debugging AS te_debugging23, t0.dt_debug AS dt_debug24, t0.download_method AS download_method25, t0.id_local AS id_local26, t0.id_servidor_autenticacao AS id_servidor_autenticacao27 FROM rede t0
    DEBUG - SELECT t0.id_rede AS id_rede1, t0.te_ip_rede AS te_ip_rede2, t0.nm_rede AS nm_rede3, t0.te_observacao AS te_observacao4, t0.nm_pessoa_contato1 AS nm_pessoa_contato15, t0.nm_pessoa_contato2 AS nm_pessoa_contato26, t0.nu_telefone1 AS nu_telefone17, t0.te_email_contato2 AS te_email_contato28, t0.nu_telefone2 AS nu_telefone29, t0.te_email_contato1 AS te_email_contato110, t0.te_serv_cacic AS te_serv_cacic11, t0.te_serv_updates AS te_serv_updates12, t0.te_path_serv_updates AS te_path_serv_updates13, t0.nm_usuario_login_serv_updates AS nm_usuario_login_serv_updates14, t0.te_senha_login_serv_updates AS te_senha_login_serv_updates15, t0.nu_porta_serv_updates AS nu_porta_serv_updates16, t0.te_mascara_rede AS te_mascara_rede17, t0.dt_verifica_updates AS dt_verifica_updates18, t0.nm_usuario_login_serv_updates_gerente AS nm_usuario_login_serv_updates_gerente19, t0.te_senha_login_serv_updates_gerente AS te_senha_login_serv_updates_gerente20, t0.nu_limite_ftp AS nu_limite_ftp21, t0.cs_permitir_desativar_srcacic AS cs_permitir_desativar_srcacic22, t0.te_debugging AS te_debugging23, t0.dt_debug AS dt_debug24, t0.download_method AS download_method25, t0.id_local AS id_local26, t0.id_servidor_autenticacao AS id_servidor_autenticacao27 FROM rede t0
    DEBUG - "START TRANSACTION"
    DEBUG - INSERT INTO rede (te_ip_rede, nm_rede, te_observacao, nm_pessoa_contato1, nm_pessoa_contato2, nu_telefone1, te_email_contato2, nu_telefone2, te_email_contato1, te_serv_cacic, te_serv_updates, te_path_serv_updates, nm_usuario_login_serv_updates, te_senha_login_serv_updates, nu_porta_serv_updates, te_mascara_rede, dt_verifica_updates, nm_usuario_login_serv_updates_gerente, te_senha_login_serv_updates_gerente, nu_limite_ftp, cs_permitir_desativar_srcacic, te_debugging, dt_debug, download_method, id_local, id_servidor_autenticacao) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
    DEBUG - "ROLLBACK"
    CRITICAL - Uncaught PHP Exception Doctrine\DBAL\DBALException: "An exception occurred while executing 'INSERT INTO rede (te_ip_rede, nm_rede, te_observacao, nm_pessoa_contato1, nm_pessoa_contato2, nu_telefone1, te_email_contato2, nu_telefone2, te_email_contato1, te_serv_cacic, te_serv_updates, te_path_serv_updates, nm_usuario_login_serv_updates, te_senha_login_serv_updates, nu_porta_serv_updates, te_mascara_rede, dt_verifica_updates, nm_usuario_login_serv_updates_gerente, te_senha_login_serv_updates_gerente, nu_limite_ftp, cs_permitir_desativar_srcacic, te_debugging, dt_debug, download_method, id_local, id_servidor_autenticacao) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params ["10.71.0.0", "sub-rede 01", "observa\u00e7\u00f5es 01", null, null, "", null, "", null, "servidor 01", "servidor 01", null, "ftpcacic", "suporte", "21", "255.255.255.0", null, "ftpcacic", "suporte", 100, null, null, null, null, 1, null]: SQLSTATE[23502]: Not null violation: 7 ERRO: valor nulo na coluna "cs_permitir_desativar_srcacic" viola a restrição não-nula" at /srv/cacic/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 91
    DEBUG - Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\ErrorsLoggerListener::injectLogger".
    DEBUG - Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\ErrorsLoggerListener::injectLogger".
    DEBUG - Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\ErrorsLoggerListener::injectLogger".
    DEBUG - Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure".
    DEBUG - Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelRequest".
    DEBUG - Notified event "kernel.request" to listener "Symfony\Bundle\FrameworkBundle\EventListener\SessionListener::onKernelRequest".
    DEBUG - Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest".
    DEBUG - Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest".
    DEBUG - Notified event "kernel.request" to listener "Symfony\Component\Security\Http\Firewall::onKernelRequest".
    DEBUG - Notified event "kernel.request" to listener "Symfony\Bundle\AsseticBundle\EventListener\RequestListener::onKernelRequest".
    DEBUG - Notified event "kernel.request" to listener "Knp\Bundle\PaginatorBundle\Subscriber\SlidingPaginationSubscriber::onKernelRequest".
    DEBUG - Notified event "kernel.request" to listener "Knp\Bundle\MenuBundle\EventListener\VoterInitializerListener::onKernelRequest".
    DEBUG - Notified event "kernel.controller" to listener "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController".
    DEBUG - Notified event "kernel.controller" to listener "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController".
    DEBUG - Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\ControllerListener::onKernelController".
    DEBUG - Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\ParamConverterListener::onKernelController".
    DEBUG - Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\TemplateListener::onKernelController".

Autor: Adilson Oliveira Cruz

Discussões
Blog
Feed do Repositório

CONVITE EVENTO: Comemoração 10 anos da comunidade CACIC

18 de Junho de 2015, 16:52, por Desconhecido

No dia 24 de junho de 2014 às 15:00 horas, próxima quarta-feira, o CISL-Comitê Técnico de Implementação do Software Livre no Governo Federal vai organizar o evento de comemoração de 10 anos da comunidade CACIC, que alcançou no mês de junho mais de 40 mil pessoas interessadas na comunidade. Durante o evento será apresentado o estágio atual da solução e serão debatidas as demandas para as futuras versões. A atual versão é resultado do apoio no desenvolvimento dado pela Dataprev, Ministério do Planejamento, Procuradoria Geral da Fazenda e membros da comunidade.

sem comentários ainda Leia mais

AJUDA (Executando comandos do Symfony)

23 de Abril de 2015, 14:32, por Desconhecido

Na parte de eu usar comando "php composer.phar install"

sem comentários ainda Leia mais

Suporte

19 de Fevereiro de 2015, 14:11, por Desconhecido

Autor: Anderson Porto

sem comentários ainda Leia mais

Em construção

8 de Dezembro de 2014, 9:07, por Marisa Souza dos Santos

Em construção.

COCAR vai se integrar ao CACIC

22 de Novembro de 2013, 13:53, por Desconhecido

O COCAR passa por um processo de reformulação completa para ser integrado ao Sistema de Inventário CACIC, bem como às mais recentes tecnologias e padrões de desenvolvimento em Software Livre.

sem comentários ainda Leia mais