Upgrade Stuck in TP_ACTION_CP2STAB Phase

[Former Member]

Hello Guru's

We are in the process of upgrading our Production Copy server and we

are stuck in phase MAIN_SHDIMP/TP_ACTION_CP2STAB!.

Errors are accumulated in file 'CP2SHDT.ELG' and log files

suggests "'ORA-00942: table or view does not exist'"error.

After going through the log files we found following are the tables

which are throwing ORA-00942 error.

/SAPTRX/FU

DMEE_TREE_

OXT_ER_GOB

SURAPPLVEC

T242Q~

T5B5C~

T604O~

TAMLAYBT~

TCY30T~

TMC1K~

We have already upgrade our development system and upgrade process went

fine but facing this issue in PRD copy server.

Please suggest, how to resolve this issue.

Rehan

[Sandeep_Kumar]

Check the following :

1.the spelling of the table or view name.

2.that a view is not specified where a table is required.

3. that an existing table or view name exists.

Also , for the erorrs for T242Q~

T5B5C~ check if the secondary/primary views exist for these tables.

Contact the database administrator if the table needs to be created or if user or application privileges are required to access the table.

Also, if attempting to access a table or view in another schema, make certain the correct schema is referenced and that access to the object is granted.

[Former Member]

Hi,

Thanks for the reply, We have checked the table name and found following tables with correct name.

These are the "~ tables" which are not there in the database

/SAPTRX/FUNCTNT~

DMEE_TREE_SORT~

OXT_ER_GOBJDEF~

SURAPPLVECTORT~

T242Q~

T5B5C~

T604O~

TAMLAYBT~

TCY30T~

TMC1K~

We have found the similar thread on the SDN :

Pls suggest what to do next.

Rehan

Edited by: Rehan Manzoor on Jan 19, 2011 12:34 PM

We have done the upgrade reset and start all over again