My Oracle Support Banner

Initial Log-In Entry In Oracle Clinical Failing ( The Database Was Cloned) (Doc ID 1296097.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Clinical - Version: 4.5.3 and later   [Release: 4.5.3 and later ]
This problem can occur on any platform.

Symptoms

While attempting to enter data with the INITIAL LOG-IN AND FIRST-PASS ENTRY form, and  after clicking PgDn, then entering more data, and attempting to save then exit, the form indicates that there are pending changes.

ERROR MESSAGES:
FRM-40508: ORACLE error: unable to INSERT record.

You find the following statement in a database trace:

INSERT INTO RECEIVED_DCMS (LOG_IN_TS,DCM_LAYOUT_SN,BLANK_FLAG,RECEIVED_DCM_STATUS_CODE,QUALIFYING_VALUE,LAB,CLIN_PLAN_EVE_NAME,SUBEVENT_NUMBER,VISIT_NUMBER,RECEIVED_DCM_ID,RECEIVED_DCM_ENTRY_TS,RECEIVED_DCI_ID,ACCESSIBLE_TS,SN,END_TS,CLINICAL_STUDY_ID,LAST_STATUS_CHANGE_TS,DCM_ID,DCM_SUBSET_SN,CLIN_PLAN_EVE_ID,ACTUAL_EVENT_ID,DATA_COMMENT_TEXT,LAB_ID,LAB_RANGE_SUBSET_NUM,INVESTIGATOR_ID,INVESTIGATOR,SITE_ID,SITE,PATIENT_POSITION_ID,PATIENT,DATA_LOCK_FLAG,DATA_LOCK_TS,ENTERED_BY,MODIFIED_BY,MODIFICATION_TS,DCM_DATE,DCM_TIME,LAB_ASSIGNMENT_TYPE_CODE,LAB_MODIFICATION_TS,COMMENT_TEXT,DOCUMENT_NUMBER,LAST_DATA_CHANGE_TS,PASS_ONE_TS,PASS_ONE_BY,PASS_TWO_TS,PASS_TWO_BY,LAST_RESPONSE_MODIFICATION_TS,DCI_ID)  
VALUES (:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,:16,:17,:18,:19,:20,:21,:22,:23,:24,:25,:26,:27,:28,:29,:30,:31,:32,:33,:34,:35,:36,:37,:38,:39,:40,:41,:42,:43,:44,:45,:46,:47,:48)  
END OF STMT
ERROR #92:err=1 tim=96222062

If

Select received_dcm_seq.nextval From dual <  Select max(received_dcm_id) From RECEIVED_DCMS;

then you have this problem.

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
  Symptoms
  Cause
  Solution
  References

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.