Support Article
Deployment Manager unable to export and import product files
Summary
Deployment Manager is unable to export and import the product files.
Error Messages
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
com.pega.pegarules.pub.database.DatabaseException: 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
SELECT "PARENTPC0".L1 AS "pyID" , "PARENTPC0".L2 AS "pyStatus" , "PARENTPC0".L3 AS "pyTaskStage" , "PARENTPC0".L4 AS "pyBuildName" , "PARENTPC0".L5 AS "pyEventName" , "PARENTPC0".L6 AS "pxSaveDateTime" , "PARENTPC0".L7 AS "pzRank" FROM ( SELECT DISTINCT "PC0"."pyID" AS "L1" , "PC0"."pyStatus" AS "L2" , "PC0"."pyTaskStage" AS "L3" , "PC0"."pyBuildName" AS "L4" , "PC0"."pyEventName" AS "L5" , "PC0"."pxSaveDateTime" AS "L6" , ROW_NUMBER() OVER (PARTITION BY "PC0"."pyEventName" ORDER BY (CASE WHEN "PC0"."pxSaveDateTime" IS NULL THEN 1 ELSE 0 END), "PC0"."pxSaveDateTime" DESC) AS "L7" FROM Data.pr_data_pipeline_event "PC0" WHERE ( "PC0"."pyStatus" IN (? , ? , ? , ? , ? , ? , ? , ? ) AND "PC0"."pyID" = ? AND "PC0"."pyTaskStage" = ? AND UPPER(Data.pr_read_from_stream('.pyInternalEvent', "PC0".pzInsKey, "PC0".pzPVStream)) IS NULL ) AND "PC0"."pxObjClass" = ? ) "PARENTPC0" WHERE "PARENTPC0".L7 <= ? ORDER BY 5 DESC, 7 ASC
Steps to Reproduce
Start the Continuous Integration/Continuous Deployment (CI/CD) Deployment Manager pipeline.
Root Cause
A defect in Pegasystems’ code or rules.
The pzgetcompletedtasksdetailsforbuild report referenced the pyInternalEvent, which is an unexposed property. This caused a reference to the pr_read_from_stream. This failed because the CLR was not enabled on the database due to a policy.
Resolution
Perform the following local-change:
Expose the pyInternalEvent property in the DATA-PIPELINE-EVENT class.
Published August 15, 2019 - 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.