Error(s) occured in phase MAIN_SHDIMP/PARMVNT_SHD!

[Former Member]

Hi All

I am in the midst of upgrading BI 7.0 EHP1 to BI 7.3.

During the phase MAIN_SHDIMP/PARMVNT_SHD!  I have encounter the following errror :-

MVNTABS ERRORS: ddlntabs and RETURN CODE in PD000903.BIP

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

2EETP345 11:08:37: Retcode 1024: SQL-error "955-ORA-00955: name is already used by an existing obje

2EETP345 ct" in DDL statement for "RPDCHKF03                     "

2EETP334 11:08:37: error in DDL, nametab for "RPDCHKF03" not activated

2EETP345 11:08:49: Retcode 1024: SQL-error "955-ORA-00955: name is already used by an existing obje

2EETP345 ct" in DDL statement for "TXV_T100_TXTLOAD              "

2EETP334 11:08:49: error in DDL, nametab for "TXV_T100_TXTLOAD" not activated

2EETP345 11:09:01: Retcode 1024: SQL-error "955-ORA-00955: name is already used by an existing obje

2EETP345 ct" in DDL statement for "UPA_MCB_10T                   "

2EETP334 11:09:01: error in DDL, nametab for "UPA_MCB_10T" not activated

2EETP345 11:09:13: Retcode 1024: SQL-error "955-ORA-00955: name is already used by an existing obje

2EETP345 ct" in DDL statement for "VER06567_NBUF_KY              "

2EETP334 11:09:13: error in DDL, nametab for "VER06567_NBUF_KY" not activated

1 ETP111 exit code           : "8"

Please advice further , I can't proceed with the upgrade now .Thanks

Regards

Clement

[former_member189725]

Can you check if the shadow schema if these tables already exist ?

What is the database ?

Regards

Ratnajit

[Former Member]

The shadow system does not exist , it has already past,

The database is oracle 11g

[Former Member]

Refer to attachment

Obviously it is exist but not active and all the activate and database button is grey out .

[former_member189725]

Can you check in the oracle database if tables such as RPDCHKF03~ exist in dba_tables .

Did you paste the screenshot above logging into primary instance ?

What is the tool you are using SUM or SAPup ?

Regards

Ratnajit

[Former Member]

Yes it's from the primary instance

I am using STARTUP , the shadow system is down at this moment

sapprd02:bipadm 50> ./SAPup startshd

Enter the path of your root directory [/usr/sap/BIP/upg/abap]:

Root directory =

*** Reexecuting ./SAPup with adapted environment and restart=0x3.

At this time the shadow instance does not yet exist since you have passed phase STOP_SHDI_*!

[former_member189725]

Can you activate the table from SE11 ?

Regards

Ratnajit

[Former Member]

oesn't not  exist in SE11 , in DEV it is exist . Its a transparent table .

Refer to attachment DB02 , those DB Table without unique index is the cause.

[former_member189725]

Can you please check in table PUTTB_SHD , if the entry exist for the above tables .

It seems these tables which are SAP standard are delivered  with NW 7.3 and does not exist in NW 7.01 .

Also check if the tables have entries from the database level (select count(*) from <schema_id>.<tabname>)

Regards

Ratnajit

[former_member340078]

Hello,

as far as i got it the above mentioned tables exists at the db-level but doesn't in Dictionary, correct?

Perhaps, it makes sense to drop them on db-level and re-start the phase...

You can play with the last one (VER06567_NBUF_KY). This one is a part of the internal SAP test framework (wonder how it happens to be here) so it definitely doesn't make any harm...

Regards,

Ilya

[Former Member]

Yes the tables exist in PUTTB_SHD .Yes the tables are SAP Standard delivered with NM 7.3

What is the SQL statement to check the entries ?

[Former Member]

Hello Ilya

The following tables are not active in dictionary  but exist in the database.

RPDCHKF03

TXV_T100_TXTLOAD

VER06567_NBUF_KY

but one  table which is UPA_MCB_10T is active and exist in the database for the list given

[former_member189725]

Login as user ora<sid>

sqlplus "/as sysdba"

select count(*) from sap<sid>.<tablename>;

If they do not contain any entry , you can drop them as follows:

drop table sap<sid>.<tablename>;

I believe dropping the below tables would not be an issue.

RPDCHKF03

TXV_T100_TXTLOAD

VER06567_NBUF_KY

But the table UPA_MCB_10T is the one which seems to be a problem .

When you upgraded the DEV system , did you face any issue as this .

Is the BI-CONT version choosen in BIP system stack file generation  different than DEV ?

Regards

Ratnajit

[former_member340078]

It would be interesting to know which DDL statement (mentioned at the message body) failed. I guess they all are mentioned in PD000903.BIP log file. My only concern that the file is too big to be posted here...

Maybe you can find the corresponding DDL using table names (RPDCHKF03,TXV_T100_TXTLOAD,VER06567_NBUF_KY,UPA_MCB_10T) and post them here.

I guess it something like this: "CREATE TABLE/INDEX <bla-bla-bla>"

Thanks,

Ilya

[Former Member]

Attachment is the PD000903.BIP log file.Thanks

Regards

Clement

Error.txt.zip

[former_member189725]

This seems to be pretty abnormal considering the fact that the table exist in the database and again the upgrade tool is trying to invoke the table creation .

I feel you should be using the SUM tool to avoid such issues .

Are you using SUM?

Regards

Ratnajit

[Former Member]

It is abnormal indeed , all this table exist in DEV (which is on 7.3 )

I am using STARTUP the standard upgrade tool.

[former_member340078]

Hello Clement,

So the tables are empty, aren't they?

Considering all mentioned above i would stick with idea to drop all those tables on db-level and start the upgrade process at this point.

I believe that being dropped tables will be re-created via DDL statmets aftewards and upgrade process will go further.

As i got there is a doubt about UPA_MCB_10T.

In case it contains any data you can export it (as a transport) before deletion and upload it again in case it will not be properly populated.

Regards,

Ilya