Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Rajesh Congola (RajeshC)
CMC Markets
Senior System Architect
CMC Markets
GB
RajeshC Member since 2009 12 posts
CMC Markets
Posted: Dec 2, 2020
Last activity: Aug 7, 2023
Posted: 2 Dec 2020 9:57 EST
Last activity: 7 Aug 2023 10:35 EDT
Closed

Upgrading from 7.3 to 8.5

During tomcat startup after doing the upgrade, it hangs. Oracle db is used, it hangs after message Postgres RDB queries are enabled....see below.

Is kind of intermittent as I was able to start up the server a couple of times but now after every other restart, it hangs.

Show More

During tomcat startup after doing the upgrade, it hangs. Oracle db is used, it hangs after message Postgres RDB queries are enabled....see below.

Is kind of intermittent as I was able to start up the server a couple of times but now after every other restart, it hangs.

2020-12-02 14:41:02,097 [StartUp-TaskExecutor] [          ] [                    ] [                    ] (ary.ClassMapDatabasePageReader) INFO    - Read 13321 class definitions
2020-12-02 14:41:03,346 [StartUp-TaskExecutor] [          ] [                    ] [                    ] (ternal.dictionary.ClassMapImpl) INFO    - ClassMapData is preloaded
2020-12-02 14:41:03,800 [StartUp-TaskExecutor] [          ] [                    ] [                    ] (ternal.dictionary.ClassMapImpl) INFO    - ClassMap initialization completed in 10172 ms
2020-12-02 14:41:03,802 [StartUp-TaskExecutor] [          ] [                    ] [                    ] (  internal.access.DatabaseImpl) INFO    - Database product: Oracle
2020-12-02 14:41:03,802 [StartUp-TaskExecutor] [          ] [                    ] [                    ] (  internal.access.DatabaseImpl) INFO    - Database version: Oracle Database 19c Enterprise Edition Release Proprietary information hidden.0 - Production
2020-12-02 14:41:03,802 [StartUp-TaskExecutor] [          ] [                    ] [                    ] (  internal.access.DatabaseImpl) INFO    - Driver: Oracle JDBC driver
2020-12-02 14:41:03,802 [StartUp-TaskExecutor] [          ] [                    ] [                    ] (  internal.access.DatabaseImpl) INFO    - Driver version: Proprietary information hidden.0
2020-12-02 14:41:03,802 [StartUp-TaskExecutor] [          ] [                    ] [                    ] (  internal.access.DatabaseImpl) INFO    - Version of JDBC supported by driver: 4.2
2020-12-02 14:41:04,003 [StartUp-TaskExecutor] [          ] [                    ] [                    ] (  internal.access.DatabaseImpl) INFO    - This system does not support batch ID generation, using legacy ID generation
2020-12-02 14:41:04,074 [StartUp-TaskExecutor] [          ] [                    ] [                    ] (        internal.access.Lister) INFO    - Fetch size for certain Postgres RDB queries is enabled
 

Show Less
***Edited by Moderator Marissa to update Platform Capability tags****
To see attachments, please log in.
Pega Platform 8.5.1
Data Integration
Updates
Senior System Architect

Posted: 5 years ago
Posted: 3 Dec 2020 7:13 EST
Gowrishankar Ramasamy (GowrishankarR29)
Citicorp Services India Private Limited

Citicorp Services India Private Limited
IN

Hi Rajesh,

       This is strange behavior. Is this application deployed in PostgreSQL database prior to upgrade?, Could you please confirm whether all the post upgrade steps(mandatory and optional) have been completed. Please find below the link on post upgrade steps.

https://community.pega.com/knowledgebase/articles/pega-customer-decision-hub-7x-85-upgrade-guide/85/completing-recommended-post-upgrade-steps

Please let us know if this helps.

To see attachments, please log in.
Posted: 5 years ago
Posted: 3 Dec 2020 9:54 EST
Rajesh Congola (RajeshC)
CMC Markets
Senior System Architect
CMC Markets
GB

Hi Gowri,

Thanks for your response.

Yeah, have done all the steps as per the 8.5 upgrade guides.

It was always on Oracle db. I killed unix processes linked to Pega, Kafka and Cassandra and did a DB cache clear and then a Pega restart and it worked.

Still see this line in the startup logs, so maybe its expected  - "...Fetch size for certain Postgres RDB queries is enabled..."
Sounds a bit strange.

Will keep monitoring as we would expect a consistent restart every time.

 

Thanks,

Rajesh.

To see attachments, please log in.
Posted: 5 years ago
Posted: 10 Dec 2020 9:30 EST
Stefan Clemens (SCLEMENS)
Sopra Steria AG

Sopra Steria AG
CH

Hi all,

I am facing the same issue after upgrading a test system fom 7.2.1 to 8.5.1. Upgrade was done following the steps mentioned in the particular upgrade guide.

The bad news is that I cannot properly reproduce the issue but I am facing different issues...

Clearing the DB cache helped once.

