Missing JDBC URL Connection String
I have a PEGA 6.1 SP2 instance on WebLogic server with an Oracle Database that was set up a few years and I need your expertise on the way the DB connections have been set up.
Inside my PEGA application (under Rules Explorer -> SysAdmin -> Database) I have a custom DB with JDBC URL String specified and a PegaRules DB WITHOUT a JDBC URL String specification.
In the WebLogic Console, the JDBC URL String is specified for both Databases and my application is working.
When I test my DB connection (for the DB without the JDBC URL String specified) I get the following msg. --
Test Database Connection :- Status Value: No DataSource definition available for database PegaRULES:
code: <none>
SQLState: <none>
Message: <none>
Fail
When I test my DB connection (for the custom DB with the JDBC URL String specified) I get the following msg. --
Test Database Connection
Status Value: Good
Successfully connected to database
On page 31 of the installation guide, the string is specified but inside my application the string is absent and my application is still working.
https://pdn.pega.com/documents/prpc-61-sp2-installing-weblogic-application-servers
I have a PEGA 6.1 SP2 instance on WebLogic server with an Oracle Database that was set up a few years and I need your expertise on the way the DB connections have been set up.
Inside my PEGA application (under Rules Explorer -> SysAdmin -> Database) I have a custom DB with JDBC URL String specified and a PegaRules DB WITHOUT a JDBC URL String specification.
In the WebLogic Console, the JDBC URL String is specified for both Databases and my application is working.
When I test my DB connection (for the DB without the JDBC URL String specified) I get the following msg. --
Test Database Connection :- Status Value: No DataSource definition available for database PegaRULES:
code: <none>
SQLState: <none>
Message: <none>
Fail
When I test my DB connection (for the custom DB with the JDBC URL String specified) I get the following msg. --
Test Database Connection
Status Value: Good
Successfully connected to database
On page 31 of the installation guide, the string is specified but inside my application the string is absent and my application is still working.
https://pdn.pega.com/documents/prpc-61-sp2-installing-weblogic-application-servers
Where would I find the settings for the PegaRules Database which is able to connect without specifying the JDBC URL Connection String inside the Developer Portal? Screen shots are attached.
***Updated by Moderator: Vidyaranjan. Removed user added Ask the Expert tag. Apologies for confusion, shouldn't have been an end-user option***
Pegasystems Inc.
IN
Hi,
In page 31 of the installation the JDBC string specified is WebLogic console value but your mentioning it as Pega portal "On page 31 of the installation guide, the string is specified but inside my application the string is absent and my application is still working." . So as per the above note your refering to Pega portal but it should be WebLogic console. More over you noted "In the WebLogic Console, the JDBC URL String is specified for both Databases and my application is working." as per this you have already configured the data soures in correct way.
for your question "Where would I find the settings for the PegaRules Database which is able to connect without specifying the JDBC URL Connection String inside the Developer Portal? "
We will configure data base information on server side it self in your case in Weblogic console.
FDIC
US
HI!
Thanks for your reply. I am taking over a Legacy PEGA Application whose PegaRULES password has not been changed in almost ten years.
My understanding is that the DB Connection has to be set up in the Developer PORTAL (under Rules Explorer -> SysAdmin -> Database) AND
this JDBC Connection URL String (in the developer portal) has to match with the JDBC Connection URL String in the WebLogic Console.
As you can see from the screen shots, the custom DB in my application has a JDBC URL specified, while the PegaRULES DB has no JDBC URL specification.
From inside my developer portal, I can see that the JDBC URL Connection String is empty but in the WebLogic Console the JDBC URL String is populated.
The Connection to the PegaRULES DB (see screen shot) says the following
1. Use Configuration in Preferences
2. Entry created by System
3. Record any advanced options for this database in the PegaRULES preferences file
The installation guide (pg 31) does not specify this particular type of set up and I need to know where this is specified - how a PEGA application can connect to a DB WITHOUT specifying the JDBC URL Connection String inside the Developer Portal but the JDBC URL being specified ONLY in the WebLogic Console. How does PEGA know and/or pick up the connection to the PegaRULES DB?
HI!
Thanks for your reply. I am taking over a Legacy PEGA Application whose PegaRULES password has not been changed in almost ten years.
My understanding is that the DB Connection has to be set up in the Developer PORTAL (under Rules Explorer -> SysAdmin -> Database) AND
this JDBC Connection URL String (in the developer portal) has to match with the JDBC Connection URL String in the WebLogic Console.
As you can see from the screen shots, the custom DB in my application has a JDBC URL specified, while the PegaRULES DB has no JDBC URL specification.
From inside my developer portal, I can see that the JDBC URL Connection String is empty but in the WebLogic Console the JDBC URL String is populated.
The Connection to the PegaRULES DB (see screen shot) says the following
1. Use Configuration in Preferences
2. Entry created by System
3. Record any advanced options for this database in the PegaRULES preferences file
The installation guide (pg 31) does not specify this particular type of set up and I need to know where this is specified - how a PEGA application can connect to a DB WITHOUT specifying the JDBC URL Connection String inside the Developer Portal but the JDBC URL being specified ONLY in the WebLogic Console. How does PEGA know and/or pick up the connection to the PegaRULES DB?
The DB password is set to change and I need to know all the locations I need to change the password for the PegaRULES DB.
Pegasystems Inc.
IN
Hi
PegaRules Data instance created by the wizard and by default it is referring to preference file to check the DB details.
ex: prconfig.xml
Even if you have db details in prconfig, you will get this error in 6.2 sp2 because there is existing bug opened for this case.
If you want Hotfix, you can raise SR from my support portal.
Pegasystems Inc.
IN
Hello!
Please let us know the SR number if you end up creating one with Pega Support.
Regards,
Lochan | Community Moderator | Pegasystems Inc.
Virtusa IT Consulting
AE
As you have described the behaviour is on 6.1 sp2.
As I understand the behaviour you are reporting with addition of "oracle.jdbc.v8compatible=true" extra DB connection property while adding the JDBC url in database rule in PRPC. So you need not add this extra connection property "oracle.jdbc.v8compatible=true" when you define database rule, you can use only the base JDBC url.
oracle.jdbc.v8compatible=true is used to define PegaRULES datasource on application server to support 'Date' datatype for the Data model defined in PRPC rulebase.