CDA 4.0: Setting Up the Source System with Oracle Clinical 5.2.x Fails With ' ORA-00942: table or view does not exist '
(Doc ID 2811475.1)
Last updated on JULY 13, 2023
Applies to:
Oracle Life Sciences Clinical Development Analytics - Version 4.0.0 and laterInformation in this document applies to any platform.
Symptoms
CDA 4.0.0 -> Trying to add OC ( Oracle Clinical) as datasource, you are receiving the below error in ocda_oc_odi_driverscript<DATE>.log:
8. Enter values in the following fields:
- OC Source Server Host Name
- OC Source Server Port No
- OC Source Server Service Name
- OC Source System Password
9. Click Next.
10. Enter values in the following fields:
- OC Source Schema Name [RXC] -> the wrong step
- OC Source Schema Password
11. Click Next.
The OCDA Oracle Clinical Source System Details screen appears.
12. Enter values in the following fields:
- OCDA OC Source Schema Name
- OCDA OC Source Schema Password
- OCDA OC Source Schema Confirm Password
- OCDA OC Default Tablespace Name
- OCDA OC Temporary Tablespace Name
13. Click Next.
The OCDA Oracle Clinical Work Schema Details screen appears.
14. Enter values in the following fields:
- OCDA OC Work Schema Name
- OCDA OC Work Schema Password
- OCDA OC Work Schema Confirm Password
- OCDA OC Work Default Tablespace Name
- OCDA OC Work Temporary Tablespace Name
15. Click Next.
The Summary screen appears
16. Click Install.
Changes
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 |
Changes |
Cause |
Solution |