Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

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.

Suggest Edit

Published July 10, 2017 - Updated December 2, 2021

Did you find this content helpful? Yes No

Have a question? Get answers now.

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

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us