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

 kamalesh Mohanty (Kamalesh_mohanty)
Areteans
Associate director- Technology
Areteans
IN
Kamalesh_mohanty Member since 2010 7 posts
Areteans
Posted: Jul 27, 2016
Last activity: Aug 13, 2017
Posted: 27 Jul 2016 12:22 EDT
Last activity: 13 Aug 2017 22:30 EDT
Closed
Solved

issue in exporting a product using prpcUtils.sh

Hi Guys,

I am trying to export a product and create an archive in the server using prpcUtils.sh.

I am facing some issue in connection using jdbc driver.

I have added the jar path in the properties file and this is the right jar for DB & Pega version we are using.

Getting the below error while exporting.

Configuration:
[echo] Database Type: oracledate
[echo] JDBC Driver JAR: ./home/fclvappi002061/scripts/scripts/utils/ojdbc7.jar
[echo] Bootstrap Config: /tmp/PegaInstallTemp-27-July-2016-10.01.25/prbootstrap.properties
[echo] PegaRULES Config: /tmp/PegaInstallTemp-27-July-2016-10.01.25/prconfig.xml
[echo] PegaRULES Logging Config: /tmp/PegaInstallTemp-27-July-2016-10.01.25/prlogging.xml

Show More

Hi Guys,

I am trying to export a product and create an archive in the server using prpcUtils.sh.

I am facing some issue in connection using jdbc driver.

I have added the jar path in the properties file and this is the right jar for DB & Pega version we are using.

Getting the below error while exporting.

Configuration:
[echo] Database Type: oracledate
[echo] JDBC Driver JAR: ./home/fclvappi002061/scripts/scripts/utils/ojdbc7.jar
[echo] Bootstrap Config: /tmp/PegaInstallTemp-27-July-2016-10.01.25/prbootstrap.properties
[echo] PegaRULES Config: /tmp/PegaInstallTemp-27-July-2016-10.01.25/prconfig.xml
[echo] PegaRULES Logging Config: /tmp/PegaInstallTemp-27-July-2016-10.01.25/prlogging.xml

-exportArchive:
[echo] about to Export Rules to : ./ProductArchive/exported-product.zip archive ...
[echo] arg line : -C Rule-
[java] Jul 27, 2016 10:01:30 AM com.pega.pegarules.internal.bootstrap.PRBootstrapDataSource
[java] 19830421: Loading bootstrap properties from file:////tmp/PegaInstallTemp-27-July-2016-10.01.25/prbootstrap.properties
[java] Jul 27, 2016 10:01:30 AM com.pega.pegarules.internal.bootstrap.SettingReaderJNDI
[java] 19830421: Could not find java:comp/env/prbootstrap/ in the local JNDI context, skipping prconfig setting lookup
[java] Jul 27, 2016 10:01:30 AM com.pega.pegarules.internal.bootstrap.SettingReaderJNDI
[java] 19830421: Could not find prbootstrap in the local JNDI context, skipping prconfig setting lookup
[java] Jul 27, 2016 10:01:30 AM com.pega.pegarules.internal.bootstrap.PRBootstrapDataSource
[java] 19830421: Bootstrap datatables schema: DATAADM
[java] Jul 27, 2016 10:01:30 AM com.pega.pegarules.internal.bootstrap.PRBootstrapDataSource
[java] SEVERE: Unable to connect to database. Will only use properties from file.
[java] com.pega.pegarules.configdbcp.dbcp.SQLNestedException: Cannot load JDBC driver class 'oracle.jdbc.OracleDriver'
[java] at com.pega.pegarules.configdbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:743)

***Updated by Moderator: Vidyaranjan. Removed user added Ask the Expert tag. Apologies for confusion, shouldn't have been an end-user option***


Show Less
To see attachments, please log in.

Accepted Solution

Posted: 8 years ago
Posted: 28 Jul 2016 7:02 EDT
Celeste Dufresne (CelesteDufresne_GCS)
PEGA
Fellow, Technical Support, Cloud Service
Pegasystems Inc.
US

pega.jdbc.driver.jar=./home/fclvappi002061/scripts/scripts/utils/ojdbc7.jar

Remove the leading period when setting the jdbc driver location, ie /home instead of ./home

To see attachments, please log in.
Posted: 8 years ago
Posted: 28 Jul 2016 1:47 EDT
Abhishek Kumar (kumaa33)
Pegasystems Inc.
Senior Solutions Engineer
Pegasystems Inc.
IN

Hi Mohanty,

1.Can you check your prconfig.xml file once.

2.Ensure that the JDBC driver and version of Java are compatible with each other.

3. Is it refrencing the correct database jar file.

4.Also check whether database configuration details mentioned correctly in context.xml file under config folder.

To see attachments, please log in.
Posted: 8 years ago
Posted: 28 Jul 2016 2:48 EDT
Manikanta Gunturu (MP_DCS)
DCS
PEGA Consultant
DCS
AU

Hi Mohanty,

Verify the full path of Jar location and DB connectivity details.

[pega:propertyparser] Reading Properties from : /home/fclvappi002061/scripts/scripts/utils/prpcUtils.properties
[pega:propertyparser] pega.jdbc.driver.jar=./home/fclvappi002061/scripts/scripts/utils/ojdbc7.jar

[pega:propertyparser] pega.jdbc.url=jdbc:oracle:thin:@172.25.136.180:1525/dbprpcd


For reference, take the DB driver and class details from server (if jboss/config file) of specific environment and update the same in the CLU (prpcUtils.properties) configuration file.


 

To see attachments, please log in.

Accepted Solution

Posted: 8 years ago
Posted: 28 Jul 2016 7:02 EDT
Celeste Dufresne (CelesteDufresne_GCS)
PEGA
Fellow, Technical Support, Cloud Service
Pegasystems Inc.
US

pega.jdbc.driver.jar=./home/fclvappi002061/scripts/scripts/utils/ojdbc7.jar

Remove the leading period when setting the jdbc driver location, ie /home instead of ./home

To see attachments, please log in.
Posted: 7 years ago
Posted: 13 Aug 2017 22:30 EDT
Vishnu Vardhan Puli (VishnuVardhanP5688)
IBM

IBM
IN

Hi to all,

      When i am import the product file into My personal edition I got An issue,but i have tried so many times

whenever i was import the rule i got same issue,my issue was stored in the document,so please find the attached doc

 

Many Many Thanks,

Vishnu P

 

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