May I have assistance with my system failures in the Post Deployment Configuration Portion of the upgrade?
I am not an Expert Pega User. I have been struggling with my Upgrade for the last week and when I finally dumped domain User Ids and Integrated Security I was able to make Progress. I feel that I have followed the two documents I have. 1) the PreUpgrade Assessment and 2) the Pega7.1.8 Upgrade Guide. I will attach as much information as you would care to see. My upgrade says it was successful. The WebSphere work looks correct. I am unable to get the Application to start. It complains in the browser about
PegaRULES Web Application Error
Message: An has occurred processing this request. Please contact your system administrator.
Unable to obtain build properties due to java.lang.reflect.InvocationTargetException: null
and it complains in the WebSphere Logs that
************ Start Display Current Environment ************
WebSphere [IBMJAVA71 Proprietary information hidden cf041446.01]Platform Proprietary information hidden [ND Proprietary information hidden cf041446.03] running with process name PEGA_va10n50735DEVCell01A\PEGA_va10n50736DEVNode01\DEV_PEGA_736 and process id 5932
Host Operating System is Windows, version 6.3
Java version = 1.7.0, Java Runtime Version = pwa6470_27sr2ifx-20141115_01 (SR2+IV66608+IV66375+IV66944 SR2+IV66608+IV66375+IV66944), Java Compiler = j9jit27, Java VM name = IBM J9 VM
I am not an Expert Pega User. I have been struggling with my Upgrade for the last week and when I finally dumped domain User Ids and Integrated Security I was able to make Progress. I feel that I have followed the two documents I have. 1) the PreUpgrade Assessment and 2) the Pega7.1.8 Upgrade Guide. I will attach as much information as you would care to see. My upgrade says it was successful. The WebSphere work looks correct. I am unable to get the Application to start. It complains in the browser about
PegaRULES Web Application Error
Message: An has occurred processing this request. Please contact your system administrator.
Unable to obtain build properties due to java.lang.reflect.InvocationTargetException: null
and it complains in the WebSphere Logs that
************ Start Display Current Environment ************
WebSphere [IBMJAVA71 Proprietary information hidden cf041446.01]Platform Proprietary information hidden [ND Proprietary information hidden cf041446.03] running with process name PEGA_va10n50735DEVCell01A\PEGA_va10n50736DEVNode01\DEV_PEGA_736 and process id 5932
Host Operating System is Windows, version 6.3
Java version = 1.7.0, Java Runtime Version = pwa6470_27sr2ifx-20141115_01 (SR2+IV66608+IV66375+IV66944 SR2+IV66608+IV66375+IV66944), Java Compiler = j9jit27, Java VM name = IBM J9 VM
was.install.root = E:\IBM\WebSphere\AppServer
user.install.root = E:\IBM\WebSphere\AppServer\profiles\dev_pega_mngd_node
Java Home = E:\IBM\WebSphere\AppServer\java_1.7.1_64\jre
ws.ext.dirs = E:\IBM\WebSphere\AppServer/java_1.7.1_64/lib;E:\IBM\WebSphere\AppServer\profiles\dev_pega_mngd_node/classes;E:\IBM\WebSphere\AppServer/classes;E:\IBM\WebSphere\AppServer/lib;E:\IBM\WebSphere\AppServer/installedChannels;E:\IBM\WebSphere\AppServer/lib/ext;E:\IBM\WebSphere\AppServer/web/help;E:\IBM\WebSphere\AppServer/deploytool/itp/plugins/com.ibm.etools.ejbdeploy/runtime
Classpath = E:\IBM\WebSphere\AppServer\profiles\dev_pega_mngd_node/properties;E:\IBM\WebSphere\AppServer/properties;E:\IBM\WebSphere\AppServer/lib/startup.jar;E:\IBM\WebSphere\AppServer/lib/bootstrap.jar;E:\IBM\WebSphere\AppServer/lib/jsf-nls.jar;E:\IBM\WebSphere\AppServer/lib/lmproxy.jar;E:\IBM\WebSphere\AppServer/lib/urlprotocols.jar;E:\IBM\WebSphere\AppServer/deploytool/itp/batchboot.jar;E:\IBM\WebSphere\AppServer/deploytool/itp/batch2.jar;E:\IBM\WebSphere\AppServer/java_1.7.1_64/lib/tools.jar
Java Library path = E:\IBM\WebSphere\AppServer/lib/native/win/x86_64/;E:\IBM\WebSphere\AppServer\java_1.7.1_64\jre\bin\compressedrefs;E:\IBM\WebSphere\AppServer\java_1.7.1_64\jre\bin;C:\Windows\system32;C:\Windows;E:\IBM\WebSphere\AppServer\lib\native\win\x86_64;E:\IBM\WebSphere\AppServer\bin;E:\IBM\WebSphere\AppServer\java_1.7.1_64\bin;E:\IBM\WebSphere\AppServer\java_1.7.1_64\jre\bin;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\IBM\ITM\bin;C:\IBM\ITM\InstallITM;C:\IBM\ITM\TMAITM6;
Orb Version = IBM Java ORB build orb727-20140912.00
************* End Display Current Environment *************
[11/13/15 8:45:21:753 EST] 000000a6 webapp I com.ibm.ws.webcontainer.webapp.WebApp log SRVE0296E: [prpc_j2ee14_ws#prweb.war][/prweb][Servlet.LOG]:.Web Application Error: :.javax.servlet.ServletException: SRVE0207E: Uncaught initialization exception created by servlet
at com.ibm.ws.webcontainer.servlet.ServletWrapper.init(ServletWrapper.java:404)
at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.init(ServletWrapperImpl.java:168)
AND ....
============ PegaRULES Bootstrap Configuration ============
Date: Fri Nov 13 08:53:56 EST 2015
Java Version: IBM Corporation 1.7.0
Configuration: wsjar:file:/E:/IBM/WebSphere/AppServer/profiles/dev_pega_mngd_node/installedApps/PEGA_va10n50735DEVCell01A/prpc_j2ee14_ws.ear/APP-INF/lib/prresources.jar!/prbootstrap.properties
Pega-EngineCode:
Database: Microsoft SQL Server 11.00.5613
Driver: Microsoft JDBC Driver 4.1 for SQL Server 4.1.5605.100
Unable to use given database configuration
Unable to locate classes on filesystem
=============== End Bootstrap Configuration ===============
[11/13/15 8:53:56:345 EST] 000000a6 PRBootstrap E com.pega.pegarules.internal.bootstrap.PRBootstrap Error initializing PRAppLoader
java.lang.ClassNotFoundException: com.pega.pegarules.internal.bootstrap.phase2.PRBootstrapImpl
at com.pega.pegarules.internal.bootstrap.PRMiniLoader.loadClass(PRMiniLoader.java:388)
at java.lang.ClassLoader.loadClass(ClassLoader.java:847)
What part of the process should I redo to determine the Root Cause of this issue?
thanks,
adam
anthem
US
Forgot to add this seemingly significant information
[11/13/15 8:53:56:345 EST] 000000a6 ServletWrappe E com.ibm.ws.webcontainer.servlet.ServletWrapper init Uncaught.init.exception.thrown.by.servlet
[11/13/15 8:53:56:361 EST] 000000a6 PRBootstrap Z com.pega.pegarules.internal.bootstrap.PRBootstrap prbootstrap.properties merged with prbootstrap entries in Data-Admin-System-Settings
[11/13/15 8:53:56:486 EST] 000000a6 PRBootstrap Z com.pega.pegarules.internal.bootstrap.PRBootstrap PRBootstrap.calculateEngineCodeVersionFromDB() - unable to calculate codeset version from database: Invalid object name 'pr_engineclasses'.
[11/13/15 8:53:56:486 EST] 000000a6 PRMiniLoader Z com.pega.pegarules.internal.bootstrap.PRMiniLoader Will load phase 2 bootstrap from Pega-EngineCode:
[11/13/15 8:53:56:486 EST] 000000a6 PRMiniLoader Z com.pega.pegarules.internal.bootstrap.PRMiniLoader PRMiniLoader - unable to load classes from the database: Invalid object name 'pr_engineclasses'.
[11/13/15 8:53:56:486 EST] 000000a6 SystemOut O E:\IBM\WebSphere\AppServer\profiles\dev_pega_mngd_node\installedApps\PEGA_va10n50735DEVCell01A\prpc_j2ee14_ws.ear\APP-INF\lib\boot\prbootphase2.jar (The system cannot find the path specified.)
[11/13/15 8:53:56:486 EST] 000000a6 SystemOut O Perhaps executing with a non-standard classpath (e.g. JUnit tests)?
[11/13/15 8:53:56:501 EST] 000000a6 PRBootstrap Z com.pega.pegarules.internal.bootstrap.PRBootstrap
Pegasystems Inc.
US
most likely your schema names are not defined correctly, as Adi suggested.
unable to calculate codeset version from database: Invalid object name 'pr_engineclasses'.
From the error its clear during engine init it could not find the right PegaRULES JDBC connection, that is why you see:
Unable to use given database configuration Unable to locate classes on filesystem
I would start with looking into JDBC resources for PegaRULES defined on WAS console (Resources > JDBC > JDBC Providers), sometimes slightest of wrongly typed URL can cause this issue. Also check if the JNDI bindings for PegaDATA and PegaRULES are correctly typed.
anthem
US
I'm using the "Microsoft JDBC Driver 4.1 for SQL Server" and unless I use the "URL" custom Property there is no URL that involved. I have tried with and with out that property and I get the same result. When I use the Test Connection button I am able to connect to the DB. I have looked at the JNDI bindings and they seem to be properly configured. I will look at these again. I have the document you mentioned as well. It'll take me a while to reconfirm everything again.
anthem
US
I'm continuing to remove and replace everything related to DB connections. Does this point at the DB?
[11/13/15 13:39:17:943 EST] 0000009b PRBootstrap Z com.pega.pegarules.internal.bootstrap.PRBootstrap prbootstrap.properties merged with prbootstrap entries in Data-Admin-System-Settings
[11/13/15 13:39:17:958 EST] 0000009b PRBootstrap Z com.pega.pegarules.internal.bootstrap.PRBootstrap PRBootstrap.calculateEngineCodeVersionFromDB() - unable to calculate codeset version from database: Invalid object name 'pr_engineclasses'.
[11/13/15 13:39:17:958 EST] 0000009b PRMiniLoader Z com.pega.pegarules.internal.bootstrap.PRMiniLoader Will load phase 2 bootstrap from Pega-EngineCode:
[11/13/15 13:39:17:974 EST] 0000009b PRMiniLoader Z com.pega.pegarules.internal.bootstrap.PRMiniLoader PRMiniLoader - unable to load classes from the database: Invalid object name 'pr_engineclasses'.
[11/13/15 13:39:17:974 EST] 0000009b SystemOut O E:\IBM\WebSphere\AppServer\profiles\dev_pega_mngd_node\installedApps\PEGA_va10n50735DEVCell01A\prpc_j2ee14_ws.ear\APP-INF\lib\boot\prbootphase2.jar (The system cannot find the path specified.)
[11/13/15 13:39:17:974 EST] 0000009b SystemOut O Perhaps executing with a non-standard classpath (e.g. JUnit tests)?
[11/13/15 13:39:17:974 EST] 0000009b PRBootstrap Z com.pega.pegarules.internal.bootstrap.PRBootstrap
anthem
US
I have configured the JDBC connection just as expressed in the document and there is no conversation about a URL. on page 30 and 31 of the 7.1.8 Installation Guide WebSphere MS SQL I am asked to enter the Database information in the provided boxes. The Test Connection of that Data Source works. Are you saying to utilize the Customer URL Custom Properties?
Pegasystems Inc.
US
Within your PegaRULES datasource you should have a url defined in this format.
jdbc:microsoft:sqlserver://server:port;DatabaseName=database
If test connection works that just means that the db user that you have specified in the datasource can connect to the database. Do you have the JNDI bindings for PegaDATA and PegaRULES default schemas specfied correctly? Does the db user actually have the correct permissions to access the tables in the pegarules and pegadata schemas?
As the db user in your datasource log into a 3rd party tool to connect to the database and run this db query, replaceing <RulesSchema> with the actual rules schema name: select distinct pzcodesetversion from <RULESSchema>.pr_engineclasses;
anthem
US
When I run the query I can see the
select distinct pzcodesetversion from dbo.pr_engineclasses;
Msg 208, Level 16, State 1, Line 1
Invalid object name 'dbo.pr_engineclasses'.
select distinct pzcodesetversion from ECSRules.pr_engineclasses;
07-10-17
Pegasystems Inc.
US
From this it looks like your rules schema is ECSRules.
If you look in the install guide there is a section which talks about setting the name space bindings for PegaRULESDefaultSchema and PegaDATADefaultSchema. Please set these to the appropriate schema names.
anthem
US
Here is the Name Space Bindings. I was thinking based on the fact that the SQL statement didn't return a version that perhaps the dbo schema wasn't upgraded properly. I can look into that but I swear I edited the properties files that were given to me by Pega PreAssessment. Would you like to see those?
anthem
US
The other Database I have upgraded is completely missing the pr_engineclasses version. I'm going to ask the DBA to restore the DB unless you have any other suggestions.
Hi Adam,
I can't tell from the screenshots, but is the "name in namespace" path set correctly? One should be PegaRULES and the other is PegaDATA like below.
prconfig/database/databases/PegaRULES/defaultSchema
prconfig/database/databases/PegaDATA/defaultSchema
Pegasystems Inc.
US
As Richard is saying check the rest of the name field that is not visible in the screenshots to make sure they are defined correctly. Also it almost looks like there is a space between ECSR and ules in the screenshot.
Pegasystems Inc.
US
Is ecsrules not your rules schema? The table is in that schema. If you post the upgrade logs we can see what the schema names should be or what went wrong with the upgrade.
Updated: 17 Nov 2015 6:18 EST
Citicorp Services India Private Limited
IN
Hi Adam,
Could you please make sure PegaRULES data source and Namespace binding (split schema configuration) are in the correct scope?. If the issue still persists, could you please create data source (PegaRULES) and Namespace binding (split schema configuration) in the server scope.
Please let me know if this helps.
Thanks,
Gowrishankar.
anthem
US
I redid the conversion on a clean database and I have the same issue. (It's taken quite some time to get that complete)
What scope would you like me to use for the data sources and binding? I am pretty sure I used Cell.
anthem
US
I made the Data Source at the SErver level, recycled nodeagent,JVM and DMgr. Exact same errors.
How can I examine what is in the file below?
Configuration: wsjar:file:/E:/IBM/WebSphere/AppServer/profiles/dev_pega_mngd_node/installedApps/PEGA_va10n50735DEVCell01A/prpc_j2ee14_ws.ear/APP-INF/lib/prresources.jar!/prbootstrap.properties
anthem
US
After changing the scope of the Naming Bindings I have a new error
[11/20/15 10:42:15:108 EST] 000000ba webapp E com.ibm.ws.webcontainer.webapp.WebApp logServletError SRVE0293E: [Servlet Error]-[WebStandard]: com.ibm.ws.webcontainer.webapp.WebAppErrorReport: PegaRULES server not available
at com.ibm.ws.webcontainer.webapp.WebAppDispatcherContext.sendError(WebAppDispatcherContext.java:632)
which is a 503 in the browser
Pegasystems Inc.
US
Your server still does not recognize the schema names defined in the naming binding:
[11/20/15 10:08:01:270 EST] 0000006d PRBootstrap Z com.pega.pegarules.internal.bootstrap.PRBootstrap Engine classes schema: null
[11/20/15 10:08:01:270 EST] 0000006d PRBootstrap Z com.pega.pegarules.internal.bootstrap.PRBootstrap Assembled classes schema: null
Can you double check those settings suggested earlier? Maybe deleting them and recreating (need server restart), I would even enter them manually to avoid certain strange copy/paste invisible characters.
Pegasystems Inc.
IN
Hi adam kennedy
Were you able to open a SR as per Kevin Zheng request? If you were, please let us know the SR so that we can track it for you within this thread.
Thanks!
Pegasystems Inc.
US
Sorry to hear that our system gave you a little trouble. Just as FYI - I've entered a note for the GCS engineer working the SR to cross-reference this discussion for additional context.
Thanks.
B.