PATIENTE AVIRON 2
J'ai voulu réimporter la patiente AVIRON que j'ai nommé "2" pour la distinguer de la 1ère importation et de nouveau, je rencontre le pb d'importation à QMED : ci-dessous le message d'erreur
Grails Runtime Exception
Error Details
Error 500: Executing action [uploadQmed] of controller [com.eggman.sttdatabase.MereController] caused exception: Hibernate operation: could not insert: [com.eggman.sttdatabase.Qmed]; uncategorized SQLException for SQL [insert into qmed (version, age_enfant, anomalie, anomalie_tonus, appui_avt_bras, autres, caracteristiques, clonus_chev, compli_cardiaque, compli_cardiaque_rq, compli_renale, compli_renale_rq, controle_tete_faible, convulsion, date, deplace, detresse_respi, dev_mental, dev_mental_rq, dev_psycho_mot, dev_psycho_mot_rq, dim_angle_add, dim_dorsiflex_chev, dpb, enfant_id, enterocolite, enterocolite_rq, etat_moteur, etf, etf_rq, examen_clinique, flex_infd, flex_infg, flex_supd, flex_supg, grade, hi_encephalopathie, hiv, hiv_niveau, hypertonie_inf, hypertonie_sup, hypoplasie_pulmo, hypotonie_axe, hypotonie_inf, hypotonie_sup, imc, irm, irm_rq, joue_mains, leucomalacie, limitation_inf, limitation_sup, maladie_pulmo_chronique, malfo, malfo_rq, mmh, mvt_anormaux, nb_jours_ventil, nystagmus, pb_autres, pc, perte_acuite, poids, prob_futur, prob_futur_rq, prob_gastro, prob_gastro_rq, prob_hemodyn, prob_hemodyn_rq, prob_infect, prob_infect_rq, prob_neuro, prob_ophtalmo, prob_ophtalmo_rq, prob_psycho_mot, prob_psycho_mot_rq, pronation_supd, pronation_supg, reagit_prenom, reagit_son, remarque_gale, repete_syllabe, respi_autre, rot_augm_inf, rot_augm_sup, saisit_pouce, sequelles, souleve_epaules, sourire, stimul_son, strabisme, taille, tient_sans_appui, tient_tete, tourne_tete, transfusion, trouble_auditif, troubles_compo, type_qmed, ventillation) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; SQL state [HY000]; error code [1364]; Field 'rq' doesn't have a default value; nested exception is java.sql.SQLException: Field 'rq' doesn't have a default value
Servlet: grails
URI: /sttdatabase/grails/mere/uploadQmed.dispatch
Exception Message: Field 'rq' doesn't have a default value
Caused by: Field 'rq' doesn't have a default value
Class: MereController
At Line: [3680]
Code Snippet:
Stack Trace
java.sql.SQLException: Field 'rq' doesn't have a default value
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3558)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3490)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2109)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2648)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2077)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2362)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2280)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2265)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at $Proxy188.saveOrUpdate(Unknown Source)
at com.eggman.sttdatabase.MereController$_closure32.doCall(MereController.groovy:3680)
at com.eggman.sttdatabase.MereController$_closure32.doCall(MereController.groovy)
at com.sun.enterprise.web.WebPipeline.invoke(WebPipeline.java:98)
at com.sun.enterprise.web.PESessionLockingStandardPipeline.invoke(PESessionLockingStandardPipeline.java:91)
at com.sun.enterprise.v3.services.impl.ContainerMapper.service(ContainerMapper.java:170)
at com.sun.grizzly.http.ProcessorTask.invokeAdapter(ProcessorTask.java:822)
at com.sun.grizzly.http.ProcessorTask.doProcess(ProcessorTask.java:719)
at com.sun.grizzly.http.ProcessorTask.process(ProcessorTask.java:1013)
at com.sun.grizzly.http.DefaultProtocolFilter.execute(DefaultProtocolFilter.java:225)
at com.sun.grizzly.DefaultProtocolChain.executeProtocolFilter(DefaultProtocolChain.java:137)
at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:104)
at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:90)
at com.sun.grizzly.http.HttpProtocolChain.execute(HttpProtocolChain.java:79)
at com.sun.grizzly.ProtocolChainContextTask.doCall(ProtocolChainContextTask.java:54)
at com.sun.grizzly.SelectionKeyContextTask.call(SelectionKeyContextTask.java:59)
at com.sun.grizzly.ContextTask.run(ContextTask.java:71)
Quand je recherches les patientes "A" pour retrouver AVIRON 2, je ne trouve qu'AVIRON, comme si je n'avais pas du tout importer une seconde fois cette patiente bien que ça ait buggé au QMED. Je te le précise au cas où. Je vais essayer de la réimporter et je te tiens au courant