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 February 21, 2017 - Updated March 14, 2017

Have a question? Get answers now.

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