Bonjour,
Sur une instance 4.0 , j’ai une erreur (Column ‘row_id’ in where clause is ambiguous - Cf ci-dessous) qui survient à l’enregistrement de mon objet TrackinDemand. J’ai l’impression que cette erreur est apparue avec la dernière mise à jour car je n’ai pas eu le problème avant. Pour moi c’est une requête générée par le socle donc j’en ai déduit que mon paramétrage doit poser problème. Toutefois je ne sais pas dans quelle direction mener mes recherches,
Si vous avez des pistes à m’apporter je suis preneuse. Merci d’avance.
Version :
Simplicité® version 4.0.P12, built on 2018-03-12 16:45 (revision 4fd20b7b8f9fbd32a2a3bc006d0a76d736a883a3) for tomcat 8, encoding UTF-8 (system encoding UTF-8)
Stracktrace :
2018-03-22 14:52:07,019 ERROR [com.simplicite.util.engine.ObjectManager] SIMPLICITE|http://partenor.simplicite.io:10328||ECOREDB001|system|com.simplicite.util.engine.ObjectManager|query||Erreur SQL requête: jdbc/simplicite: select count(*) from tracking_demand t left outer join tracking_demand t_demDemandId on (t.dem_demand_id=t_demDemandId.row_id) inner join tracking_project t_demPrjDetectId on (t.dem_prj_detect_id=t_demPrjDetectId.row_id) left outer join tracking_sous_projet t_demSousProjetId on (t.dem_sous_projet_id=t_demSousProjetId.row_id) left outer join tracking_client t_prjCliId on (t_demPrjDetectId.prj_cli_id=t_prjCliId.row_id) inner join tracking_version t_demVrsDetectId on (t.dem_vrs_detect_id=t_demVrsDetectId.row_id) left outer join tracking_project t_vrsPrjId on (t_demVrsDetectId.vrs_prj_id=t_vrsPrjId.row_id) left outer join tracking_prj_usr t_demPrjUsrDetectId on (t.dem_detect_usr_id=t_demPrjUsrDetectId.row_id) left outer join m_user t_demPrjUsrDetectId_prjusrUsrId on (t_demPrjUsrDetectId.prjusr_usr_id=t_demPrjUsrDetectId_prjusrUsrId.row_id) left outer join tracking_prj_usr t_demPrjUsrChefProId on (t.dem_chefproj_usr_id=t_demPrjUsrChefProId.row_id) left outer join m_user t_demPrjUsrChefProId_prjusrUsrId on (t_demPrjUsrChefProId.prjusr_usr_id=t_demPrjUsrChefProId_prjusrUsrId.row_id) left outer join tracking_prj_usr t_demPrjUsrDvpId on (t.dem_dvp_usr_id=t_demPrjUsrDvpId.row_id) left outer join m_user t_demPrjUsrDvpId_prjusrUsrId on (t_demPrjUsrDvpId.prjusr_usr_id=t_demPrjUsrDvpId_prjusrUsrId.row_id) left outer join tracking_prj_usr t_demPrjUsrTestId on (t.dem_test_usr_id=t_demPrjUsrTestId.row_id) left outer join m_user t_demPrjUsrTestId_prjusrUsrId on (t_demPrjUsrTestId.prjusr_usr_id=t_demPrjUsrTestId_prjusrUsrId.row_id) left outer join tracking_prj_usr t_demPrjUsrChiffId on (t.dem_chiff_usr_id=t_demPrjUsrChiffId.row_id) left outer join m_user t_demPrjUsrChiffId_prjusrUsrId on (t_demPrjUsrChiffId.prjusr_usr_id=t_demPrjUsrChiffId_prjusrUsrId.row_id) left outer join tracking_version t_demVrsDvpId on (t.dem_vrs_dvp_id=t_demVrsDvpId.row_id) where row_id=410 and t.dem_prj_detect_id=49
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column ‘row_id’ in where clause is ambiguous
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
at com.mysql.jdbc.Util.getInstance(Util.java:408)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1966)
at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:82)
at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:82)
at com.simplicite.util.engine.DBAccess.query(DBAccess.java:660)
at com.simplicite.util.engine.DBAccess.query(DBAccess.java:509)
at com.simplicite.util.engine.DBAccess.simpleQuery(DBAccess.java:858)
at com.simplicite.util.engine.DBAccess.simpleQuery(DBAccess.java:834)
at com.simplicite.util.engine.ObjectManager.fkExists(ObjectManager.java:1234)
at com.simplicite.util.engine.ObjectManager.update(ObjectManager.java:1894)
at com.simplicite.util.engine.ObjectManager.save(ObjectManager.java:2491)
at com.simplicite.util.ObjectDirect.save(ObjectDirect.java:424)
at com.simplicite.util.ObjectDB.save(ObjectDB.java:885)
at com.simplicite.webapp.ObjectForm.validateAndSave(ObjectForm.java:1801)
at com.simplicite.webapp.ObjectForm.display(ObjectForm.java:201)
at com.simplicite.webapp.ObjectForm.display(ObjectForm.java:74)
at com.simplicite.util.ObjectDB.displayForm(ObjectDB.java:2205)
at com.simplicite.util.ScriptedObjectDB.displayForm(ScriptedObjectDB.java:1937)
at com.simplicite.webapp.servlets.ui.BusinessObjectServlet.service(BusinessObjectServlet.java:165)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at com.simplicite.webapp.filters.AuthMethodFilter.doFilter(AuthMethodFilter.java:108)
at com.simplicite.webapp.filters.AbstractFilter.doFilter(AbstractFilter.java:37)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:496)
at com.simplicite.tomcat.valves.APISessionValve.invoke(Unknown Source)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:650)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:803)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:790)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1459)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:748)