My Oracle Support Banner

OCDA_INFA_DayDimension_SIL_PRG Program Fails with CMN_1022 Database driver error (Doc ID 1332803.1)

Last updated on JULY 16, 2018

Applies to:

Oracle Health Sciences Clinical Development Analytics - Version 2.0.0 and later
Information in this document applies to any platform.

Symptoms

On Oracle Clinical Development Analytics (CDA) 2.0.0.2 version,
When attempting to run the Informatica OCDA_INFA_DayDimension_SIL_PRG program,
the following error is generated in program output log file:

ERROR
-----------------------

MAPPING> CMN_1022 Database driver error...
CMN_1022 [
Database driver error...
Function Name : Logon
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

Database driver error...
Function Name : Connect
Database Error: Failed to connect to database using user [ZZ_CDR_SI_210066] and connection string [CTMSRT].]



STEPS
-----------------------
The issue can be reproduced with the following steps:
1. Login to LSH Application;
2. Navigate to OCDA_DOMAIN > OCDA_CODE_APP_AREA > OCDA_WORK_AREA;
3. Run the OCDA_INFA_DayDimension_SIL_PRG with submission type immediate.
    It fails to connect to the database while executing.

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.