Hareen Ganesh Yadlapalli (Hareen.Yadlapalli)
Incessant Technologies Pvt Ltd.

Incessant Technologies Pvt Ltd.
Hareen.Yadlapalli Member since 2011 17 posts
Incessant Technologies Pvt Ltd.
Posted: July 11, 2016
Last activity: July 18, 2016
Posted: 11 Jul 2016 20:01 EDT
Last activity: 18 Jul 2016 0:11 EDT

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?





***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, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.