RPD JDBC Connections Fail After Enabling End-to-End SSL (Doc ID 2887354.1)

Last updated on FEBRUARY 01, 2024

Applies to:

Symptoms

Analysis that is based on RDP Connection Pool Type JDBC(JNDI) Fails with

Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000)
State: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS. (HY000)
State: HY000. Code: 43119. [nQSError: 43119] Query Failed: (HY000)
State: HY000. Code: 100031. [nQSError: 100031] Unknown Call interface type JDBC (JNDI). (HY000)

after enabling End-to-End SSL

Without SSL same reports run fine.

 obis1-diagnostic.log file has below entries -

[2022-08-01T16:20:22.616-05:00] [OBIS] [NOTIFICATION:1] [] [] [ecid:005tJIHKFV7Fw000jzwkno0004mp0000HX,0] [sik: ssi] [tid: ca85c700] Loading
metadata for JavaDS Host: https://obihost:9503/obiee/javads. Use SQL over HTTP:False. Use Password Auth: False

[2022-08-01T16:20:22.771-05:00] [OBIS] [ERROR:1] [] [] [ecid:005tJIHKFV7Fw000jzwkno0004mp0000HX,0] [sik: ssi] [tid: ca85c700] [nQSError:12002] Socket communication error at call=SSL_connect: (Number=1)error:14090086:SSL routines:ssl3_get_server_certificate:certificate verify failed [[file: server/Utility/Comm/Src/SUCMSSL.cpp; line: 919]]
[2022-08-01T16:20:22.772-05:00] [OBIS] [ERROR:1] [] [] [ecid:005tJIHKFV7Fw000jzwkno0004mp0000HX,0] [sik: ssi] [tid: ca85c700] [nQSError:12002] Socket communication error at call=SSL_connect: (Number=1)error:14090086:SSL routines:ssl3_get_server_certificate:certificate verify failed [[file: server/Utility/Comm/Src/SUCMSSL.cpp; line: 919

[nQSError: 46119] Failed to open HTTP connection to server ohihost at port 9503.

Changes

 Enabled End-to-End SSL

Cause

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