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.

Published May 29, 2017 - Updated July 10, 2017

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.