2579078 - SUM SQL14217 on "DEMOCDSUPPER" and "DEMO_CDS_STRFUNC" - SAP ASE for Business Suite

• You are upgrading SAP from NW 7.50 to NW 7.52 using latest SUM release
• You encounter the following errors in phase MAIN_SHDINST/SUBMOD_SHDALIASCRE/SUBMOD_SHDVIEWCRE/EU_CLONE_CRE_SHDVIEWS
• Two objects "DEMOCDSUPPER" and "DEMO_CDS_STRFUNC" cannot be created due to database error "(SYB) (SQL error 14217)"

   A1 EIMP 012 Starting create for object "DEMOCDSUPPER" of type "CDS view" #20171130151226
  A1 ESYB 003 DEMOCDSUPPER dropped
  A1EEIMP 007 Task failed with error: (SYB) DDL statement failed
  A1EEIMP 007 #(CREATE VIEW  "DEMOCDSUPPER"  AS SELECT   "T100"."SPRSL", "T100"."ARBGB",
  A1EEIMP 007   "T100"."MSGNR", "T100"."TEXT", SAPSR3.SAP_UPPER( "T100"."TEXT" ) AS "UPPER_TEXT"
  A1EEIMP 007   FROM  "T100" "T100")
  A1EEIMP 007 DbSlExecute: rc = 99
  A1EEIMP 007 (SYB) (SQL error 14217)
  A1EEIMP 007 #Error message returned by DbSl:
  A1EEIMP 007 (SYB) DbSlErrorMsg rc = 0 'everything went well'
  A1EEIMP 007 (SYB) [ASE Error SQL14217][SAP][ASE ODBC Driver][Adaptive Server Enterprise]SQL function not found. If you are attempting to call a java UDF, Java services are not enabled.
  A1EEIMP 016 Finished create for object "DEMOCDSUPPER" of type "CDS view" with error in 0 sec #20171130151226

  
  A1 EIMP 012 Starting create for object "DEMO_CDS_STRFUNC" of type "CDS view" #20171130151229
  A1 ESYB 003 DEMO_CDS_STRFUNC dropped
  A1EEIMP 007 Task failed with error: (SYB) DDL statement failed
  A1EEIMP 007 #(CREATE VIEW  "DEMO_CDS_STRFUNC"  AS SELECT   "DEMO_EXPRESSIONS"."MANDT"
  A1EEIMP 007   AS "MANDT", sap_length( "DEMO_EXPRESSIONS"."CHAR1" ) AS "R_LENGTH", SAPSR3.SAP_INSTR(
  A1EEIMP 007   "DEMO_EXPRESSIONS"."CHAR1", 'CD' ) AS "R_INSTR", SAPSR3.SAP_CONCAT( "DEMO_EXPRESSIONS"."CHAR1",
  A1EEIMP 007   "DEMO_EXPRESSIONS"."CHAR2" ) AS "R_CONCAT", sap_concat_separated_by_space(
  A1EEIMP 007   "DEMO_EXPRESSIONS"."CHAR1", "DEMO_EXPRESSIONS"."CHAR2", CAST( 10 AS TINYINT)
  A1EEIMP 007   ) AS "R_CONCAT_WITH_SPACE", SAPSR3.SAP_LEFT( "DEMO_EXPRESSIONS"."CHAR1",
  A1EEIMP 007   CAST( 3 AS TINYINT) ) AS "R_LEFT", SAPSR3.SAP_LOWER( "DEMO_EXPRESSIONS"."CHAR1"
  A1EEIMP 007   ) AS "R_LOWER", sap_right( "DEMO_EXPRESSIONS"."CHAR2", CAST( 3 AS TINYINT)
  A1EEIMP 007   ) AS "R_RIGHT", sap_lpad( "DEMO_EXPRESSIONS"."CHAR1",CAST( 10 AS TINYINT),'x')
  A1EEIMP 007   AS "R_LPAD", SAPSR3.SAP_RPAD( "DEMO_EXPRESSIONS"."CHAR2", CAST( 10 AS TINYINT),
  A1EEIMP 007   'y') AS "R_RPAD", sap_ltrim( "DEMO_EXPRESSIONS"."CHAR1", 'A' ) AS "R_LTRIM",
  A1EEIMP 007   sap_rtrim( "DEMO_EXPRESSIONS"."CHAR1", 'E' ) AS "R_RTRIM", SAPSR3.SAP_REPLACE(
  A1EEIMP 007   "DEMO_EXPRESSIONS"."CHAR2", 'GHI', 'XXX' ) AS "R_REPLACE", sap_rtrim( substring(
  A1EEIMP 007   "DEMO_EXPRESSIONS"."CHAR2", CAST( 2 AS TINYINT), CAST( 3 AS TINYINT) ),' ')
  A1EEIMP 007   AS "R_SUBSTRING", SAPSR3.SAP_UPPER( "DEMO_EXPRESSIONS"."CHAR2" ) AS "R_UPPER"
  A1EEIMP 007   FROM  "DEMO_EXPRESSIONS" "DEMO_EXPRESSIONS")
  A1EEIMP 007 DbSlExecute: rc = 99
  A1EEIMP 007 (SYB) (SQL error 14217)
  A1EEIMP 007 #Error message returned by DbSl:
  A1EEIMP 007 (SYB) DbSlErrorMsg rc = 0 'everything went well'
  A1EEIMP 007 (SYB) [ASE Error SQL14217][SAP][ASE ODBC Driver][Adaptive Server Enterprise]SQL function not found. If you are attempting to call a java UDF, Java services are not enabled.
  A1EEIMP 016 Finished create for object "DEMO_CDS_STRFUNC" of type "CDS view" with error in 0 sec #20171130151229

