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

Deployment Manager unable to export and import product files

SA-81545

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.
Suggest Edit

Published August 15, 2019 - Updated December 2, 2021

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