Agent connection for Mysql failing with Communications link failure (Doc ID 2810974.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

MySQL connection for Veridata fails with the following;

2021-09-22T10:30:26.517-05:00] [VERIDATA_server1] [ERROR] [] [oracle.veridata.server] [tid: [ACTIVE].ExecuteThread: '35' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <veridata_admin_user>] [ecid: 6e47c087-0bd3-
496d-ab70-88630c7473fb-00001858,0] [APP: veridata] [partition-name: DOMAIN] [tenant-name: GLOBAL] [DSID: 0000NkDuH865qYP6yfR_6G1XHEvw00000I] Agent database information:source:mysql:jdbc:mysql://lvicggmysqljp01.ingramcontent.com:3306/coreso
urce?serverTimezone=UTC&zeroDateTimeBehavior=CONVERT_TO_NULL&sessionVariables=sql_mode='PAD_CHAR_TO_FULL_LENGTH'

[2021-09-22T10:30:26.517-05:00] [VERIDATA_server1] [ERROR] [OGGV-00122] [oracle.veridata.server] [tid: [ACTIVE].ExecuteThread: '35' for queue:
'weblogic.kernel.Default (self-tuning)'] [userId: <veridata_admin_user>] [ecid: 6e47c087-0bd3-496d-ab70-88630c7473fb-00001858,0] [APP: veridata] [partition-name: DOMAIN] [tenant-name: GLOBAL] [DSID: 0000NkDuH865qYP6yfR_6G1XHEvw00000I] Error
Message from Source Agent: (IPC code = 101): OGGV-60025: User 'dba_batch' could not connect to database: Communications link failure[[

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.; Communications link failure
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.; No appropriate protocol (protocol is disabled
or cipher suites are inappropriate)]]


[2021-09-22T10:30:26.518-05:00] [VERIDATA_server1] [WARNING] [OGGV-00184] [oracle.veridata.ui] [tid: [ACTIVE].ExecuteThread: '35' for queue:
'weblogic.kernel.Default (self-tuning)'] [userId: <veridata_admin_user>] [ecid: 6e47c087-0bd3-496d-ab70-88630c7473fb-00001858,0] [APP: veridata] [partition-name: DOMAIN]
[tenant-name: GLOBAL] [DSID: 0000NkDuH865qYP6yfR_6G1XHEvw00000I] Error
message:

OGGV-00122: Error Message from Source Agent: (IPC code = 101): OGGV-60025: User 'dba_batch' could not connect to database: Communications link failure[[
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.; Communications link failure
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.; No appropriate protocol (protocol is disabled
or cipher suites are inappropriate) [ACTION]: Please check agent logs to see the error. IPC code 101 represents a generic VeriAgentException..]]
[2021-09-22T10:30:26.579-05:00] [VERIDATA_server1] [WARNING] []

[org.apache.myfaces.shared_tomahawk.renderkit.html.HtmlImageRendererBase] [tid: [ACTIVE].ExecuteThread: '35' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <veridata_admin_user>] [ecid: 6e47c087-0bd3-496d-ab70-88630c7473fb-00001859,0] [APP:
veridata] [partition-name: DOMAIN] [tenant-name: GLOBAL] [DSID: 0000NkDuH865qYP6yfR_6G1XHEvw00000I] ALT attribute is missing for : j_id_id542

Cause

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