Question

5
Replies
776
Views
Hareen.Yadlapalli Member since 2011 17 posts
Incessant Technologies Pvt Ltd.
Posted: 4 years ago
Last activity: 4 years 3 months ago
Closed

Database Table - Test Connection failure - NonexistentTable exception

We've two MS SQL 2008 R2 databases (pega 7.1.8) which have all the connectivities working.

 

1. PegaRULES

2. PegaREF

 

The size of the database PegaRULES has grown over the last few years, backup and recovery of database are taking more time.

 

To reduce the time taken for the backup and recovery, we've made below changes at the database.

 

1. Created an additional database, PegaRULES-Syn

2. Copied few tables from PegaRULES to PegaRULES-Syn.

     a. pca_work

2. Deleted few tables in PegaRULES, tables list below

     a. pca_work

3. Created a synonym for the above table in PegaRULES database and pointed it to the table pca_work in the database PegaRULES-Syn.

 

After making the above changes, executing the SQL queries on pca_work by selecting the PegaRULES database is working fine, but when tried to test the connectivity (restarted Pega App Server) after making above changes, it fails. Pega is not able to establish the connectivity with the tables that have synonyms created, suggesting that the table doesn't exist in the PegaRULES database!

 

Does pega have any different steps if the database / tables is setup this way? If "No", what changes would fix the connectivity issue?

 

Regards,

Hareen

 

***Updated by moderator: Vidyaranjan. Removed user added #helpme and Ask the Expert tags. Apologies for confusion, shouldn't have been an end-user option.

Data Integration
Moderation Team has archived post
Share this page LinkedIn