The corresponding IMPORT log also states:

A1EEIMP 007 Task failed with error: (SYB) DDL statement failed
A1EEIMP 007 (CREATE VIEW "DEMOCDSUPPER" AS SELECT "T100"."SPRSL", "T100"."ARBGB",
A1EEIMP 007 "T100"."MSGNR", "T100"."TEXT", SAPSR3.SAP_UPPER( "T100"."TEXT" ) AS "UPPER_TEXT"
A1EEIMP 007 FROM "T100" "T100")
A1EEIMP 007 DbSlExecute: rc = 99
A1EEIMP 007 (SYB) (SQL error 14217)
A1EEIMP 007 Error message returned by DbSl:
A1EEIMP 007 (SYB) DbSlErrorMsg rc = 0 'everything went well'
A1EEIMP 007 (SYB) [ASE Error SQL14217][SAP][ASE ODBC Driver][Adaptive Server Enterprise]SQL function not found. If you are attempting to call a java UDF, Java
services are not enabled.
A1EEIMP 016 Finished create for object "DEMOCDSUPPER" of type "CDS view" with error in 0 sec #20171214110847

A1 ESYB 003 DEMO_CDS_STRFUNC dropped
A1EEIMP 007 Task failed with error: (SYB) DDL statement failed
A1EEIMP 007 (CREATE VIEW "DEMO_CDS_STRFUNC" AS SELECT "DEMO_EXPRESSIONS"."MANDT"
A1EEIMP 007 AS "MANDT", sap_length( "DEMO_EXPRESSIONS"."CHAR1" ) AS "R_LENGTH", SAPSR3.SAP_INSTR(
A1EEIMP 007 "DEMO_EXPRESSIONS"."CHAR1", 'CD' ) AS "R_INSTR", SAPSR3.SAP_CONCAT( "DEMO_EXPRESSIONS"."CHAR1",
A1EEIMP 007 "DEMO_EXPRESSIONS"."CHAR2" ) AS "R_CONCAT", sap_concat_separated_by_space(
A1EEIMP 007 "DEMO_EXPRESSIONS"."CHAR1", "DEMO_EXPRESSIONS"."CHAR2", CAST( 10 AS TINYINT)
A1EEIMP 007 ) AS "R_CONCAT_WITH_SPACE", SAPSR3.SAP_LEFT( "DEMO_EXPRESSIONS"."CHAR1",
A1EEIMP 007 CAST( 3 AS TINYINT) ) AS "R_LEFT", SAPSR3.SAP_LOWER( "DEMO_EXPRESSIONS"."CHAR1"
A1EEIMP 007 ) AS "R_LOWER", sap_right( "DEMO_EXPRESSIONS"."CHAR2", CAST( 3 AS TINYINT)
A1EEIMP 007 ) AS "R_RIGHT", sap_lpad( "DEMO_EXPRESSIONS"."CHAR1",CAST( 10 AS TINYINT),'x')
A1EEIMP 007 AS "R_LPAD", SAPSR3.SAP_RPAD( "DEMO_EXPRESSIONS"."CHAR2", CAST( 10 AS TINYINT),
A1EEIMP 007 'y') AS "R_RPAD", sap_ltrim( "DEMO_EXPRESSIONS"."CHAR1", 'A' ) AS "R_LTRIM",
A1EEIMP 007 sap_rtrim( "DEMO_EXPRESSIONS"."CHAR1", 'E' ) AS "R_RTRIM", SAPSR3.SAP_REPLACE(
A1EEIMP 007 "DEMO_EXPRESSIONS"."CHAR2", 'GHI', 'XXX' ) AS "R_REPLACE", sap_rtrim( substring(
A1EEIMP 007 "DEMO_EXPRESSIONS"."CHAR2", CAST( 2 AS TINYINT), CAST( 3 AS TINYINT) ),' ')
A1EEIMP 007 AS "R_SUBSTRING", SAPSR3.SAP_UPPER( "DEMO_EXPRESSIONS"."CHAR2" ) AS "R_UPPER"
A1EEIMP 007 FROM "DEMO_EXPRESSIONS" "DEMO_EXPRESSIONS")
A1EEIMP 007 DbSlExecute: rc = 99
A1EEIMP 007 (SYB) (SQL error 14217)
A1EEIMP 007 Error message returned by DbSl:
A1EEIMP 007 (SYB) DbSlErrorMsg rc = 0 'everything went well'
A1EEIMP 007 (SYB) [ASE Error SQL14217][SAP][ASE ODBC Driver][Adaptive Server Enterprise]SQL function not found. If you are attempting to call a java UDF, Java
services are not enabled.

•  The errors persist even after running report RUTCNVFUNCCRE1 as suggested in SAP KBA 2418979

• SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
• SAP NetWeaver (NW) - 7.51 and 7.52
• Software Update Manager (SUM) 1.0 and 2.0

SQL14217, "DEMOCDSUPPER", "DEMO_CDS_STRFUNC", SUM, "SQL error 14217" , KBA , sap_lower/sap_lower , cds , eu_clone_cre_shdviews , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Problem