2579078 - SUM SQL14217 on "DEMOCDSUPPER" and "DEMO_CDS_STRFUNC" - SAP ASE for Business Suite | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

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

Symptom

  • 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

Read more...

Environment

  • 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

Product

SAP NetWeaver 7.5

Keywords

SQL14217, "DEMOCDSUPPER", "DEMO_CDS_STRFUNC", SUM, "SQL error 14217" , KBA , sap_lower/sap_lower , cds , eu_clone_cre_shdviews , BC-DB-SYB , SAP Business Suite on Sybase ASE Database Platform , 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.