Exception in thread "main" java.lang.IllegalArgumentException: Unable to load class: oracle.jdbc.OracleDriver
Hi team,
We are trying to update the application from 7.1.9 to 7.2.2.
While running the Updating the data schema step, im getting the bellow error in the step of apply UDF.: Apply UDFs inner: Load UDF
Error:
Hi team,
We are trying to update the application from 7.1.9 to 7.2.2.
While running the Updating the data schema step, im getting the bellow error in the step of apply UDF.: Apply UDFs inner: Load UDF
Error:
[java] Exception in thread "main" java.lang.IllegalArgumentException: Unable to load class: oracle.jdbc.OracleDriver
[java] at com.pega.pegarules.install.ConnectionWrapper.get(ConnectionWrapper.java:333)
[java] at com.pega.pegarules.install.ConnectionWrapper.createStatement(ConnectionWrapper.java:352)
[java] at com.pega.pegarules.install.udf.loaders.OracleUDFJarLoader.installJarOnOracle(OracleUDFJarLoader.java:124)
[java] at com.pega.pegarules.install.udf.loaders.OracleUDFJarLoader.load(OracleUDFJarLoader.java:73)
[java] at com.pega.pegarules.install.UDFManager$AbstractUDFExecutor.loadUDFJar(UDFManager.java:348)
[java] at com.pega.pegarules.install.UDFManager$ExecuteUDFWithOutTransaction.executeInner(UDFManager.java:293)
[java] at com.pega.pegarules.install.UDFManager$AbstractUDFExecutor.execute(UDFManager.java:357)
[java] at com.pega.pegarules.install.UDFManager.process(UDFManager.java:178)
[java] at com.pega.pegarules.install.UDFManager.main(UDFManager.java:129)
[java] Caused by: java.lang.ClassNotFoundException: oracle.jdbc.OracleDriver
[java] at java.net.URLClassLoader$1.run(Unknown Source)
[java] at java.net.URLClassLoader$1.run(Unknown Source)
[java] at java.security.AccessController.doPrivileged(Native Method)
[java] at java.net.URLClassLoader.findClass(Unknown Source)
[java] at java.lang.ClassLoader.loadClass(Unknown Source)
[java] at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
[java] at java.lang.ClassLoader.loadClass(Unknown Source)
[java] at java.lang.Class.forName0(Native Method)
[java] at java.lang.Class.forName(Unknown Source)
[java] at com.pega.pegarules.install.ConnectionWrapper.get(ConnectionWrapper.java:331)
[java] ... 8 more
We have mentioned the properties file as mentioned in the instruction document. And too tried with changing the parameter "bypass.pega.schema" as empty.
in both steps, we are getting the same Error.
Could someone suggest us to resolve the issue.
Attached the log file too
Thanks
**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.
Accepted Solution
Paypal Inc
IN
Is the driver jar path valid ? Should it be /home/gemsops/ojdbc7.jar ?
Pegasystems Inc.
IN
Could you please make sure that correct jdbc jar file path is provided. Looks like it is not loading the jdbc driver class.
The log file is empty please re upload it.
Virtusa
IN
HI Dhevandra,
We proceeded the error by making the bypass.pega.schema=true. Please correct me if my understanding is wrong.
When done the changes, the updation of the data schema proceeds and i get the below error.
Error log:
Schema Upgrade:
[echo] Skipping automatic schema upgrade because bypass.pega.schema is set to true
_getSystemName:
_findSystemName:
[echo] select max(s.pySystemName) from RuleSchema.pr_data_admin s inner join RuleSchema.pr_data_admin r on s.pySystemName = r.pySystemName where s.pxobjclass = 'Data-Admin-System' and r.pxObjClass = 'Data-Admin-Requestor'
[echo] System Name: prpc
[replace] Replaced 1 occurrences in 1 files.
Replace System Name:
HI Dhevandra,
We proceeded the error by making the bypass.pega.schema=true. Please correct me if my understanding is wrong.
When done the changes, the updation of the data schema proceeds and i get the below error.
Error log:
Schema Upgrade:
[echo] Skipping automatic schema upgrade because bypass.pega.schema is set to true
_getSystemName:
_findSystemName:
[echo] select max(s.pySystemName) from RuleSchema.pr_data_admin s inner join RuleSchema.pr_data_admin r on s.pySystemName = r.pySystemName where s.pxobjclass = 'Data-Admin-System' and r.pxObjClass = 'Data-Admin-Requestor'
[echo] System Name: prpc
[replace] Replaced 1 occurrences in 1 files.
Replace System Name:
Optimize Data Instances:
[echo] Optimizing the following classes: Data-Admin-Connect-AtomServer,Data-Admin-Connect-FTPServer,Data-Admin-Connect-JCAAdapter, Data-Admin-Connect-JMSProducerModel,Data-Admin-Connect-JNDIServer,Data-Admin-Connect-MQServer, Data-Admin-Connect-SOAPServer,Data-Admin-Connect-Transport-JMS,Data-Admin-RequestProcessor-Connect, Data-Admin-RequestProcessor-Service, Data-Admin-Security-Keystore,Data-Admin-Security-OAuth-Client,Data-Admin-Security-OAuth2-Provider, Data-Admin-Security-OAuth2-RegisteredApplication,Data-Admin-Security-WSSecurityProfile, Data-Admin-ServicePackage,Data-Admin-WebServices-Policy,Data-EmailAccount,Data-Admin-Security-AuthenticationProfile
[java] Mar 14, 2017 4:23:27 AM com.pega.pegarules.internal.bootstrap.PRBootstrapDataSource
[java] 1050: Loading bootstrap properties from file:////app/gems/Pega722/TEMP/PegaInstallTemp-14-March-2017-02.56.31/prbootstrap.properties
[java] Mar 14, 2017 4:23:27 AM com.pega.pegarules.internal.bootstrap.SettingReaderJNDI
[java] INFO: Could not find java:comp/env/prbootstrap/ in the local JNDI context, skipping prconfig setting lookup
[java] Mar 14, 2017 4:23:27 AM com.pega.pegarules.internal.bootstrap.SettingReaderJNDI
[java] INFO: Could not find prbootstrap in the local JNDI context, skipping prconfig setting lookup
[java] Mar 14, 2017 4:23:27 AM com.pega.pegarules.internal.bootstrap.PRBootstrapDataSource
[java] 1050: Archive version [0 ]
[java] Mar 14, 2017 4:23:27 AM com.pega.pegarules.internal.bootstrap.PRBootstrap
[java] 1050: Engine schema defined in allclasses: null
[java] Mar 14, 2017 4:23:27 AM com.pega.pegarules.internal.bootstrap.SettingReaderJNDI
[java] INFO: Could not find java:comp/env/prconfig/ in the local JNDI context, skipping prconfig setting lookup
[java] Mar 14, 2017 4:23:27 AM com.pega.pegarules.internal.bootstrap.SettingReaderJNDI
[java] INFO: Could not find prconfig in the local JNDI context, skipping prconfig setting lookup
[java] Mar 14, 2017 4:23:27 AM com.pega.pegarules.internal.bootstrap.PRBootstrap
[java] 1050: Engine classes schema: null
[java] Mar 14, 2017 4:23:27 AM com.pega.pegarules.internal.bootstrap.PRBootstrap
[java] 1050: Assembled classes schema: null
[java] Mar 14, 2017 4:23:27 AM com.pega.pegarules.internal.bootstrap.PRBootstrap
[java] 1050:
[java] Mar 14, 2017 4:23:27 AM com.pega.pegarules.internal.bootstrap.PRBootstrap
[java] 1050: *=================================================================*
[java] Mar 14, 2017 4:23:27 AM com.pega.pegarules.internal.bootstrap.PRBootstrap
[java] 1050: prbootstrap.properties entry "initialization.settingsource=file"; note that
[java] Mar 14, 2017 4:23:27 AM com.pega.pegarules.internal.bootstrap.PRBootstrap
[java] 1050: this excludes use of entries in Data-Admin-System-Settings as prbootstrap settings
[java] Mar 14, 2017 4:23:27 AM com.pega.pegarules.internal.bootstrap.PRBootstrap
[java] 1050: *=================================================================*
[java]
[java] Mar 14, 2017 4:23:27 AM com.pega.pegarules.internal.bootstrap.PRMiniLoader
[java] 1050: Will load phase 2 bootstrap from Pega-EngineCode:07-10-27
[java] Mar 14, 2017 4:23:27 AM com.pega.pegarules.internal.bootstrap.PRMiniLoader
[java] 1050: PRMiniLoader - unable to load classes from the database: Cannot load JDBC driver class 'oracle.jdbc.OracleDriver'
[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)
[java] at com.pega.pegarules.configdbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:520)
[java] at com.pega.pegarules.internal.bootstrap.PRBootstrap.printConfiguration(PRBootstrap.java:772)
[java] at com.pega.pegarules.internal.bootstrap.PRBootstrap.checkForStartup(PRBootstrap.java:665)
[java] at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropagatingThrowable(PRBootstrap.java:408)
[java] /app/gems/Pega722/TEMP/PegaInstallTemp-14-March-2017-02.56.31/load/WEB-INF/lib/boot/prbootphase2.jar (No such file or directory)
[java] Perhaps executing with a non-standard classpath (e.g. JUnit tests)?
[java] at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethodPropagatingThrowable(AppServerBridgeToPega.java:224)
[java] at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethod(AppServerBridgeToPega.java:273)
[java] at com.pega.pegarules.pub.PegaRULES.main(PegaRULES.java:85)
[java] Caused by: java.lang.ClassNotFoundException: oracle.jdbc.OracleDriver
[java] at java.net.URLClassLoader$1.run(Unknown Source)
[java] at java.net.URLClassLoader$1.run(Unknown Source)
[java] at java.security.AccessController.doPrivileged(Native Method)
[java] at java.net.URLClassLoader.findClass(Unknown Source)
[java] at java.lang.ClassLoader.loadClass(Unknown Source)
[java] at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
[java] at java.lang.ClassLoader.loadClass(Unknown Source)
[java] at java.lang.Class.forName0(Native Method)
[java] at java.lang.Class.forName(Unknown Source)
[java] at com.pega.pegarules.configdbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:737)
[java] ... 7 more
Could you please have a look on this and suggest us something to resolve the issue.
Thanks,
Aruldevan
Pegasystems Inc.
IN
you have to set bypass.pega.schema=true only if you have generated the ddl and applied it manually. Otherwise this will lead to inconsistance.
By looking at the errors ojdcb.jar file is not gettng loaded properly.
Could you please check the following.
1) Make sure you are using correct version of ojdbc.jar file
2) You should not have multiple ojdbc.jar files in the path
3) ojdc.jar file should have full permisions for the app server user
Ff everything is fine. Could you please try the following command to make sure that you have the proper connection details and it is able to generate the DDL.
generateddl.sh --upgradedataonly true
Virtusa
IN
Hi Dhevendra,
Thanks fro you reply.
we have given appropriate privilages to the ojdbc jar (755) for the user and we have given "bypass.pega.schema" and "bypass.udf.generation" as blank.
While executing the "./update.sh --dataOnly true" command, we are getting the below error.
Apply UDFs:
Apply UDFs Inner:
Hi Dhevendra,
Thanks fro you reply.
we have given appropriate privilages to the ojdbc jar (755) for the user and we have given "bypass.pega.schema" and "bypass.udf.generation" as blank.
While executing the "./update.sh --dataOnly true" command, we are getting the below error.
Apply UDFs:
Apply UDFs Inner:
Load UDF:
[pega:executesqlintransaction] Execute SQL In Transaction:false
[mkdir] Created dir: /app/gems/Pega722/TEMP/PegaInstallTemp-15-March-2017-03.31.07/udf_temp
[copy] Copying 6 files to /app/gems/Pega722/TEMP/PegaInstallTemp-15-March-2017-03.31.07/udf_temp
[echo] arg values : --config=/app/gems/Pega722/TEMP/PegaInstallTemp-15-March-2017-03.31.07/prbootstrap.properties --profile=install.oracledate --dataOnly=true --run-in-transaction=false --jar-path=/app/gems/Pega722/115289_P722UPD_Extract/scripts/../archives/udf/prreadstream.jar /app/gems/Pega722/TEMP/PegaInstallTemp-15-March-2017-03.31.07/udf_temp
[java] 2017-03-15 05:07:17,303 ( UDFManager) INFO - AutoCommit set to true. Executing with out transaction
[java] 2017-03-15 05:07:17,316 ( OracleUDFJarLoader) INFO - Loading UDF jar on Oracle DB
[java] 2017-03-15 05:07:17,318 ( OracleUDFJarLoader) INFO - Getting the jar file from /app/gems/Pega722/115289_P722UPD_Extract/scripts/../archives/udf/prreadstream.jar
[java] 2017-03-15 05:07:17,320 ( OracleUDFJarLoader) INFO - Adding com/pega/pegarules/data/udf/directstreamreader/CachedDirectStream.class to the list for addition to the table.
[java] 2017-03-15 05:07:17,321 ( OracleUDFJarLoader) INFO - Adding com/pega/pegarules/data/udf/directstreamreader/DirectStreamReaderDB2LUW.class to the list for addition to the table.
[java] 2017-03-15 05:07:17,322 ( OracleUDFJarLoader) INFO - Adding com/pega/pegarules/data/udf/directstreamreader/DirectStreamReader.class to the list for addition to the table.
[java] 2017-03-15 05:07:17,324 ( OracleUDFJarLoader) INFO - Adding com/pega/pegarules/data/udf/directstreamreader/DirectStreamReaderDB2ZOS.class to the list for addition to the table.
[java] 2017-03-15 05:07:17,325 ( OracleUDFJarLoader) INFO - Adding com/pega/pegarules/data/udf/directstreamreader/BasicEnvironmentAdapter.class to the list for addition to the table.
[java] 2017-03-15 05:07:17,327 ( OracleUDFJarLoader) INFO - Adding com/pega/pegarules/data/udf/directstreamreader/DirectStreamReaderBase.class to the list for addition to the table.
[java] 2017-03-15 05:07:17,328 ( OracleUDFJarLoader) INFO - Adding com/pega/pegarules/data/udf/directstreamreader/DirectStreamReaderBase$Version6.class to the list for addition to the table.
[java] 2017-03-15 05:07:17,330 ( OracleUDFJarLoader) INFO - Adding com/pega/pegarules/data/udf/directstreamreader/FixedCacheMap.class to the list for addition to the table.
[java] 2017-03-15 05:07:17,331 ( OracleUDFJarLoader) INFO - Adding com/pega/pegarules/data/udf/directstreamreader/UnsupportedFeatureException.class to the list for addition to the table.
[java] 2017-03-15 05:07:17,333 ( OracleUDFJarLoader) INFO - Adding com/pega/pegarules/data/udf/directstreamreader/DirectStreamReaderPostgreSQL.class to the list for addition to the table.
[java] 2017-03-15 05:07:17,334 ( OracleUDFJarLoader) INFO - Adding com/pega/pegarules/data/udf/directstreamreader/DirectStreamReaderBase$Version7.class to the list for addition to the table.
[java] 2017-03-15 05:07:17,336 ( OracleUDFJarLoader) INFO - Adding com/pega/pegarules/data/internal/clipboard/directstream/ByteArrayUtil.class to the list for addition to the table.
[java] 2017-03-15 05:07:17,337 ( OracleUDFJarLoader) INFO - Adding com/pega/pegarules/data/internal/clipboard/directstream/InflaterV7.class to the list for addition to the table.
[java] 2017-03-15 05:07:17,338 ( OracleUDFJarLoader) INFO - Adding com/pega/pegarules/data/internal/clipboard/directstream/DirectStreamV7.class to the list for addition to the table.
[java] 2017-03-15 05:07:17,340 ( OracleUDFJarLoader) INFO - Adding com/pega/pegarules/data/internal/clipboard/directstream/ReferenceString.class to the list for addition to the table.
[java] 2017-03-15 05:07:17,341 ( OracleUDFJarLoader) INFO - Adding com/pega/pegarules/data/internal/clipboard/directstream/BadStreamDataException.class to the list for addition to the table.
[java] 2017-03-15 05:07:17,342 ( OracleUDFJarLoader) INFO - Adding com/pega/pegarules/data/internal/clipboard/directstream/DirectStream.class to the list for addition to the table.
[java] 2017-03-15 05:07:17,344 ( OracleUDFJarLoader) INFO - Adding com/pega/pegarules/data/internal/clipboard/directstream/BadReferenceException.class to the list for addition to the table.
[java] 2017-03-15 05:07:17,345 ( OracleUDFJarLoader) INFO - Adding com/pega/pegarules/data/internal/clipboard/directstream/DirectStreamEnvironmentAdapter.class to the list for addition to the table.
[java] 2017-03-15 05:07:17,347 ( OracleUDFJarLoader) INFO - Adding com/pega/pegarules/data/internal/clipboard/directstream/PropertyReferenceUtilities.class to the list for addition to the table.
[java] 2017-03-15 05:07:17,350 ( ConnectionWrapper) INFO - Attempting to load profile "install.oracledate":
[java] 2017-03-15 05:07:17,352 ( ConnectionWrapper) INFO - Type: oracledate
[java] 2017-03-15 05:07:17,353 ( ConnectionWrapper) INFO - Class: oracle.jdbc.OracleDriver
[java] 2017-03-15 05:07:17,354 ( ConnectionWrapper) INFO - URL: jdbc:oracle:thin:@uklpdufmsa-scan.uk.standardchartered.com:1622/GEMS_UAT.uk.standardchartered.com
[java] 2017-03-15 05:07:17,356 ( ConnectionWrapper) INFO - User: GEMS_UAT_06
[java] 2017-03-15 05:07:17,357 ( ConnectionWrapper) INFO - JDBC Properties: oracle.jdbc.V8Compatible=true
[java] Exception in thread "main" java.lang.IllegalArgumentException: Unable to load class: oracle.jdbc.OracleDriver
[java] at com.pega.pegarules.install.ConnectionWrapper.get(ConnectionWrapper.java:333)
[java] at com.pega.pegarules.install.ConnectionWrapper.createStatement(ConnectionWrapper.java:352)
[java] at com.pega.pegarules.install.udf.loaders.OracleUDFJarLoader.installJarOnOracle(OracleUDFJarLoader.java:124)
[java] at com.pega.pegarules.install.udf.loaders.OracleUDFJarLoader.load(OracleUDFJarLoader.java:73)
[java] at com.pega.pegarules.install.UDFManager$AbstractUDFExecutor.loadUDFJar(UDFManager.java:348)
[java] at com.pega.pegarules.install.UDFManager$ExecuteUDFWithOutTransaction.executeInner(UDFManager.java:293)
[java] at com.pega.pegarules.install.UDFManager$AbstractUDFExecutor.execute(UDFManager.java:357)
[java] at com.pega.pegarules.install.UDFManager.process(UDFManager.java:178)
[java] at com.pega.pegarules.install.UDFManager.main(UDFManager.java:129)
[java] Caused by: java.lang.ClassNotFoundException: oracle.jdbc.OracleDriver
[java] at java.net.URLClassLoader$1.run(Unknown Source)
[java] at java.net.URLClassLoader$1.run(Unknown Source)
[java] at java.security.AccessController.doPrivileged(Native Method)
[java] at java.net.URLClassLoader.findClass(Unknown Source)
[java] at java.lang.ClassLoader.loadClass(Unknown Source)
[java] at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
[java] at java.lang.ClassLoader.loadClass(Unknown Source)
[java] at java.lang.Class.forName0(Native Method)
[java] at java.lang.Class.forName(Unknown Source)
[java] at com.pega.pegarules.install.ConnectionWrapper.get(ConnectionWrapper.java:331)
[java] ... 8 more
could you please suggest us on this.
Thanks.
Pegasystems Inc.
IN
Looks like it is not loading the jar file. Could you please try generating the ddl for the dataonly upgrde by running the following command and let us know the output.
generateddl.sh