Alvaro Hidalgo Romera (AlvaroH3)
Accenture Technology

Accenture Technology
AlvaroH3 Member since 2018 5 posts
Accenture Technology
Posted: October 30, 2018
Last activity: November 5, 2018
Posted: 30 Oct 2018 4:46 EDT
Last activity: 5 Nov 2018 9:35 EST

Error trying to import Pega Marketing app sample

Hi all,

I am trying to import the pega marketing application sample, PegaCRMMarketingSample. I tried to import it automatically and I get the following error.

Encountered an issue applying DDL: CREATE VIEW APPMKT.CRM_VW_CAMPAIGN_ORGANIZATION AS SELECT, org.pzinskey, org.territoryid AS territory, 
org.industry, org.pystatuswork AS workstatus, org.revenue, addr.pycity AS city, addr.pystate AS state, addr.pycountry AS country, addr.pypostalcode AS postalcode FROM (saplus_work_org org
LEFT JOIN APPDATA.crm_index_address addr ON (((addr.pxinsindexedkey) = (org.pzinskey)))) WHERE ((((addr.isprimary) = 'true') 
AND ((addr.pxindexpurpose) = 'Index_Addresses')) AND ((org.pystatuswork) not like 'Resolved%')):

 Database-General Problem executing SQL to update database schema 942 42000 ORA-00942: 
table or view does not exist DatabaseException caused by prior exception: 
java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist | SQL Code: 942 | SQL State: 42000 

Do you know where I could find documentation about its integration? Or should I created those table by own in the database?

I am using Pega 7.4 and Pega Marketing 7.4

Thank you all

Pega Marketing
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.