See <http://ci.codelutin.com/jenkins/job/observe-nightly/fr.ird.observe$observe-business/16/changes> Changes: [chemit] use version 3.5 instead of version 4.0 [chemit] move to version 3.5 [chemit] refs #4115 migration des reports et des Its [chemit] move to 4.0-RC1 version [chemit] add 4.0 referentiel [chemit] add FIXME for eugene generation... [chemit] add license headers [chemit] fixes #4115: Traduire le schéma de la base (tables/champs) en anglais [chemit] refs #5300: Mise en place modèle ObServeLL ------------------------------------------ [...truncated 6899 lines...] CREATE TABLE SIZEMEASURE(TOPIAID VARCHAR(255) NOT NULL ,TOPIAVERSION BIGINT NOT NULL ,TOPIACREATEDATE TIMESTAMP ,SIZE FLOAT ,SIZEMEASURETYPE VARCHAR(255) ,CATCHLONGLINE VARCHAR(255)); INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1228/1310] ALTER TABLE SIZEMEASURE ADD CONSTRAINT PK_SIZEMEASURE PRIMARY KEY(TOPIAID); INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1229/1310] -- Add longline data Tdr INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1230/1310] CREATE TABLE TDR(TOPIAID VARCHAR(255) NOT NULL ,TOPIAVERSION BIGINT NOT NULL ,TOPIACREATEDATE TIMESTAMP ,HOMEID INTEGER ,FLOATLINE1LENGTH FLOAT ,FLOATLINE2LENGTH FLOAT ,SERIALNO VARCHAR(255) ,DATA VARCHAR(255) ,FILELOCATION VARCHAR(255) ,DEPLOYMENTSTART TIMESTAMP ,DEPLOYEMENTEND TIMESTAMP ,FISHINGSTART TIMESTAMP ,FISHINGEND TIMESTAMP ,FISHINGSTARTDEPTH INTEGER ,FISHINGENDDEPTH INTEGER ,MEANDEPLOYEMENTDEPTH INTEGER ,MEDIANDEPLOYEMENTDEPTH INTEGER ,MINFISHINGDEPTH INTEGER ,MAXFISHINGDEPTH INTEGER ,MEANFISHINGDEPTH INTEGER ,MEDIANFISHINGDEPTH INTEGER ,SENSORBRAND VARCHAR(255) ,ITEMLOCATIONONLONGLINE VARCHAR(255) ,ITEMLOCATIONONBRANCHLINE VARCHAR(255) ,SENSORPOSITION VARCHAR(255) ,BASKET VARCHAR(255) ,SECTION VARCHAR(255) ,FISHINGOPERATION VARCHAR(255)); INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1231/1310] ALTER TABLE TDR ADD CONSTRAINT PK_TDR PRIMARY KEY(TOPIAID); INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1232/1310] CREATE TABLE SPECIES_TDR(TDR VARCHAR(255) NOT NULL,SPECIES VARCHAR(255) NOT NULL); INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1233/1310] -- Add longline data TdrRecord INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1234/1310] CREATE TABLE TDRRECORD(TOPIAID VARCHAR(255) NOT NULL ,TOPIAVERSION BIGINT NOT NULL ,TOPIACREATEDATE TIMESTAMP ,TIMESTAMP TIMESTAMP ,TEMPERATURE FLOAT ,DEPTH FLOAT ,BASKET VARCHAR(255) ,TDR VARCHAR(255)); INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1235/1310] ALTER TABLE TDRRECORD ADD CONSTRAINT PK_TDRRECORD PRIMARY KEY(TOPIAID); INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1236/1310] -- Add longline data TripLongline INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1237/1310] CREATE TABLE TRIPLONGLINE(TOPIAID VARCHAR(255) NOT NULL ,TOPIAVERSION BIGINT NOT NULL ,TOPIACREATEDATE TIMESTAMP ,COMMENT VARCHAR(255) ,STARTDATE TIMESTAMP ,ENDDATE TIMESTAMP ,TOTALFISHINGOPERATIONSNUMBER INTEGER ,HOMEID VARCHAR(255) ,TRIPTYPE VARCHAR(255) ,OBSERVER VARCHAR(255) ,VESSEL VARCHAR(255) ,CAPTAIN VARCHAR(255) ,DATAINPUTOR VARCHAR(255)); INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1238/1310] ALTER TABLE TRIPLONGLINE ADD CONSTRAINT PK_TRIPLONGLINE PRIMARY KEY(TOPIAID); INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1239/1310] -- Add longline data WeightMeasure INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1240/1310] CREATE TABLE WEIGHTMEASURE(TOPIAID VARCHAR(255) NOT NULL ,TOPIAVERSION BIGINT NOT NULL ,TOPIACREATEDATE TIMESTAMP ,WEIGHT FLOAT ,WEIGHTMEASURETYPE VARCHAR(255) ,CATCHLONGLINE VARCHAR(255)); INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1241/1310] ALTER TABLE WEIGHTMEASURE ADD CONSTRAINT PK_WEIGHTMEASURE PRIMARY KEY(TOPIAID); INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1242/1310] -- Add longline data constraints INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1243/1310] ALTER TABLE ACTIVITYLONGLINE ADD CONSTRAINT FK_ACTIVITYLONGLINE_FPAZONE FOREIGN KEY(FPAZONE) REFERENCES FPAZONE(TOPIAID) NOCHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1244/1310] ALTER TABLE ACTIVITYLONGLINE ADD CONSTRAINT FK_ACTIVITYLONGLINE_FISHINGOPERATION FOREIGN KEY(FISHINGOPERATION) REFERENCES FISHINGOPERATION(TOPIAID) NOCHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1245/1310] ALTER TABLE ACTIVITYLONGLINE ADD CONSTRAINT FK_ACTIVITYLONGLINE_TRIPLONGLINE FOREIGN KEY(TRIPLONGLINE) REFERENCES TRIPLONGLINE(TOPIAID) NOCHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1246/1310] ALTER TABLE ACTIVITYLONGLINE ADD CONSTRAINT FK_ACTIVITYLONGLINE_VESSELACTIVITYLONGLINE FOREIGN KEY(VESSELACTIVITYLONGLINE) REFERENCES VESSELACTIVITYLONGLINE(TOPIAID) NOCHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1247/1310] ALTER TABLE BAITSCOMPOSITION ADD CONSTRAINT FK_BAITSCOMPOSITION_FISHINGOPERATION FOREIGN KEY(FISHINGOPERATION) REFERENCES FISHINGOPERATION(TOPIAID) NOCHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1248/1310] ALTER TABLE BAITSCOMPOSITION ADD CONSTRAINT FK_BAITSCOMPOSITION_BAITTYPE FOREIGN KEY(BAITTYPE) REFERENCES BAITTYPE(TOPIAID) NOCHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1249/1310] ALTER TABLE BAITSCOMPOSITION ADD CONSTRAINT FK_BAITSCOMPOSITION_BAITSETTINGSTATUS FOREIGN KEY(BAITSETTINGSTATUS) REFERENCES BAITSETTINGSTATUS(TOPIAID) NOCHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1250/1310] ALTER TABLE BASKET ADD CONSTRAINT FK_BASKET_SECTION FOREIGN KEY(SECTION) REFERENCES SECTION(TOPIAID) NOCHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1251/1310] ALTER TABLE BRANCHLINE ADD CONSTRAINT FK_BRANCHLINE_HOOKTYPE FOREIGN KEY(HOOKTYPE) REFERENCES HOOKTYPE(TOPIAID) NOCHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1252/1310] ALTER TABLE BRANCHLINE ADD CONSTRAINT FK_BRANCHLINE_TRACELINETYPE FOREIGN KEY(TRACELINETYPE) REFERENCES BRANCHLINETYPE(TOPIAID) NOCHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1253/1310] ALTER TABLE BRANCHLINE ADD CONSTRAINT FK_BRANCHLINE_MAXLOCTDRPRECISION FOREIGN KEY(MAXLOCTDRPRECISION) REFERENCES TDR(TOPIAID) NOCHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1254/1310] ALTER TABLE BRANCHLINE ADD CONSTRAINT FK_BRANCHLINE_BAITSETTINGSTATUS FOREIGN KEY(BAITSETTINGSTATUS) REFERENCES BAITSETTINGSTATUS(TOPIAID) NOCHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1255/1310] ALTER TABLE BRANCHLINE ADD CONSTRAINT FK_BRANCHLINE_BAITHAULINGSTATUS FOREIGN KEY(BAITHAULINGSTATUS) REFERENCES BAITHAULINGSTATUS(TOPIAID) NOCHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1256/1310] ALTER TABLE BRANCHLINE ADD CONSTRAINT FK_BRANCHLINE_TOPTYPE FOREIGN KEY(TOPTYPE) REFERENCES BRANCHLINETYPE(TOPIAID) NOCHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1257/1310] ALTER TABLE BRANCHLINE ADD CONSTRAINT FK_BRANCHLINE_TRACELINEBAITSETTINGSTATUS FOREIGN KEY(TRACELINEBAITSETTINGSTATUS) REFERENCES BAITSETTINGSTATUS(TOPIAID) NOCHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1258/1310] ALTER TABLE BRANCHLINE ADD CONSTRAINT FK_BRANCHLINE_TOPBAITSETTINGSTATUS FOREIGN KEY(TOPBAITSETTINGSTATUS) REFERENCES BAITSETTINGSTATUS(TOPIAID) NOCHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1259/1310] ALTER TABLE BRANCHLINE ADD CONSTRAINT FK_BRANCHLINE_CATCHLONGLINE FOREIGN KEY(CATCHLONGLINE) REFERENCES CATCHLONGLINE(TOPIAID) NOCHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1260/1310] ALTER TABLE BRANCHLINE ADD CONSTRAINT FK_BRANCHLINE_BASKET FOREIGN KEY(BASKET) REFERENCES BASKET(TOPIAID) NOCHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1261/1310] ALTER TABLE BRANCHLINE ADD CONSTRAINT FK_BRANCHLINE_BAITTYPE FOREIGN KEY(BAITTYPE) REFERENCES BAITTYPE(TOPIAID) NOCHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1262/1310] ALTER TABLE BRANCHLINESCOMPOSITION ADD CONSTRAINT FK_BRANCHLINESCOMPOSITION_TRACELINETYPE FOREIGN KEY(TRACELINETYPE) REFERENCES BRANCHLINETYPE(TOPIAID) NOCHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1263/1310] ALTER TABLE BRANCHLINESCOMPOSITION ADD CONSTRAINT FK_BRANCHLINESCOMPOSITION_TOPTYPE FOREIGN KEY(TOPTYPE) REFERENCES BRANCHLINETYPE(TOPIAID) NOCHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1264/1310] ALTER TABLE BRANCHLINESCOMPOSITION ADD CONSTRAINT FK_BRANCHLINESCOMPOSITION_FISHINGOPERATION FOREIGN KEY(FISHINGOPERATION) REFERENCES FISHINGOPERATION(TOPIAID) NOCHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1265/1310] ALTER TABLE CATCHLONGLINE ADD CONSTRAINT FK_CATCHLONGLINE_DISCARDHEALTHNESS FOREIGN KEY(DISCARDHEALTHNESS) REFERENCES HEALTHNESS(TOPIAID) NOCHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1266/1310] ALTER TABLE CATCHLONGLINE ADD CONSTRAINT FK_CATCHLONGLINE_CATCHHEALTHNESS FOREIGN KEY(CATCHHEALTHNESS) REFERENCES HEALTHNESS(TOPIAID) NOCHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1267/1310] ALTER TABLE CATCHLONGLINE ADD CONSTRAINT FK_CATCHLONGLINE_STOMACFULLNESS FOREIGN KEY(STOMACFULLNESS) REFERENCES STOMACFULLNESS(TOPIAID) NOCHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1268/1310] ALTER TABLE CATCHLONGLINE ADD CONSTRAINT FK_CATCHLONGLINE_SPECIESCATCH FOREIGN KEY(SPECIESCATCH) REFERENCES SPECIES(TOPIAID) NOCHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1269/1310] ALTER TABLE CATCHLONGLINE ADD CONSTRAINT FK_CATCHLONGLINE_FISHINGOPERATION FOREIGN KEY(FISHINGOPERATION) REFERENCES FISHINGOPERATION(TOPIAID) NOCHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1270/1310] ALTER TABLE CATCHLONGLINE ADD CONSTRAINT FK_CATCHLONGLINE_MATURITYSTATUS FOREIGN KEY(MATURITYSTATUS) REFERENCES MATURITYSTATUS(TOPIAID) NOCHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1271/1310] ALTER TABLE CATCHLONGLINE ADD CONSTRAINT FK_CATCHLONGLINE_BASKET FOREIGN KEY(BASKET) REFERENCES BASKET(TOPIAID) NOCHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1272/1310] ALTER TABLE CATCHLONGLINE ADD CONSTRAINT FK_CATCHLONGLINE_ITEMLOCATIONONLONGLINE FOREIGN KEY(ITEMLOCATIONONLONGLINE) REFERENCES ITEMLOCATIONONLONGLINE(TOPIAID) NOCHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1273/1310] ALTER TABLE CATCHLONGLINE ADD CONSTRAINT FK_CATCHLONGLINE_HOOKPOSITION FOREIGN KEY(HOOKPOSITION) REFERENCES HOOKPOSITION(TOPIAID) NOCHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1274/1310] ALTER TABLE CATCHLONGLINE ADD CONSTRAINT FK_CATCHLONGLINE_SEX FOREIGN KEY(SEX) REFERENCES SEX(TOPIAID) NOCHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1275/1310] ALTER TABLE CATCHLONGLINE ADD CONSTRAINT FK_CATCHLONGLINE_CATCHFATELONGLINE FOREIGN KEY(CATCHFATELONGLINE) REFERENCES CATCHFATELONGLINE(TOPIAID) NOCHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1276/1310] ALTER TABLE CATCHLONGLINE ADD CONSTRAINT FK_CATCHLONGLINE_SECTION FOREIGN KEY(SECTION) REFERENCES SECTION(TOPIAID) NOCHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1277/1310] ALTER TABLE CATCHLONGLINE_PREDATORS ADD CONSTRAINT FK_CATCHLONGLINE_PREDATORS FOREIGN KEY(PREDATORS) REFERENCES SPECIES(TOPIAID) NOCHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1278/1310] ALTER TABLE CATCHLONGLINE_PREDATORS ADD CONSTRAINT FK_CATCHLONGLINE_CATCHLONGLINE FOREIGN KEY(CATCHLONGLINE) REFERENCES CATCHLONGLINE(TOPIAID) NOCHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1279/1310] ALTER TABLE ENCOUNTER ADD CONSTRAINT FK_ENCOUNTER_ACTIVITYLONGLINE FOREIGN KEY(ACTIVITYLONGLINE) REFERENCES ACTIVITYLONGLINE(TOPIAID) NOCHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1280/1310] ALTER TABLE ENCOUNTER ADD CONSTRAINT FK_ENCOUNTER_SPECIES FOREIGN KEY(SPECIES) REFERENCES SPECIES(TOPIAID) NOCHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1281/1310] ALTER TABLE ENCOUNTER ADD CONSTRAINT FK_ENCOUNTER_ENCOUNTERTYPE FOREIGN KEY(ENCOUNTERTYPE) REFERENCES ENCOUNTERTYPE(TOPIAID) NOCHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1282/1310] ALTER TABLE FISHINGOPERATION_MITIGATIONTYPE ADD CONSTRAINT FK_FISHINGOPERATION_MITIGATIONTYPE_MITIGATIONTYPE FOREIGN KEY(MITIGATIONTYPE) REFERENCES MITIGATIONTYPE(TOPIAID) NOCHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1283/1310] ALTER TABLE FISHINGOPERATION_MITIGATIONTYPE ADD CONSTRAINT FK_FISHINGOPERATION_MITIGATIONTYPE_FISHINGOPERATION FOREIGN KEY(FISHINGOPERATION) REFERENCES FISHINGOPERATION(TOPIAID) NOCHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1284/1310] ALTER TABLE FLOATLINESCOMPOSITION ADD CONSTRAINT FK_FLOATLINESCOMPOSITION_FLOATLINETYPE FOREIGN KEY(FLOATLINETYPE) REFERENCES FLOATLINETYPE(TOPIAID) NOCHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1285/1310] ALTER TABLE FLOATLINESCOMPOSITION ADD CONSTRAINT FK_FLOATLINESCOMPOSITION_FISHINGOPERATION FOREIGN KEY(FISHINGOPERATION) REFERENCES FISHINGOPERATION(TOPIAID) NOCHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1286/1310] ALTER TABLE HOOKSCOMPOSITION ADD CONSTRAINT FK_HOOKSCOMPOSITION_FISHINGOPERATION FOREIGN KEY(FISHINGOPERATION) REFERENCES FISHINGOPERATION(TOPIAID) NOCHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1287/1310] ALTER TABLE SECTION ADD CONSTRAINT FK_SECTION_FISHINGOPERATION FOREIGN KEY(FISHINGOPERATION) REFERENCES FISHINGOPERATION(TOPIAID) NOCHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1288/1310] ALTER TABLE SENSORUSED ADD CONSTRAINT FK_SENSORUSED_SENSORTYPE FOREIGN KEY(SENSORTYPE) REFERENCES SENSORTYPE(TOPIAID) NOCHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1289/1310] ALTER TABLE SENSORUSED ADD CONSTRAINT FK_SENSORUSED_SENSORDATAFORMAT FOREIGN KEY(SENSORDATAFORMAT) REFERENCES SENSORDATAFORMAT(TOPIAID) NOCHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1290/1310] ALTER TABLE SENSORUSED ADD CONSTRAINT FK_SENSORUSED_ACTIVITYLONGLINE FOREIGN KEY(ACTIVITYLONGLINE) REFERENCES ACTIVITYLONGLINE(TOPIAID) NOCHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1291/1310] ALTER TABLE SENSORUSED ADD CONSTRAINT FK_SENSORUSED_SENSORBRAND FOREIGN KEY(SENSORBRAND) REFERENCES SENSORBRAND(TOPIAID) NOCHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1292/1310] ALTER TABLE SIZEMEASURE ADD CONSTRAINT FK_SIZEMEASURE_SIZEMEASURETYPE FOREIGN KEY(SIZEMEASURETYPE) REFERENCES SIZEMEASURETYPE(TOPIAID) NOCHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1293/1310] ALTER TABLE SIZEMEASURE ADD CONSTRAINT FK_SIZEMEASURE_CATCHLONGLINE FOREIGN KEY(CATCHLONGLINE) REFERENCES CATCHLONGLINE(TOPIAID) NOCHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1294/1310] ALTER TABLE SPECIES_TDR ADD CONSTRAINT FK_SPECIES_TDR_SPECIES FOREIGN KEY(SPECIES) REFERENCES SPECIES(TOPIAID) NOCHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1295/1310] ALTER TABLE SPECIES_TDR ADD CONSTRAINT FK_SPECIES_TDR_TDR FOREIGN KEY(TDR) REFERENCES TDR(TOPIAID) NOCHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1296/1310] ALTER TABLE TDR ADD CONSTRAINT FK_TDR_SECTION FOREIGN KEY(SECTION) REFERENCES SECTION(TOPIAID) NOCHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1297/1310] ALTER TABLE TDR ADD CONSTRAINT FK_TDR_SENSORBRAND FOREIGN KEY(SENSORBRAND) REFERENCES SENSORBRAND(TOPIAID) NOCHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1298/1310] ALTER TABLE TDR ADD CONSTRAINT FK_TDR_FISHINGOPERATION FOREIGN KEY(FISHINGOPERATION) REFERENCES FISHINGOPERATION(TOPIAID) NOCHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1299/1310] ALTER TABLE TDR ADD CONSTRAINT FK_TDR_ITEMLOCATIONONBRANCHLINE FOREIGN KEY(ITEMLOCATIONONBRANCHLINE) REFERENCES ITEMLOCATIONONBRANCHLINE(TOPIAID) NOCHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1300/1310] ALTER TABLE TDR ADD CONSTRAINT FK_TDR_BASKET FOREIGN KEY(BASKET) REFERENCES BASKET(TOPIAID) NOCHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1301/1310] ALTER TABLE TDR ADD CONSTRAINT FK_TDR_ITEMLOCATIONONLONGLINE FOREIGN KEY(ITEMLOCATIONONLONGLINE) REFERENCES ITEMLOCATIONONLONGLINE(TOPIAID) NOCHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1302/1310] ALTER TABLE TDR ADD CONSTRAINT FK_TDR_SENSORPOSITION FOREIGN KEY(SENSORPOSITION) REFERENCES SENSORPOSITION(TOPIAID) NOCHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1303/1310] ALTER TABLE TDRRECORD ADD CONSTRAINT FK_TDRRECORD_BASKET FOREIGN KEY(BASKET) REFERENCES BASKET(TOPIAID) NOCHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1304/1310] ALTER TABLE TDRRECORD ADD CONSTRAINT FK_TDRRECORD_TDR FOREIGN KEY(TDR) REFERENCES TDR(TOPIAID) NOCHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1305/1310] ALTER TABLE TRIPLONGLINE ADD CONSTRAINT FK_TRIPLONGLINE_VESSEL FOREIGN KEY(VESSEL) REFERENCES VESSEL(TOPIAID) NOCHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1306/1310] ALTER TABLE TRIPLONGLINE ADD CONSTRAINT FK_TRIPLONGLINE_CAPTAIN FOREIGN KEY(CAPTAIN) REFERENCES PERSON(TOPIAID) NOCHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1307/1310] ALTER TABLE TRIPLONGLINE ADD CONSTRAINT FK_TRIPLONGLINE_TRIPTYPE FOREIGN KEY(TRIPTYPE) REFERENCES TRIPTYPE(TOPIAID) NOCHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1308/1310] ALTER TABLE TRIPLONGLINE ADD CONSTRAINT FK_TRIPLONGLINE_DATAINPUTOR FOREIGN KEY(DATAINPUTOR) REFERENCES PERSON(TOPIAID) NOCHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1309/1310] ALTER TABLE TRIPLONGLINE ADD CONSTRAINT FK_TRIPLONGLINE_OBSERVER FOREIGN KEY(OBSERVER) REFERENCES PERSON(TOPIAID) NOCHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1310/1310] ALTER TABLE WEIGHTMEASURE ADD CONSTRAINT FK_WEIGHTMEASURE_CATCHLONGLINE FOREIGN KEY(CATCHLONGLINE) REFERENCES CATCHLONGLINE(TOPIAID) NOCHECK; INFO [main] (org.nuiton.topia.migration.TopiaMigrationEngine:462) saveApplicationVersion - Sauvegarde de la nouvelle version de la base : 3.5 INFO [main] (fr.ird.observe.db.DataSourceFactory:102) onNewMessage - Le service de persistence [localDB_testMigrateFrom0_TO_3.5 <http://ci.codelutin.com/jenkins/job/observe-nightly/fr.ird.observe$observe-business/ws/target/surefire-workdir/04_07_2014/03_01_47/H2DataSourceMigrationIT/localDB_testMigrateFrom0_TO_3.5/obstuna]> est ouvert INFO [main] (fr.ird.observe.db.DataSourceFactory:211) dispose - close all services (1) Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 3.956 sec - in fr.ird.observe.its.migration.H2DataSourceMigrationIT Results : Tests in error: DataSourceFactoryIT.testCreateH2ConfigImportLocalStorage:140 » DataSource org.... Tests run: 31, Failures: 0, Errors: 1, Skipped: 7 [ERROR] There are test failures. Please refer to <http://ci.codelutin.com/jenkins/job/observe-nightly/fr.ird.observe$observe-business/ws/target/surefire-reports> for the individual test results. [JENKINS] Recording test results [INFO] [INFO] --- maven-surefire-plugin:2.17:test (after-integration-tests) @ observe-business --- [INFO] Surefire report directory: <http://ci.codelutin.com/jenkins/job/observe-nightly/fr.ird.observe$observe-business/ws/target/surefire-reports> ------------------------------------------------------- T E S T S ------------------------------------------------------- Running fr.ird.observe.its.RestoreEmptyPGIT INFO [main] (fr.ird.observe.test.TestHelper:80) getTestsTimeStamp - tests timestamp : 1404435767482 INFO [main] (fr.ird.observe.test.TestHelper:99) getTestDir - tests basedir : <http://ci.codelutin.com/jenkins/job/observe-nightly/fr.ird.observe$observe-business/ws/target/surefire-workdir/04_07_2014/03_02_47> WARN [main] (fr.ird.observe.its.RestoreEmptyPGIT:70) init - Could not connect to postgres, will skip the test. Tests run: 1, Failures: 0, Errors: 0, Skipped: 1, Time elapsed: 0.676 sec - in fr.ird.observe.its.RestoreEmptyPGIT Results : Tests run: 1, Failures: 0, Errors: 0, Skipped: 1 [JENKINS] Recording test results [INFO] [INFO] --- helper-maven-plugin:2.1:share-server-secret (get-pgp-passphrase) @ observe-business --- [INFO] Exporting server [gpg-signer] username in ${gpg.keyname} [INFO] Exporting server [gpg-signer] password in ${gpg.passphrase} [INFO] [INFO] --- helper-maven-plugin:2.1:collect-files (collect-build-artifacts) @ observe-business --- [INFO] Loaded /var/local/forge/data/codelutin.com/jenkins/workspace/observe-nightly/trunk/target/collect-artifacts.txt [INFO] Copying observe-business-3.5.jar to /var/local/forge/data/codelutin.com/jenkins/workspace/observe-nightly/trunk/target/collect/fr.ird.observe--observe-business/observe-business-3.5.jar [INFO] Copying THIRD-PARTY.properties to /var/local/forge/data/codelutin.com/jenkins/workspace/observe-nightly/trunk/target/collect/fr.ird.observe--observe-business/THIRD-PARTY.properties [INFO] Copying observe-business-3.5-sources.jar to /var/local/forge/data/codelutin.com/jenkins/workspace/observe-nightly/trunk/target/collect/fr.ird.observe--observe-business/observe-business-3.5-sources.jar [INFO] Copying observe-business-3.5-javadoc.jar to /var/local/forge/data/codelutin.com/jenkins/workspace/observe-nightly/trunk/target/collect/fr.ird.observe--observe-business/observe-business-3.5-javadoc.jar [INFO] Copying observe-business-3.5-tests.jar to /var/local/forge/data/codelutin.com/jenkins/workspace/observe-nightly/trunk/target/collect/fr.ird.observe--observe-business/observe-business-3.5-tests.jar [INFO] [INFO] --- helper-maven-plugin:2.1:collect-files (collect-build-attachements) @ observe-business --- [WARNING] Skipping goal (No file to collect). [INFO] [INFO] --- maven-gpg-plugin:1.5:sign (sign-artifacts) @ observe-business --- [INFO] [INFO] --- maven-dependency-plugin:2.8:analyze-only (analyze) @ observe-business --- [INFO] Used declared dependencies found: [INFO] fr.ird:msaccess-importer:jar:1.4.1:compile [INFO] org.nuiton:nuiton-utils:jar:3.0-rc-3:compile [INFO] org.nuiton:nuiton-validator:jar:3.0-rc-1:compile [INFO] org.nuiton:nuiton-config:jar:3.0-alpha-2:compile [INFO] org.nuiton:nuiton-decorator:jar:3.0-alpha-3:compile [INFO] org.nuiton.i18n:nuiton-i18n:jar:3.1:compile [INFO] org.apache.commons:commons-lang3:jar:3.3.2:compile [INFO] commons-logging:commons-logging:jar:1.1.3:compile [INFO] commons-collections:commons-collections:jar:3.2.1:compile [INFO] commons-io:commons-io:jar:2.4:compile [INFO] commons-jxpath:commons-jxpath:jar:1.3:compile [INFO] com.google.guava:guava:jar:17.0:compile [INFO] org.nuiton.topia:topia-persistence:jar:2.9:compile [INFO] org.nuiton.topia:topia-service-replication:jar:2.9:compile [INFO] org.nuiton.topia:topia-service-migration:jar:2.9:compile [INFO] xpp3:xpp3:jar:1.1.4c:compile [INFO] org.nuiton.jaxx:jaxx-runtime:jar:2.8.7:compile [INFO] org.nuiton.jaxx:jaxx-validator:jar:2.8.7:compile [INFO] org.apache.struts.xwork:xwork-core:jar:2.3.15.1:compile [INFO] com.h2database:h2:jar:1.3.173:compile [INFO] postgresql:postgresql:jar:9.1-901-1.jdbc4:compile [INFO] org.hibernate:hibernate-core:jar:4.3.5.Final:compile [INFO] junit:junit:jar:4.11:test [INFO] org.nuiton.topia:topia-persistence:jar:tests:2.9:test [INFO] org.nuiton.topia:topia-service-replication:jar:tests:2.9:test [WARNING] Unused declared dependencies found: [WARNING] commons-beanutils:commons-beanutils:jar:1.9.2:compile [JENKINS] Archiving disabled