ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Multiple Registries connecting to database with multiple schemas

book

Article ID: 6968

calendar_today

Updated On:

Products

CA Application Test CA Continuous Application Insight (PathFinder)

Issue/Introduction

Currently Installing CA DevTest on two linux boxes.

Have deployed the standard DDL's onto 2 separate schema's per instructions from conversations had with support.

In the documentation, it states that manual deployments are possible.

Question is how to configure the Registry to point to different schema before Registry service start?

 

Cause

After reviewing the SQL Server, there is only 1 database, but that database has 2 sets of Registry tables, being differentiated by a prefix.

Environment

All supported DevTest releases and platforms.

Resolution

DevTest can only connect to the Registry based on its connection string for SQL Server in the site.properties file. There is no way to specify a set of DevTest tables based on its prefix in the connection string. Registries and Enterprise Dashboards must each have a unique schema (database), so it is not possible not point multiple Registries at the same database. Need to change the one database with the 2 sets of tables to only have one set.