How to resolve the error "Attempt to DV Login failed" in the cs_server.log while restarting a TIBCO Data Virtualization server?

How to resolve the error "Attempt to DV Login failed" in the cs_server.log while restarting a TIBCO Data Virtualization server?

book

Article ID: KB0071600

calendar_today

Updated On:

Products Versions
TIBCO Data Virtualization All Supported versions

Description

When attempting to connect to a TIBCO Data Virtualization server, it is possible that an error message may appear in the cs_server.log. One such error is outlined below:
=======================================
WARN [main] 2023-02-28 13:08:09.201 -0800 DistributedTaskPrimitives - Attempt (1) to DV Login failed. Cause: java.net.ConnectException: Connection refused (Connection refused)
=======================================
This warning message indicates that the Drillbit process took longer than usual to run, but it has not yet failed completely. The Drillbit process is designed to retry login attempts multiple times before it completely fails, which is why you may see this warning message multiple times before the system starts working properly.

It is important to note that Drillbit is utilized by the Massively Parallel Processing(MPP) engine to process requests, and MPP is set to true by default on Linux machines.

Issue/Introduction

The purpose of this article is to provide an explanation of the warning message "Attempt to DV Login failed" that is observed in the cs_server.log and steps to eliminate this message.

Environment

Linux/Ubuntu Environments

Resolution

When MPP (Massively Parallel Processing) is enabled, it attempts to start itself during server restart, which can lead to warning messages being displayed.
Despite the warnings, there is no need for concern as the Drillbit process is making several attempts to start up, rather than failing altogether. Therefore, it is safe to ignore these warning messages as they are simply part of the normal process for starting up the Drillbit process.

The following log entry confirms the successful startup of the Drillbit process:  
=======================================
DrillEngine - Configured DV plugin. No modifications.
=======================================
To eliminate the warning messages, one solution is to disable the Massively Parallel Processing (MPP) engine if it isn't actively used . MPP relies on the Drillbit process.
Here are the steps to follow in order to disable Massively Parallel Processing (MPP):
  1. Navigate to TIBCO Data Virtualization Studio > Administration > Configuration > Server > SQL Engine > Parallel Processing
  2. If the "Enabled" option is set to "True", change it to "False". Please note that MPP is enabled by default in TIBCO Data Virtualization on Linux.
By disabling Massively Parallel Processing (MPP), Drillbit will not attempt to start during server startup, and the warning messages will not be displayed. However, it is important to note that the time taken for this process to complete may vary across different Linux instances.

Note: Regardless of the duration, these warning messages can be safely ignored as they are not indicative of any significant issues.