Support Article
Pega Customer Service For Healthcare Sample Data Upload Error
SA-33978
Summary
Developer 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 Messages
Save Failed: Database-Config-KeyPropertyNotExposed PegaCPMHC-Link-PMContact PMID Import
Steps to Reproduce
1. 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 Cause
The 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.
Resolution
As 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 March 15, 2017 - Updated December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.