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

No enum constant com.pega.pegarules.priv.database.sqlgen.constan

SA-31406

Summary



User is seeing the following error in the clipboard on running  Report Definition.

No enum constant com.pega.pegarules.priv.database.sqlgen.constants.ColumnType.NVARCHAR(MAX).

Issue only observed in MSSQL DB.


Error Messages



No enum constant com.pega.pegarules.priv.database.sqlgen.constants.ColumnType.NVARCHAR(MAX)

Steps to Reproduce



1. Open some User Story.
2. Perform Resolve action.Action drop-down is empty.
3. Check clipboard, data page will show the error.


Root Cause



User deployed PRPC application on weblogic server with default MS SQL jdbc driver provided by weblogic instead of SQLJDBC, and nvarchar column type is not supported with weblogic.jdbc.sqlserver.SQLServerDriver weblogic driver.


Resolution



Use com.microsoft.sqlserver.jdbc.SQLServerDriver driver, add the MS SQL jdbc driver (SQLJDBC4.jar) in classpath of the weblogic server.

In the setDomainEnv.cmd (windows) or the setDomainEnv.sh (UNIX) file, add the line as below,

Set EXT_PRE_CLASSPATH = <Path to JDBC Directory>\sqljdbc4.jar

 
Suggest Edit

Published December 24, 2016 - 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