My Oracle Support Banner

Error when Syncing into Existing Protocol with Clintrial 4.7.3 and CIS 4.6.2 or above - FAILED_EXECUTING_SQL_SCRIPT - CREATE SEQUENCE (Doc ID 2354703.1)

Last updated on JULY 13, 2023

Applies to:

Oracle Life Sciences CIS - Version 4.6.2 and later
Information in this document applies to any platform.

Symptoms

<<<<<< There was a problem during the PREPROCESS stage of the sync connection >>>>>>

There was a problem during the Create Protocol stage of the sync connection
There was a problem trying to create the Clintrial Protocol.

System.Web.Services.Protocols.SoapException: [FAILED_EXECUTING_SQL_SCRIPT] Failed executing SQL script
/* This script will update a CT Protocol with the necessary changes for 4.0.4.4426 */
CREATE SEQUENCE protocol.INF_TRANSACTIONID_SEQ
START WITH 1
NOMAXVALUE
MINVALUE 1
NOCYCLE
CACHE 20
NOORDER ---> [FAILED_EXECUTING_SQL_SCRIPT] Failed executing SQL script

 

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

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