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

Supported data types in MySql

SA-5760

Summary



Unable to use all data types from mapped external (MySql) table in a Report Definition.
For example, you receive the following error when running the Report Definition:

Error:
** ** No enum constant com.pega.pegarules.data.external.rd.constants.ColumnType.MEDIUMTEXT

------------------------
mysql Ver 14.14

------------------------


Resolution



HFix-10049 corrects a regression issue in Pega 7.1.6 whereby support for certain external Database column types no longer functioned as expected in comparison to earlier releases.
 
However, this does not imply that all Database vendor specific column data types can or will be supported by Report Definitions for external access.  For example, the MySQL ‘MEDIUMTEXT’ data type is not supported by deploying HFix-10049.
 
PRPC does not support MySQL as the underlying host Database platform at this time.  There is only partial support for external Report Definition access to the more common column data types.

Published January 31, 2016 - Updated October 8, 2020

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