Discussion

2
Replies
400
Views
Close popover
Chiranjeevi Mangisetty (CHIRANJEEVI-2)
Virtusa

Virtusa
IN
CHIRANJEEVI-2 Member since 2010 4 posts
Virtusa
Posted: May 11, 2016
Last activity: April 6, 2018
Closed

Connect-SQL Schema

Hi Team,

We have created one data table in PEGA schema and using connect-SQL i tried to connect to the table to perform Create/Delete/Update operations. In the connect SQL i did not mention any schema before table name, i called this SQL on the page where the class of this page is mapped to the table using Data base table rule. I am able to connect this table in E1 dev environment. At run time schema name will be getting from the data base table urle.

But when it moves to E2-UAT environment, it is not working. But if i hard code the schema name before the table in the connect-SQL rule it is working properly.

Could you please suggest why it is behaving differently in higher environments.

Thanks,

Chiranjeevi M

**Moderation Team has archived post**

This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.

System Administration Upgrades
Moderation Team has archived post