Posted: 16 Nov 2017 14:56 EST Last activity: 4 Dec 2017 7:49 EST
Execution of user code in the .NET Framework is disabled. "clr enabled " option is not feasible.
Please find the below mentioned error message in the logs.
An error occured on executing the query for the report definition - There was a problem getting a list: code: 6263 SQLState: S0001 Message: Execution of user code in the .NET Framework is disabled. Enable "clr enabled" configuration option.
DatabaseException caused by prior exception: com.microsoft.sqlserver.jdbc.SQLServerException: Execution of user code in the .NET Framework is disabled. Enable "clr enabled" configuration option.
| SQL Code: 6263 | SQL State: S0001
Recommendations from PEGA :
"To resolve this issue, connect to the Microsoft SQL Server using a SQL Client as the database administrator and issue the following command:
sp_configure 'clr enabled', 1 "
We cannot implement the above mentioned setting in our database.Please provide us the alternate solutions.
***Updated by moderator: Lochan to remove proprietary information***
It looks like the error is coming from trying to run a report. In order to avoid the use of User Defined Functions (which need clr enabled), all properties needed by the report definition must be exposed. For more information, please see the following PDN article: