Text archives


Re: [pstage-utilisateurs] Erreur création nouvelle convention en PStage V2.2.2


Chronological Thread 
  • From: Thierry Sebbar < >
  • To: " " < >
  • Subject: Re: [pstage-utilisateurs] Erreur création nouvelle convention en PStage V2.2.2
  • Date: Mon, 20 Oct 2014 14:25:46 +0000
  • Accept-language: fr-FR, en-US

J'ai oublié de joindre le fichier de config Esup-Pstage (ci-joint).

Merci de votre aide.

De : Thierry SEBBAR < >
Répondre à : Thierry SEBBAR < >
Date : lundi 20 octobre 2014 15:40
À : " " < >
Objet : [pstage-utilisateurs] Erreur création nouvelle convention en PStage V2.2.2

Bonjour;

Je viens de mettre à jour Esup-PStage de V2.1.0 à V2.2.2 en test.
En essayant de créer une nouvelle convention, j'ai eu l'erreur ci-dessous à l'Etape 8 - Récapitulatif de la convention (par clic sue le bouton "Créer").
(Les données de l'étudiant ont été modifiées

Pour info :
Voici la structure de la table Affectation :
CREATE TABLE IF NOT EXISTS `Affectation` (
  `codeAffectation` varchar(10) NOT NULL,
  `libelleAffectation` varchar(150) default NULL,
  `codeUniversite` varchar(50) NOT NULL default ' ',
  PRIMARY KEY  (`codeAffectation`,`codeUniversite`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Et dedans, j'ai uniquement des enregistrements de ce type :
codeAffectation libelleAffectation codeUniversite
16901 UFR des sciences et techniques des activités physi...075172N
….
Donc aucun de type codeAffectation = "{APOGEE}8SP"

Dans la fenêtre du navigateur :
Une erreur s'est produite à l'enregistrement de l'Ufr : SqlMapClient operation; SQL []; --- The error occurred in META-INF/dao/ibatis/mapping/affectation.xml. --- The error occurred while applying a parameter map. --- Check the addAffectation-InlineParameterMap. --- Check the statement (update failed). --- Cause: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'codeAffectation' at row 1; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in META-INF/dao/ibatis/mapping/affectation.xml. --- The error occurred while applying a parameter map. --- Check the addAffectation-InlineParameterMap. --- Check the statement (update failed). --- Cause: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'codeAffectation' at row 1.


Dans le log PStage :
2014-10-20 14:40:23,408 ERROR [TP-Processor12, org.esupportail.pstage.web.controllers.ConventionController] - WebServiceDataBaseException
org.esupportail.pstagedata.exceptions.WebServiceDataBaseException: SqlMapClient operation; SQL [];   
--- The error occurred in META-INF/dao/ibatis/mapping/affectation.xml.  
--- The error occurred while applying a parameter map.  
--- Check the addAffectation-InlineParameterMap.  
--- Check the statement (update failed).  
--- Cause: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'codeAffectation' at row 1; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:   
--- The error occurred in META-INF/dao/ibatis/mapping/affectation.xml.  
--- The error occurred while applying a parameter map.  
--- Check the addAffectation-InlineParameterMap.  
--- Check the statement (update failed).  
--- Cause: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'codeAffectation' at row 1
at org.esupportail.pstage.web.controllers.ConventionController.goToAjouterConvention(ConventionController.java:1963)

Dans le log PStage-Data :
2014-10-20 14:40:23,344 DEBUG [http-8480-1, java.sql.Connection] - {conn-104851} Connection
2014-10-20 14:40:23,344 DEBUG [http-8480-1, java.sql.Connection] - {conn-104851} Preparing Statement:          INSERT INTO Etape (codeEtape,codeVersionEtape, libelleEtape, codeUniversite)   VALUES (?, ?, ?, ?);
2014-10-20 14:40:23,353 DEBUG [http-8480-1, java.sql.PreparedStatement] - {pstm-104852} Executing Statement:          INSERT INTO Etape (codeEtape,codeVersionEtape, libelleEtape, codeUniversite)   VALUES (?, ?, ?, ?);
2014-10-20 14:40:23,353 DEBUG [http-8480-1, java.sql.PreparedStatement] - {pstm-104852} Parameters: [AMP402, 421, M 2 MEEF 2ND DEGRE PLC, 075172N]
2014-10-20 14:40:23,353 DEBUG [http-8480-1, java.sql.PreparedStatement] - {pstm-104852} Types: [java.lang.String, java.lang.String, java.lang.String, java.lang.String]
20 oct. 2014 14:40:23 org.apache.cxf.phase.PhaseInterceptorChain doDefaultLogging
INFO: Application {http://remote.pstagedata.esupportail.org/}RemoteServicesImplService#{http://remote.pstagedata.esupportail.org/}addEtape has thrown exception, unwinding now: org.esupportail.pstagedata.exceptions.EtapeAlreadyExistingForCodeException: Etape deja existante pour code : AMP402
2014-10-20 14:40:23,362 DEBUG [http-8480-1, java.sql.Connection] - {conn-104853} Connection
2014-10-20 14:40:23,362 DEBUG [http-8480-1, java.sql.Connection] - {conn-104853} Preparing Statement:         INSERT IGNORE INTO Ufr (codeUFR, libelleUFR, codeUniversite)   VALUES (?, ?, ?);
2014-10-20 14:40:23,367 DEBUG [http-8480-1, java.sql.PreparedStatement] - {pstm-104854} Executing Statement:         INSERT IGNORE INTO Ufr (codeUFR, libelleUFR, codeUniversite)   VALUES (?, ?, ?);
2014-10-20 14:40:23,367 DEBUG [http-8480-1, java.sql.PreparedStatement] - {pstm-104854} Parameters: [8SP, UFR STAPS, 075172N]
2014-10-20 14:40:23,367 DEBUG [http-8480-1, java.sql.PreparedStatement] - {pstm-104854} Types: [java.lang.String, java.lang.String, java.lang.String]
2014-10-20 14:40:23,367 DEBUG [http-8480-1, java.sql.Connection] - {conn-104853} Preparing Statement:     SELECT LAST_INSERT_ID()
2014-10-20 14:40:23,367 DEBUG [http-8480-1, java.sql.PreparedStatement] - {pstm-104855} Executing Statement:     SELECT LAST_INSERT_ID()
2014-10-20 14:40:23,367 DEBUG [http-8480-1, java.sql.PreparedStatement] - {pstm-104855} Parameters: []
2014-10-20 14:40:23,367 DEBUG [http-8480-1, java.sql.PreparedStatement] - {pstm-104855} Types: []
2014-10-20 14:40:23,367 DEBUG [http-8480-1, java.sql.ResultSet] - {rset-104856} ResultSet
2014-10-20 14:40:23,368 DEBUG [http-8480-1, java.sql.ResultSet] - {rset-104856} Header: [LAST_INSERT_ID()]
2014-10-20 14:40:23,368 DEBUG [http-8480-1, java.sql.ResultSet] - {rset-104856} Result: [0]
2014-10-20 14:40:23,379 DEBUG [http-8480-1, java.sql.Connection] - {conn-104857} Connection
2014-10-20 14:40:23,379 DEBUG [http-8480-1, java.sql.Connection] - {conn-104857} Preparing Statement:          INSERT INTO Etudiant          ( idEtudiant,identEtudiant,nom,nomMarital,prenom,mail,numEtudiant,codeUniversite,codeSexe,dateNais,          loginCreation,dateCreation)               VALUES      ( ?,?,?,?,?,?,?,?,?,?,          ?,CURRENT_TIMESTAMP())
2014-10-20 14:40:23,384 DEBUG [http-8480-1, java.sql.PreparedStatement] - {pstm-104858} Executing Statement:          INSERT INTO Etudiant          ( idEtudiant,identEtudiant,nom,nomMarital,prenom,mail,numEtudiant,codeUniversite,codeSexe,dateNais,          loginCreation,dateCreation)               VALUES      ( ?,?,?,?,?,?,?,?,?,?,          ?,CURRENT_TIMESTAMP())
2014-10-20 14:40:23,384 DEBUG [http-8480-1, java.sql.PreparedStatement] - {pstm-104858} Parameters: [0, hyyyyyy, EVANOVA, null, MAXIME, , 20602806, 075172N, M, 1988-03-18 00:00:00.0, sebbar]
2014-10-20 14:40:23,384 DEBUG [http-8480-1, java.sql.PreparedStatement] - {pstm-104858} Types: [java.lang.Integer, java.lang.String, java.lang.String, null, java.lang.String, java.lang.String, java.lang.String, java.lang.String, java.lang.String, java.sql.Timestamp, java.lang.String]
2014-10-20 14:40:23,388 DEBUG [http-8480-1, java.sql.Connection] - {conn-104859} Connection
2014-10-20 14:40:23,388 DEBUG [http-8480-1, java.sql.Connection] - {conn-104859} Preparing Statement:    SELECT * FROM Etudiant   WHERE identEtudiant = ?   AND codeUniversite = ?   LIMIT 0,1
2014-10-20 14:40:23,392 DEBUG [http-8480-1, java.sql.PreparedStatement] - {pstm-104860} Executing Statement:    SELECT * FROM Etudiant   WHERE identEtudiant = ?   AND codeUniversite = ?   LIMIT 0,1
2014-10-20 14:40:23,392 DEBUG [http-8480-1, java.sql.PreparedStatement] - {pstm-104860} Parameters: [hyyyyyy, 075172N]
2014-10-20 14:40:23,392 DEBUG [http-8480-1, java.sql.PreparedStatement] - {pstm-104860} Types: [java.lang.String, java.lang.String]
2014-10-20 14:40:23,393 DEBUG [http-8480-1, java.sql.ResultSet] - {rset-104861} ResultSet
2014-10-20 14:40:23,393 DEBUG [http-8480-1, java.sql.ResultSet] - {rset-104861} Header: [idEtudiant, identEtudiant, nom, nomMarital, prenom, mail, numEtudiant, codeUniversite, codeSexe, dateNais, loginCreation, dateCreation, loginModif, dateModif]
2014-10-20 14:40:23,393 DEBUG [http-8480-1, java.sql.ResultSet] - {rset-104861} Result: [26, hyyyyyy, EVANOVA, null, MAXIME, , 20602806, 075172N, M, 1988-03-18 00:00:00.0, mmmmm, 2014-10-20 10:17:43.0, null, null]
2014-10-20 14:40:23,399 DEBUG [http-8480-1, java.sql.Connection] - {conn-104862} Connection
2014-10-20 14:40:23,399 DEBUG [http-8480-1, java.sql.Connection] - {conn-104862} Preparing Statement:    INSERT INTO Affectation (CodeAffectation,libelleAffectation, codeUniversite)   VALUES (?,?, ?)
2014-10-20 14:40:23,404 DEBUG [http-8480-1, java.sql.PreparedStatement] - {pstm-104863} Executing Statement:    INSERT INTO Affectation (CodeAffectation,libelleAffectation, codeUniversite)   VALUES (?,?, ?)
2014-10-20 14:40:23,404 DEBUG [http-8480-1, java.sql.PreparedStatement] - {pstm-104863} Parameters: [{APOGEE}8SP, , 075172N]
2014-10-20 14:40:23,404 DEBUG [http-8480-1, java.sql.PreparedStatement] - {pstm-104863} Types: [java.lang.String, java.lang.String, java.lang.String]
20 oct. 2014 14:40:23 org.apache.cxf.phase.PhaseInterceptorChain doDefaultLogging
INFO: Application {http://remote.pstagedata.esupportail.org/}RemoteServicesImplService#{http://remote.pstagedata.esupportail.org/}addAffectation has thrown exception, unwinding now: org.esupportail.pstagedata.exceptions.WebServiceDataBaseException: SqlMapClient operation; SQL [];
--- The error occurred in META-INF/dao/ibatis/mapping/affectation.xml.
--- The error occurred while applying a parameter map.
--- Check the addAffectation-InlineParameterMap.
--- Check the statement (update failed).
--- Cause: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column codeAffectation at row 1; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in META-INF/dao/ibatis/mapping/affectation.xml.
--- The error occurred while applying a parameter map.
--- Check the addAffectation-InlineParameterMap.
--- Check the statement (update failed).
--- Cause: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column codeAffectation at row 1

Attachment: PStage_config.properties
Description: PStage_config.properties




Archive powered by MHonArc 2.6.19.