Uploaded image for project: 'Offre de formation'
  1. Offre de formation
  2. ODF-489

Error du bouton "Synchronisation globale" d'ODF

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Major Major
    • 2.0.0
    • None
    • None
    • None

      Bonjour

      Quand je fait "Synchronisation globale" du module ODF, j'ai eu des erreurs:

      • ERROR : org.ametys.runtime.plugins.core.sqlmap.dao.DataAccessException: Unable to get education add elements from DIP : 5E29, VDI: 101
        at org.ametys.odf.apogee.daos.DefaultApogeeDAO.getAddElements(DefaultApogeeDAO.java:116)
        at org.ametys.odf.apogee.program.ApogeeProgramsSynchronizationManager._synchronizeProgram(ApogeeProgramsSynchronizationManager.java:272)
        at org.ametys.odf.apogee.program.ApogeeProgramsSynchronizationManager.synchronizePrograms(ApogeeProgramsSynchronizationManager.java:176)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.ametys.runtime.plugin.component.PluginsComponentManager$ComponentInvocationHandler.invoke(PluginsComponentManager.java:159)
        at $Proxy30.synchronizePrograms(Unknown Source)
        at org.ametys.odf.apogee.synchronization.ApogeeGlobalSynchronizationManager.synchronize(ApogeeGlobalSynchronizationManager.java:81)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.ametys.runtime.plugin.component.PluginsComponentManager$ComponentInvocationHandler.invoke(PluginsComponentManager.java:159)
        at $Proxy31.synchronize(Unknown Source)
        at org.ametys.odf.synchronization.GlobalSynchronizationEngine._synchronize(GlobalSynchronizationEngine.java:126)
        at org.ametys.odf.synchronization.GlobalSynchronizationEngine.run(GlobalSynchronizationEngine.java:110)
        at java.lang.Thread.run(Thread.java:662)
        Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:
          • The error occurred in file:/home/cms/Ametys_CMS/application/v1_1_0/cms/WEB-INF/param/odf/apogee/programs.xml.
          • The error occurred while applying a parameter map.
          • Check the Programs.getAddElements-InlineParameterMap.
          • Check the statement (query failed).
          • Cause: java.sql.SQLException: ORA-00942: Table ou vue inexistante
            at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:185)
            at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForObject(GeneralStatement.java:104)
            at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:566)
            at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:541)
            at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(SqlMapSessionImpl.java:106)
            at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForObject(SqlMapClientImpl.java:83)
            at org.ametys.odf.apogee.daos.DefaultApogeeDAO.getAddElements(DefaultApogeeDAO.java:112)
            ... 18 more
            Caused by: java.sql.SQLException: ORA-00942: Table ou vue inexistante
            at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
            at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
            at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
            at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
            at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:219)
            at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:813)
            at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1049)
            at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:854)
            at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1154)
            at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3370)
            at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3476)
            at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
            at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
            at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:186)
            at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQuery(GeneralStatement.java:205)
            at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:173)

      J'ai testé la requête "getAddElements", elle fonctionne sauf elle trouve aucun element, c'est pas plutôt à gérer en exception?

      2ème error

      • ERROR : Impossible de retrouver l'ELP : 1FUANG1D, ce code n'existe plus dans Apogée.

      3ème error

      • ERROR : Unable to retrieve the person with login : xxxx, this code no longer exists in the LDAP directory

      Où et comment je peux corriger ces erreurs?

      Merci d'avance pour votre aide
      Cordialement

            Unassigned Unassigned
            duffy Chong WU
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: