Support Article
Application not working properly after upgrade
Summary
User upgraded from Pega 7.1.5 to Pega 7.1.9 using the split-schema and brought the server up and tried to access the screens but they see DatabaseException and those screens were not populating data.Error Messages
2016-05-14 22:20:00,607 [fault (self-tuning)'] [TABTHREAD0] [ ] [ GEMS:01.01.01] ( rd.queryexec.SqlQueryExecutor) ERROR <<your_server_name>>|<<your_ip_address>> <<username>> - An error occurred on executing the query for the report definition - There was a problem getting a list: code: 904 SQLState: 42000 Message: ORA-00904: : invalid identifier
com.pega.pegarules.pub.database.DatabaseException: There was a problem getting a list: code: 904 SQLState: 42000 Message: ORA-00904: : invalid identifierSteps to Reproduce
Login to application and try to navigate through different screens after upgrade.Root Cause
User was using a different user credentials to connect to the database in the WebLogic data source configuration which do not have the access to execute any procedure on the schemas.Resolution
User provided the Execute Any Procedure privilege to the correct user account which was configured in the WebLogic data source.
Here is the SQL - GRANT EXECUTE ANY PROCEDURE TO <<Weblogic_Datasource_User>> ;
Published May 23, 2016 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.