Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Gunawan Deng (GunawanD) Accenture
Accenture
SG
GunawanD Member since 2013 14 posts
Accenture
Posted: Jul 31, 2017
Last activity: Sep 12, 2017
Posted: 31 Jul 2017 3:47 EDT
Last activity: 12 Sep 2017 8:35 EDT
Closed

Deploying multiple Pega instances (different Pega instances) on the same WebSphere App server

Currently, we are trying to setup more than 1 Pega instance in the same WebSphere App Server.

We managed to change all JNDIs (explicittempdir, ejb/EngineBMT, etc.) to be unique.

One thing we are unable to change is Name space bindings. The Name space binding need to be unique

  • prconfig/database/databases/PegaRULES/defaultSchema
  • prconfig/database/databases/PegaDATA/defaultSchema
  • prconfig/database/databases/PegaRULES/dataSourceAdmin
  • prconfig/database/databases/PegaDATA/dataSourceAdmin

What we've tried to workaround the issue is we change prconfig.xml to include defaultSchema.

Pega instance 1:

<env name="database/databases/PegaRULES/dataSource" value="java:comp/env/jdbc/PegaRULES"/>
<env name="database/databases/PegaDATA/dataSource" value="java:comp/env/jdbc/PegaDATA"/>
<env name="database/databases/PegaRULES/defaultSchema" value="PegaRULES" />
<env name="database/databases/PegaDATA/defaultSchema" value="PegaDATA" />

Pega instance 2:

<env name="database/databases/PegaRULES/dataSource" value="java:comp/env/jdbc/PegaRULESCRM"/>
<env name="database/databases/PegaDATA/dataSource" value="java:comp/env/jdbc/PegaDATACRM"/>
<env name="database/databases/PegaRULES/defaultSchema" value="PegaRULESCRM" />
<env name="database/databases/PegaDATA/defaultSchema" value="PegaDATACRM" />

Show More

Currently, we are trying to setup more than 1 Pega instance in the same WebSphere App Server.

We managed to change all JNDIs (explicittempdir, ejb/EngineBMT, etc.) to be unique.

One thing we are unable to change is Name space bindings. The Name space binding need to be unique

  • prconfig/database/databases/PegaRULES/defaultSchema
  • prconfig/database/databases/PegaDATA/defaultSchema
  • prconfig/database/databases/PegaRULES/dataSourceAdmin
  • prconfig/database/databases/PegaDATA/dataSourceAdmin

What we've tried to workaround the issue is we change prconfig.xml to include defaultSchema.

Pega instance 1:

<env name="database/databases/PegaRULES/dataSource" value="java:comp/env/jdbc/PegaRULES"/>
<env name="database/databases/PegaDATA/dataSource" value="java:comp/env/jdbc/PegaDATA"/>
<env name="database/databases/PegaRULES/defaultSchema" value="PegaRULES" />
<env name="database/databases/PegaDATA/defaultSchema" value="PegaDATA" />

Pega instance 2:

<env name="database/databases/PegaRULES/dataSource" value="java:comp/env/jdbc/PegaRULESCRM"/>
<env name="database/databases/PegaDATA/dataSource" value="java:comp/env/jdbc/PegaDATACRM"/>
<env name="database/databases/PegaRULES/defaultSchema" value="PegaRULESCRM" />
<env name="database/databases/PegaDATA/defaultSchema" value="PegaDATACRM" />

When I started Pega instance 2, the server log showed the following:

(ccess.DatabaseConfigurationMap) INFO - Base database information:
(ccess.DatabaseConfigurationMap) INFO - Database name: pegadata
(ccess.DatabaseConfigurationMap) INFO - Defined by: JNDI name
(ccess.DatabaseConfigurationMap) INFO - Data source name: java:comp/env/jdbc/PegaRULESCRM
(ccess.DatabaseConfigurationMap) INFO - Minimum connection count: 0
(ccess.DatabaseConfigurationMap) INFO - Maximum connection count: unlimited
(ccess.DatabaseConfigurationMap) INFO - Default Schema: PegaDATA
(ccess.DatabaseConfigurationMap) INFO - Base database information:
(ccess.DatabaseConfigurationMap) INFO - Database name: pegarules
(ccess.DatabaseConfigurationMap) INFO - Defined by: JNDI name
(ccess.DatabaseConfigurationMap) INFO - Data source name: java:comp/env/jdbc/PegaDATACRM
(ccess.DatabaseConfigurationMap) INFO - Minimum connection count: 0
(ccess.DatabaseConfigurationMap) INFO - Maximum connection count: unlimited
(ccess.DatabaseConfigurationMap) INFO - Default Schema: PegaRULES

Question

  1. How do achieve that so that Pega instance 2 can read from schema PegaRULESCRM and PegaDATACRM?
  2. How do change the lookup name so that Pega will lookup different key instead? Like the example below, instead of looking up by PegaRULES database, it should look up by using PegaRULESCRM.
  • prconfig/database/databases/PegaRULESCRM/defaultSchema
  • prconfig/database/databases/PegaDATACRM/defaultSchema
  • prconfig/database/databases/PegaRULESCRM/dataSourceAdmin
  • prconfig/database/databases/PegaDATACRM/dataSourceAdmin

Thanks


Show Less
To see attachments, please log in.
Installation and Deployment

Posted: 7 years ago
Posted: 1 Aug 2017 4:27 EDT
Habeeb Baig (BaigHabeeb) Virtusa IT Consulting Lead Decisioning Architect
Virtusa IT Consulting
AE

Probably in your case the Pega instance 2 is pointing to the same datasource with name space bindings given for pega instance 1.

Can you help us with some more information as below?

Are both nodes on different app profiles?

What is the scope of datasource jdbc/PegaRULES configured? Cell/Node?

I presume if both nodes are configured with different app profiles and pointing to same JNDI but the difference can be made from their name space bindings.

 

To see attachments, please log in.
Posted: 7 years ago
Posted: 28 Aug 2017 9:41 EDT
Gunawan Deng (GunawanD) Accenture
Accenture
SG

Hi HabeebBaig,

There are both using the same app profile. If they are using different WebSphere app profile, we don't have this issue.

Thanks

To see attachments, please log in.
Posted: 7 years ago
Posted: 12 Sep 2017 6:13 EDT
Habeeb Baig (BaigHabeeb) Virtusa IT Consulting Lead Decisioning Architect
Virtusa IT Consulting
AE

Hi,

If you are using different app profiles then I believe that's way it should be.

Thanks,

 

To see attachments, please log in.
Posted: 7 years ago
Posted: 12 Sep 2017 8:35 EDT
Sudhakar Reddy Yaparla (YSudhakarReddy) JPMorgan Chase & Company
JPMorgan Chase & Company
US

Hi,

Please create data source node level, it should resolve the issue. Please give JNDI name as jdbc/PegaRULES for both nodes but at the time creating datasource you can map it to different schemas. You can create name space bindings also node level.

I hope this will resolve the issue.

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice