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

 Debraj Bhowmik (DebrajB16819133) Areteans Technology Solutions Senior Architect
Areteans Technology Solutions
IN
DebrajB16819133 Member since 2023 22 posts
Areteans Technology Solutions
Posted: Dec 6, 2018
Last activity: Mar 8, 2019
Posted: 6 Dec 2018 8:07 EST
Last activity: 8 Mar 2019 15:23 EST
Closed

Entry for AdminPegaRULES in prconfig.xml

I am trying to deploy R-A-P product using prpcUtils.sh from command line. I am getting the below errors in log:

-init:

[pega:propertyparser] Reading Properties from : /app/GPG/dyn/local/tmp/prpc7_install/scripts/utils/prpcUtils.properties

[pega:propertyparser] pega.jdbc.driver.jar=/app/ora/dbclient/jdbc/lib/ojdbc6.jar

[pega:propertyparser] pega.jdbc.driver.class=oracle.jdbc.OracleDriver

[pega:propertyparser] pega.database.type=oracledate

[pega:propertyparser] pega.jdbc.url=jdbc:oracle:thin:@localhost:24188:PGDBT

[pega:propertyparser] pega.jdbc.username=pgadmin

[pega:propertyparser] pega.jdbc.password=******

[pega:propertyparser] pega.user.username=

[pega:propertyparser] pega.user.password=

[pega:propertyparser] rules.schema.name=prpcrules

[pega:propertyparser] data.schema.name=prpcdata

[pega:propertyparser] pega.agents.enable=true

[pega:propertyparser] column.population.job.mode=COMMANDLINE_JOB

[pega:propertyparser] user.temp.dir=/app/GPG/dyn/local/tmp/prpc7_install/tmp

[pega:propertyparser] import.archive.path=/app/pega7/av/ Proprietary information hidden/0324_all_P3Product.zip

[pega:propertyparser] import.mode=import

[pega:propertyparser] import.existing.instances=skip

[pega:propertyparser] import.nofailonerror=false

[pega:propertyparser] import.commit.count=100

[pega:propertyparser] import.compile.libraries=true

Show More

I am trying to deploy R-A-P product using prpcUtils.sh from command line. I am getting the below errors in log:

-init:

[pega:propertyparser] Reading Properties from : /app/GPG/dyn/local/tmp/prpc7_install/scripts/utils/prpcUtils.properties

[pega:propertyparser] pega.jdbc.driver.jar=/app/ora/dbclient/jdbc/lib/ojdbc6.jar

[pega:propertyparser] pega.jdbc.driver.class=oracle.jdbc.OracleDriver

[pega:propertyparser] pega.database.type=oracledate

[pega:propertyparser] pega.jdbc.url=jdbc:oracle:thin:@localhost:24188:PGDBT

[pega:propertyparser] pega.jdbc.username=pgadmin

[pega:propertyparser] pega.jdbc.password=******

[pega:propertyparser] pega.user.username=

[pega:propertyparser] pega.user.password=

[pega:propertyparser] rules.schema.name=prpcrules

[pega:propertyparser] data.schema.name=prpcdata

[pega:propertyparser] pega.agents.enable=true

[pega:propertyparser] column.population.job.mode=COMMANDLINE_JOB

[pega:propertyparser] user.temp.dir=/app/GPG/dyn/local/tmp/prpc7_install/tmp

[pega:propertyparser] import.archive.path=/app/pega7/av/ Proprietary information hidden/0324_all_P3Product.zip

[pega:propertyparser] import.mode=import

[pega:propertyparser] import.existing.instances=skip

[pega:propertyparser] import.nofailonerror=false

[pega:propertyparser] import.commit.count=100

[pega:propertyparser] import.compile.libraries=true

Here pgadmin is the Admin user(schema) which has both read-write access to prpcrules and prpcdata schemas. Oracle database is used.

..............

...............

[java] 2018-11-28 09:09:37,271 [ main] [ ] [ ] (ernal.access.DataSourceManager) ERROR - Unable to obtain DataSource for sample: j

ava:comp/env/jdbc/PegaRULES

[java] 2018-11-28 09:09:37,274 [ main] [ ] [ ] (ernal.access.DataSourceManager) ERROR - Unable to obtain DataSource for pegadata:

jdbc/PegaRULES

The below entries are there in prconfig.xml that is used by prpcUtils.sh:

<env name="database/databases/PegaRULES/defaultSchema" value="prpcrules" />
<env name="database/databases/PegaDATA/defaultSchema" value="prpcdata" />

Please inform if the below line needs to be included in prconfig.xml to get rid off the above mentioned error "Unable to obtain DataSource"?

<env name="database/databases/AdminPegaRULES/defaultSchema" value="pgadmin" />

What may be the other solution?

***Edited by Moderator Marissa to update SR Details***


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

Posted: 5 years ago
Posted: 10 Dec 2018 22:29 EST
Manjunatha Anantharaju (Manju_PEGA) British Telecom Senior Pega Developer
British Telecom
IN

Hi Deb,

Sure its DB configuration issue, as we could see the below error mesage.

[java] 2018-11-28 09:09:37,271 [ main] [ ] [ ] (ernal.access.DataSourceManager) ERROR - Unable to obtain DataSource for sample: j

ava:comp/env/jdbc/PegaRULES

If you have not tried adding the below one to prconfig, could you please give a try:

<env name="database/databases/AdminPegaRULES/defaultSchema" value="pgadmin" />

Show More

Hi Deb,

Sure its DB configuration issue, as we could see the below error mesage.

[java] 2018-11-28 09:09:37,271 [ main] [ ] [ ] (ernal.access.DataSourceManager) ERROR - Unable to obtain DataSource for sample: j

ava:comp/env/jdbc/PegaRULES

If you have not tried adding the below one to prconfig, could you please give a try:

<env name="database/databases/AdminPegaRULES/defaultSchema" value="pgadmin" />

And also DB configuration in context.xml file(if tomcat server)is correct?

You can find out exact error message for command line jobs in the designer studio by following below steps:

If you are doing Import process,For every  command line run  instance will be created 

1) Check the instances of Log-PegaRemoteManagement-Import and open the ImportRequest XML

2) Check the pyErrorMessage.

 

 

 


Show Less
To see attachments, please log in.
Posted: 5 years ago
Posted: 25 Dec 2018 23:26 EST
Debraj Bhowmik (DebrajB16819133) Areteans Technology Solutions Senior Architect
Areteans Technology Solutions
IN

We are using Oracle database. The prconfig.xml is used by prpcUtils.sh. SR-C54249 has been created for the below issue:

[java] 2018-11-28 09:09:37,271 [ main] [ ] [ ] (ernal.access.DataSourceManager) ERROR - Unable to obtain DataSource for sample: java:comp/env/jdbc/PegaRULES

[java] 2018-11-28 09:09:37,274 [ main] [ ] [ ] (ernal.access.DataSourceManager) ERROR - Unable to obtain DataSource for pegadata: jdbc/PegaRULES

Using prpcUtils.sh we are unable to deploy a product containing the data instances 'DATA-ADMIN-DB-NAME PEGARULESEXT'. It is getting skipped during import. But when the same product is deployed from Pega Designer Studio, the instance is getting imported. 

We are running Pega on WebSphere and Oracle.

To see attachments, please log in.
Posted: 5 years ago
Posted: 31 Jan 2019 11:07 EST
Jagannath Rajagopalan (JagannathR8869) DXC Technology
DXC Technology
BE

Dears,

Can you let me know if there was a hotfix provided for this SR mentioned? 

I have a similar issue where one of my datasources is not detected by prpcUtils during data instance import. 

[java] 2019-01-31 15:34:50,153 [         was30457.bc] [  STANDARD] [     PegaRULES:07.10] (ss.DatabaseSchemaGeneratorImpl) ERROR JSR94|Deployment|Utility|pxImportAppBundle|A3FBF1BC4F7E3AFA1538E68E78577497F  - 'XXXStore' is not a valid database.
     [java] com.pega.pegarules.pub.database.BadDatabaseDefinitionException: Database-BadDBDef-Missing   XXXStore

The same datainstance jar gets imported successfully when done with designer studio.

regards,

Jagan

 

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