After restarting the entire system, the issue occured again but clearing the DB cache was no more helpful. I had to delete prweb.war and prweb folder, clearing the DB cache and re-deploy the prweb.war.

This procedure did not help at all after restarting the entire system one more time. At the moment, I cannot startup Pega at all but the system always stucks at the mentioned log entry.

Any additional idea or suggestion?

 

Thanks and regards

Stefan

To see attachments, please log in.
Posted: 5 years ago
Updated: 5 years ago
Posted: 10 Dec 2020 9:54 EST
Updated: 10 Dec 2020 9:55 EST
Rajesh Congola (RajeshC)
CMC Markets
Senior System Architect
CMC Markets
GB

Hi Stefan, 

For me the issue goes away after a DB cache clear of Pega tables. However this is not ideal.

I have raised an SR from my side around this which is under investigation. I will post any resolution received to this discussion.

Thanks,

Rajesh.

To see attachments, please log in.
Posted: 5 years ago
Posted: 10 Dec 2020 10:07 EST
Stefan Clemens (SCLEMENS)
Sopra Steria AG

Sopra Steria AG
CH

Hi Rajesh,

thanks for your fast response. So far, I have cleared the overall postgres cache using the following commands (I am working in a CentOS environment):

  • service postgresql-11 stop
  • sync; echo 3 > /proc/sys/vm/drop_caches
  • service postgresql-11 start

Can you please let me know which tables you are refering to and how you cleared the caches in your environment?

 

Thanks a lot!

Stefan

 

To see attachments, please log in.
Posted: 5 years ago
Posted: 10 Dec 2020 10:17 EST
Rajesh Congola (RajeshC)
CMC Markets
Senior System Architect
CMC Markets
GB

Hi Stefan,

We are using oracle and not postgres and hence not sure why that line shows up in the startup logs.

Are you using cloud or on premise and is it split schema for rules and data.

There is a list of tables used by Pega for caching as shown below. 

Take a DB restore point before you attempt it, in case cache clear gives any issue.

truncate table pr_sys_appcache_dep;
truncate table pr_sys_appcache_entry;
truncate table pr_sys_appcache_shortcut;
truncate table pr_sys_cache_dep;
truncate table pr_sys_cache_entry;
truncate table pr_sys_cache_impl;
truncate table pr_assembledclasses;
truncate table pr4_rule_sysgen;
truncate table pr_sys_rule_impl;
TRUNCATE TABLE PR_SYS_APP_HIERARCHY_FLAT;
TRUNCATE TABLE PR_SYS_APP_RULESET_INDEX;
TRUNCATE TABLE PR_SYS_CLASS_ANCESTORS;
TRUNCATE TABLE pr_sys_ruleset_index;
TRUNCATE TABLE pr_sysgen_static_content;

truncate table pega.pr_sys_updatescache;
TRUNCATE TABLE pega.pr_sys_statusnodes;
TRUNCATE TABLE pega.pr_sys_locks;
TRUNCATE TABLE pega.prpc_ignite_server_addr;
TRUNCATE TABLE pega.pr_sys_queue_ftsindexer;
 

Thanks,

Rajesh.

To see attachments, please log in.
Posted: 5 years ago
Updated: 5 years ago
Posted: 11 Dec 2020 1:04 EST
Updated: 11 Dec 2020 1:18 EST
Stefan Clemens (SCLEMENS)
Sopra Steria AG

Sopra Steria AG
CH

Hi Rajesh,

thank you so much!

 

I decided to

  • clear the caches according to the procedure I mentioned above
  • truncate the tables that you mentioned
  • un- and redeploy prwew
  • stopped the applicaction server
  • deleted prweb.war from <TomcatHome>/webapps
  • retarted the entire vm

and it is working perfectly fine now so I dont have to clear the caches any more (I did 3 restarts for testing purposes).

Thank you very much for your support! I keep my fingers crossed that your issue will be resolved soon as well!

 

Cheers!
Stefan

To see attachments, please log in.
Posted: 5 years ago
Posted: 14 Dec 2020 1:23 EST
Stefan Clemens (SCLEMENS)
Sopra Steria AG

Sopra Steria AG
CH

Hi Rajesh,

I fear that i have rejoiced too soon, the issue appeared again...

Could you please do me a favor and share your insights when your SR will get resolved? Thank you very much!

 

Cheers,

Stefan

To see attachments, please log in.
Posted: 5 years ago
Updated: 5 years ago
Posted: 14 Dec 2020 5:31 EST
Updated: 14 Dec 2020 5:36 EST
Rajesh Congola (RajeshC)
CMC Markets
Senior System Architect
CMC Markets
GB

Hi Stefan, 

In a way good to know that you are also facing the same issue even with your configuration.

I would suggest for you to raise an SR, that way there is a record of the issue and gives visibility for a fix to test with different configuration.

Let me know once you have raised an SR and I can link the same.

Will let you know once I have an update for my SR.

Thanks,

Rajesh.

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice