Connecting to on-premise databases after TIBCO Cloud Integration Upgrade may generate errors with error code 400

Connecting to on-premise databases after TIBCO Cloud Integration Upgrade may generate errors with error code 400

book

Article ID: KB0073866

calendar_today

Updated On:

Products Versions
TIBCO Flogo Connector for Oracle MySQL -
TIBCO Flogo Connector for Oracle Database -
TIBCO Flogo Connector for PostgreSQL -

Description

When using the below DB connections to connect to on-premise DB, a connection error may happen with error code 400.

TIBCO Flogo Connector for Oracle MySQL
TIBCO Flogo Connector for Microsoft SQL Server
TIBCO Flogo Connector for Oracle Database
TIBCO Flogo Connector for PostgreSQL

This issue happens because if the TCI has an update, the DB service could not update automatically. This might cause the DB connections could not work properly. 

Issue/Introduction

Connecting to on-premise databases after TIBCO Cloud Integration Upgrade may generate errors with error code 400

Environment

TIBCO Flogo Connector for Oracle MySQL TIBCO Flogo Connector for Microsoft SQL Server TIBCO Flogo Connector for Oracle Database TIBCO Flogo Connector for PostgreSQL

Resolution

To resolve the issue, please navigate to Environment & Tools->Hybrid Database Connection page, disable and enable the DB service.

Using the below commands could do the same.
         tibcli org dbservice disable
         tibcli org dbservice enable --accessKey <keyname>