EHP5 upgrade stuck in MAIN_SWITCH/PARMVNT_XCNV

[Former Member]

Hello Dear,

doing an upgarde ECC6.0 EHP3 to ECC6.0 EHP5 on Win2003 x86_64 with MaxDB7.8

Currently upgrade stucks in MAIN_SWITCH/PARMVNT_XCNV with:

Severe error(s) occured in phase MAIN_SWITCH/PARMVNT_XCNV!

Last error code set: Single errors (code > 😎 found in logfile 'MVNTXCNV.ELG'

MVNTXCNV.ELG shows::

============

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

MVNTABS ERRORS: ddlntabs and RETURN CODE in PD000628.SED

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

2EETP345 17:10:13: Retcode 1024: SQL-error "-955-POS(15) Duplicate name:GENSETC" in

DDL statement f

2EETP345 or "GENSETC "

2EETP334 17:10:13: error in DDL, nametab for "GENSETC" not activated

2EETP345 17:10:25: Retcode 1024: SQL-error "-955-POS(15) Duplicate name:SERVTYPE" in

DDL statement

2EETP345 for "SERVTYPE "

2EETP334 17:10:25: error in DDL, nametab for "SERVTYPE" not activated

2EETP345 17:10:37: Retcode 1024: SQL-error "-955-POS(15) Duplicate

name:SRT_MONILOG_DATA" in DDL st

2EETP345 atement for "SRT_MONILOG_DATA "

2EETP334 17:10:37: error in DDL, nametab for "SRT_MONILOG_DATA" not activated

1 ETP111 exit code : "8"

I have seen similar messages wich lead to sapnote 589296.

- is is note applicable to maxdb ??

- any doubt, if GENSETC contains a couple of entries (21)??

Any further idea??

Thanks, Ernst

[sunny_pahuja2 · Accepted solution]

Hi,

note which you mentioned is not for MaxDB. Check SAP note 1285700.

Thanks

Sunny

[Former Member]

Hello,

I have the same problem, but syntax from note - 589296 doesn't applicable for MaxDB

Can someone share a correct syntax for MaxDB?

[Former Member]

Hi.

Using SQL-Studio, replace <SID> with your actual SID !!

first check:

select * from "SAP<SID>"."DDXTT~" where TABNAME " = 'SERVERTYPE'

than update:

update "SAP<SID>"."DDXTT~" set modeflag = 'A' where TABNAME = 'GENSETC'

update "SAP<SID>"."DDXTT~" set modeflag = 'A' where TABNAME = 'SRT_MONILOG_DATA'

good luck!

& kind regards

Ernst

[Former Member]

I have an error from sql studio.

-

---

Error -

---

Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed

Base table not found;-4004 POS(9) Unknown table name:DDXTT~

update "SAPDEM"."DDXTT~" set modeflag = 'A' where TABNAME = 'SRT_MONILOG_DATA'

what should I do next?

[Former Member]

Hello.

Pls check

a)

select * from "SAPDEM"."DDXTT~" where TABNAME " = 'SRT_MONILOG_DATA'

b)

select * from "SAPDEM"."DDXTT" where TABNAME " = 'SRT_MONILOG_DATA'

Do you get an result an the MODEFLAG is P ? ( then i would do a corresponding update ...)

Regards, Ernst

[Former Member]

Two errors for both requests.

-

---

Error -

---

Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed

Syntax error or access violation;-3014 POS(48) Invalid end of SQL statement

select * from "SAPDEM"."DDXTT~" where TABNAME " = 'SRT_MONILOG_DATA'

-

---

Error -

---

Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed

Syntax error or access violation;-3014 POS(47) Invalid end of SQL statement

select * from "SAPDEM"."DDXTT" where TABNAME " = 'SRT_MONILOG_DATA'

[Former Member]

Sorry, one " to much (cut&paste-err) ...

a)

select * from "SAPDEM"."DDXTT~" where TABNAME = 'SRT_MONILOG_DATA'

b)

select * from "SAPDEM"."DDXTT" where TABNAME = 'SRT_MONILOG_DATA'

Do you get an result an the MODEFLAG is P ? ( then i would do a corresponding update ...)

Tks

[Former Member]

same(((

-

---

Error -

---

Auto Commit: Off, SQL Mode: Internal, Isolation Level: Committed

Base table not found;-4004 POS(16) Unknown table name:DDXTT

select * from "SAPDEM"."DDXTT" where TABNAME = 'SRT_MONILOG_DATA'

-

---

Error -

---

Auto Commit: Off, SQL Mode: Internal, Isolation Level: Committed

Base table not found;-4004 POS(16) Unknown table name:DDXTT~

select * from "SAPDEM"."DDXTT~" where TABNAME = 'SRT_MONILOG_DATA'

[Former Member]

finaly!!!!

I tryed to update tables as superdba/control user....

But it should be done by sap<sid> user. ))

tnx for you time.

[nicholas_chang]

Hi Ernst-Georg Knierim,

I got certain entries which is modeflag = P, may i know what's the corresponding update?

Do you get an result an the MODEFLAG is P ? ( then i would do a corresponding update ...)

Your kind advice is very much appreciated. Thanks!

Cheers,

Nicholas Chang

[Former Member]

Hi,

for info, problem was solved by following sapnote 589296

( i was told by sapsupport, that it can be used for maxdb as well ).

Tks for help.

[paul_power]

Dear Ernst,

Please check the table, it seems

SERVTYPE

is already existing. Is it existing in a customization of this table?

regards,

Paul