Application not working properly after upgrade
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.
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 identifier
Steps to Reproduce
Login to application and try to navigate through different screens after upgrade.
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.
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
0% found this useful
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.