SAP Knowledge Base Article - Preview

3112354 - Error during Netweaver Upgrade with SUM 2.0

Symptom

During the Netweaver upgrade from NW 7.5 to NW 7.52 using SUM 2.0, the following error happens in the phase

MAIN_SHDINST/SUBMODE_SHDALIASCRE/SUBMOD_SHDVIEWCRE/EU_CLONE_CRE_SHDVIEWS

A1EEIMP 008 #(CREATE VIEW  "DEMO_CDS_STRFUNC"  AS
A1EEIMP 008 SELECT   "DEMO_EXPRESSIONS"."MANDT" AS "MANDT", LEN( "DEMO_EXPRESSIONS"."CHAR1"
A1EEIMP 008 ) AS "R_LENGTH", CHARINDEX( N'CD', RTRIM( "DEMO_EXPRESSIONS"."CHAR1" )
A1EEIMP 008 ) AS "R_INSTR", &dbschema&.SAP_CONCAT( "DEMO_EXPRESSIONS"."CHAR1", "DEMO_EXPRESSIONS"."CHAR2")
A1EEIMP 008 AS "R_CONCAT", &dbschema&.CONCAT_WITH_SPACE( "DEMO_EXPRESSIONS"."CHAR1",
A1EEIMP 008 "DEMO_EXPRESSIONS"."CHAR2", CAST( 10 AS TINYINT)) AS "R_CONCAT_WITH_SPACE",
A1EEIMP 008 RTRIM( LEFT( "DEMO_EXPRESSIONS"."CHAR1", CAST( 3 AS TINYINT) )) AS "R_LEFT",
A1EEIMP 008 dbo.SAP_LOWER( "DEMO_EXPRESSIONS"."CHAR1" ) AS "R_LOWER", RIGHT( RTRIM(
A1EEIMP 008 "DEMO_EXPRESSIONS"."CHAR2"), CAST( 3 AS TINYINT) ) AS "R_RIGHT", &dbschema&.SAP_LPAD(
A1EEIMP 008 "DEMO_EXPRESSIONS"."CHAR1", CAST( 10 AS TINYINT), N'x') AS "R_LPAD", &dbschema&.SAP_RPAD(
A1EEIMP 008 "DEMO_EXPRESSIONS"."CHAR2", CAST( 10 AS TINYINT), N'y') AS "R_RPAD", &dbschema&.SAP_LTRIM(
A1EEIMP 008 "DEMO_EXPRESSIONS"."CHAR1", N'A' ) AS "R_LTRIM", &dbschema&.SAP_RTRIM(
A1EEIMP 008 "DEMO_EXPRESSIONS"."CHAR1", N'E' ) AS "R_RTRIM", REPLACE( RTRIM( "DEMO_EXPRESSIONS"."CHAR2"
A1EEIMP 008 ), RTRIM( N'GHI' ), RTRIM( N'XXX' ) ) AS "R_REPLACE", SUBSTRING( "DEMO_EXPRESSIONS"."CHAR2",
A1EEIMP 008 CAST( 2 AS TINYINT), CAST( 3 AS TINYINT) ) AS "R_SUBSTRING", dbo.SAP_UPPER(
A1EEIMP 008 "DEMO_EXPRESSIONS"."CHAR2" ) AS "R_UPPER" FROM  "DEMO_EXPRESSIONS" "DEMO_EXPRESSIONS")
A1EEIMP 008 #DbSlExecute: rc = 99
A1EEIMP 008 (MSS) SQL error = 4121
A1EEIMP 008 (MSS) Cannot find either column "tpr_shd" or the user-defined function or aggregate "tpr_shd.SAP_LTRIM", or the name is ambiguous.
A1EEIMP 008 (IMP) Statement 1 of 1 failed for the object DEMO_CDS_STRFUNC
A2EETSK 007 Finished create for object "DEMO_CDS_STRFUNC" of type "CDS view" with error in 0.00 sec #20211022153128


Read more...

Environment

Netweaver 7.5 upgrade with SUM 2.0.

Product

SAP NetWeaver 7.5

Keywords

KBA , BC-DB-MSS , SQL Server in SAP NetWeaver Products , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.