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.
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 :–>
setupDatabase.property file update for rule and data schema
generateddl.sh
generateudf.sh
upgrate.sh --ruleOnly true
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:?]