'742400' Error appears when trying to Retire a DCI Form Version. (Doc ID 2100243.1)

Last updated on MAY 03, 2020

Applies to:

Symptoms

SCENARIO 1:
When attempting to retire a DCI Form which only has batch loaded data collected (i.e. version_sn is null for all the CRFs entered into the 'RXC.RECEIVED_DCIS' table for this particular DCI) then the following error occurs.

ERROR
--------
742400: Cannot set the status to Retired. No data has been collected using this DCI form version.

In this case the following query returns with a count greater than 0:
 SELECT COUNT(*)
 FROM   RXC.received_dcis
 WHERE  dci_id = &dci_id;

and the following query returns 0 for the count:
 select count(*)
   from   rxc.received_dcis rdci, 
          dci_form_versions dcifv
  where  rdci.dci_id      = &dci_id
   and   rdci.version_sn  = &version_sn
   and   dcifv.dci_id     = rdci.dci_id
   and   dcifv.version_sn = rdci.version_sn 
   and   dcifv.fl_status  = 'A'
   and   dcifv.language   = 'en_US';

SCENARIO 2:
The 742400 error is returned when:

• user is in TEST Mode
• production data has been entered for the DCI/Form Version that has to be retired (i.e. the two above mentioned queries both return data).

Changes

Cause