Install SP09 in NW 7.4 ABAP using SUM on HANA

[Former Member]

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

[Reagan · Accepted solution]

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

[Former Member · Accepted solution]

Can I do it in "Execution" phase? System is not working now, so I will have to start SAP manual, although I am during update?  Thanks, check it out.

[Reagan · Accepted solution]

Yes you can but you will need to unlock the system as suggested in this SAP KBA 1901463 - How to unlock the SAP system to perform correction(s) during an upgrade. to do manual activation.

[Former Member · Accepted solution]

Ok, before or after the start system I have do this?

[Reagan · Accepted solution]

The system will only let you login with the DDIC user. To login with another user you will need to unlock the system during an upgrade and to perform such tasks. The SAP KBA is suggesting you the steps to unlock the system. Once you have unlocked the system you will need to connect to the SAP system and call Tx SE11.

[Former Member · Accepted solution]

Ok, so

1. Unlock original system

2. startsap

3. Login to system for example with DDIC

4. Manually activate with SE11

5. Lock the original system

6(?). And... then stopsap or leave the system working, and then "Repeat" in SUM?

Regards

[Reagan · Accepted solution]

As far as I know user DDIC will not let you activate objects. You will need to use another user.

[Former Member · Accepted solution]

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!

[srinivasan_vinayagam]

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

[divyanshu_srivastava3]

Hi OK,

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

Regards,