After Installing TSAC with external Postgres DB, Login fails with the following error in the UI (browser):
"Something went wrong! Please try again."


And 'tssa_connector.log' shows the following error: (located under '<TSAC install dir>/truesight/application/common/tssa-connector/logs/' folder)

ERROR 63 --- [workmanager-request-poll-2] c.b.c.worker.WorkManagerWorkScheduler    : configureTasks(): Error occured while processing Worker normal tasks

com.bmc.connector.worker.WorkerException: com.bmc.truesight.dem.client.RestException: Error invoking API
...
Caused by: com.bmc.truesight.dem.client.RestException: Error invoking API
...
Caused by: com.bmc.truesight.dem.client.RestException: Got error for creating access token
...
Caused by: com.bmc.secops.identitymanagement.jwt.IDMClientException: User could not be found.

While 'createupdatedbschema.log*' shows the following error: (located under '<TSAC install dir>/truesight/application/common/connector-service/logs/' folder)

2024-07-26 00:56:26.252 - error: database/DatabaseUtils.js:63:20:Error occurred while executing script for args [ 'public', 'tsac_database_connector_db' ] with sqlfile QueryFile {
    file: "/opt/bmc/truesight/connectors-service/src/database/scripts/master_schema/latest/createmaster_tables.sql"
    options: {"minify":true,"debug":false}
    query: "SET search_path TO $1; SET default_tablespace = $2; CREATE EXTENSION IF NOT EXISTS "uuid-ossp"; CREATE TABLE IF NOT EXISTS tenants_schema_mapping ( id uuid PRIMARY KEY, tenant_id varchar(255) NOT NULL UNIQUE, description varchar(255), schema_id varchar(255) NOT NULL UNIQUE, schema_version varchar(255), status varchar(255), created_time timestamp NOT NULL, updated_time timestamp ); CREATE TABLE IF NOT EXISTS cloud_collector_scheduler ( connector_id varchar(255) NOT NULL PRIMARY KEY, connector_type varchar(255) NOT NULL, tenant_id varchar(255) NOT NULL, org_id varchar(255), collection_frequency integer, next_collection_time timestamp, last_data_received_time timestamp, is_hosted boolean, is_enabled boolean, data_refresh_enabled boolean DEFAULT FALSE, state varchar(100), last_schedule_time timestamp ); CREATE TABLE IF NOT EXISTS application_properties ( property_key varchar(255) PRIMARY KEY, property_value varchar(255) NOT NULL, json_value JSONB ); CREATE TABLE IF NOT EXISTS connector_artifacts ( connector_type varchar(255) NOT NULL, connector_definitions json NOT NULL, created_time timestamp NOT NULL, updated_time timestamp NOT NULL, CONSTRAINT uk_connector_artifacts UNIQUE (connector_type) ); SET default_tablespace = 'pg_default'; SET search_path TO 'public';"
}
error: extension "uuid-ossp" is not available
...
 

The error is often observed with TSAC installation with an external postgres DB, where some of the required libraries are missing on the Postgres DB server causing the creation commands to fail.

Please refer to the following doc page to find the system requirements and supported versions for TSAC 24.3:
TSAC System requirements

In order to resolve the issue, follow the below steps:

1. Make sure that the below libraries are installed:
postgres<version>-contrib*

If you are using Postgres 15 then run the below command:
yum install postgres15-contrib*