Responses Not Saved If Tablespace Is Full (Doc ID 1121223.1)

Last updated on JUNE 23, 2010

Applies to:

Oracle Clinical - Version: 4.5.3 and later   [Release: 4.5 and later ]
Information in this document applies to any platform.

Goal

The tablespace where the indexes of table RESPONSES are stored (RXC_RESP_IDXM_TSPA) was 100% full and couldn't be extended anymore. So the reponses index RESPONSE_RDCM_NFK_IDX couldn't be refreshed and the complete insert on the table RESPONSES was rolled back.

The received DCIs and Received DCMs, however, were saved as 'Entry complete'. This led to a situation where RDCMs and RDCIs with status 'Entry complete' existed, but no Responses.



Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms