Versions Compared

Old Version 1

changes.mady.by.user Vinayak Pawar

Saved on

compared with

New Version Current

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

Saved on

Key

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

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
    ORACLE:

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;


    Note: Don't write above XML into notepad and copy it into SQLPlus command prompt. Directly write above SQL into SQLPlus command prompt.
  3. Restart OpenSpecimen