Question
Ernst & Young Global Limited
LK
Last activity: 15 Feb 2017 9:54 EST
Pega Customer Service For Healthcare Sample Data Upload Error
I am Using PRPC 7.2.2 And I already install HCIF 7.1.4 , CPM 7.2.1 , Care Management 7.1.4 and pega Servay 7.1.2.
When I import Pega Customer Service for Healthcare Sample Data (CSHCSample.jar) it gives the following errors.
“Save Failed: Database-Config-KeyPropertyNotExposed PegaCPMHC-Link-PMContact PMID Import”
When I checked with the "PegaCPMHC-Link-PMContact” class, in "External Mapping" column names are defined in wrong way.
Is this a known issue which has a solution or hotfix for that?
Instellars
IN
Hi Stewart,
This is a known issue while using MS SQL server where the column name in the sql file and the same column key in the class are different. For e.g. as per the above error the class will show PMID as the column key, but the SQL script is generated using a different letter case and it becomes PMId. Since SQL server is case sensitive, the import fails.
To resolve this issue, please perform the local change as mentioned in the following pdn article:
https://community.pega.com/support/support-articles/cssample-install-failure-ms-sql-server-database
Hope it helps.