Support Article
ORA-1720 Exception during Pega Marketing Bundle Import
SA-38668
Summary
While trying to import Pega Marketing 7.22 on Pega 7.2.2, user receives below error on running the following SQL:
Grant select PegaMKT_COMMUNICATION_HISTORY to PegaMKT
It is a split schema configuration.
Error Messages
"ORA-1720 Grant option does not exist for PEGADATA.PR_DATA_IH_DIM_CONTEXT" error on the following sql:
grant select PegaMKT_COMMUNICATION_HISTORY to PegaMKT
Steps to Reproduce
Import PegaMarketing_0722.zip as documented on page 10 of the Pega Marketing 7.22 install guide, using below link:
https://pdn.pega.com/documents/pega-marketing-722-installation-guide
Root Cause
There is a permissions set-up issue on the Oralce DB for the PegaMKT user when performing the installation.
Resolution
Make the following change to the operating environment:
1. Apply the following SQL using sysdba user to provide the required grants to PegaMKT user.
GRANT SELECT ON PEGADATA.PR_DATA_IH_DIM_ACTION TO PegaMKT with grant option;
GRANT SELECT ON PEGADATA.PR_DATA_IH_DIM_APPLICATION TO PegaMKT with grant option;
GRANT SELECT ON PEGADATA.PR_DATA_IH_DIM_CHANNEL TO PegaMKT with grant option;
GRANT SELECT ON PEGADATA.PR_DATA_IH_DIM_CONTEXT TO PegaMKT with grant option;
GRANT SELECT ON PEGADATA.PR_DATA_IH_DIM_CUSTOMER TO PegaMKT with grant option;
GRANT SELECT ON PEGADATA.PR_DATA_IH_DIM_LOCATION TO PegaMKT with grant option;
GRANT SELECT ON PEGADATA.PR_DATA_IH_DIM_OPERATOR TO PegaMKT with grant option;
GRANT SELECT ON PEGADATA.PR_DATA_IH_DIM_OUTCOME TO PegaMKT with grant option;
GRANT SELECT ON PEGADATA.PR_DATA_IH_FACT TO PegaMKT with grant option;
commit;
2. Then re-try the application import.
Tags:
Published July 10, 2017 - Updated December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.