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