Support Article
AES does not start due to "clr enabled" exceptions
SA-17351
Summary
An exception prevents normal startup and operation of the AES server.
Error Messages
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Execution of user code in the .NET Framework is disabled. Enable "clr enabled" configuration option.
21:11:09,936 INFO [stdout] (Dispatcher-Thread-102) at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:196)
21:11:09,936 INFO [stdout] (Dispatcher-Thread-102) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1454)
21:11:09,936 INFO [stdout] (Dispatcher-Thread-102) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:388)
21:11:09,936 INFO [stdout] (Dispatcher-Thread-102) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:338)
Steps to Reproduce
Not Applicable
Root Cause
A defect in Pegasystems’ code or rules: The database column mapping was incorrectly using mixed case, which caused the database to attempt to use the CLR functionality to read from the BLOB.
Resolution
Apply HFix-24976.
Published January 31, 2016 - Updated December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.