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

Property ‘CAParentID' is not a DatabaseColumn

SA-7854

Summary



Post CMPHC 713 installation on Microsoft SQL Server, the validation procedure described in the installation manual produces error.

Error Messages



Property ‘CAParentID' is not a DatabaseColumn

Steps to Reproduce





Install or Upgrade CPMHC712 or PCSHC713 using out-of-the-box scripts on MS-SQL database where collation is set to case sensitive. 
Post installation, validate the setup as per guide.

1. Log in as CPMHCSysAdmin
2. Launch the Interaction Portal
3. Click on the +New at the top of the page
4. Select Phone Call – Member

Root Cause



Below MS-SQL scripts create table 'cpmhc_work' with column 'CAPARENTID' (all upper case) instead of 'CAParentID'(camel case) and thus MS-SQL database for administrator, where table and column names are case sensitive, fails to resolve the reference of property CAParentID to column CAPARENTID.

114794_PCSHC713.zip\Install\DDL\CPMHC_mssql.sql
114646_CPMHC712.zip\Install\DDL\CPMHC_mssql.sql
114646_CPMHC712.zip\Upgrade\DDL\CPMHC_Upgrade_mssql.sql

Resolution



Either alter the column name to CAParentID or switch the collation as case insensitive in MS-SQL database.

Published January 31, 2016 - 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