Support Article
Column named pxClassHeight not found in SQL columns or embedded
SA-2066
Summary
After installing Pega 7.1.5, the user gets an error when browsing rule or data instances.
Error Messages
2014-10-07 11:09:58,032 [ WebContainer : 6] [ STANDARD] [ ] [ PegaRULES:07.10] (che.appcentric.AppShortcutImpl) ERROR <127.0.0.1|127.0.0.1 [email protected] -
Exception caught when retrieving infer candidates for Rule Type Rule-HTML-Section, Rule Name PZAPPEXPLORERINCLUDE, Class Data-Portal-DesignerStudio, Aspect Stream, for appHash PegaRULES!en_US__shared!PRPC:Administrators!07.10$bf1d8fc2ad4457e979a61805dab37c52
com.pega.pegarules.pub.clipboard.InvalidParameterException: Column named pxClassHeight was not found in SQL columns or embedded object
Steps to Reproduce
Install Pega 7.1.5 on WebSphere Application Server 8 and DB2.
Root Cause
A defect or misconfiguration in the Pega operating environment
For users using the DB2 Version 4 drivers (db2jcc4.jar), it is necessary to set the custom connection property useJDBC4ColumnNameAndLabelSemantics to “false”.
For users using DB2 with WebSphere Application Server, the useJDBC4ColumnNameAndLabelSemantics property in the DB2 data source needs to be changed from a Boolean to an Integer and set to "2".
Note: The Data Source Custom Property names are case-sensitive.
Resolution
Perform the following local-change:
Change db2jcc4.jar. to db2jcc.jar.
Related Content
https://pdn.pega.com/release-note/required-db2-settings
https://pdn.pega.com/pegarules-database/troubleshooting-invalidparameterexception-database-column-aliases-not-found-after-jdbc-driver-update
Published May 4, 2017 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.