Versions Compared

Old Version 3

changes.mady.by.user Vinayak Pawar

Saved on

compared with

New Version 4

changes.mady.by.user Krishna Waidande (Unlicensed)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Error: Migration failed for change set db/3.4/schema.xml::Unique PPID per collection protocol::vlonushte: Reason: liquibase.exception.DatabaseException: java.sql.SQLIntegrityConstraintViolationException: ORA-02299: cannot validate (OPENSPECIMEN.CAT_CPR_CP_ID_PPID_UQ) - duplicate keys found

Reason: caTissue DB allowed duplicate PPIDs within a CP whereas OS DB has a constraint to enforce unique PPID per CP.

...

Code Block
languagesql
update 
  catissue_coll_prot_reg 
set 
  protocol_participant_id = concat(concat(protocol_participant_id, '_'), participant_ididentifier)
where 
  protocol_participant_id in ( 
    select 
	  t.protocol_participant_id 
	from ( 
	  select 
	    protocol_participant_id 
	  from
        catissue_coll_prot_reg reg 
	  group by 
	    reg.collection_protocol_id, reg.protocol_participant_id 
	  having
	    count(reg.protocol_participant_id) > 1 
	) t 
  );

...

Code Block
languagesql
update
  catissue_coll_prot_reg
set
  protocol_participant_id = concat(concat(collection_protocol_id, '_'), participant_ididentifier)
where
  protocol_participant_id is null;

...