Symptom
If you are upgrading your system the upgrade fails in phase MAIN_NEWBAS/RUN_RUTCN
In SAPupConsole.log
Checks after phase MAIN_NEWBAS/RUN_RUTCN were negative!
Last error code set:
Batchjob 'RUTCNVFUNCCRE1' with id '01020300' is aborted
A job DMP is generated
ABAP Short Dump Header Data
---------------------------
Short Dump Category: Resource bottleneck
Runtime Error: DBIF_REPO_SQL_ERROR
ABAP Program: CLAS CL_DD_DB_VIEW_MSS
ABAP Main Program: CL_DD_DB_VIEW_MSS=============CP
ABAP Package: SDVI_DB_MSS
Software Component: SAP_BASIS
Application Component: BC-DB-MSS Microsoft SQL Server
And if you check work process trace
C CREATE or ALTER ASSEMBLY for assembly 'SAPCLR' with the SAFE or EXTERNAL_ACCESS option failed because the 'clr strict security' option of sp_configure is set to 1. Microsoft recommends that you sign the assembly with a certificate or asymmetric key that has a corresponding login with UNSAFE ASSEMBLY permission. Alternatively, you can trust the assembly using sp_add_trusted_assembly.
B ***LOG BY2=> sql error 10343 performing EXE [dbds 684]
B ***LOG BY0=> CREATE or ALTER ASSEMBLY for assembly 'SAPCLR' with the SAFE or EXTERNAL_ACCESS option failed because the 'clr strict security' option of sp_configure is set to 1. Microsoft recommends that you sign the assembly with a certificate or asymmetric key that has a corresponding login with UNSAFE ASSEMBLY permission. Alternatively, you can trust the assembly using sp_add_trusted_assembly. [dbds 684]
C ERROR: -1 in function StartSelect (execute) [line 17558]
Read more...
Environment
Upgrade on MS SQL 2017
Product
Keywords
MAIN_NEWBAS RUN_RUTCN ASSEMBLY 'clr strict security' RUTCNVFUNCCRE1 , KBA , BC-DB-MSS , SQL Server in SAP NetWeaver Products , Known Error
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.