Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

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

Was this useful?

0% found this useful

Have a question? Get answers now.

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

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us