Page Comparison

The distributed event form in caTissue / OS v1.1 is not compatible with that present in v2x onward. As a result, during upgrade, following error is encountered: CATISSUE_DISTRI_EVENT_PARAM: ORA-00942: table or view does not exist 

To fix the problem, follow below steps:

1. Retrieve distributed event form ID

   Code Block
   select identifier from dyextn_containers where name = 'SpecimenDistributedEvent';

   
   

2. Reset the existing form definition in database. Replace CONTAINER_ID occurring at 2 places in below SQL with the value obtained in step #1.

   Code Block
   update dyextn_containers set xml = utl_raw.cast_to_raw('<container id="1"><id>CONTAINER_ID</id></id><name>SpecimenDistributedEvent</name>' || '<managedTables>true</managedTables><controlsMap class="linked-hash-map" id="2">' || '</controlsMap><skipRules id="22"/></container>') where identifier = CONTAINER_ID; commit;

   
   

3. Restart OpenSpecimen

...