Pega Customer Service For Healthcare Sample Data Upload Error
SummaryDeveloper is using Pega 7.2.2 and already installed HealthCare Industry Foundation (HCIF) 7.1.4, Customer Process Manager (CPM) 7.2.1, Care Management 7.1.4 and Pega Survey 7.1.2.When developer tries to import Pega Customer Service for Healthcare Sample Data (CSHCSample.jar) it gives errors.
When developer checked with the "PegaCPMHC-Link-PMContact” class, in "External Mapping" column names are defined in wrong way.
Error MessagesSave Failed: Database-Config-KeyPropertyNotExposed PegaCPMHC-Link-PMContact PMID Import
Steps to Reproduce1. Install HCIF 7.1.4 , CPM 7.2.1 , Care Management 7.1.4 and Pega Survey 7.1.2 on Pega 7.2.2.
2. Upload CustomerService_HC_721.jar and CSHC_CMA_Config.jar.
3. Upload CSHCSample.jar.
Root CauseThe developer is facing this issue because the class key or database attribute defined in "PegaCPMHC-Link-PMContact" class is in different letter case from the ones generated in the CSHCSample.sql.
In the database the table "cpmhc_pm_contact_assc" has created with the columns as "PMId" and "ContactId" but in the class "PegaCPMHC-Link-PMContact" the properties are defined like "PMID" and "ContactID".
Since the attributes are case sensitive, the import fails with error.
ResolutionAs the table has already been created, by doing the following steps resolves the issue.
1) Run this script :ALTER TABLE cpmhc_pm_contact_assc CHANGE PMId PMID VARCHAR(20);
ALTER TABLE cpmhc_pm_contact_assc CHANGE Contactid ContactID VARCHAR(20);2) Select manual import option while importing CSHC sample jar and in that remove the following script:CREATE TABLE cpmhc_pm_contact_assc
"PMId" VARCHAR (20) NOT NULL,
"ContactId" VARCHAR (20) NOT NULL,
"BirthMonth" VARCHAR (2),
"Role" VARCHAR (64) NOT NULL,
"HCCustomerType" VARCHAR (10) )
Published February 21, 2017 - Updated March 14, 2017