See <http://ci.codelutin.com/jenkins/job/observe-technical-site-snapshot/16/changes> Changes: [Tony CHEMIT] Utilisation du nouveau moteur de calcul de différentiel pour la synchro [Tony CHEMIT] ajout méthode utile et utilisation [Tony CHEMIT] Quelques adaptations niveau ui pour utiliser les nouvelles api [Tony CHEMIT] Rendre la synchro de données utilisable en mode serveur [Tony CHEMIT] utilisation version stable de ToPIA ------------------------------------------ [...truncated 8282 lines...] INFO [main] (fr.ird.observe.services.service.actions.report.ReportBuilder:251) getRequests - Detects a request : fr.ird.observe.services.dto.actions.report.ReportRequest@67455097[request=Select Count(a) From TripSeineImpl m Join m.route r Join r.activitySeine a, ObservedSystemImpl os Where m.id = :tripId and a.setSeine.schoolType = 1 and a.setSeine.reasonForNullSet is null and os.topiaId = 'fr.ird.observe.entities.referentiel.seine.ObservedSystem#1239832686428#0.9217864901728908' and os not in elements(a.observedSystem),layout=column,location=java.awt.Point[x=3,y=0],repeatVariable=<null>] INFO [main] (fr.ird.observe.services.service.actions.report.ReportBuilder:251) getRequests - Detects a request : fr.ird.observe.services.dto.actions.report.ReportRequest@669bc687[request=Select Count(a) From TripSeineImpl m Join m.route r Join r.activitySeine a, ObservedSystemImpl os Where m.id = :tripId and a.setSeine.schoolType = 1 and a.setSeine.reasonForNullSet is not null and os.topiaId = 'fr.ird.observe.entities.referentiel.seine.ObservedSystem#1239832686428#0.9217864901728908' and os not in elements(a.observedSystem),layout=column,location=java.awt.Point[x=3,y=1],repeatVariable=<null>] INFO [main] (fr.ird.observe.services.service.actions.report.ReportBuilder:330) getOperations - Detects a operations : SumIntRow INFO [main] (fr.ird.observe.services.service.actions.report.ReportBuilder:330) getOperations - Detects a operations : SumIntColumn INFO [main] (fr.ird.observe.services.service.actions.report.ReportBuilder:251) getRequests - Detects a request : fr.ird.observe.services.dto.actions.report.ReportRequest@31ec7829[request=Select Sum(CASE ct.weightCategory.species.topiaId When 'fr.ird.observe.entities.referentiel.Species#1239832685474#0.8943253454598569' Then ct.catchWeight Else 0.0 End), Sum(CASE ct.weightCategory.species.topiaId When 'fr.ird.observe.entities.referentiel.Species#1239832685474#0.975344121171992' Then ct.catchWeight Else 0.0 End), Sum(CASE ct.weightCategory.species.topiaId When 'fr.ird.observe.entities.referentiel.Species#1239832685475#0.13349466123905152' Then ct.catchWeight Else 0.0 End), Sum(CASE ct.weightCategory.species.topiaId When 'fr.ird.observe.entities.referentiel.Species#1239832685477#0.8024257002747615' Then ct.catchWeight Else 0.0 End), Sum(CASE ct.weightCategory.species.topiaId When 'fr.ird.observe.entities.referentiel.Species#1239832685477#0.3846921632590058' Then ct.catchWeight Else 0.0 End), Sum(CASE ct.weightCategory.species.topiaId When 'fr.ird.observe.entities.referentiel.Species#1239832685474#0.8943253454598569' Then 0.0 When 'fr.ird.observe.entities.referentiel.Species#1239832685474#0.975344121171992' Then 0.0 When 'fr.ird.observe.entities.referentiel.Species#1239832685475#0.13349466123905152' Then 0.0 When 'fr.ird.observe.entities.referentiel.Species#1239832685477#0.8024257002747615' Then 0.0 When 'fr.ird.observe.entities.referentiel.Species#1239832685477#0.3846921632590058' Then 0.0 Else ct.catchWeight End) From TripSeineImpl m Join m.route r Join r.activitySeine a Join a.setSeine c with c.schoolType = 2 Join c.targetCatch ct with ct.discarded = false, ObservedSystemImpl os Where m.id = :tripId and os.topiaId = 'fr.ird.observe.entities.referentiel.seine.ObservedSystem#1239832686428#0.9395222812356602' and os not in elements(a.observedSystem),layout=row,location=java.awt.Point[x=0,y=0],repeatVariable=<null>] INFO [main] (fr.ird.observe.services.service.actions.report.ReportBuilder:251) getRequests - Detects a request : fr.ird.observe.services.dto.actions.report.ReportRequest@323b414e[request=Select Sum(CASE ct.weightCategory.species.topiaId When 'fr.ird.observe.entities.referentiel.Species#1239832685474#0.8943253454598569' Then ct.catchWeight Else 0.0 End), Sum(CASE ct.weightCategory.species.topiaId When 'fr.ird.observe.entities.referentiel.Species#1239832685474#0.975344121171992' Then ct.catchWeight Else 0.0 End), Sum(CASE ct.weightCategory.species.topiaId When 'fr.ird.observe.entities.referentiel.Species#1239832685475#0.13349466123905152' Then ct.catchWeight Else 0.0 End), Sum(CASE ct.weightCategory.species.topiaId When 'fr.ird.observe.entities.referentiel.Species#1239832685477#0.8024257002747615' Then ct.catchWeight Else 0.0 End), Sum(CASE ct.weightCategory.species.topiaId When 'fr.ird.observe.entities.referentiel.Species#1239832685477#0.3846921632590058' Then ct.catchWeight Else 0.0 End), Sum(CASE ct.weightCategory.species.topiaId When 'fr.ird.observe.entities.referentiel.Species#1239832685474#0.8943253454598569' Then 0.0 When 'fr.ird.observe.entities.referentiel.Species#1239832685474#0.975344121171992' Then 0.0 When 'fr.ird.observe.entities.referentiel.Species#1239832685475#0.13349466123905152' Then 0.0 When 'fr.ird.observe.entities.referentiel.Species#1239832685477#0.8024257002747615' Then 0.0 When 'fr.ird.observe.entities.referentiel.Species#1239832685477#0.3846921632590058' Then 0.0 Else ct.catchWeight End) From TripSeineImpl m Join m.route r Join r.activitySeine a Join a.setSeine c with c.schoolType = 2 Join c.targetCatch ct with ct.discarded = false, ObservedSystemImpl os Where m.id = :tripId and os.topiaId = 'fr.ird.observe.entities.referentiel.seine.ObservedSystem#1239832686428#0.9395222812356602' and os in elements(a.observedSystem),layout=row,location=java.awt.Point[x=0,y=1],repeatVariable=<null>] INFO [main] (fr.ird.observe.services.service.actions.report.ReportBuilder:251) getRequests - Detects a request : fr.ird.observe.services.dto.actions.report.ReportRequest@7f377e76[request=Select Sum(CASE ct.weightCategory.species.topiaId When 'fr.ird.observe.entities.referentiel.Species#1239832685474#0.8943253454598569' Then ct.catchWeight Else 0.0 End), Sum(CASE ct.weightCategory.species.topiaId When 'fr.ird.observe.entities.referentiel.Species#1239832685474#0.975344121171992' Then ct.catchWeight Else 0.0 End), Sum(CASE ct.weightCategory.species.topiaId When 'fr.ird.observe.entities.referentiel.Species#1239832685475#0.13349466123905152' Then ct.catchWeight Else 0.0 End), Sum(CASE ct.weightCategory.species.topiaId When 'fr.ird.observe.entities.referentiel.Species#1239832685477#0.8024257002747615' Then ct.catchWeight Else 0.0 End), Sum(CASE ct.weightCategory.species.topiaId When 'fr.ird.observe.entities.referentiel.Species#1239832685477#0.3846921632590058' Then ct.catchWeight Else 0.0 End), Sum(CASE ct.weightCategory.species.topiaId When 'fr.ird.observe.entities.referentiel.Species#1239832685474#0.8943253454598569' Then 0.0 When 'fr.ird.observe.entities.referentiel.Species#1239832685474#0.975344121171992' Then 0.0 When 'fr.ird.observe.entities.referentiel.Species#1239832685475#0.13349466123905152' Then 0.0 When 'fr.ird.observe.entities.referentiel.Species#1239832685477#0.8024257002747615' Then 0.0 When 'fr.ird.observe.entities.referentiel.Species#1239832685477#0.3846921632590058' Then 0.0 Else ct.catchWeight End) From TripSeineImpl m Join m.route r Join r.activitySeine a Join a.setSeine c with c.schoolType = 1 Join c.targetCatch ct with ct.discarded = false, ObservedSystemImpl os Where m.id = :tripId and os.topiaId = 'fr.ird.observe.entities.referentiel.seine.ObservedSystem#1239832686428#0.9217864901728908' and os in elements(a.observedSystem),layout=row,location=java.awt.Point[x=0,y=2],repeatVariable=<null>] INFO [main] (fr.ird.observe.services.service.actions.report.ReportBuilder:251) getRequests - Detects a request : fr.ird.observe.services.dto.actions.report.ReportRequest@47a020e9[request=Select Sum(CASE ct.weightCategory.species.topiaId When 'fr.ird.observe.entities.referentiel.Species#1239832685474#0.8943253454598569' Then ct.catchWeight Else 0.0 End), Sum(CASE ct.weightCategory.species.topiaId When 'fr.ird.observe.entities.referentiel.Species#1239832685474#0.975344121171992' Then ct.catchWeight Else 0.0 End), Sum(CASE ct.weightCategory.species.topiaId When 'fr.ird.observe.entities.referentiel.Species#1239832685475#0.13349466123905152' Then ct.catchWeight Else 0.0 End), Sum(CASE ct.weightCategory.species.topiaId When 'fr.ird.observe.entities.referentiel.Species#1239832685477#0.8024257002747615' Then ct.catchWeight Else 0.0 End), Sum(CASE ct.weightCategory.species.topiaId When 'fr.ird.observe.entities.referentiel.Species#1239832685477#0.3846921632590058' Then ct.catchWeight Else 0.0 End), Sum(CASE ct.weightCategory.species.topiaId When 'fr.ird.observe.entities.referentiel.Species#1239832685474#0.8943253454598569' Then 0.0 When 'fr.ird.observe.entities.referentiel.Species#1239832685474#0.975344121171992' Then 0.0 When 'fr.ird.observe.entities.referentiel.Species#1239832685475#0.13349466123905152' Then 0.0 When 'fr.ird.observe.entities.referentiel.Species#1239832685477#0.8024257002747615' Then 0.0 When 'fr.ird.observe.entities.referentiel.Species#1239832685477#0.3846921632590058' Then 0.0 Else ct.catchWeight End) From TripSeineImpl m Join m.route r Join r.activitySeine a Join a.setSeine c with c.schoolType = 1 Join c.targetCatch ct with ct.discarded = false, ObservedSystemImpl os Where m.id = :tripId and os.topiaId = 'fr.ird.observe.entities.referentiel.seine.ObservedSystem#1239832686428#0.9217864901728908' and os not in elements(a.observedSystem),layout=row,location=java.awt.Point[x=0,y=3],repeatVariable=<null>] INFO [main] (fr.ird.observe.services.service.actions.report.ReportBuilder:330) getOperations - Detects a operations : SumRow INFO [main] (fr.ird.observe.services.service.actions.report.ReportBuilder:330) getOperations - Detects a operations : SumColumn INFO [main] (fr.ird.observe.services.service.actions.report.ReportBuilder:251) getRequests - Detects a request : fr.ird.observe.services.dto.actions.report.ReportRequest@155f3504[request=Select Sum(CASE ct.weightCategory.species.topiaId When 'fr.ird.observe.entities.referentiel.Species#1239832685474#0.8943253454598569' Then ct.catchWeight Else 0.0 End), Sum(CASE ct.weightCategory.species.topiaId When 'fr.ird.observe.entities.referentiel.Species#1239832685474#0.975344121171992' Then ct.catchWeight Else 0.0 End), Sum(CASE ct.weightCategory.species.topiaId When 'fr.ird.observe.entities.referentiel.Species#1239832685475#0.13349466123905152' Then ct.catchWeight Else 0.0 End), Sum(CASE ct.weightCategory.species.topiaId When 'fr.ird.observe.entities.referentiel.Species#1239832685477#0.8024257002747615' Then ct.catchWeight Else 0.0 End), Sum(CASE ct.weightCategory.species.topiaId When 'fr.ird.observe.entities.referentiel.Species#1239832685477#0.3846921632590058' Then ct.catchWeight Else 0.0 End), Sum(CASE ct.weightCategory.species.topiaId When 'fr.ird.observe.entities.referentiel.Species#1239832685474#0.8943253454598569' Then 0.0 When 'fr.ird.observe.entities.referentiel.Species#1239832685474#0.975344121171992' Then 0.0 When 'fr.ird.observe.entities.referentiel.Species#1239832685475#0.13349466123905152' Then 0.0 When 'fr.ird.observe.entities.referentiel.Species#1239832685477#0.8024257002747615' Then 0.0 When 'fr.ird.observe.entities.referentiel.Species#1239832685477#0.3846921632590058' Then 0.0 Else ct.catchWeight End) From TripSeineImpl m Join m.route r Join r.activitySeine a Join a.setSeine c with c.schoolType = 2 Join c.targetCatch ct with ct.discarded = true, ObservedSystemImpl os Where m.id = :tripId and os.topiaId = 'fr.ird.observe.entities.referentiel.seine.ObservedSystem#1239832686428#0.9395222812356602' and os not in elements(a.observedSystem),layout=row,location=java.awt.Point[x=0,y=0],repeatVariable=<null>] INFO [main] (fr.ird.observe.services.service.actions.report.ReportBuilder:251) getRequests - Detects a request : fr.ird.observe.services.dto.actions.report.ReportRequest@7d0627d0[request=Select Sum(CASE ct.weightCategory.species.topiaId When 'fr.ird.observe.entities.referentiel.Species#1239832685474#0.8943253454598569' Then ct.catchWeight Else 0.0 End), Sum(CASE ct.weightCategory.species.topiaId When 'fr.ird.observe.entities.referentiel.Species#1239832685474#0.975344121171992' Then ct.catchWeight Else 0.0 End), Sum(CASE ct.weightCategory.species.topiaId When 'fr.ird.observe.entities.referentiel.Species#1239832685475#0.13349466123905152' Then ct.catchWeight Else 0.0 End), Sum(CASE ct.weightCategory.species.topiaId When 'fr.ird.observe.entities.referentiel.Species#1239832685477#0.8024257002747615' Then ct.catchWeight Else 0.0 End), Sum(CASE ct.weightCategory.species.topiaId When 'fr.ird.observe.entities.referentiel.Species#1239832685477#0.3846921632590058' Then ct.catchWeight Else 0.0 End), Sum(CASE ct.weightCategory.species.topiaId When 'fr.ird.observe.entities.referentiel.Species#1239832685474#0.8943253454598569' Then 0.0 When 'fr.ird.observe.entities.referentiel.Species#1239832685474#0.975344121171992' Then 0.0 When 'fr.ird.observe.entities.referentiel.Species#1239832685475#0.13349466123905152' Then 0.0 When 'fr.ird.observe.entities.referentiel.Species#1239832685477#0.8024257002747615' Then 0.0 When 'fr.ird.observe.entities.referentiel.Species#1239832685477#0.3846921632590058' Then 0.0 Else ct.catchWeight End) From TripSeineImpl m Join m.route r Join r.activitySeine a Join a.setSeine c with c.schoolType = 2 Join c.targetCatch ct with ct.discarded = true, ObservedSystemImpl os Where m.id = :tripId and os.topiaId = 'fr.ird.observe.entities.referentiel.seine.ObservedSystem#1239832686428#0.9395222812356602' and os in elements(a.observedSystem),layout=row,location=java.awt.Point[x=0,y=1],repeatVariable=<null>] INFO [main] (fr.ird.observe.services.service.actions.report.ReportBuilder:251) getRequests - Detects a request : fr.ird.observe.services.dto.actions.report.ReportRequest@390632c8[request=Select Sum(CASE ct.weightCategory.species.topiaId When 'fr.ird.observe.entities.referentiel.Species#1239832685474#0.8943253454598569' Then ct.catchWeight Else 0.0 End), Sum(CASE ct.weightCategory.species.topiaId When 'fr.ird.observe.entities.referentiel.Species#1239832685474#0.975344121171992' Then ct.catchWeight Else 0.0 End), Sum(CASE ct.weightCategory.species.topiaId When 'fr.ird.observe.entities.referentiel.Species#1239832685475#0.13349466123905152' Then ct.catchWeight Else 0.0 End), Sum(CASE ct.weightCategory.species.topiaId When 'fr.ird.observe.entities.referentiel.Species#1239832685477#0.8024257002747615' Then ct.catchWeight Else 0.0 End), Sum(CASE ct.weightCategory.species.topiaId When 'fr.ird.observe.entities.referentiel.Species#1239832685477#0.3846921632590058' Then ct.catchWeight Else 0.0 End), Sum(CASE ct.weightCategory.species.topiaId When 'fr.ird.observe.entities.referentiel.Species#1239832685474#0.8943253454598569' Then 0.0 When 'fr.ird.observe.entities.referentiel.Species#1239832685474#0.975344121171992' Then 0.0 When 'fr.ird.observe.entities.referentiel.Species#1239832685475#0.13349466123905152' Then 0.0 When 'fr.ird.observe.entities.referentiel.Species#1239832685477#0.8024257002747615' Then 0.0 When 'fr.ird.observe.entities.referentiel.Species#1239832685477#0.3846921632590058' Then 0.0 Else ct.catchWeight End) From TripSeineImpl m Join m.route r Join r.activitySeine a Join a.setSeine c with c.schoolType = 1 Join c.targetCatch ct with ct.discarded = true, ObservedSystemImpl os Where m.id = :tripId and os.topiaId = 'fr.ird.observe.entities.referentiel.seine.ObservedSystem#1239832686428#0.9217864901728908' and os in elements(a.observedSystem),layout=row,location=java.awt.Point[x=0,y=2],repeatVariable=<null>] INFO [main] (fr.ird.observe.services.service.actions.report.ReportBuilder:251) getRequests - Detects a request : fr.ird.observe.services.dto.actions.report.ReportRequest@7fe7fa69[request=Select Sum(CASE ct.weightCategory.species.topiaId When 'fr.ird.observe.entities.referentiel.Species#1239832685474#0.8943253454598569' Then ct.catchWeight Else 0.0 End), Sum(CASE ct.weightCategory.species.topiaId When 'fr.ird.observe.entities.referentiel.Species#1239832685474#0.975344121171992' Then ct.catchWeight Else 0.0 End), Sum(CASE ct.weightCategory.species.topiaId When 'fr.ird.observe.entities.referentiel.Species#1239832685475#0.13349466123905152' Then ct.catchWeight Else 0.0 End), Sum(CASE ct.weightCategory.species.topiaId When 'fr.ird.observe.entities.referentiel.Species#1239832685477#0.8024257002747615' Then ct.catchWeight Else 0.0 End), Sum(CASE ct.weightCategory.species.topiaId When 'fr.ird.observe.entities.referentiel.Species#1239832685477#0.3846921632590058' Then ct.catchWeight Else 0.0 End), Sum(CASE ct.weightCategory.species.topiaId When 'fr.ird.observe.entities.referentiel.Species#1239832685474#0.8943253454598569' Then 0.0 When 'fr.ird.observe.entities.referentiel.Species#1239832685474#0.975344121171992' Then 0.0 When 'fr.ird.observe.entities.referentiel.Species#1239832685475#0.13349466123905152' Then 0.0 When 'fr.ird.observe.entities.referentiel.Species#1239832685477#0.8024257002747615' Then 0.0 When 'fr.ird.observe.entities.referentiel.Species#1239832685477#0.3846921632590058' Then 0.0 Else ct.catchWeight End) From TripSeineImpl m Join m.route r Join r.activitySeine a Join a.setSeine c with c.schoolType = 1 Join c.targetCatch ct with ct.discarded = true, ObservedSystemImpl os Where m.id = :tripId and os.topiaId = 'fr.ird.observe.entities.referentiel.seine.ObservedSystem#1239832686428#0.9217864901728908' and os not in elements(a.observedSystem),layout=row,location=java.awt.Point[x=0,y=3],repeatVariable=<null>] INFO [main] (fr.ird.observe.services.service.actions.report.ReportBuilder:330) getOperations - Detects a operations : SumRow INFO [main] (fr.ird.observe.services.service.actions.report.ReportBuilder:330) getOperations - Detects a operations : SumColumn INFO [main] (fr.ird.observe.services.service.actions.report.ReportBuilder:251) getRequests - Detects a request : fr.ird.observe.services.dto.actions.report.ReportRequest@137c1784[request= Select tl.length , Sum(tl.count) From TripSeineImpl t Join t.route r Join r.activitySeine a Join a.setSeine.targetSample ts Join ts.targetLength tl Where t.id = :tripId And tl.species.id = :speciesId And tl.measureType = 1And ts.discarded = true Group By tl.length Order By tl.length,layout=row,location=java.awt.Point[x=0,y=0],repeatVariable=<null>] INFO [main] (fr.ird.observe.services.service.actions.report.ReportBuilder:330) getOperations - Detects a operations : GroupByLength INFO [main] (fr.ird.observe.services.service.actions.report.ReportBuilder:376) getVariables - Detects a variable : [targetDiscardedDistributionLengthsLD1:speciesId] = Select distinct tl.species From TripSeineImpl t Join t.route r Join r.activitySeine a Join a.setSeine.targetSample ts Join ts.targetLength tl Where t.id = :tripId And tl.measureType = 1 And ts.discarded = true (type = fr.ird.observe.services.dto.referential.SpeciesDto) INFO [main] (fr.ird.observe.services.service.actions.report.ReportBuilder:251) getRequests - Detects a request : fr.ird.observe.services.dto.actions.report.ReportRequest@5f888a9c[request= Select tl.length , Sum(tl.count) From TripSeineImpl t Join t.route r Join r.activitySeine a Join a.setSeine.targetSample ts Join ts.targetLength tl Where t.id = :tripId And tl.species.id = :speciesId And tl.measureType = 2 And ts.discarded = true Group By tl.length Order By tl.length,layout=row,location=java.awt.Point[x=0,y=0],repeatVariable=<null>] INFO [main] (fr.ird.observe.services.service.actions.report.ReportBuilder:330) getOperations - Detects a operations : GroupByLength INFO [main] (fr.ird.observe.services.service.actions.report.ReportBuilder:376) getVariables - Detects a variable : [targetDiscardedDistributionLengthsLF:speciesId] = Select distinct tl.species From TripSeineImpl t Join t.route r Join r.activitySeine a Join a.setSeine.targetSample ts Join ts.targetLength tl Where t.id = :tripId And tl.measureType = 2 And ts.discarded = true (type = fr.ird.observe.services.dto.referential.SpeciesDto) INFO [main] (fr.ird.observe.services.service.actions.report.ReportBuilder:251) getRequests - Detects a request : fr.ird.observe.services.dto.actions.report.ReportRequest@571073d7[request= Select tl.length , Sum(tl.count) From TripSeineImpl t Join t.route r Join r.activitySeine a Join a.setSeine.targetSample ts Join ts.targetLength tl Where t.id = :tripId And tl.species.id = :speciesId And tl.measureType = 1 And ts.discarded = false Group By tl.length Order By tl.length,layout=row,location=java.awt.Point[x=0,y=0],repeatVariable=<null>] INFO [main] (fr.ird.observe.services.service.actions.report.ReportBuilder:330) getOperations - Detects a operations : GroupByLength INFO [main] (fr.ird.observe.services.service.actions.report.ReportBuilder:376) getVariables - Detects a variable : [targetStoredDistributionLengthsLD1:speciesId] = Select distinct tl.species From TripSeineImpl t Join t.route r Join r.activitySeine a Join a.setSeine.targetSample ts Join ts.targetLength tl Where t.id = :tripId And tl.measureType = 1 And ts.discarded = false (type = fr.ird.observe.services.dto.referential.SpeciesDto) INFO [main] (fr.ird.observe.services.service.actions.report.ReportBuilder:251) getRequests - Detects a request : fr.ird.observe.services.dto.actions.report.ReportRequest@1764efee[request= Select tl.length , Sum(tl.count) From TripSeineImpl t Join t.route r Join r.activitySeine a Join a.setSeine.targetSample ts Join ts.targetLength tl Where t.id = :tripId And tl.species.id = :speciesId And tl.measureType = 2 And ts.discarded = false Group By tl.length Order By tl.length,layout=row,location=java.awt.Point[x=0,y=0],repeatVariable=<null>] INFO [main] (fr.ird.observe.services.service.actions.report.ReportBuilder:330) getOperations - Detects a operations : GroupByLength INFO [main] (fr.ird.observe.services.service.actions.report.ReportBuilder:376) getVariables - Detects a variable : [targetStoredDistributionLengthsLF:speciesId] = Select distinct tl.species From TripSeineImpl t Join t.route r Join r.activitySeine a Join a.setSeine.targetSample ts Join ts.targetLength tl Where t.id = :tripId And tl.measureType = 2 And ts.discarded = false (type = fr.ird.observe.services.dto.referential.SpeciesDto) INFO [main] (fr.ird.observe.services.service.actions.report.AbstractReportServiceTopiaTest:79) setUp - Will use report 'Liste des captures accessoires selon le type de banc, filtrées par groupe' INFO [main] (fr.ird.observe.services.service.actions.report.AbstractReportServiceTopiaTest:113) testReport - Result : [FAO]LUK [sc]Selene dorsalis [fr]Selene dorsalis - - [FAO]ABU [sc]Abudefduf saxatilis [fr]Sergent-major - - [FAO]ALI [sc]Alepisaurus spp [fr]Lanciers nca - - [FAO]ALS [sc]Carcharhinus albimarginatus [fr]Requin pointe blanche - - [FAO]ALX [sc]Alepisaurus ferox [fr]Lancier longnez - - [FAO]AMB [sc]Seriola dumerili [fr]Purlish amberjack - - [FAO]AML [sc]Carcharhinus amblyrhynchos [fr]Grey reef shark - - [FAO]DDD [sc]Abudefduf vaigiensis [fr]Sergent-major - - [FAO]AVR [sc]Aprion virescens [fr]Job gris - - [FAO]- [sc]Balistes capriscus [fr]Baliste (Atlantique) - - [FAO]AJS [sc]Abalistes stellatus [fr]Baliste étoilé - + Effectif : 20 Poids total (t) : 0.01 [FAO]TRG [sc]Balistes carolinensis [fr]Baliste cabri - - [FAO]BVP [sc]Balistes punctatus [fr]Baliste à taches bleues - - [FAO]BAR [sc]Sphyraena spp [fr]Barracudas nca - - [FAO]ALN [sc]Aluterus scriptus [fr]Bourse écriture + Effectif : 1 Poids total (t) : 0.00050 - [FAO]ALM [sc]Aluterus monoceros [fr]Bourse loulou - + Effectif : 16 Poids total (t) : 0.01060 [FAO]CNT [sc]Canthidermis maculata [fr]Baliste rude + Effectif : 2 Poids total (t) : 0.00134 + Effectif : 2230 Poids total (t) : 1.49359 [FAO]BAF [sc]Ablennes hians [fr]Orphie plate - - [FAO]BLR [sc]Carcharhinus melanopterus [fr]Requin pointes noires - - [FAO]BON [sc]Sarda sarda [fr]Bonite à dos rayé - + Effectif : 11 [FAO]BPQ [sc]Brama japonica [fr]Castagnole du Pacific - - [FAO]BRA [sc]Brama spp. [fr] - - [FAO]BRZ [sc]Bramidae [fr]Famille Bramidae - - [FAO]BRO [sc]Carcharhinus brachyurus [fr]Requin cuivre - - [FAO]CAQ [sc]Catharacta lonnbergi [fr]Labbe brun - - [FAO]CBG [sc]Cubiceps gracilis [fr]Libine - - [FAO]DVH [sc]Cyclichthys orbicularis [fr]Cyclichthys orbicularis - - [FAO]CCL [sc]Carcharhinus limbatus [fr]Requin bordé - - [FAO]CCP [sc]Carcharhinus plumbeus [fr]Requin gris - - [FAO]MSD [sc]Decapterus macarellus [fr]Comète maquereau + Effectif : 47 Poids total (t) : 0.0024 + Effectif : 6 Poids total (t) : 0.0027 [FAO]CLP [sc]Clupeidae [fr]Famille Clupeidae - - [FAO]NXU [sc]Caranx lugubris [fr]Carangue noire - - [FAO]CFW [sc]Coryphaena equiselis [fr]Coryphène dauphin + Effectif : 2 Poids total (t) : 0.008 - [FAO]DOL [sc]Coryphaena hippurus [fr]Coryphène commun + Effectif : 5 Poids total (t) : 0.03824 + Effectif : 107 Poids total (t) : 0.57632 [FAO]NGT [sc]Carangoides orthogrammus [fr]Carangue des îles - - [FAO]CXS [sc]Caranx sexfasciatus [fr]Carangue vorace - + Effectif : 22 Poids total (t) : 0.01100 [FAO]CRU [sc]Crustacea [fr]Crustacés nca - - [FAO]RUB [sc]Caranx crysos [fr]Carangue coubali - - [FAO]3CUH [sc]Uraspis helvola [fr]Carangue coton helvola - - [FAO]CUP [sc]Cubiceps spp [fr]Cubiceps nca - - [FAO]USE [sc]Uraspis secunda [fr]Carangue coton - - [FAO]3CUX [sc]Uraspis spp [fr]Carangue coton - - [FAO]CWZ [sc]Carcharhinus spp [fr]Requins Carcharhinus nca - - [FAO]CWZ [sc]Carcharhinus spp [fr]Requins Carcharhinus nca - - [FAO]DIY [sc]Diodon hystrix [fr]Porc-épic boubou - - [FAO]DIO [sc]Diodontidae [fr]Famille Diodontidae + Effectif : 1 Poids total (t) : 0.00050 - [FAO]3DEY [sc]Diodon eydouxii [fr]Porc-épic - - [FAO]EAG [sc]Myliobatidae [fr]Aigles de mer nca - - [FAO]EHN [sc]Echeneis naucrates [fr]Rémora commun + Effectif : 7 Poids total (t) : 0.00350 - [FAO]RRU [sc]Elagatis bipinnulata [fr]Commère saumon - + Effectif : 211 Poids total (t) : 0.45108 [FAO]HTL [sc]Phtheirichthys lineatus [fr]Rémora - - [FAO]TRI [sc]Balistidae [fr]Famille Balistidae - - [FAO]BEN [sc]Belonidae [fr]Famille Belonidae - - [FAO]FBT [sc]Natator depressus [fr]Tortue plate - - [FAO]DOX [sc]Coryphaenidae [fr]Famille Coryphaenidae - - [FAO]CGX [sc]Carangidae [fr]Famille Carangidae + Effectif : 1 Poids total (t) : 0.00050 + Effectif : 49 Poids total (t) : 0.02450 [FAO]ECN [sc]Echeneidae [fr]Famille Echeneidae + Effectif : 2 Poids total (t) : 0.00100 - [FAO]SPA [sc]Ephippidae [fr]Famille Ephippidae - - [FAO]EXQ [sc]Euleptorhamphus velox [fr]Demi-bec volant - - [FAO]FLY [sc]Exocoetidae [fr]Famille Exocoetidae - - [FAO]FIT [sc]Fistularia spp [fr]Cornettes - - [FAO]FFX [sc]Monacanthidae [fr]Poisson-lime - - [FAO]KYP [sc]Kyphosus spp [fr]Kyphosus calicagères nca - - [FAO]3MOP [sc]Molidae [fr]Famille Molidae - - [FAO]DSF [sc]Pomacentridae [fr]Famille Pomacentridae - - [FAO]MAX [sc]Scombridae [fr]Famille Scombridae - - [FAO]BSX [sc]Serranidae [fr]Famille Serranidae - - [FAO]PUX [sc]Tetraodontidae [fr]Famille Tetraodontidae - - [FAO]GEP [sc]Gempylidae [fr]Escoliers, rouvets nca - - [FAO]GES [sc]Gempylus serpens [fr]Escolier serpent - - [FAO]JDP [sc]Dasyatis pastinaca [fr]Pastenague commune - - [FAO]KYC [sc]Kyphosus cinerascens [fr]Calicagère bleue - - [FAO]KYS [sc]Kyphosus sectatrix [fr]Calicagère blanche - - [FAO]KYV [sc]Kyphosus vaigiensis [fr]Caligagère - + Effectif : 5 Poids total (t) : 0.0025 [FAO]LAG [sc]Lampris guttatus [fr]Opah - - [FAO]LAM [sc]Lampris spp [fr]Saumon des dieux - - [FAO]LAP [sc]Lampris spp [fr]Opah - - [FAO]3LDI [sc]Lactoria diaphana [fr]Lactoria diaphana - - [FAO]LEC [sc]Lepidocybium flavobrunneum [fr]Escolier noir - - [FAO]LGH [sc]Lagocephalus lagocephalus [fr]Compère océanique - - [FAO]LMA [sc]Isurus paucus [fr]Petite taupe, Mako - - [FAO]LOB [sc]Lobotes surinamensis [fr]Croupia roche - + Effectif : 28 Poids total (t) : 0.06754 [FAO]LOP [sc]Lophotus capellei [fr]Roi des harengs - - [FAO]LVM [sc]Luvarus imperialis [fr]Luvar - - [FAO]MRW [sc]Masturus lanceolatus [fr]Poisson-lune à queue pointue - - [FAO]MAW [sc]Scomberomorus tritor [fr]Thazard blanc - - [FAO]MAZ [sc]Scomber spp [fr]Maquereaux scomber nca - - [FAO]MOX [sc]Mola mola [fr]Poisson lune - - [FAO]MOP [sc]Mola spp [fr]Poissons lunes nca - - [FAO]MZZ [sc]Osteichthyes [fr]Poissons marins nca - - [FAO]NAU [sc]Naucrates ductor [fr]Poisson pilote + Effectif : 1 Poids total (t) : 0.00050 - [FAO]NEN [sc]Nesiarchus nasutus [fr]Escolier long nez - - [FAO]NXI [sc]Caranx ignobilis [fr]Carangue têtue - - [FAO]OMZ [sc]Ommastrephidae [fr]Encornets Ommastrephidae nca - - [FAO]OOT [sc]Oreosoma atlanticum [fr]Oreosoma atlanticum - - [FAO]OSF [sc]Stegostoma fasciatum [fr]Requin zèbre - - [FAO]PFM [sc]Pristipomoides filamentosus [fr]Colas fil - - [FAO]BAT [sc]Platax spp [fr]Poules d'eau - - [FAO]BAO [sc]Platax teira [fr]Poule d'eau - - [FAO]POA [sc]Brama brama [fr]Grande castagnole - - [FAO]PRP [sc]Promethichthys prometheus [fr]Escolier clair - - [FAO]PSC [sc]Psenes cyanophrys [fr]Psenes cyanophrys - - [FAO]PSK [sc]Pseudocarcharias kamoharai [fr]Requin crocodile - - [FAO]RAJ [sc]Rajidae [fr]Rajidés nca - - [FAO]RZV [sc]Ranzania laevis [fr]Ranzania - - [FAO]3RAU [sc]Remora australis [fr]Rémora - - [FAO]RDB [sc]Dasyatis benneti [fr]Bennett s stingray - - [FAO]RDX [sc]Dasyatis ushiei [fr]Cow stingray - - [FAO]RDZ [sc]Dasyatis zugei [fr]Pale-edged stingray - - [FAO]RRL [sc]Remorina albescens [fr]Rémora blanche - - [FAO]REO [sc]Remora remora [fr]Rémora + Effectif : 2 Poids total (t) : 0.001 - [FAO]REZ [sc]Remora osteochir [fr]Rémora des marlins - - [FAO]REY [sc]Remora brachyptera [fr]Rémora des espadons - - [FAO]RMH [sc]Mobula hypostoma [fr]Mante diable - - [FAO]OIL [sc]Ruvettus pretiosus [fr]Rouvet - - [FAO]RXX [sc]Rexea spp. [fr]Rexea spp. - - [FAO]SBF [sc]Thunnus maccoyii [fr]Thon rouge du Sud - - [FAO]SDX [sc]Decapterus spp [fr]Comètes nca - - [FAO]YTL [sc]Seriola rivoliana [fr]Sériole limon - - [FAO]MAS [sc]Scomber japonicus [fr]Maquereau espagnol - - [FAO]SKH [sc]Selachimorpha [fr]Requins divers nca - - [FAO]SKX [sc]Elasmobranchii [fr]Requins, raies, etc. nca - - [FAO]SLP [sc]Hydrurga leptonyx [fr]Léopard de mer - - [FAO]SNK [sc]Thyrsites atun [fr]Escolier - - [FAO]GBA [sc]Sphyraena barracuda [fr]Barracuda - + Effectif : 26 Poids total (t) : 0.11222 [FAO]BAZ [sc]Sphyraenidae [fr]Famille Sphyraenidae - - [FAO]SPN [sc]Sphyrna spp [fr]Requins marteau nca - - [FAO]SQC [sc]Loligo spp [fr]Calmars Loligo nca - - [FAO]MAC [sc]Scomber scombrus [fr]Maquereau commun - - [FAO]SXH [sc]Scombrolabrax heterolepis [fr]Escolier aile longue - - [FAO]TAL [sc]Taractichthys longipinnis [fr]Big-scale pomfret - - [FAO]BTS [sc]Tylosurus crocodilus [fr]Aiguille crocodile - + Effectif : 1 Poids total (t) : 0.00050 [FAO]TCR [sc]Taractes rubescens [fr]Keeltail pomfret - - [FAO]THM [sc]Thyrsitoides merleyi [fr]Escolier gracile - - [FAO]TJZ [sc]Trachipterus jacksonensis [fr] - - [FAO]TRE [sc]Caranx spp [fr]Chinchards, carangues nca - - [FAO]TRQ [sc]Trachipterus trachipterus [fr]Mediterranean dealfish - - [FAO]TRW [sc]Trachipterus ishikawae [fr] - - [FAO]TST [sc]Taractichtys steindachneri [fr]Castagnole fauchoire - - [FAO]TUS [sc]Thunnus spp [fr]Thons Thunnus nca - - [FAO]UBP [sc]Cubiceps capensis [fr]Dérivant - - [FAO]URU [sc]Uraspis uraspis [fr]Carangue paia - - [FAO]VLF* [sc]Very long fish nei [fr]Très longs poissons nca - - [FAO]VVL* [sc]Very very long fish nei [fr]Très très longs poissons nca - - [FAO]WAH [sc]Acanthocybium solandri [fr]Thazard bâtard - + Effectif : 90 Poids total (t) : 0.6800 [FAO]WHH [sc]Tetrapturus spp [fr]Makaires Tetrapturus nca - - [FAO]9XXX [sc]Indéterminé [fr]Indéterminé - - [FAO]XXX* [sc] [fr] - - [FAO]YMO [sc]Sthenoteuthis oualaniensis [fr]Encornet bande violette - - [FAO]YTC [sc]Seriola lalandi [fr]Sériole chicard - - [FAO]ZAO [sc]Zanclus cornutus [fr]Zanclus cornutus - - Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 90.876 sec - in fr.ird.observe.services.service.actions.report.ReportAccessoryCatch2Test Running fr.ird.observe.services.service.actions.report.ReportSetByAssociationTest INFO [main] (fr.ird.observe.services.ObserveTopiaApplicationContextFactory:166) createTopiaApplicationContext - H2 Topia configuration: {hibernate.connection.url=jdbc:h2:<http://ci.codelutin.com/jenkins/job/observe-technical-site-snapshot/ws/observe-services-topia/target/surefire-workdir/commons/4_904/dataForTestSeine/obstuna;FILE_LOCK=file;LOG=0;MODE=postgresql;DEFAULT_LOCK_TIMEOUT=100;DB_CLOSE_DELAY=0;LOCK_MODE=3;TRACE_LEVEL_FILE=0;TRACE_LEVEL_SYSTEM_OUT=0;CACHE_SIZE=65536,> hibernate.connection.username=***** hidden by BeanTopiaConfiguration#toString *****, hibernate.connection.password=***** hidden by BeanTopiaConfiguration#toString *****, hibernate.connection.driver_class=org.h2.Driver, topia.persistence.initSchema=false, topia.persistence.validateSchema=false, topia.persistence.topiaIdFactoryClassName=fr.ird.observe.ObserveTopiaIdFactory, topia.service..migration=fr.ird.observe.entities.migration.ObserveMigrationEngine, topia.service..migration.callback=fr.ird.observe.entities.migration.H2DataSourceMigration, topia.service..migration.showProgression=false, topia.service..migration.showSql=false, topia.service..sqlBatch=org.nuiton.topia.service.sql.batch.TopiaSqlBatchServiceImpl} INFO [main] (fr.ird.observe.services.service.actions.report.AbstractReportServiceTopiaTest:79) setUp - Will use report 'Nombre de calées selon le type d’association' WARN [main] (fr.ird.observe.services.dto.actions.report.DataMatrix:190) merge - No matching rows number : should have 3, but was 2 WARN [main] (fr.ird.observe.services.dto.actions.report.DataMatrix:201) merge - No matching columns number : should have 5, but was 4 INFO [main] (fr.ird.observe.services.service.actions.report.AbstractReportServiceTopiaTest:113) testReport - Result : 19 1 0 6 26 9 0 0 0 9 28 1 0 6 35 Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 113.585 sec - in fr.ird.observe.services.service.actions.report.ReportSetByAssociationTest Running fr.ird.observe.services.service.actions.report.ReportAccessoryCatchByGroup2Test INFO [main] (fr.ird.observe.services.ObserveTopiaApplicationContextFactory:166) createTopiaApplicationContext - H2 Topia configuration: {hibernate.connection.url=jdbc:h2:<http://ci.codelutin.com/jenkins/job/observe-technical-site-snapshot/ws/observe-services-topia/target/surefire-workdir/commons/4_904/dataForTestSeine/obstuna;FILE_LOCK=file;LOG=0;MODE=postgresql;DEFAULT_LOCK_TIMEOUT=100;DB_CLOSE_DELAY=0;LOCK_MODE=3;TRACE_LEVEL_FILE=0;TRACE_LEVEL_SYSTEM_OUT=0;CACHE_SIZE=65536,> hibernate.connection.username=***** hidden by BeanTopiaConfiguration#toString *****, hibernate.connection.password=***** hidden by BeanTopiaConfiguration#toString *****, hibernate.connection.driver_class=org.h2.Driver, topia.persistence.initSchema=false, topia.persistence.validateSchema=false, topia.persistence.topiaIdFactoryClassName=fr.ird.observe.ObserveTopiaIdFactory, topia.service..migration=fr.ird.observe.entities.migration.ObserveMigrationEngine, topia.service..migration.callback=fr.ird.observe.entities.migration.H2DataSourceMigration, topia.service..migration.showProgression=false, topia.service..migration.showSql=false, topia.service..sqlBatch=org.nuiton.topia.service.sql.batch.TopiaSqlBatchServiceImpl} INFO [main] (fr.ird.observe.services.service.actions.report.AbstractReportServiceTopiaTest:79) setUp - Will use report 'Dénombrement des captures accessoires et devenir, filtrés par groupe' Results : Tests run: 26, Failures: 0, Errors: 0, Skipped: 1 [INFO] ------------------------------------------------------------------------ [INFO] Reactor Summary: [INFO] [INFO] ObServe ............................................ SUCCESS [02:41 min] [INFO] ObServe :: Check API maven plugin .................. SUCCESS [01:14 min] [INFO] ObServe :: ToPIA Extension ......................... SUCCESS [05:19 min] [INFO] ObServe :: ToPIA Templates Extension ............... SUCCESS [02:16 min] [INFO] ObServe :: Services Configuration API .............. SUCCESS [01:40 min] [INFO] ObServe :: Services ToPIA Configuration ............ SUCCESS [ 41.947 s] [INFO] ObServe :: Services REST Configuration ............. SUCCESS [ 27.110 s] [INFO] ObServe :: Services model .......................... SUCCESS [01:33 min] [INFO] ObServe :: Services API ............................ SUCCESS [ 48.020 s] [INFO] ObServe :: Test data ............................... SUCCESS [ 52.902 s] [INFO] ObServe :: Entities ................................ SUCCESS [07:55 min] [INFO] ObServe :: Entities Migration ...................... SUCCESS [02:30 min] [INFO] ObServe :: Services ToPIA validation ............... SUCCESS [01:46 min] [INFO] ObServe :: Services ToPIA Implementation ........... FAILURE [46:10 min] [INFO] ObServe :: Services REST Implementation ............ SKIPPED [INFO] ObServe :: Services Runner ......................... SKIPPED [INFO] ObServe :: Application Web ......................... SKIPPED [INFO] ObServe :: Application Swing Decoration ............ SKIPPED [INFO] ObServe :: Application Swing Validation ............ SKIPPED [INFO] ObServe :: Application Swing ....................... SKIPPED [INFO] ------------------------------------------------------------------------ [INFO] BUILD FAILURE [INFO] ------------------------------------------------------------------------ [INFO] Total time: 01:16 h [INFO] Finished at: 2016-08-18T04:05:25+02:00 [INFO] Final Memory: 150M/529M [INFO] ------------------------------------------------------------------------ [ERROR] Failed to execute goal org.apache.maven.plugins:maven-surefire-plugin:2.19.1:test (default-test) on project observe-services-topia: Execution default-test of goal org.apache.maven.plugins:maven-surefire-plugin:2.19.1:test failed: The forked VM terminated without properly saying goodbye. VM crash or System.exit called? [ERROR] Command was /bin/sh -c cd <http://ci.codelutin.com/jenkins/job/observe-technical-site-snapshot/ws/observe-services-topia> && /opt/repository/jdk1.8.0_102/jre/bin/java -jar <http://ci.codelutin.com/jenkins/job/observe-technical-site-snapshot/ws/observe-services-topia/target/surefire/surefirebooter8930071005574274618.jar> <http://ci.codelutin.com/jenkins/job/observe-technical-site-snapshot/ws/observe-services-topia/target/surefire/surefire4147196478139792468tmp> <http://ci.codelutin.com/jenkins/job/observe-technical-site-snapshot/ws/observe-services-topia/target/surefire/surefire_4284802482246663106tmp> [ERROR] -> [Help 1] [ERROR] [ERROR] To see the full stack trace of the errors, re-run Maven with the -e switch. [ERROR] Re-run Maven using the -X switch to enable full debug logging. [ERROR] [ERROR] For more information about the errors and possible solutions, please read the following articles: [ERROR] [Help 1] http://cwiki.apache.org/confluence/display/MAVEN/PluginExecutionException [ERROR] [ERROR] After correcting the problems, you can resume the build with the command [ERROR] mvn <goals> -rf :observe-services-topia Build step 'Invoke top-level Maven targets' marked build as failure Started calculate disk usage of build Finished Calculation of disk usage of build in 0 seconds Started calculate disk usage of workspace Finished Calculation of disk usage of workspace in 19 second