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

 Srinivas Bharat Komarina (KOMARINA)
Accenture
Senior System Architect
Accenture
GB
KOMARINA Member since 2012 184 posts
Accenture
Posted: Feb 10, 2022
Last activity: Aug 7, 2023
Posted: 10 Feb 2022 11:36 EST
Last activity: 7 Aug 2023 10:33 EDT
Closed
Solved

Pega Upgrade 8.3.x to 8.7 - Issue on starting the application

Hi,

Greetings. Hope you are doing well! 

We are in the midst of upgrading Pega 8.3.x to 8.7, we are doing in-place update via command line to bypass UDFs, this activity itself did not return any errors but whilst prweb is getting redeployed, on startup, i see the below error

Show More

Hi,

Greetings. Hope you are doing well! 

We are in the midst of upgrading Pega 8.3.x to 8.7, we are doing in-place update via command line to bypass UDFs, this activity itself did not return any errors but whilst prweb is getting redeployed, on startup, i see the below error

2022-02-10 11:18:06,216 [ERVICESMAPPING_CACHE] [  STANDARD] [                    ] [                    ] (   external.async.IStartupTask) ERROR   - Error in the execution of Startup Task: [com.pega.pegarules.session.internal.async.startup.AppAliasToAuthServiceMappingCacheStartupTask] com.pega.pegarules.pub.PRRuntimeException: Exception in fetching list of auth service names mapped to app aliases     at com.pega.platform.web.application.authentication.AppAliasToAuthServiceMappingCacheLoader.executeListSpecification(AppAliasToAuthServiceMappingCacheLoader.java:81) ~[web.jar:?]     at com.pega.platform.web.application.authentication.AppAliasToAuthServiceMappingCacheLoader.fetchAuthServicesForAppAliasesFromDB(AppAliasToAuthServiceMappingCacheLoader.java:70) ~[web.jar:?]     at com.pega.platform.web.application.authentication.AppAliasToAuthServiceMappingCacheImpl.loadAppAliasToAuthServiceMappingCache(AppAliasToAuthServiceMappingCacheImpl.java:63) ~[web.jar:?]     at com.pega.pegarules.session.internal.async.startup.AppAliasToAuthServiceMappingCacheStartupTask.runTask(AppAliasToAuthServiceMappingCacheStartupTask.java:40) ~[prprivate-session.jar:?]     at com.pega.pegarules.session.internal.async.startup.StartupTask$1.run(StartupTask.java:55) ~[prprivate-session.jar:?]     at com.pega.pegarules.session.internal.PRSessionProviderImpl.performTargetActionWithLock(PRSessionProviderImpl.java:1381) ~[prprivate-session.jar:?]     at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:1124) ~[prprivate-session.jar:?]     at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:931) ~[prprivate-session.jar:?]     at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:897) ~[prprivate-session.jar:?]     at com.pega.pegarules.session.internal.async.startup.StartupTask.run(StartupTask.java:48) ~[prprivate-session.jar:?]     at java.lang.Thread.run(Thread.java:748) [?:1.8.0_282] Caused by: com.pega.pegarules.pub.database.DatabaseException: Database-General    There was a problem getting a list    0    42501    ERROR: permission denied for table pr_data_appalias_authservice DatabaseException caused by prior exception: org.postgresql.util.PSQLException: ERROR: permission denied for table pr_data_appalias_authservice

I have re-executed GRANT on the table again but still the exception is generated for the same reason.

With the same user that the application server has been set-up, logged into pgadmin and was able to query the table (though the table is empty, but did not threw any error w.r.t. permissions)

Anyone have any similar issues previously, please let me know if there is something that i missed.

Regards,

Bharat

 

Show Less
***Edited by Moderator: Pooja Gadige to change category from Product to Update***
To see attachments, please log in.
Pega Platform 8.7
Updates
Government
Senior System Architect

Accepted Solution

Posted: 2 years ago
Updated: 2 years ago
Posted: 15 Feb 2022 7:33 EST
Updated: 17 Feb 2022 3:32 EST
Sushant Samuel (SushantSamuel)
PEGA
Lead Service Assurance Advisor, Cloud Migrations
Pegasystems Inc.
IN

Hi @KOMARINA

Could you confirm if all the privileges has been granted to baseuser as described in configuring PostgreSQL user permissions in the update guide.

https://community.pega.com/media/pega-platform-87-major-update-guide-apache-tomcat-and-postgresql

Thanks,

To see attachments, please log in.
Posted: 2 years ago
Posted: 29 May 2022 15:00 EDT
Sujeet Kumar (SPSUJITMCA)
Boubyan Bank
Lead System Architect
Boubyan Bank
KW

@SushantSamuel   and @PegaTeam

I have upgraded Pega 8.3.1 to 8.7.1 but by restarting JBoss getting same issue ,even we have given full grant to pegaadmin and pegabase users.

Let me know if we can get any help OR mining full suggestion as per below mention details form Pega upgrade team because its look like blocker for us. 

Environment details :--->

Pega current version : 8.3.1 

Pega upgraded version : 8.7.1

App server : Jboss 7.4.1

Database : Postgres

 

Upgrade (In place ) script execution step :-->

1. setupDatabase.property file update for rule and data schema 2. generateddl.sh 3. generateudf.sh 4. upgrate.sh --ruleOnly true 5. upgrade.sh --dataonly true

Note : mighrate.sh --> not done because we had perform in place upgrade

Major changes in table

 

live DB

Clone DB (Post upgrade)

PegaRULES

82

382

PegaDATA

360

403

 

Show More

@SushantSamuel   and @PegaTeam

