Support Article
Error while using prpcUtils.sh script to automate deployment
SA-59532
Summary
Error occurs while using the prpcUtils.sh script to automate the deployment.
Error Messages
BUILD FAILED
/appfiles/pega_import_utility/7.1.8/PegaAutomatedDeployment/scripts/commonUtilities.xml:40: Unable to execute sql query:
select max(s.pySystemName) from APPRULES.pr_data_admin s inner join APPRULES.pr_data_admin r on s.pySystemName = r.pySystemName where s.pxobjclass = 'Data-Admin-System ' and r.pxObjClass = 'Data-Admin-Requestor'
Steps to Reproduce
Run the prpcutils.sh script.
Root Cause
A defect or configuration issue in the operating environment. Permissions were not correct.
Resolution
Perform the following local-change:Specify the user as Admin in the prpcUtils.properties:
- CREATE SESSION
- CREATE ANY TABLE
- ALTER ANY TABLE
- INSERT ANY TABLE WITH ADMIN OPTION
- SELECT ANY TABLE
- UPDATE ANY TABLE
- DELETE ANY TABLE
- CREATE ANY INDEX
- CREATE ANY PROCEDURE
- EXECUTE ANY PROCEDURE
- CREATE ANY VIEW
- CREATE ANY TYPE
- CREATE ANY TRIGGER
- ALTER ANY TRIGGER
- GRANT ANY OBJECT PRIVILEGE
- DROP ANY PROCEDURE
- DROP ANY TRIGGER
- DROP ANY TABLE
- DROP ANY VIEW
- DROP ANY INDEX
- ANALYZE ANY
- ANALYZE ANY DICTIONARY
- SELECT_CATALOG_ROLE (role, not a privilege)
Published February 12, 2019 - 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.