Support Article

Error while importing PegaMarketingFS_Artifacts_7.22.1

SA-38803

Summary



Error while importing PegaMarketingFS_Artifacts_7.22.1 on Oracle DB with Pega Marketing for Financial Services 7.22.1.

Error Messages



Encountered an issue applying DDL: GRANT SELECT on EXTERNALMKTDATA.FSF_SAMPLE_CUST_VIEW to EXTERNALMKTDATA: Database-General Problem executing SQL to update database schema 1720 42000 ORA-01720: grant option does not exist for 'PRPCD.FSF_SAMPLE_CUST_COMMS'DatabaseException caused by prior exception: java.sql.SQLSyntaxErrorException: ORA-01720: grant option does not exist for 'PRPCD.FSF_SAMPLE_CUST_COMMS' | SQL Code: 1720 | SQL State: 42000 -- See the log for additional information.

Steps to Reproduce



Import PegaMarketingFS_Artifacts_7.22.1.

Root Cause



View creation failing as the grant option does not exist for the tables referenced.

Resolution



Run the below SQL using sysdba:

GRANT SELECT ON PRPCD.fsf_sample_cust TO ExternalMKTData with grant option;
GRANT SELECT ON PRPCD.fsf_sample_cust_address TO ExternalMKTData with grant option;
GRANT SELECT ON PRPCD.fsf_sample_cust_comms TO ExternalMKTData with grant option;
GRANT SELECT ON PRPCD.fsf_sample_custacctxref TO ExternalMKTData with grant option;
GRANT SELECT ON PRPCD.fsf_sample_ccacct TO ExternalMKTData with grant option;
GRANT SELECT ON PRPCD.fsf_sample_acct TO ExternalMKTData with grant option;

Published June 1, 2017 - Updated July 13, 2017

Have a question? Get answers now.

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