Generate Provisional Dci Form Fails

(Doc ID 812003.1)

Last updated on MARCH 02, 2012

Applies to:

Oracle Clinical - Version: 4.5.3 and later   [Release: 4.5.3 and later ]
Information in this document applies to any platform.
***Checked for relevance on 2-Mar-2012***

Symptoms

-- Problem Statement:
OC error 24311 - ORA-12203 when trying to generate a Provisional Layout

-- Steps To Reproduce:
1. Fresh install of OC RDC 4.5.3
2. Create DVGs/Questions/QG/DCMs/DCIs in that sequence.
3. Graphic layout generation completed.
4. After this:
Generate the DEMOG DCI Form Version
Query for the created DCIs.
Place focus on the DEMOG DCI row.
Select DCI Layout from the Special menu, then select Generate Provisional Layout.
Click Save. The system generates a provisional layout.
-> completes without any error.
Select Special, DCI Layout, and then Generate Provisional Dci form.
-> Gives an error (Screenshot attached) and teh end user loses connection to the application.

-- Business Impact:
Can't complete smoketest

There is not database error in the trace files. There is not error in the alert.log either. The last statement in the sql trace file is:

RPC CALL:FUNCTION RXC.OCL_DCIF_GENERATOR.ISPDFGENERATED(PURLPATH IN VARCHAR2, PFILENAME IN VARCHAR2) RETURN BOOLEAN;
RPC BINDS:
bind 0: dty=1 bfp=092ccf24 flg=08 avl=47 mxl=200 val="http://syngdcs0150.SYNTELORG.COM/opa45/rdc/temp"
bind 1: dty=1 bfp=092cd00c flg=08 avl=35 mxl=35 val="PDFGEN21011USOPS$GUEST25735temp.pdf"
bind 2: dty=3 bfp=092cd040 flg=02 avl=04 mxl=04 val=00

Cause

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