Hi All,

Initially we have configured everything in our SIT environment after few months database server decommissioned but application server(Weblogic) is there.

Later we have new database serverand we created new database(Oracle) and installed pega again and changed the JNDI(database) connections at weblogic server side and restarted the application server.

But once we access the pega url we are getting PegaRULES server not available.

We have given PRPC_RULES_USR and PRPC_DATA-USR as schema names.

Please find the log and help me out.

<Nov 22, 2016 9:53:38 AM AST> <Emergency> <com.pega.pegarules.internal.bootstrap.PRBootstrapDataSource> <BEA-000000> <Loading bootstrap properties from /prbootstrap.properties>
<Nov 22, 2016 9:53:38 AM AST> <Emergency> <com.pega.pegarules.internal.bootstrap.SettingReaderJNDI> <BEA-000000> <Could not find java:comp/env/prbootstrap/ in the local JNDI context, skipping prconfig setting lookup>
<Nov 22, 2016 9:53:38 AM AST> <Emergency> <com.pega.pegarules.internal.bootstrap.SettingReaderJNDI> <BEA-000000> <Could not find prbootstrap in the local JNDI context, skipping prconfig setting lookup>
<Nov 22, 2016 9:53:38 AM AST> <Emergency> <com.pega.pegarules.internal.bootstrap.SettingReaderJNDI> <BEA-000000> <>
<Nov 22, 2016 9:53:38 AM AST> <Emergency> <com.pega.pegarules.internal.bootstrap.SettingReaderJNDI> <BEA-000000> <>
<Nov 22, 2016 9:53:38 AM AST> <Emergency> <com.pega.pegarules.internal.bootstrap.PRBootstrapDataSource> <BEA-000000> <Bootstrap datatables schema: PRPC_DATA_USR>
<Nov 22, 2016 9:53:38 AM AST> <Error> <com.pega.pegarules.internal.bootstrap.PRBootstrapDataSource> <BEA-000000> <Unable to connect to database.  Will only use properties from file.
java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
        at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059)
        at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522)
        at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257)
        Truncated. see log file for complete stacktrace
>
<Nov 22, 2016 9:53:38 AM AST> <Emergency> <com.pega.pegarules.internal.bootstrap.PRBootstrap> <BEA-000000> <Engine schema defined in allclasses: null>
<Nov 22, 2016 9:53:38 AM AST> <Emergency> <com.pega.pegarules.internal.bootstrap.SettingReaderJNDI> <BEA-000000> <>
<Nov 22, 2016 9:53:38 AM AST> <Emergency> <com.pega.pegarules.internal.bootstrap.SettingReaderJNDI> <BEA-000000> <>
<Nov 22, 2016 9:53:38 AM AST> <Emergency> <com.pega.pegarules.internal.bootstrap.PRBootstrap> <BEA-000000> <Engine classes schema: PRPC_RULES_USR>
<Nov 22, 2016 9:53:38 AM AST> <Emergency> <com.pega.pegarules.internal.bootstrap.PRBootstrap> <BEA-000000> <Assembled classes schema: PRPC_RULES_USR>
<Nov 22, 2016 9:53:38 AM AST> <Emergency> <com.pega.pegarules.internal.bootstrap.PRBootstrap> <BEA-000000> <prbootstrap.properties merged with prbootstrap entries in Data-Admin-System-Settings>
<Nov 22, 2016 9:53:38 AM AST> <Emergency> <com.pega.pegarules.internal.bootstrap.PRBootstrap> <BEA-000000> <Using latest detected engine version:(EngineCodeSetVersion= 07-10-15). To specify a different version, use the setting com.pega.pegarules.bootstrap.codeset.version.Pega-EngineCode in prbootstrap.properties.>
<Nov 22, 2016 9:53:38 AM AST> <Emergency> <com.pega.pegarules.internal.bootstrap.PRMiniLoader> <BEA-000000> <Will load phase 2 bootstrap from Pega-EngineCode:07-10-15>
<Nov 22, 2016 9:53:44 AM AST> <Emergency> <com.pega.pegarules.internal.bootstrap.phase2.PRBootstrapImpl> <BEA-000000> <PegaRULES signed jar files will be extracted to: /tmp/extractedFiles>
<Nov 22, 2016 9:53:44 AM AST> <Emergency> <com.pega.pegarules.internal.bootstrap.phase2.PRBootstrapImpl> <BEA-000000> <PegaRULES classes will be loaded from the database>
<Nov 22, 2016 9:53:44 AM AST> <Emergency> <com.pega.pegarules.internal.bootstrap.PRBootstrap> <BEA-000000> <
============ PegaRULES Bootstrap Configuration ============
           Date: Tue Nov 22 09:53:44 AST 2016
   Java Version: Oracle Corporation 1.7.0_45
  Configuration: zip:/app/pega/weblogic/user_projects/domains/pegaINT/servers/saryptintapp_ms/tmp/_WL_user/prpc_wls_jee4/92iz3k/APP-INF/lib/prresources.jar!/prbootstrap.properties
Pega-EngineCode: 07-10-15
    ASM Version: -1239066975
       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
Active CodeSets: pega-enginecode:07-10-15 at (latest patch)

***Updated by moderator: Lochan to add Categories***