SPAM IMPORT BASIS SP9 - SQL-error "14217

[jorge_velasquez]

Hi Experts,

Importing SP 9 NW 7.4 stopped with error IMPORT PROPER

Watching trans log:

2 ETP330XActivation of Shadownametabs with DDL

2 ETP301 ----------------------------------------------------------------------

2 ETP301 ----------------------------------------------------------------------

3 ETP361 "0" Shadow-Nametabs activated, DDL executed

3 ETP362 "0" Shadow-Nametab activations failed

2 ETP360 Begin: Act. of Shadow-Nametabs with DDL ("2015/07/12 11:59:25")

2 ETP363 End  : Act. of Shadow-Nametabs with DDL ("2015/07/12 11:59:25")

2 ETP301 ----------------------------------------------------------------------

2 ETP301 ----------------------------------------------------------------------

2 ETP360 Begin: Act. of Shadow-Nametabs with DDL ("2015/07/12 11:59:25")

2 ETP301 ----------------------------------------------------------------------

2 ETP000   processing modeflag 'V'

2 ETP301 ----------------------------------------------------------------------

2 ETP330XActivation of Shadownametabs with DDL

2 ETP301 ----------------------------------------------------------------------

3 ETP379X11:59:25: activating Nametab "DEMO_CDS_SQLFUNC":

3 ETP355XCDS View statements:

3 ETP000 CREATE VIEW "DEMO_CDS_SQLFUNC" AS SELECT "DEMO_EXPRESSIONS"."MANDT"

3 ETP000 AS "MANDT", CAST( ABS( "DEMO_EXPRESSIONS"."NUM1" ) AS int) AS

3 ETP000 "ABS_NUM1", cast( ceiling( "DEMO_EXPRESSIONS"."FLTP1" ) as int) AS

3 ETP000 "CEIL_FLTP1", FLOOR( "DEMO_EXPRESSIONS"."DEC1" ) AS "FLOOR_DEC1",

3 ETP000 cast( ( "DEMO_EXPRESSIONS"."NUM1" / "DEMO_EXPRESSIONS"."NUM2") as int)

3 ETP000 AS "DIV_NUM1_NUM2", case "DEMO_EXPRESSIONS"."NUM2" when 0 then

3 ETP000 "DEMO_EXPRESSIONS"."NUM1" else ( ( "DEMO_EXPRESSIONS"."NUM1" ) % (

3 ETP000 "DEMO_EXPRESSIONS"."NUM2" )) end AS "MOD_NUM1_NUM2", ROUND( (

3 ETP000 "DEMO_EXPRESSIONS"."DEC2" / "DEMO_EXPRESSIONS"."DEC3"), CAST( 3 AS

3 ETP000 TINYINT)) AS "DVISION_DEC2_DEC3", CAST( ROUND(

3 ETP000 "DEMO_EXPRESSIONS"."DEC3", CAST( 2 AS TINYINT) ) AS decimal(

3 ETP000 000011,000003)) AS "ROUND_DEC3", SAPSR3.SAP_CONCAT(

3 ETP000 "DEMO_EXPRESSIONS"."CHAR1", "DEMO_EXPRESSIONS"."CHAR2" ) AS

3 ETP000 "CONCAT_CHAR1_CHAR2", SAPSR3.SAP_LPAD( "DEMO_EXPRESSIONS"."CHAR1",

3 ETP000 CAST( 10 AS TINYINT), 'x', ' '

3 ETP000 ) AS "LPAD_CHAR1", SAPSR3.SAP_REPLACE( "DEMO_EXPRESSIONS"."CHAR2",

3 ETP000 'GHI', 'XXX' ) AS "REPLACE_CHAR2", substring(

3 ETP000 "DEMO_EXPRESSIONS"."CHAR2", CAST( 2 AS TINYINT), CAST( 3 AS TINYINT)

3 ETP000 ) AS "SUBSTRING_CHAR2" FROM "DEMO_EXPRESSIONS" "DEMO_EXPRESSIONS"

3 ETP000 

2WETP000 11:59:25: Retcode 1: error in DDL statement for "DEMO_CDS_SQLFUNC              " - repeat

2EETP345 11:59:37: Retcode 1: SQL-error "14217-[ASE Error SQL14217][SAP][ASE ODBC Driver][Adaptive

2EETP345 Server Enterprise]SQL function not found. If you are attempting to call a java UDF, Java s

2EETP345 ervices are not enabled.

2EETP345 " in DDL statement for "DEMO_CDS_SQLFUNC              "

2 ETP000  --------------- DB-ROLLBACK() ---------------

2EETP334 11:59:37: error in DDL, nametab for "DEMO_CDS_SQLFUNC" not activated

2 ETP301 ----------------------------------------------------------------------

3 ETP361 "0" Shadow-Nametabs activated, DDL executed

2 ETP362 "1" Shadow-Nametab activations failed

2 ETP360 Begin: Act. of Shadow-Nametabs with DDL ("2015/07/12 11:59:25")

2 ETP363 End  : Act. of Shadow-Nametabs with DDL ("2015/07/12 11:59:37")

2 ETP301 ----------------------------------------------------------------------

2 ETP301 ----------------------------------------------------------------------

2 ETP364 Begin: Act. of Shadow-Nametabs ("2015/07/12 11:59:37")

2 ETP301 ----------------------------------------------------------------------

2 ETP301 ----------------------------------------------------------------------

2 ETP338XTouch Load of nametabs

2 ETP301 ----------------------------------------------------------------------

2 ETP301 ----------------------------------------------------------------------

3 ETP365 "0" TouchLoad succeeded

3 ETP362 "0" TouchLoad failed

2 ETP364 Begin: TouchLoad of Nametabs ("2015/07/12 11:59:37")

2 ETP366 End:   TouchLoad of Shadow-Nametabs ("2015/07/12 11:59:37")

Any clue?

[former_member186895]

Hello ,

Also check these nametab DEMO_CDS_SQLFUNC is active or not?

If not please try to activate manually.

Also have a look on SAP note 2144394 - DMO: Views missing from database in phase RUN_RSDB02CK_END

May be help helpful in activation of missing nametab.

Thank

Ramesh

[former_member186895]

Hi ,

Please check tp connection is working proper or not?

you can check in se38 program "rstptest".

Thank

Ramesh

[mamartins]

Hi,

SAP doesn't recommend the use of SPAM anymore for updating systems, instead SUM should be used.

One of the benefits of SUM is the identification of SAP notes relevant to the system with corrections to problems that could occur during the update.

Regards,

MM

[Former Member]

Jorge,

As per SAP

for SAPKB74009  before you import the Support Packages, you must use the tp with Version 380.20.12 or higher.  For more information about this, see SAP Note 2079338.

Have you checked this step.

Please refer

1843157 - Known problems with Support Packages in SAP NW 7.40 AS ABAP

Regards

Anand

[jorge_velasquez]

Hi,

My tp version is  380.35.63

Regards

[divyanshu_srivastava3]

Hi Jorge,

Are you trying to import support pack for any specific component or are you applying a stack ?

Also, what is the version/level of ASE ?

Regards,

[jorge_velasquez]

Hi,

ASE 15.7 PATCH 134.

Importing SP Basis for CRM 7.0 EHP3 from spam.

Regards

[divyanshu_srivastava3]

Hi Jorge,

I was not even able to find the SQL error mentioned on ASE site.

Please raise it with SAP support.

Regards,