Question
Huntington Bancshares Inc
US
Last activity: 10 Jun 2016 11:59 EDT
unable start prpc engine
unable start prpc engine after jdbc url is changed in context,xml file.
Below is the error
============ PegaRULES Bootstrap Configuration ============
Date: Wed Jun 08 14:46:35 EDT 2016
Java Version: Sun Microsystems Inc. 1.6.0_45
Configuration: file:/opt/apps/asa/tomcat-instances/prpcmna/webapps/prweb/WEB-INF/classes/prbootstrap.properties
Pega-EngineCode: <none specified>
JNDI Reference: java:comp/env/jdbc/PegaRULES
Database: Oracle Oracle Database 12c Enterprise Edition Release Proprietary information hidden.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
Driver: Oracle JDBC driver Proprietary information hidden.0
Unable to use given database configuration
Unable to locate classes on filesystem
=============== End Bootstrap Configuration ===============
Unable to load phase 2 bootstrap class: com.pega.pegarules.internal.bootstrap.phase2.PRBootstrapImpl
Jun 8, 2016 2:46:35 PM com.pega.pegarules.internal.bootstrap.PRBootstrap
SEVERE: Error initializing PRAppLoader
Accepted Solution
Huntington Bancshares Inc
US
After refreshing the new database with another test environment's database, the connection was successful.
Thanks!
Pegasystems Inc.
US
Can you post the full log file? I expect there should be a reason why the database connection is not completing successfully with your updated url.
Huntington Bancshares Inc
US
============ PegaRULES Bootstrap Configuration ============
Date: Wed Jun 08 14:46:35 EDT 2016
Java Version: Sun Microsystems Inc. 1.6.0_45
Configuration: file:/opt/apps/asa/tomcat-instances/prpcmna/webapps/prweb/WEB-INF/classes/prbootstrap.properties
Pega-EngineCode: <none specified>
JNDI Reference: java:comp/env/jdbc/PegaRULES
Database: Oracle Oracle Database 12c Enterprise Edition Release Proprietary information hidden.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
Driver: Oracle JDBC driver Proprietary information hidden.0
Unable to use given database configuration
Unable to locate classes on filesystem
=============== End Bootstrap Configuration ===============
Unable to load phase 2 bootstrap class: com.pega.pegarules.internal.bootstrap.phase2.PRBootstrapImpl
Jun 8, 2016 2:46:35 PM com.pega.pegarules.internal.bootstrap.PRBootstrap
SEVERE: Error initializing PRAppLoader
java.lang.ClassNotFoundException: com.pega.pegarules.internal.bootstrap.phase2.PRBootstrapImpl
at com.pega.pegarules.internal.bootstrap.PRMiniLoader.loadClass(PRMiniLoader.java:365)
at java.lang.ClassLoader.loadClass(ClassLoader.java:247)
at com.pega.pegarules.internal.bootstrap.PRBootstrap.checkForStartup(PRBootstrap.java:589)
============ PegaRULES Bootstrap Configuration ============
Date: Wed Jun 08 14:46:35 EDT 2016
Java Version: Sun Microsystems Inc. 1.6.0_45
Configuration: file:/opt/apps/asa/tomcat-instances/prpcmna/webapps/prweb/WEB-INF/classes/prbootstrap.properties
Pega-EngineCode: <none specified>
JNDI Reference: java:comp/env/jdbc/PegaRULES
Database: Oracle Oracle Database 12c Enterprise Edition Release Proprietary information hidden.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
Driver: Oracle JDBC driver Proprietary information hidden.0
Unable to use given database configuration
Unable to locate classes on filesystem
=============== End Bootstrap Configuration ===============
Unable to load phase 2 bootstrap class: com.pega.pegarules.internal.bootstrap.phase2.PRBootstrapImpl
Jun 8, 2016 2:46:35 PM com.pega.pegarules.internal.bootstrap.PRBootstrap
SEVERE: Error initializing PRAppLoader
java.lang.ClassNotFoundException: com.pega.pegarules.internal.bootstrap.phase2.PRBootstrapImpl
at com.pega.pegarules.internal.bootstrap.PRMiniLoader.loadClass(PRMiniLoader.java:365)
at java.lang.ClassLoader.loadClass(ClassLoader.java:247)
at com.pega.pegarules.internal.bootstrap.PRBootstrap.checkForStartup(PRBootstrap.java:589)
at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropagatingThrowable(PRBootstrap.java:387)
at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBootstrap.java:439)
at com.pega.pegarules.internal.web.servlet.WebAppLifeCycleListenerBoot.contextInitialized(WebAppLifeCycleListenerBoot.java:83)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5017)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5531)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:652)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:677)
at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1912)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:439)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
at java.lang.Thread.run(Thread.java:662)
Jun 8, 2016 2:46:35 PM com.pega.pegarules.internal.bootstrap.PRBootstrap
SEVERE: Problem during method invocation (contextInitialized)
java.lang.RuntimeException: PRAppLoader was not properly initialized, unable to load class com.pega.pegarules.web.servlet.WebAppLifeCycleListener
at com.pega.pegarules.internal.bootstrap.PRBootstrap.getImplementationOf(PRBootstrap.java:213)
at com.pega.pegarules.internal.bootstrap.PRBootstrap.getEntry(PRBootstrap.java:303)
at com.pega.pegarules.internal.bootstrap.PRBootstrap.getMethod(PRBootstrap.java:283)
at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropagatingThrowable(PRBootstrap.java:388)
at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBootstrap.java:439)
at com.pega.pegarules.internal.web.servlet.WebAppLifeCycleListenerBoot.contextInitialized(WebAppLifeCycleListenerBoot.java:83)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5017)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5531)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:652)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:677)
at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1912)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:439)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
at java.lang.Thread.run(Thread.java:662)
Jun 8, 2016 2:46:35 PM org.apache.catalina.core.StandardContext startInternal
SEVERE: One or more listeners failed to start. Full details will be found in the appropriate container log file
Jun 8, 2016 2:46:35 PM org.apache.catalina.core.StandardContext startInternal
SEVERE: Context [/prweb] startup failed due to previous errors
Jun 8, 2016 2:46:35 PM com.pega.pegarules.internal.bootstrap.PRBootstrap
19830421: prbootstrap.properties merged with prbootstrap entries in Data-Admin-System-Settings
Jun 8, 2016 2:46:35 PM com.pega.pegarules.internal.bootstrap.PRMiniLoader
19830421: Classes will NOT be loaded from the database; no version specified for Pega-EngineCode.
Jun 8, 2016 2:46:35 PM com.pega.pegarules.internal.bootstrap.PRBootstrap
19830421:
============ PegaRULES Bootstrap Configuration ============
Date: Wed Jun 08 14:46:35 EDT 2016
Java Version: Sun Microsystems Inc. 1.6.0_45
Configuration: file:/opt/apps/asa/tomcat-instances/prpcmna/webapps/prweb/WEB-INF/classes/prbootstrap.properties
Pega-EngineCode: <none specified>
JNDI Reference: java:comp/env/jdbc/PegaRULES
Database: Oracle Oracle Database 12c Enterprise Edition Release Proprietary information hidden.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
Driver: Oracle JDBC driver Proprietary information hidden.0
Unable to use given database configuration
Unable to locate classes on filesystem
=============== End Bootstrap Configuration ===============
Unable to load phase 2 bootstrap class: com.pega.pegarules.internal.bootstrap.phase2.PRBootstrapImpl
Jun 8, 2016 2:46:35 PM com.pega.pegarules.internal.bootstrap.PRBootstrap
SEVERE: Error initializing PRAppLoader
Huntington Bancshares Inc
US
Jun 8, 2016 2:46:33 PM org.apache.catalina.startup.TldConfig execute
INFO: At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
SMA: Using configuration file: /opt/apps/asa/tomcat-instances/prpcmna/work/Catalina/localhost/prsysmgmt/Nodes.xml
Jun 8, 2016 2:46:34 PM org.apache.struts.util.PropertyMessageResources <init>
INFO: Initializing, config='org.apache.struts.util.LocalStrings', returnNull=true
Jun 8, 2016 2:46:34 PM org.apache.struts.util.PropertyMessageResources <init>
INFO: Initializing, config='org.apache.struts.action.ActionResources', returnNull=true
Jun 8, 2016 2:46:34 PM org.apache.struts.util.PropertyMessageResources <init>
INFO: Initializing, config='ApplicationResources', returnNull=true
Jun 8, 2016 2:46:34 PM org.apache.catalina.startup.HostConfig deployDescriptor
INFO: Deployment of configuration descriptor /opt/apps/asa/tomcat-instances/prpcmna/conf/Catalina/localhost/prsysmgmt.xml has finished in 1,932 ms
Jun 8, 2016 2:46:34 PM org.apache.catalina.startup.HostConfig deployDescriptor
INFO: Deploying configuration descriptor /opt/apps/asa/tomcat-instances/prpcmna/conf/Catalina/localhost/prweb.xml
Jun 8, 2016 2:46:34 PM org.apache.catalina.startup.HostConfig deployDescriptor
Jun 8, 2016 2:46:33 PM org.apache.catalina.startup.TldConfig execute
INFO: At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
SMA: Using configuration file: /opt/apps/asa/tomcat-instances/prpcmna/work/Catalina/localhost/prsysmgmt/Nodes.xml
Jun 8, 2016 2:46:34 PM org.apache.struts.util.PropertyMessageResources <init>
INFO: Initializing, config='org.apache.struts.util.LocalStrings', returnNull=true
Jun 8, 2016 2:46:34 PM org.apache.struts.util.PropertyMessageResources <init>
INFO: Initializing, config='org.apache.struts.action.ActionResources', returnNull=true
Jun 8, 2016 2:46:34 PM org.apache.struts.util.PropertyMessageResources <init>
INFO: Initializing, config='ApplicationResources', returnNull=true
Jun 8, 2016 2:46:34 PM org.apache.catalina.startup.HostConfig deployDescriptor
INFO: Deployment of configuration descriptor /opt/apps/asa/tomcat-instances/prpcmna/conf/Catalina/localhost/prsysmgmt.xml has finished in 1,932 ms
Jun 8, 2016 2:46:34 PM org.apache.catalina.startup.HostConfig deployDescriptor
INFO: Deploying configuration descriptor /opt/apps/asa/tomcat-instances/prpcmna/conf/Catalina/localhost/prweb.xml
Jun 8, 2016 2:46:34 PM org.apache.catalina.startup.HostConfig deployDescriptor
WARNING: A docBase /opt/apps/asa/tomcat-instances/prpcmna/webapps/prweb.war inside the host appBase has been specified, and will be ignored
Jun 8, 2016 2:46:35 PM org.apache.catalina.startup.TldConfig execute
INFO: At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
Jun 8, 2016 2:46:35 PM com.pega.pegarules.internal.bootstrap.PRBootstrapDataSource
19830421: Loading bootstrap properties from /prbootstrap.properties
Jun 8, 2016 2:46:35 PM com.pega.pegarules.internal.bootstrap.PRBootstrap
19830421: prbootstrap.properties merged with prbootstrap entries in Data-Admin-System-Settings
Jun 8, 2016 2:46:35 PM com.pega.pegarules.internal.bootstrap.PRMiniLoader
19830421: Classes will NOT be loaded from the database; no version specified for Pega-EngineCode.
Jun 8, 2016 2:46:35 PM com.pega.pegarules.internal.bootstrap.PRBootstrap
19830421:
============ PegaRULES Bootstrap Configuration ============
Date: Wed Jun 08 14:46:35 EDT 2016
Java Version: Sun Microsystems Inc. 1.6.0_45
Configuration: file:/opt/apps/asa/tomcat-instances/prpcmna/webapps/prweb/WEB-INF/classes/prbootstrap.properties
Pega-EngineCode: <none specified>
JNDI Reference: java:comp/env/jdbc/PegaRULES
Database: Oracle Oracle Database 12c Enterprise Edition Release Proprietary information hidden.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
Driver: Oracle JDBC driver Proprietary information hidden.0
Unable to use given database configuration
Unable to locate classes on filesystem
=============== End Bootstrap Configuration ===============
Unable to load phase 2 bootstrap class: com.pega.pegarules.internal.bootstrap.phase2.PRBootstrapImpl
Jun 8, 2016 2:46:35 PM com.pega.pegarules.internal.bootstrap.PRBootstrap
SEVERE: Error initializing PRAppLoader
java.lang.ClassNotFoundException: com.pega.pegarules.internal.bootstrap.phase2.PRBootstrapImpl
at com.pega.pegarules.internal.bootstrap.PRMiniLoader.loadClass(PRMiniLoader.java:365)
at java.lang.ClassLoader.loadClass(ClassLoader.java:247)
at com.pega.pegarules.internal.bootstrap.PRBootstrap.checkForStartup(PRBootstrap.java:589)
at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropagatingThrowable(PRBootstrap.java:387)
at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBootstrap.java:439)
at com.pega.pegarules.internal.web.servlet.WebAppLifeCycleListenerBoot.contextInitialized(WebAppLifeCycleListenerBoot.java:83)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5017)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5531)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:652)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:677)
at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1912)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:439)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
at java.lang.Thread.run(Thread.java:662)
Jun 8, 2016 2:46:35 PM com.pega.pegarules.internal.bootstrap.PRBootstrap
SEVERE: Problem during method invocation (contextInitialized)
java.lang.RuntimeException: PRAppLoader was not properly initialized, unable to load class com.pega.pegarules.web.servlet.WebAppLifeCycleListener
at com.pega.pegarules.internal.bootstrap.PRBootstrap.getImplementationOf(PRBootstrap.java:213)
at com.pega.pegarules.internal.bootstrap.PRBootstrap.getEntry(PRBootstrap.java:303)
at com.pega.pegarules.internal.bootstrap.PRBootstrap.getMethod(PRBootstrap.java:283)
at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropagatingThrowable(PRBootstrap.java:388)
at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBootstrap.java:439)
at com.pega.pegarules.internal.web.servlet.WebAppLifeCycleListenerBoot.contextInitialized(WebAppLifeCycleListenerBoot.java:83)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5017)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5531)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:652)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:677)
at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1912)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:439)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
at java.lang.Thread.run(Thread.java:662)
Jun 8, 2016 2:46:35 PM org.apache.catalina.core.StandardContext startInternal
SEVERE: One or more listeners failed to start. Full details will be found in the appropriate container log file
Jun 8, 2016 2:46:35 PM org.apache.catalina.core.StandardContext startInternal
SEVERE: Context [/prweb] startup failed due to previous errors
Jun 8, 2016 2:46:35 PM com.pega.pegarules.internal.bootstrap.PRBootstrap
19830421: prbootstrap.properties merged with prbootstrap entries in Data-Admin-System-Settings
Jun 8, 2016 2:46:35 PM com.pega.pegarules.internal.bootstrap.PRMiniLoader
19830421: Classes will NOT be loaded from the database; no version specified for Pega-EngineCode.
Jun 8, 2016 2:46:35 PM com.pega.pegarules.internal.bootstrap.PRBootstrap
19830421:
============ PegaRULES Bootstrap Configuration ============
Date: Wed Jun 08 14:46:35 EDT 2016
Java Version: Sun Microsystems Inc. 1.6.0_45
Configuration: file:/opt/apps/asa/tomcat-instances/prpcmna/webapps/prweb/WEB-INF/classes/prbootstrap.properties
Pega-EngineCode: <none specified>
JNDI Reference: java:comp/env/jdbc/PegaRULES
Database: Oracle Oracle Database 12c Enterprise Edition Release Proprietary information hidden.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
Driver: Oracle JDBC driver Proprietary information hidden.0
Unable to use given database configuration
Unable to locate classes on filesystem
=============== End Bootstrap Configuration ===============
Unable to load phase 2 bootstrap class: com.pega.pegarules.internal.bootstrap.phase2.PRBootstrapImpl
Jun 8, 2016 2:46:35 PM com.pega.pegarules.internal.bootstrap.PRBootstrap
SEVERE: Error initializing PRAppLoader
java.lang.ClassNotFoundException: com.pega.pegarules.internal.bootstrap.phase2.PRBootstrapImpl
at com.pega.pegarules.internal.bootstrap.PRMiniLoader.loadClass(PRMiniLoader.java:365)
at java.lang.ClassLoader.loadClass(ClassLoader.java:247)
at com.pega.pegarules.internal.bootstrap.PRBootstrap.checkForStartup(PRBootstrap.java:589)
at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropagatingThrowable(PRBootstrap.java:387)
at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBootstrap.java:439)
at com.pega.pegarules.internal.web.servlet.WebAppLifeCycleListenerBoot.contextDestroyed(WebAppLifeCycleListenerBoot.java:67)
at org.apache.catalina.core.StandardContext.listenerStop(StandardContext.java:5064)
at org.apache.catalina.core.StandardContext.stopInternal(StandardContext.java:5726)
at org.apache.catalina.util.LifecycleBase.stop(LifecycleBase.java:232)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:160)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:652)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:677)
at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1912)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:439)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
at java.lang.Thread.run(Thread.java:662)
Jun 8, 2016 2:46:35 PM com.pega.pegarules.internal.bootstrap.PRBootstrap
SEVERE: Problem during method invocation (contextDestroyed)
java.lang.RuntimeException: PRAppLoader was not properly initialized, unable to load class com.pega.pegarules.web.servlet.WebAppLifeCycleListener
at com.pega.pegarules.internal.bootstrap.PRBootstrap.getImplementationOf(PRBootstrap.java:213)
at com.pega.pegarules.internal.bootstrap.PRBootstrap.getEntry(PRBootstrap.java:303)
at com.pega.pegarules.internal.bootstrap.PRBootstrap.getMethod(PRBootstrap.java:283)
at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropagatingThrowable(PRBootstrap.java:388)
at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBootstrap.java:439)
at com.pega.pegarules.internal.web.servlet.WebAppLifeCycleListenerBoot.contextDestroyed(WebAppLifeCycleListenerBoot.java:67)
at org.apache.catalina.core.StandardContext.listenerStop(StandardContext.java:5064)
at org.apache.catalina.core.StandardContext.stopInternal(StandardContext.java:5726)
at org.apache.catalina.util.LifecycleBase.stop(LifecycleBase.java:232)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:160)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:652)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:677)
at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1912)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:439)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
at java.lang.Thread.run(Thread.java:662)
Jun 8, 2016 2:46:35 PM org.apache.catalina.startup.HostConfig deployDescriptor
Pegasystems Inc.
US
This environment was working previously and all you did was update the url in the context.xml file is that correct?
Using the url and the username/password specified in the context.xml file can you successfully connect to the database using sqlplus or some other tool and run this query:
select distinct pzcodesetversion from pr_engineclasses;
Huntington Bancshares Inc
US
I am unable to use the above query with the new connection. Get the table doesnt exist exception.
Looks like a DB issue. The old DB connection seems fine.
Thanks Celeste!
Huntington Bancshares Inc
US
Hi Celeste,
I am able to query the below query now. However, i am seeing still the same errors. Yes, this environment was working previously and all we did was update the url in the context.xml file
select distinct pzcodesetversion from pr_engineclasses;
Unable to use given database configuration
Unable to locate classes on filesystem
Akash - we were pointing to 12 c previously too
Pegasystems Inc.
US
Using the username from context.xml what is the results of the query when you execute it outside of pega?
Pegasystems Inc.
IN
Was your old URL pointing to a 11g database? If that's true; try updating your oracle driver jars since your new database is a 12c.
Huntington Bancshares Inc
US
Celeste -
The query returned 06-03-10.
this environment was working previously and all we did was update the url in the context.xml file. Is there any other config changes that we need to make other than context.xml file?
Pegasystems Inc.
US
Please post the updated url. Why did you change it? Is this a different database that you are pointing to? It seems like it cannot connect to the database but there isn't any error in the logs you posted previously indicating what the issue is. I'm wondering, if this is a different database server that you are trying to connect to, if there is an issue connecting to that from this app server node. Maybe there is a firewall and the needed ports are not open? Do you have a 3rd party tool on this app server node that you can try to connect to the database using? Or we could write a simple Java program to try the connection using the same oracle JDBC driver.
Huntington Bancshares Inc
US
new url="jdbc:oracle:thin:@maaipega02.hban.us:1521:PRPCMI" - not working
old url="jdbc:oracle:thin:@dvapega.huntington.com:1521:PRPCDVMA" - working
we are creating a new PRPC env and want to use the existing env with new DB connections. Its same oracle database/drivers.
3rd party tool connection from my desktop works w/o issue. There is no 3rd party tool on the server. I was able to do a telnet and test that there is no firewall issue
I was able to get oracle client debugging enabled and it doesn’t seem to throw any errors around the loading of the engine classes.
Pegasystems Inc.
US
Telnet doesn't really prove that there isn't a firewall issue. To make the connection the port of the listener (in your case 1521) needs to be open and also a port for the database server to make the connection back to the client node.
Where did you enable oracle debugging?
If you look in tomcat's logs do you see any error messages?
Huntington Bancshares Inc
US
Enabled oracle client debugging on java arguments.
The errors that I posted above are from catalina.out file of tomcat server.
Is there any other config changes that we need to make other than context.xml file?
Pegasystems Inc.
US
No. If you are just changing the db connection from one 6.3sp1 database to another the only thing that you should need to update on tomcat is the url/username/password in the context.xml. You should clear the pegatemp directory but that doesn't have anything to do with making the database connection.
By oracle debugging are you saying that you ran a jdbc trace? Does the trace show that it is connecting to the database and issuing a query on pr_engineclasses table?
Accepted Solution
Huntington Bancshares Inc
US
After refreshing the new database with another test environment's database, the connection was successful.
Thanks!