Skip to Content
author's profile photo Former Member
0
Former Member

Install SP09 in NW 7.4 ABAP using SUM on HANA

Posted on Dec 09, 2014 at 03:54 PM 301 Views

Hello,

I would update my NW 7.4 by SUM. Earlier, done with SUM without bigger problems, but now I can't do this.

Below logs are in SUM:

Checks after phase MAIN_TRANSEXEC/PARMVNT_TRANS were negative!

3 ETP379X15:56:40: activating Nametab "SIMDQ_DESCRIP":

2 ETP000 >> Name of inactive nametab to read : DDXTT

2 ETP000 >> Format of inactive nametab to read: 5.0

3 ETP355Xstatements:

3 ETP000

2WETP000 15:56:40: Retcode 1: error in DDL statement for "SIMDQ_DESCRIP " - repeat

2EETP345 15:56:52: Retcode 1: SQL-error "257-sql syntax error: invalid SQL type" in DDL statement f

2EETP345 or "SIMDQ_DESCRIP "

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

2EETP334 15:56:52: error in DDL, nametab for "SIMDQ_DESCRIP" not activated

3 ETP379X15:56:52: activating Nametab "SIMDQ_DSC_CLNT":

3 ETP355Xstatements:

3 ETP000

2WETP000 15:56:52: Retcode 1: error in DDL statement for "SIMDQ_DSC_CLNT " - repeat

2EETP345 15:57:04: Retcode 1: SQL-error "257-sql syntax error: invalid SQL type" in DDL statement f

2EETP345 or "SIMDQ_DSC_CLNT "

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

2EETP334 15:57:04: error in DDL, nametab for "SIMDQ_DSC_CLNT" not activated

3 ETP379X15:57:04: activating Nametab "SIMDQ_NAME":

3 ETP355Xstatements:

3 ETP000

2WETP000 15:57:04: Retcode 1: error in DDL statement for "SIMDQ_NAME " - repeat

2EETP345 15:57:16: Retcode 1: SQL-error "257-sql syntax error: invalid SQL type" in DDL statement f

2EETP345 or "SIMDQ_NAME "

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

2EETP334 15:57:16: error in DDL, nametab for "SIMDQ_NAME" not activated

3 ETP379X15:57:16: activating Nametab "SIMDQ_NAM_CLNT":

3 ETP355Xstatements:

3 ETP000

2WETP000 15:57:16: Retcode 1: error in DDL statement for "SIMDQ_NAM_CLNT " - repeat

2EETP345 15:57:28: Retcode 1: SQL-error "257-sql syntax error: invalid SQL type" in DDL statement f

2EETP345 or "SIMDQ_NAM_CLNT "

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

2EETP334 15:57:28: error in DDL, nametab for "SIMDQ_NAM_CLNT" not activated

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

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

2 ETP362 "4" Shadow-Nametab activations failed

2 ETP360 Begin: Act. of Shadow-Nametabs with DDL ("2014/12/09 15:56:40")

2 ETP363 End : Act. of Shadow-Nametabs with DDL ("2014/12/09 15:57:28")

SUM SP11, patch level 8

Kernel 742 patch number 17,

Hana Rev. 84 , Hana Client Rev. 84

tp version 380.18.94 (release 742, unicode enabled)

R3trans version 6.24 (release 742 - 18.11.14 - 20:14:09)

It is in "Execution" roadmap step. I tried "repeat" and "repeat & init" options, but not both helped me. What can I do next? I can't search similar problem.

regrds

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    author's profile photo Reagan Benjamin
    Reagan Benjamin
    Posted on Dec 09, 2014 at 03:59 PM
    2

    Have you tried to activate the nametabs manually from Tx SE11 ?

    Check this SAP note 2079338 - dipgntab - Execute DDL statements with semicolon

    After the manual activation repeat the phase in SUM. If the activation fails then you should check the activation log.

    RB

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Reagan Benjamin
      Dec 11, 2014 at 12:24 PM

      Notes and instructions supplied by you were perfectly. Now working without problems(in this time 😊 )

      for all, who will faced similar problem:

      • upgrade kernel followed by requisite in (2079338 note)
      • after check tp version
      • startsap
      • unlock system (1901463 note)
      • se11 & activate tables with any user (not DDIC)
      • lock system (1901463 note)
      • repeat phase in SUM
      • the proces "MAIN_TRANSEXEC/PARMVNT_TRANS" will be ok

      Thanks all of you, regards!

    Comment on This Answer
  • author's profile photo Divyanshu Srivastava
    Divyanshu Srivastava
    Posted on Dec 09, 2014 at 04:06 PM
    1

    Hi OK,

    Please refer - "2079338 - dipgntab - Execute DDL statements with semicolon" for this known error

    Regards,

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Srinivasan Vinayagam
    Srinivasan Vinayagam
    Posted on Dec 09, 2014 at 04:22 PM
    1

    Hi Ok,

    You can check for your issue this below notes also.

    1897236 - HANA: Error "insufficient privilege

    1989884 - DBPROC_SQL_ERROR / Error 258 while executing database procedure

    Or

    Now run Transaction SE16N ---> Table DDXTT ---> execute ---> If any entry exists here,we need to delete the same and save. if required confirmation raise a OSS message to SAP and confirm to delete.

    Check in Update Guide

    To find the affected objects, analyze the DDXTTCHK.LOG file.

    Activate these objects using transaction SE11.

    The inactive nametab is then empty.

    Continue the update with repeat.

    Regards,

    V Srinivasan

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.