Discussion

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