Bug à IMPOR QMED

Bug #797108 reported by Bussieres
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
TTTS database
Fix Released
High
Unassigned

Bug Description

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)

Revision history for this message
Bussieres (laurence-bussieres) wrote :

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

Revision history for this message
Bussieres (laurence-bussieres) wrote :

Bon, j'ai réessayé, mais ça ne marche pas. Rebelote sur le QMED d'AVIRON 2
Je change de patiente...

Changed in ttts:
status: New → Fix Committed
importance: Undecided → High
Changed in ttts:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.