See <http://ci.codelutin.com/jenkins/job/observe-nightly/fr.ird.observe$observe-business/17/changes> Changes: [chemit] fixes #5379 (security is now ok) [chemit] fixes #5379 [chemit] pass to version 3.5 [chemit] refs-50 #5379 (ok for H2) [chemit] continue migrate reports [chemit] only test concrete entities [chemit] refs #4115 migration des reports + rename some variables ------------------------------------------ [...truncated 6919 lines...] ALTER TABLE OBSERVE_LONGLINE.SIZEMEASURE ADD CONSTRAINT PK_SIZEMEASURE PRIMARY KEY(TOPIAID); INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1413/1494] -- Add longline data Tdr INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1414/1494] CREATE TABLE OBSERVE_LONGLINE.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 [1415/1494] ALTER TABLE OBSERVE_LONGLINE.TDR ADD CONSTRAINT PK_TDR PRIMARY KEY(TOPIAID); INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1416/1494] CREATE TABLE OBSERVE_LONGLINE.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 [1417/1494] -- Add longline data TdrRecord INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1418/1494] CREATE TABLE OBSERVE_LONGLINE.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 [1419/1494] ALTER TABLE OBSERVE_LONGLINE.TDRRECORD ADD CONSTRAINT PK_TDRRECORD PRIMARY KEY(TOPIAID); INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1420/1494] -- Add longline data TripLongline INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1421/1494] CREATE TABLE OBSERVE_LONGLINE.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 [1422/1494] ALTER TABLE OBSERVE_LONGLINE.TRIPLONGLINE ADD CONSTRAINT PK_TRIPLONGLINE PRIMARY KEY(TOPIAID); INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1423/1494] -- Add longline data WeightMeasure INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1424/1494] CREATE TABLE OBSERVE_LONGLINE.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 [1425/1494] ALTER TABLE OBSERVE_LONGLINE.WEIGHTMEASURE ADD CONSTRAINT PK_WEIGHTMEASURE PRIMARY KEY(TOPIAID); INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1426/1494] -- Add longline data constraints INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1427/1494] ALTER TABLE OBSERVE_LONGLINE.ACTIVITYLONGLINE ADD CONSTRAINT FK_ACTIVITYLONGLINE_FPAZONE FOREIGN KEY(FPAZONE) REFERENCES OBSERVE_COMMON.FPAZONE(TOPIAID) CHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1428/1494] ALTER TABLE OBSERVE_LONGLINE.ACTIVITYLONGLINE ADD CONSTRAINT FK_ACTIVITYLONGLINE_FISHINGOPERATION FOREIGN KEY(FISHINGOPERATION) REFERENCES OBSERVE_LONGLINE.FISHINGOPERATION(TOPIAID) CHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1429/1494] ALTER TABLE OBSERVE_LONGLINE.ACTIVITYLONGLINE ADD CONSTRAINT FK_ACTIVITYLONGLINE_TRIPLONGLINE FOREIGN KEY(TRIPLONGLINE) REFERENCES OBSERVE_LONGLINE.TRIPLONGLINE(TOPIAID) CHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1430/1494] ALTER TABLE OBSERVE_LONGLINE.ACTIVITYLONGLINE ADD CONSTRAINT FK_ACTIVITYLONGLINE_VESSELACTIVITYLONGLINE FOREIGN KEY(VESSELACTIVITYLONGLINE) REFERENCES OBSERVE_LONGLINE.VESSELACTIVITYLONGLINE(TOPIAID) CHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1431/1494] ALTER TABLE OBSERVE_LONGLINE.BAITSCOMPOSITION ADD CONSTRAINT FK_BAITSCOMPOSITION_FISHINGOPERATION FOREIGN KEY(FISHINGOPERATION) REFERENCES OBSERVE_LONGLINE.FISHINGOPERATION(TOPIAID) CHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1432/1494] ALTER TABLE OBSERVE_LONGLINE.BAITSCOMPOSITION ADD CONSTRAINT FK_BAITSCOMPOSITION_BAITTYPE FOREIGN KEY(BAITTYPE) REFERENCES OBSERVE_LONGLINE.BAITTYPE(TOPIAID) CHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1433/1494] ALTER TABLE OBSERVE_LONGLINE.BAITSCOMPOSITION ADD CONSTRAINT FK_BAITSCOMPOSITION_BAITSETTINGSTATUS FOREIGN KEY(BAITSETTINGSTATUS) REFERENCES OBSERVE_LONGLINE.BAITSETTINGSTATUS(TOPIAID) CHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1434/1494] ALTER TABLE OBSERVE_LONGLINE.BASKET ADD CONSTRAINT FK_BASKET_SECTION FOREIGN KEY(SECTION) REFERENCES OBSERVE_LONGLINE.SECTION(TOPIAID) CHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1435/1494] ALTER TABLE OBSERVE_LONGLINE.BRANCHLINE ADD CONSTRAINT FK_BRANCHLINE_HOOKTYPE FOREIGN KEY(HOOKTYPE) REFERENCES OBSERVE_LONGLINE.HOOKTYPE(TOPIAID) CHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1436/1494] ALTER TABLE OBSERVE_LONGLINE.BRANCHLINE ADD CONSTRAINT FK_BRANCHLINE_TRACELINETYPE FOREIGN KEY(TRACELINETYPE) REFERENCES OBSERVE_LONGLINE.BRANCHLINETYPE(TOPIAID) CHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1437/1494] ALTER TABLE OBSERVE_LONGLINE.BRANCHLINE ADD CONSTRAINT FK_BRANCHLINE_MAXLOCTDRPRECISION FOREIGN KEY(MAXLOCTDRPRECISION) REFERENCES OBSERVE_LONGLINE.TDR(TOPIAID) CHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1438/1494] ALTER TABLE OBSERVE_LONGLINE.BRANCHLINE ADD CONSTRAINT FK_BRANCHLINE_BAITSETTINGSTATUS FOREIGN KEY(BAITSETTINGSTATUS) REFERENCES OBSERVE_LONGLINE.BAITSETTINGSTATUS(TOPIAID) CHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1439/1494] ALTER TABLE OBSERVE_LONGLINE.BRANCHLINE ADD CONSTRAINT FK_BRANCHLINE_BAITHAULINGSTATUS FOREIGN KEY(BAITHAULINGSTATUS) REFERENCES OBSERVE_LONGLINE.BAITHAULINGSTATUS(TOPIAID) CHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1440/1494] ALTER TABLE OBSERVE_LONGLINE.BRANCHLINE ADD CONSTRAINT FK_BRANCHLINE_TOPTYPE FOREIGN KEY(TOPTYPE) REFERENCES OBSERVE_LONGLINE.BRANCHLINETYPE(TOPIAID) CHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1441/1494] ALTER TABLE OBSERVE_LONGLINE.BRANCHLINE ADD CONSTRAINT FK_BRANCHLINE_TRACELINEBAITSETTINGSTATUS FOREIGN KEY(TRACELINEBAITSETTINGSTATUS) REFERENCES OBSERVE_LONGLINE.BAITSETTINGSTATUS(TOPIAID) CHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1442/1494] ALTER TABLE OBSERVE_LONGLINE.BRANCHLINE ADD CONSTRAINT FK_BRANCHLINE_TOPBAITSETTINGSTATUS FOREIGN KEY(TOPBAITSETTINGSTATUS) REFERENCES OBSERVE_LONGLINE.BAITSETTINGSTATUS(TOPIAID) CHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1443/1494] ALTER TABLE OBSERVE_LONGLINE.BRANCHLINE ADD CONSTRAINT FK_BRANCHLINE_CATCHLONGLINE FOREIGN KEY(CATCHLONGLINE) REFERENCES OBSERVE_LONGLINE.CATCHLONGLINE(TOPIAID) CHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1444/1494] ALTER TABLE OBSERVE_LONGLINE.BRANCHLINE ADD CONSTRAINT FK_BRANCHLINE_BASKET FOREIGN KEY(BASKET) REFERENCES OBSERVE_LONGLINE.BASKET(TOPIAID) CHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1445/1494] ALTER TABLE OBSERVE_LONGLINE.BRANCHLINE ADD CONSTRAINT FK_BRANCHLINE_BAITTYPE FOREIGN KEY(BAITTYPE) REFERENCES OBSERVE_LONGLINE.BAITTYPE(TOPIAID) CHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1446/1494] ALTER TABLE OBSERVE_LONGLINE.BRANCHLINESCOMPOSITION ADD CONSTRAINT FK_BRANCHLINESCOMPOSITION_TRACELINETYPE FOREIGN KEY(TRACELINETYPE) REFERENCES OBSERVE_LONGLINE.BRANCHLINETYPE(TOPIAID) CHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1447/1494] ALTER TABLE OBSERVE_LONGLINE.BRANCHLINESCOMPOSITION ADD CONSTRAINT FK_BRANCHLINESCOMPOSITION_TOPTYPE FOREIGN KEY(TOPTYPE) REFERENCES OBSERVE_LONGLINE.BRANCHLINETYPE(TOPIAID) CHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1448/1494] ALTER TABLE OBSERVE_LONGLINE.BRANCHLINESCOMPOSITION ADD CONSTRAINT FK_BRANCHLINESCOMPOSITION_FISHINGOPERATION FOREIGN KEY(FISHINGOPERATION) REFERENCES OBSERVE_LONGLINE.FISHINGOPERATION(TOPIAID) CHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1449/1494] ALTER TABLE OBSERVE_LONGLINE.CATCHLONGLINE ADD CONSTRAINT FK_CATCHLONGLINE_DISCARDHEALTHNESS FOREIGN KEY(DISCARDHEALTHNESS) REFERENCES OBSERVE_LONGLINE.HEALTHNESS(TOPIAID) CHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1450/1494] ALTER TABLE OBSERVE_LONGLINE.CATCHLONGLINE ADD CONSTRAINT FK_CATCHLONGLINE_CATCHHEALTHNESS FOREIGN KEY(CATCHHEALTHNESS) REFERENCES OBSERVE_LONGLINE.HEALTHNESS(TOPIAID) CHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1451/1494] ALTER TABLE OBSERVE_LONGLINE.CATCHLONGLINE ADD CONSTRAINT FK_CATCHLONGLINE_STOMACFULLNESS FOREIGN KEY(STOMACFULLNESS) REFERENCES OBSERVE_LONGLINE.STOMACFULLNESS(TOPIAID) CHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1452/1494] ALTER TABLE OBSERVE_LONGLINE.CATCHLONGLINE ADD CONSTRAINT FK_CATCHLONGLINE_SPECIESCATCH FOREIGN KEY(SPECIESCATCH) REFERENCES OBSERVE_COMMON.SPECIES(TOPIAID) CHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1453/1494] ALTER TABLE OBSERVE_LONGLINE.CATCHLONGLINE ADD CONSTRAINT FK_CATCHLONGLINE_FISHINGOPERATION FOREIGN KEY(FISHINGOPERATION) REFERENCES OBSERVE_LONGLINE.FISHINGOPERATION(TOPIAID) CHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1454/1494] ALTER TABLE OBSERVE_LONGLINE.CATCHLONGLINE ADD CONSTRAINT FK_CATCHLONGLINE_MATURITYSTATUS FOREIGN KEY(MATURITYSTATUS) REFERENCES OBSERVE_LONGLINE.MATURITYSTATUS(TOPIAID) CHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1455/1494] ALTER TABLE OBSERVE_LONGLINE.CATCHLONGLINE ADD CONSTRAINT FK_CATCHLONGLINE_BASKET FOREIGN KEY(BASKET) REFERENCES OBSERVE_LONGLINE.BASKET(TOPIAID) CHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1456/1494] ALTER TABLE OBSERVE_LONGLINE.CATCHLONGLINE ADD CONSTRAINT FK_CATCHLONGLINE_ITEMLOCATIONONLONGLINE FOREIGN KEY(ITEMLOCATIONONLONGLINE) REFERENCES OBSERVE_LONGLINE.ITEMLOCATIONONLONGLINE(TOPIAID) CHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1457/1494] ALTER TABLE OBSERVE_LONGLINE.CATCHLONGLINE ADD CONSTRAINT FK_CATCHLONGLINE_HOOKPOSITION FOREIGN KEY(HOOKPOSITION) REFERENCES OBSERVE_LONGLINE.HOOKPOSITION(TOPIAID) CHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1458/1494] ALTER TABLE OBSERVE_LONGLINE.CATCHLONGLINE ADD CONSTRAINT FK_CATCHLONGLINE_SEX FOREIGN KEY(SEX) REFERENCES OBSERVE_COMMON.SEX(TOPIAID) CHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1459/1494] ALTER TABLE OBSERVE_LONGLINE.CATCHLONGLINE ADD CONSTRAINT FK_CATCHLONGLINE_CATCHFATELONGLINE FOREIGN KEY(CATCHFATELONGLINE) REFERENCES OBSERVE_LONGLINE.CATCHFATELONGLINE(TOPIAID) CHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1460/1494] ALTER TABLE OBSERVE_LONGLINE.CATCHLONGLINE ADD CONSTRAINT FK_CATCHLONGLINE_SECTION FOREIGN KEY(SECTION) REFERENCES OBSERVE_LONGLINE.SECTION(TOPIAID) CHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1461/1494] ALTER TABLE OBSERVE_LONGLINE.CATCHLONGLINE_PREDATORS ADD CONSTRAINT FK_CATCHLONGLINE_PREDATORS FOREIGN KEY(PREDATORS) REFERENCES OBSERVE_COMMON.SPECIES(TOPIAID) CHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1462/1494] ALTER TABLE OBSERVE_LONGLINE.CATCHLONGLINE_PREDATORS ADD CONSTRAINT FK_CATCHLONGLINE_CATCHLONGLINE FOREIGN KEY(CATCHLONGLINE) REFERENCES OBSERVE_LONGLINE.CATCHLONGLINE(TOPIAID) CHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1463/1494] ALTER TABLE OBSERVE_LONGLINE.ENCOUNTER ADD CONSTRAINT FK_ENCOUNTER_ACTIVITYLONGLINE FOREIGN KEY(ACTIVITYLONGLINE) REFERENCES OBSERVE_LONGLINE.ACTIVITYLONGLINE(TOPIAID) CHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1464/1494] ALTER TABLE OBSERVE_LONGLINE.ENCOUNTER ADD CONSTRAINT FK_ENCOUNTER_SPECIES FOREIGN KEY(SPECIES) REFERENCES OBSERVE_COMMON.SPECIES(TOPIAID) CHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1465/1494] ALTER TABLE OBSERVE_LONGLINE.ENCOUNTER ADD CONSTRAINT FK_ENCOUNTER_ENCOUNTERTYPE FOREIGN KEY(ENCOUNTERTYPE) REFERENCES OBSERVE_LONGLINE.ENCOUNTERTYPE(TOPIAID) CHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1466/1494] ALTER TABLE OBSERVE_LONGLINE.FISHINGOPERATION_MITIGATIONTYPE ADD CONSTRAINT FK_FISHINGOPERATION_MITIGATIONTYPE_MITIGATIONTYPE FOREIGN KEY(MITIGATIONTYPE) REFERENCES OBSERVE_LONGLINE.MITIGATIONTYPE(TOPIAID) CHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1467/1494] ALTER TABLE OBSERVE_LONGLINE.FISHINGOPERATION_MITIGATIONTYPE ADD CONSTRAINT FK_FISHINGOPERATION_MITIGATIONTYPE_FISHINGOPERATION FOREIGN KEY(FISHINGOPERATION) REFERENCES OBSERVE_LONGLINE.FISHINGOPERATION(TOPIAID) CHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1468/1494] ALTER TABLE OBSERVE_LONGLINE.FLOATLINESCOMPOSITION ADD CONSTRAINT FK_FLOATLINESCOMPOSITION_FLOATLINETYPE FOREIGN KEY(FLOATLINETYPE) REFERENCES OBSERVE_LONGLINE.FLOATLINETYPE(TOPIAID) CHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1469/1494] ALTER TABLE OBSERVE_LONGLINE.FLOATLINESCOMPOSITION ADD CONSTRAINT FK_FLOATLINESCOMPOSITION_FISHINGOPERATION FOREIGN KEY(FISHINGOPERATION) REFERENCES OBSERVE_LONGLINE.FISHINGOPERATION(TOPIAID) CHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1470/1494] ALTER TABLE OBSERVE_LONGLINE.HOOKSCOMPOSITION ADD CONSTRAINT FK_HOOKSCOMPOSITION_FISHINGOPERATION FOREIGN KEY(FISHINGOPERATION) REFERENCES OBSERVE_LONGLINE.FISHINGOPERATION(TOPIAID) CHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1471/1494] ALTER TABLE OBSERVE_LONGLINE.SECTION ADD CONSTRAINT FK_SECTION_FISHINGOPERATION FOREIGN KEY(FISHINGOPERATION) REFERENCES OBSERVE_LONGLINE.FISHINGOPERATION(TOPIAID) CHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1472/1494] ALTER TABLE OBSERVE_LONGLINE.SENSORUSED ADD CONSTRAINT FK_SENSORUSED_SENSORTYPE FOREIGN KEY(SENSORTYPE) REFERENCES OBSERVE_LONGLINE.SENSORTYPE(TOPIAID) CHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1473/1494] ALTER TABLE OBSERVE_LONGLINE.SENSORUSED ADD CONSTRAINT FK_SENSORUSED_SENSORDATAFORMAT FOREIGN KEY(SENSORDATAFORMAT) REFERENCES OBSERVE_LONGLINE.SENSORDATAFORMAT(TOPIAID) CHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1474/1494] ALTER TABLE OBSERVE_LONGLINE.SENSORUSED ADD CONSTRAINT FK_SENSORUSED_ACTIVITYLONGLINE FOREIGN KEY(ACTIVITYLONGLINE) REFERENCES OBSERVE_LONGLINE.ACTIVITYLONGLINE(TOPIAID) CHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1475/1494] ALTER TABLE OBSERVE_LONGLINE.SENSORUSED ADD CONSTRAINT FK_SENSORUSED_SENSORBRAND FOREIGN KEY(SENSORBRAND) REFERENCES OBSERVE_LONGLINE.SENSORBRAND(TOPIAID) CHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1476/1494] ALTER TABLE OBSERVE_LONGLINE.SIZEMEASURE ADD CONSTRAINT FK_SIZEMEASURE_SIZEMEASURETYPE FOREIGN KEY(SIZEMEASURETYPE) REFERENCES OBSERVE_LONGLINE.SIZEMEASURETYPE(TOPIAID) CHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1477/1494] ALTER TABLE OBSERVE_LONGLINE.SIZEMEASURE ADD CONSTRAINT FK_SIZEMEASURE_CATCHLONGLINE FOREIGN KEY(CATCHLONGLINE) REFERENCES OBSERVE_LONGLINE.CATCHLONGLINE(TOPIAID) CHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1478/1494] ALTER TABLE OBSERVE_LONGLINE.SPECIES_TDR ADD CONSTRAINT FK_SPECIES_TDR_SPECIES FOREIGN KEY(SPECIES) REFERENCES OBSERVE_COMMON.SPECIES(TOPIAID) CHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1479/1494] ALTER TABLE OBSERVE_LONGLINE.SPECIES_TDR ADD CONSTRAINT FK_SPECIES_TDR_TDR FOREIGN KEY(TDR) REFERENCES OBSERVE_LONGLINE.TDR(TOPIAID) CHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1480/1494] ALTER TABLE OBSERVE_LONGLINE.TDR ADD CONSTRAINT FK_TDR_SECTION FOREIGN KEY(SECTION) REFERENCES OBSERVE_LONGLINE.SECTION(TOPIAID) CHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1481/1494] ALTER TABLE OBSERVE_LONGLINE.TDR ADD CONSTRAINT FK_TDR_SENSORBRAND FOREIGN KEY(SENSORBRAND) REFERENCES OBSERVE_LONGLINE.SENSORBRAND(TOPIAID) CHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1482/1494] ALTER TABLE OBSERVE_LONGLINE.TDR ADD CONSTRAINT FK_TDR_FISHINGOPERATION FOREIGN KEY(FISHINGOPERATION) REFERENCES OBSERVE_LONGLINE.FISHINGOPERATION(TOPIAID) CHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1483/1494] ALTER TABLE OBSERVE_LONGLINE.TDR ADD CONSTRAINT FK_TDR_ITEMLOCATIONONBRANCHLINE FOREIGN KEY(ITEMLOCATIONONBRANCHLINE) REFERENCES OBSERVE_LONGLINE.ITEMLOCATIONONBRANCHLINE(TOPIAID) CHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1484/1494] ALTER TABLE OBSERVE_LONGLINE.TDR ADD CONSTRAINT FK_TDR_BASKET FOREIGN KEY(BASKET) REFERENCES OBSERVE_LONGLINE.BASKET(TOPIAID) CHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1485/1494] ALTER TABLE OBSERVE_LONGLINE.TDR ADD CONSTRAINT FK_TDR_ITEMLOCATIONONLONGLINE FOREIGN KEY(ITEMLOCATIONONLONGLINE) REFERENCES OBSERVE_LONGLINE.ITEMLOCATIONONLONGLINE(TOPIAID) CHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1486/1494] ALTER TABLE OBSERVE_LONGLINE.TDR ADD CONSTRAINT FK_TDR_SENSORPOSITION FOREIGN KEY(SENSORPOSITION) REFERENCES OBSERVE_LONGLINE.SENSORPOSITION(TOPIAID) CHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1487/1494] ALTER TABLE OBSERVE_LONGLINE.TDRRECORD ADD CONSTRAINT FK_TDRRECORD_BASKET FOREIGN KEY(BASKET) REFERENCES OBSERVE_LONGLINE.BASKET(TOPIAID) CHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1488/1494] ALTER TABLE OBSERVE_LONGLINE.TDRRECORD ADD CONSTRAINT FK_TDRRECORD_TDR FOREIGN KEY(TDR) REFERENCES OBSERVE_LONGLINE.TDR(TOPIAID) CHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1489/1494] ALTER TABLE OBSERVE_LONGLINE.TRIPLONGLINE ADD CONSTRAINT FK_TRIPLONGLINE_VESSEL FOREIGN KEY(VESSEL) REFERENCES OBSERVE_COMMON.VESSEL(TOPIAID) CHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1490/1494] ALTER TABLE OBSERVE_LONGLINE.TRIPLONGLINE ADD CONSTRAINT FK_TRIPLONGLINE_CAPTAIN FOREIGN KEY(CAPTAIN) REFERENCES OBSERVE_COMMON.PERSON(TOPIAID) CHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1491/1494] ALTER TABLE OBSERVE_LONGLINE.TRIPLONGLINE ADD CONSTRAINT FK_TRIPLONGLINE_TRIPTYPE FOREIGN KEY(TRIPTYPE) REFERENCES OBSERVE_LONGLINE.TRIPTYPE(TOPIAID) CHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1492/1494] ALTER TABLE OBSERVE_LONGLINE.TRIPLONGLINE ADD CONSTRAINT FK_TRIPLONGLINE_DATAINPUTOR FOREIGN KEY(DATAINPUTOR) REFERENCES OBSERVE_COMMON.PERSON(TOPIAID) CHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1493/1494] ALTER TABLE OBSERVE_LONGLINE.TRIPLONGLINE ADD CONSTRAINT FK_TRIPLONGLINE_OBSERVER FOREIGN KEY(OBSERVER) REFERENCES OBSERVE_COMMON.PERSON(TOPIAID) CHECK; INFO [main] (org.nuiton.topia.migration.AbstractTopiaMigrationCallback:205) execute - Execution de la requête [1494/1494] ALTER TABLE OBSERVE_LONGLINE.WEIGHTMEASURE ADD CONSTRAINT FK_WEIGHTMEASURE_CATCHLONGLINE FOREIGN KEY(CATCHLONGLINE) REFERENCES OBSERVE_LONGLINE.CATCHLONGLINE(TOPIAID) CHECK; 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/05_07_2014/03_02_14/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.651 sec - in fr.ird.observe.its.migration.H2DataSourceMigrationIT Results : Tests in error: DataSourceFactoryIT.testCreateH2ConfigFromDump:208 » DataSource org.nuiton.top... DataSourceFactoryIT.testCreateH2ConfigUseLocalStorage:237 » DataSource org.nui... DataSourceFactoryIT.testCreateH2ConfigImportLocalStorage:140 » DataSource org.... Tests run: 31, Failures: 0, Errors: 3, 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 : 1404522156163 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/05_07_2014/03_02_36> 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.573 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-SNAPSHOT.jar to /var/local/forge/data/codelutin.com/jenkins/workspace/observe-nightly/trunk/target/collect/fr.ird.observe--observe-business/observe-business-3.5-SNAPSHOT.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-SNAPSHOT-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-SNAPSHOT-sources.jar [INFO] Copying observe-business-3.5-SNAPSHOT-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-SNAPSHOT-javadoc.jar [INFO] Copying observe-business-3.5-SNAPSHOT-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-SNAPSHOT-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.1:compile [INFO] org.nuiton.topia:topia-service-replication:jar:2.9.1:compile [INFO] org.nuiton.topia:topia-service-migration:jar:2.9.1: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.1:test [INFO] org.nuiton.topia:topia-service-replication:jar:tests:2.9.1:test [WARNING] Unused declared dependencies found: [WARNING] commons-beanutils:commons-beanutils:jar:1.9.2:compile [JENKINS] Archiving disabled