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 for Me (Login required).

Search for additional results

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