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.
SAP Knowledge Base Article - Preview