Problem during method invocation
Installing Pega 7.2.1 using Tomcat 8 and PostgreSQL 9.3 using Java Version 8
Installing Pega 7.2.1 using Tomcat 8 and PostgreSQL 9.3 using Java Version 8
Getting below error while starting Tomcat
--------------------------------------------------------------------------------------------------------------------
14-Dec-2016 15:50:36.685 INFO [localhost-startStop-1] org.apache.jasper.servlet.TldScanner.scanJars 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.
14-Dec-2016 15:50:37.073 19830421 [localhost-startStop-1] com.pega.pegarules.internal.bootstrap.PRBootstrapDataSource. Loading bootstrap properties from /prbootstrap.properties
14-Dec-2016 15:50:37.077 19830421 [localhost-startStop-1] com.pega.pegarules.internal.bootstrap.SettingReaderJNDI. Could not find java:comp/env/prbootstrap/ in the local JNDI context, skipping prconfig setting lookup
14-Dec-2016 15:50:37.078 19830421 [localhost-startStop-1] com.pega.pegarules.internal.bootstrap.SettingReaderJNDI. Could not find prbootstrap in the local JNDI context, skipping prconfig setting lookup
14-Dec-2016 15:50:37.079 19830421 [localhost-startStop-1] com.pega.pegarules.internal.bootstrap.PRBootstrapDataSource. Bootstrap datatables schema: fieldservice
14-Dec-2016 15:50:37.233 SEVERE [localhost-startStop-1] com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega. Problem during method invocation (contextInitialized)
java.lang.AbstractMethodError: org.postgresql.jdbc3g.Jdbc3gConnection.isValid(I)Z
at org.apache.tomcat.dbcp.dbcp2.DelegatingConnection.isValid(DelegatingConnecti
14-Dec-2016 15:50:37.241 SEVERE [localhost-startStop-1] org.apache.catalina.core.StandardContext.startInternal One or more listeners failed to start. Full details will be found in the appropriate container log file
14-Dec-2016 15:50:37.243 SEVERE [localhost-startStop-1] org.apache.catalina.core.StandardContext.startInternal Context [/prweb] startup failed due to previous errors
14-Dec-2016 15:50:37.248 SEVERE [localhost-startStop-1] com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega. Problem during method invocation (contextDestroyed)
java.lang.NoClassDefFoundError: Could not initialize class com.pega.pegarules.internal.bootstrap.PRBootstrap
----------------------------------------------------------------------------
Attaching server log for more details
***Updated by moderator: Lochan to add Categories***
Accepted Solution
TechMahindra
IN
Used the driver "postgresql-9.4.1212" and added the envrionment details in application server confiugration file which fixed the issue
Pegasystems Inc.
US
Just because the install worked with that driver doesn't mean it will work during runtime, different methods could be in use.
Looking at the PostgreSQL JDBC download page, it looks like JDK 8 may need JDBC 42 drivers. I suggest going there and downloading the latest JDBC 42 driver, removing all other postgres JDBC drivers from the Tomcat lib directory and try with the new driver.
TechMahindra
IN
Now is used the latest JDBC42 driver and i am getting below error duing runtime
------------------------------------------------------------------------------------------------------------
Now is used the latest JDBC42 driver and i am getting below error duing runtime
------------------------------------------------------------------------------------------------------------
ime and JSP compilation time.
19-Dec-2016 10:00:54.535 19830421 [localhost-startStop-1] com.pega.pegarules.internal.bootstrap.PRBootstrapDataSource. Loading bootstrap properties from /prbootstrap.properties
19-Dec-2016 10:00:54.538 19830421 [localhost-startStop-1] com.pega.pegarules.internal.bootstrap.SettingReaderJNDI. Could not find java:comp/env/prbootstrap/ in the local JNDI context, skipping prconfig setting lookup
19-Dec-2016 10:00:54.538 19830421 [localhost-startStop-1] com.pega.pegarules.internal.bootstrap.SettingReaderJNDI. Could not find prbootstrap in the local JNDI context, skipping prconfig setting lookup
19-Dec-2016 10:00:54.538 19830421 [localhost-startStop-1] com.pega.pegarules.internal.bootstrap.SettingReaderJNDI. Could not find java:comp/env/prconfig/ in the local JNDI context, skipping prconfig setting lookup
19-Dec-2016 10:00:54.539 19830421 [localhost-startStop-1] com.pega.pegarules.internal.bootstrap.SettingReaderJNDI. Could not find prconfig in the local JNDI context, skipping prconfig setting lookup
19-Dec-2016 10:00:54.539 19830421 [localhost-startStop-1] com.pega.pegarules.internal.bootstrap.PRBootstrapDataSource. Bootstrap datatables schema: null
19-Dec-2016 10:00:54.707 SEVERE [localhost-startStop-1] com.pega.pegarules.internal.bootstrap.PRBootstrapDataSource. Unable to connect to database. Will only use properties from file.
org.postgresql.util.PSQLException: ERROR: relation "pr_data_admin" does not exist
Position: 34
ESI
US
Hi there, we're encountering similar error with Pega 7.2.1 on Tomcat 8 and Postgres 9.5 using Postgres jdbc driver Proprietary information hidden. Can you provide details of what you meant by "added the envrionment details in application server confiugration file" ? Thanks!
Jul 13, 2017 3:50:17 PM com.pega.pegarules.internal.bootstrap.SettingReaderJNDI 19830421:
Jul 13, 2017 3:50:17 PM com.pega.pegarules.internal.bootstrap.PRBootstrapDataSource 19830421: Bootstrap datatables schema: null
Jul 13, 2017 3:50:17 PM com.pega.pegarules.internal.bootstrap.PRBootstrapDataSource
SEVERE: Unable to connect to database. Will only use properties from file.
org.postgresql.util.PSQLException: ERROR: relation "pr_data_admin" does not exist
Position: 34
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2476)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2189)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:300)
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:428)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:354)
...