I have upgraded Pega 8.3.1 to 8.7.1 but by restarting JBoss getting same issue ,even we have given full grant to pegaadmin and pegabase users.

Let me know if we can get any help OR mining full suggestion as per below mention details form Pega upgrade team because its look like blocker for us. 

Environment details :--->

Pega current version : 8.3.1 

Pega upgraded version : 8.7.1

App server : Jboss 7.4.1

Database : Postgres

 

Upgrade (In place ) script execution step :-->

1. setupDatabase.property file update for rule and data schema 2. generateddl.sh 3. generateudf.sh 4. upgrate.sh --ruleOnly true 5. upgrade.sh --dataonly true

Note : mighrate.sh --> not done because we had perform in place upgrade

Major changes in table

 

live DB

Clone DB (Post upgrade)

PegaRULES

82

382

PegaDATA

360

403

 

BELOW ERROR DURINING SERVER START

[                    ] [                    ] (   external.async.IStartupTask) ERROR   - Error in the execution of Startup Task: [com.pega.pegarules.session.internal.async.startup.AppAliasToAuthServiceMappingCacheStartupTask] 2022-05-24 16:45:08,137 INFO  [stdout] (Log4j2-TF-9-AsyncLoggerConfig-1) com.pega.pegarules.pub.PRRuntimeException: Exception in fetching list of auth service names mapped to app aliases 2022-05-24 16:45:08,137 INFO  [stdout] (Log4j2-TF-9-AsyncLoggerConfig-1)     at com.pega.platform.web.application.authentication.AppAliasToAuthServiceMappingCacheLoader.executeListSpecification(AppAliasToAuthServiceMappingCacheLoader.java:81) ~[web.jar:?] 2022-05-24 16:45:08,137 INFO  [stdout] (Log4j2-TF-9-AsyncLoggerConfig-1)     at com.pega.platform.web.application.authentication.AppAliasToAuthServiceMappingCacheLoader.fetchAuthServicesForAppAliasesFromDB(AppAliasToAuthServiceMappingCacheLoader.java:70) ~[web.jar:?] 2022-05-24 16:45:08,137 INFO  [stdout]     (Log4j2-TF-9-AsyncLoggerConfig-1)     at com.pega.platform.web.application.authentication.AppAliasToAuthServiceMappingCacheImpl.loadAppAliasToAuthServiceMappingCache(AppAliasToAuthServiceMappingCacheImpl.java:63) ~[web.jar:?] 2022-05-24 16:45:08,137 INFO  [stdout] (Log4j2-TF-9-AsyncLoggerConfig-1)     at com.pega.pegarules.session.internal.async.startup.AppAliasToAuthServiceMappingCacheStartupTask.runTask(AppAliasToAuthServiceMappingCacheStartupTask.java:40) ~[prprivate-session.jar:?] 2022-05-24 16:45:08,137 INFO  [stdout] (Log4j2-TF-9-AsyncLoggerConfig-1)     at com.pega.pegarules.session.internal.async.startup.StartupTask$1.run(StartupTask.java:55) ~[prprivate-session.jar:?] 2022-05-24 16:45:08,137 INFO  [stdout] (Log4j2-TF-9-AsyncLoggerConfig-1)     at com.pega.pegarules.session.internal.PRSessionProviderImpl.performTargetActionWithLock(PRSessionProviderImpl.java:1381) ~[prprivate-session.jar:?] 2022-05-24 16:45:08,137 INFO  [stdout] (Log4j2-TF-9-AsyncLoggerConfig-1)     at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:1124) ~[prprivate-session.jar:?] 2022-05-24 16:45:08,137 INFO  [stdout] (Log4j2-TF-9-AsyncLoggerConfig-1)     at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:931) ~[prprivate-session.jar:?] 2022-05-24 16:45:08,137 INFO  [stdout] (Log4j2-TF-9-AsyncLoggerConfig-1)     at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:897) ~[prprivate-session.jar:?] 2022-05-24 16:45:08,137 INFO  [stdout] (Log4j2-TF-9-AsyncLoggerConfig-1)     at com.pega.pegarules.session.internal.async.startup.StartupTask.run(StartupTask.java:48) ~[prprivate-session.jar:?] 2022-05-24 16:45:08,138 INFO  [stdout] (Log4j2-TF-9-AsyncLoggerConfig-1)     at java.lang.Thread.run(Thread.java:750) [?:1.8.0_322] 2022-05-24 16:45:08,138 INFO  [stdout] (Log4j2-TF-9-AsyncLoggerConfig-1) Caused by: com.pega.pegarules.pub.database.DatabaseException: Database-General    There was a problem getting a list    0    42501    ERROR: permission denied for table pr_data_appalias_authservice 2022-05-24 16:45:08,138 INFO  [stdout] (Log4j2-TF-9-AsyncLoggerConfig-1) DatabaseException caused by prior exception: org.postgresql.util.PSQLException: ERROR: permission denied for table pr_data_appalias_authservice 2022-05-24 16:45:08,138 INFO  [stdout] (Log4j2-TF-9-AsyncLoggerConfig-1)  | SQL Code: 0 | SQL State: 42501 2022-05-24 16:45:08,138 INFO  [stdout] (Log4j2-TF-9-AsyncLoggerConfig-1)  2022-05-24 16:45:08,138 INFO  [stdout] (Log4j2-TF-9-AsyncLoggerConfig-1)     at com.pega.pegarules.data.internal.access.ExceptionInformation.createAppropriateExceptionDueToDBFailure(ExceptionInformation.java:385) ~[prprivate-data.jar:?]

 

Show Less
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