Problem during the Spam update

[baby_fabrice]

Hi i have to update our spam/saint.

We are at level 7.00/0026

I have extract the KD70037.SAR file

When i done the import i have theses errors :

15:03:45: Retcode 1: error in DDL statement for CLNT_CVRS2 - repeat

Error 959-ORA-00959: tablespace 'PSAPSR3' does not exist when executing ADD-FIELD of

Error CLNT_CVRS2 when executing ADD-FIELD of

(dummy, do not translate)

No DDL commands found for activation of CLNT_CVRS2

15:03:57: Retcode 1: error in DDL statement for OCSCCOMPAT - repeat

Error 959-ORA-00959: tablespace 'PSAPSR3' does not exist when executing ADD-FIELD of

Error OCSCCOMPAT when executing ADD-FIELD of

(dummy, do not translate)

No DDL commands found for activation of OCSCCOMPAT

15:04:09: Retcode 1: error in DDL statement for OCSSPCOMPR - repeat

Error 959-ORA-00959: tablespace 'PSAPSR3' does not exist when executing ADD-FIELD of

Error OCSSPCOMPR when executing ADD-FIELD of

(dummy, do not translate)

No DDL commands found for activation of OCSSPCOMPR

(dummy, do not translate)

(dummy, do not translate)

(dummy, do not translate)

(dummy, do not translate)

(dummy, do not translate)

(dummy, do not translate)

(dummy, do not translate)

(dummy, do not translate)

(dummy, do not translate)

15:04:22: Retcode 1: error in DDL statement for PATRTCONF - repeat

Error 959-ORA-00959: tablespace 'PSAPSR3' does not exist when executing ADD-FIELD of

Error PATRTCONF when executing ADD-FIELD of

(dummy, do not translate)

No DDL commands found for activation of PATRTCONF

15:04:34: Retcode 1: error in DDL statement for PATRTPHASE - repeat

Error 959-ORA-00959: tablespace 'PSAPSR3' does not exist when executing ADD-FIELD of

Error PATRTPHASE when executing ADD-FIELD of

(dummy, do not translate)

No DDL commands found for activation of PATRTPHASE

15:04:46: Retcode 1: error in DDL statement for PATRTVERS - repeat

Error 959-ORA-00959: tablespace 'PSAPSR3' does not exist when executing ADD-FIELD of

Error PATRTVERS when executing ADD-FIELD of

(dummy, do not translate)

Someone know how to solve the problem?

For information the tablespace PSAPSR3 not exist!! I don't kno why the program search this one....

Regards.

Edited by: BABY Fabrice on Jul 27, 2010 4:02 PM

[markus_doehr2]

> Error 959-ORA-00959: tablespace 'PSAPSR3' does not exist when executing ADD-FIELD of

This is a default tablespace if your SID is SR3.

Did you modify any of those parameter during the installation of the system?

Markus

[baby_fabrice]

In fact the system where i want to update Spam is a copy from an other system.

The source system was upgraded to 701 few weeks ago.

But i have look in the 701 system ( the old source system upgraded ) and effectively there is PSAPSR3 tablespace witch is not the case in the target client...

I supose after the copy someone made change in the tablespace name.

I will investigate in this direction.

Regards.

[baby_fabrice]

In in the system where i want to update SPAM there are theses tablespace :

NEWTBSSAPSR3

NEWTBSSAPSR3700

PSAPSR3DB

PSAPSR3USR

PSAPTEMP2010

PSAPUNDO

SYSAUX

SYSTEM

Is there a way to know witch tablespace is active (or default) like the PSAPSR3 ( i supose this is the NEWTBSSAPSR3700 ) how to be sure.

Regards.

Edited by: BABY Fabrice on Jul 27, 2010 4:59 PM

Edited by: BABY Fabrice on Jul 27, 2010 5:00 PM

Edited by: BABY Fabrice on Jul 27, 2010 5:09 PM

[markus_doehr2]

> Is there a way to know witch tablespace is active (or default) like the PSAPSR3 ( i supose this is the NEWTBSSAPSR3700 ) how to be sure.

How did you do the system copy? That kind of naming is non-standard and doesn't work with SAP systems - if you don't change all the technical settings in all tables.

Markus

[baby_fabrice]

Hi,

It s not me who make the copy so i can say you the process used.

After the rename of the tablespace into SAPSR3 and a new import all is clear now : the spam is update.

Thx again Markus.

If i have infoirmation about the copy method i will post it.

Regards

[former_member204746]

stop SAP

run these 2 commands:

brspace -c force -f tsalter -a rename -t NEWTBSSAPSR3 -n PSAPSR3

brspace -c force -f tsalter -a rename -t NEWTBSSAPSR3700 -n PSAPSR3700

start SAP

problem fixed.