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

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

Suggest Edit

Published May 4, 2017 - Updated October 8, 2020

Did you find this content helpful? Yes No

Have a question? Get answers now.

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

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