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