cancel
Showing results for 
Search instead for 
Did you mean: 

ORA-00959: tablespace 'PSAPSR370000D' does not exist

Former Member
0 Kudos

Dear all,

I've finished the Export for OS migration of Non-Unicode Central instance SAP ECC6.0 NW70 SR2 Oracle 11.2.0.3 on HP-UX 11.31. to RedHat 6.

I've installed Oracle 11.2.0.3 with the latest bundel patches on RedHat 6.

Now I've started the SWPM 1.0 to install the target system and import. I've proceed with the installation of the target, and I've got new error in sapinst.log:

CJS-30022 Program 'Migration Monitor' exits with error code 103. For details see log file(s) import_monitor.java.log, import_monitor.log.

In the import_monitor.log there was 4 Errors:
Loading of 'SAPSLEXC' import package is interrupted with R3load error.
Loading of 'SAPAPPL1' import package is interrupted with R3load error.
Loading of 'SAPSSEXC' import package is interrupted with R3load error.
Loading of 'SAP0000' import package is interrupted with R3load error.

In the logs SAPSLEXC.log, SAP0000.log, SAPSLEXC.log, the same errors:
ORA-00959: tablespace 'PSAPSR370000D' does not exist
DbSl Trace: ORA-1403 when accessing table SAPUSER

In SAPAPPL1.log just the error :

DbSl Trace: ORA-1403 when accessing table SAPUSER

This tablespace PSAPSR370000D does not exist on the source system.

TAORA from source system:

APPL0 PSAPSTABD

APPL1 PSAPBTABD

APPL2 PSAPPOOLD

CLUST PSAPCLUD

DDIM PSAPCLUD

DFACT PSAPCLUD

DODS PSAPCLUD

POOL PSAPPOOLD

SDIC PSAPDDICD

SDOCU PSAPDOCUD

SLDEF PSAPEL700D

SLEXC PSAPEL700D

SLOAD PSAPLOADD

SPROT PSAPPROTD

SSDEF PSAPES700D

SSEXC PSAPES700D

SSRC PSAPSOURCED

TEMP PSAPPROTD

USER PSAPUSER1D

USER1 PSAPUSER1D

Because of the schema on the source SAPR3  I've selected the new schema in the target SAPSR3.

I've also find the Note 1765619 - ORA-00922: missing or invalid option and Note 957917 - ORA: Conversion from old to new tablespace layout.

I was wondering if these notes can help, but in the DDLORA.TPL in the export directory there is no variable @SCHEMAID@ , just

TABLESPACE &tablespace&. That's why I don't know how these notes can help.

And the tablespace PSAPSR370000D is very stange because of the 5 zeros, I think it should be 3 zeros.

From the Note 957917, PSAP*<RELEASE>* ==> PSAP@SCHEMAID@<RELEASE>

For our tablespaces should be converted as:

PSAPEL700D ==> PSAPSR3700D

PSAPES700D ==> PSAPSR3700D

not PSAPSR370000D


I've also looked in the Notes 1689026 - Installation of NW 7.0x Systems with Oracle Client 11.2.0x and Note 1642058 - Adapt SAPInst Oracle Clien 11.2.0.x. Should I implement Method 1 from the above notes or not beacuse I'm using the SWPM tool and the last 720_EXT kernel and the link for Oracle client 10x_64 to 11x_64 was already prepared durring the installation? Or this is not the case.

How I can proceed with the import of the target?

Thank you in advance.

Thank you in advance.

BR,

Ruzica

Accepted Solutions (1)

Accepted Solutions (1)

former_member188883
Active Contributor
0 Kudos

Hi Ruzica,

Refer SAP  Note 1677201 - Oracle 11g: Dictionary corruption / ORA-959 due to DROP TBS

SAP note talks about Latest bundle patch for 11.2.0.3 dated March 2013.

If this bundle patch is not applied , you may follow the workaround mentioned in this note.

DROP TABLESPACE PSAPSR370000D INCLUDING CONTENTS AND DATAFILES ;

Hope this helps.

PS: You have posted same query in following thread. http://scn.sap.com/thread/3334077

Regards,

Deepak Kori

Former Member
0 Kudos

Hi Deepak,

I'm using the latest bundle SAP_112035_201302_LINX8664.zip

BR,

Ruzica

former_member188883
Active Contributor
0 Kudos

Hi Ruzica,

SAP_112035_201302_LINX8664.zip is from Feb 2013. SAP note mentioned above talks about Bundle patch from March 2013.

Regards,

Deepak Kori

Former Member
0 Kudos

Hi Deepak,

I see this on the SAP Note:

11.2.0.3:

UNIX SBP 11203x_date   ( date  >=  201203 )

UNIX SGR 11203x_date   ( date  >=  201203 )

It is March but 2012.

BR,

Ruzica

former_member188883
Active Contributor
0 Kudos

Hi Ruzica,

Apologies for the date mistake.

Could you check on the database whether tablespace with that name exists.

SQL> select * from v$tablespace;

Regards,

Deepak Kori

Former Member
0 Kudos

Hi Deepak,

These are the new tablespaces created on the target. There is no tablespace PSAPSR370000D

Something is wrong with the mapping in the DDLORA.TPL

SQL> select name from v$tablespace;

NAME
------------------------------
SYSTEM
SYSAUX
PSAPUNDO
PSAPTEMP
PSAPSR3
PSAPSR3700
PSAPSR3USR

7 rows selected.

SQL>

Thank you in advance,.

BR,

Ruzica

Former Member
0 Kudos

Hi Ruzica,

You are correct... Something is wrong in your DDLORA.TPL file.

Please check the following.

1. Please go to /export location/ABAP/DB/ORA and open the DDLORA.TPL check whether there is any tablespace like PSAPSR370000D ..

2. Please go to your /sapinst_instdir/*/*/*/*/*/* and open DDLORA.TPL and check the same.

If any of the above you can find PSAPSR370000D , then replace it accordingly in your sapinst_instdir location.

If not, you have to manually edit the DDLORA.TPL...

I have faced this issue before during one migration and I have manually edited the TPL file and restarted the import and it went well.

Can you please send me the DDLORA.TPL file to mjvimalan@gmail.com?

Secondly please execute the following commands in your source system and share the output also.

select name from v$tablespace;

Thanks and Regards,

Vimal

former_member188883
Active Contributor
0 Kudos

Hi Ruzica,

Could you share dbsize.XML and DDLORA.TPL files.

Regards,

Deepak Kori

Former Member
0 Kudos

Hello Vimal,

There is no tablespace PSAPSR370000D in DDLORA.TPL in the export location just in the DDLORA.TPL in the /sapinst_instdir/*/*/*/*/*/*

DDLORA.TPL from the installation dir:

# cat DDLORA.TPL

prikey: AFTER_LOAD ORDER_BY_PKEY

seckey: AFTER_LOAD

cretab: CREATE TABLE &tab_name&

        ( /{ &fld_name& &fld_desc& /-, /} )

        TABLESPACE &tablespace&

        &compress&

        &lob_cache&

        STORAGE (INITIAL     &init&

                 NEXT        &next&

                 MINEXTENTS  &minext&

                 MAXEXTENTS  &maxext&

                 PCTINCREASE &pctinc& )

drptab: DROP TABLE &tab_name&

crepky: CREATE UNIQUE INDEX &pri_key&

        ON &tab_name&

        ( &key_fld& /-, )

        TABLESPACE &tablespace&

        STORAGE (INITIAL     &init&

                 NEXT        &next&

                 MINEXTENTS  &minext&

                 MAXEXTENTS  &maxext&

                 PCTINCREASE &pctinc& )

                 NOLOGGING

                 COMPUTE STATISTICS ;

        ALTER INDEX &pri_key& LOGGING

drppky: DROP INDEX &pri_key&

creind: CREATE &unique& INDEX &ind_name&

        ON &tab_name&

        ( /{ &fld_name& /-, /} )

        TABLESPACE &tablespace&

        STORAGE (INITIAL     &init&

                 NEXT        &next&

                 MINEXTENTS  &minext&

                 MAXEXTENTS  &maxext&

                 PCTINCREASE &pctinc& )

                 NOLOGGING

                 COMPUTE STATISTICS ;

        ALTER INDEX &ind_name& LOGGING

drpind: DROP INDEX &ind_name&

crevie: CREATE VIEW &view_name&

        ( /{ &fld_name& /-, /} )

        AS &query&

drpvie: DROP VIEW &view_name&

trcdat: TRUNCATE TABLE &tab_name&

deldat: DELETE FROM &tab_name& &where&

negtab: LICHECK MLICHECK

negdat: LICHECK MLICHECK

negind: LICHECK~0 MLICHECK~0 LICHECK^0 MLICHECK^0

negvie:

negcpr:  NRIV ARFCSSTATE ARFCSDATA ARFCRSTATE TRFCQDATA TRFCQIN TRFCQOUT TRFCQSTATE QRFCTRACE QRFCLOG

# table storage parameters

loc: APPL0 PSAPSR3                      0000

     APPL1 PSAPSR3                      0000

     APPL2 PSAPSR3                      0000

     CLUST PSAPSR3                       0000

     DDIM  PSAPSR3                       0000

     DFACT PSAPSR3                       0000

     DODS  PSAPSR3                       0000

     POOL  PSAPSR3                      0000

     SDIC  PSAPSR3                      0

     SDOCU PSAPSR3                      0000

     SLDEF PSAPSR370000D                     0000

     SLEXC PSAPSR370000D                     0000

     SLOAD PSAPSR3                      0000

     SPROT PSAPSR3                      0000

     SSDEF PSAPSR370000D                     0000

     SSEXC PSAPSR370000D                     0000

     SSRC  PSAPSR3                    0000

     TEMP  PSAPSR3                      0000

     USER  PSAPSR3USR                     0000

     USER1 PSAPSR3USR                     0000

sto: 0  0000000016K 0000000040K 0000000001 2147483645

     1  0000000016K 0000000160K 0000000001 2147483645

     10 0000000016K 0000655360K 0000000001 2147483645

     11 0000000016K 0001310720K 0000000001 2147483645

     12 0000000016K 0002621440K 0000000001 2147483645

     13 0000000016K 0005242880K 0000000001 2147483645

     14 0000000016K 0010485760K 0000000001 2147483645

     2  0000000016K 0000000640K 0000000001 2147483645

     3  0000000016K 0000002560K 0000000001 2147483645

     4  0000000016K 0000010240K 0000000001 2147483645

     5  0000000016K 0000020480K 0000000001 2147483645

     6  0000000016K 0000040960K 0000000001 2147483645

     7  0000000016K 0000081920K 0000000001 2147483645

     8  0000000016K 0000163840K 0000000001 2147483645

     9  0000000016K 0000327680K 0000000001 2147483645

# index storage parameters

loc: APPL0 PSAPSR3                      0000

     APPL1 PSAPSR3                      0000

     APPL2 PSAPSR3                      0000

     CLUST PSAPSR3                       0000

     DDIM  PSAPSR3                       0000

     DFACT PSAPSR3                       0000

     DODS  PSAPSR3                       0000

     POOL  PSAPSR3                      0000

     SDIC  PSAPSR3                      0

     SDOCU PSAPSR3                      0000

     SLDEF PSAPSR370000I                     0000

     SLEXC PSAPSR370000I                     0000

     SLOAD PSAPSR3                      0000

     SPROT PSAPSR3                      0000

     SSDEF PSAPSR370000I                     0000

     SSEXC PSAPSR370000I                     0000

     SSRC  PSAPSR3                    0000

     TEMP  PSAPSR3                      0000

     USER  PSAPSR3USR                     0000

     USER1 PSAPSR3USR                     0000

sto: 0  0000000016K 0000000040K 0000000001 2147483645

     1  0000000016K 0000000080K 0000000001 2147483645

     10 0000000016K 0000163840K 0000000001 2147483645

     11 0000000016K 0000327680K 0000000001 2147483645

     12 0000000016K 0000655360K 0000000001 2147483645

     13 0000000016K 0001310720K 0000000001 2147483645

     14 0000000016K 0002621440K 0000000001 2147483645

     2  0000000016K 0000000160K 0000000001 2147483645

     3  0000000016K 0000000640K 0000000001 2147483645

     4  0000000016K 0000002560K 0000000001 2147483645

     5  0000000016K 0000005120K 0000000001 2147483645

     6  0000000016K 0000010240K 0000000001 2147483645

     7  0000000016K 0000020480K 0000000001 2147483645

     8  0000000016K 0000040960K 0000000001 2147483645

     9  0000000016K 0000081920K 0000000001 2147483645

From the source system:

SQL>  select name from v$tablespace;

NAME
------------------------------
SYSTEM
SYSAUX
PSAPUNDO
PSAPSTABD
PSAPBTABD
PSAPBTABI
PSAPPOOLD
PSAPCLUD
PSAPDDICD
PSAPDDICI
PSAPDOCUD

NAME
------------------------------
PSAPEL46CD
PSAPLOADD
PSAPLOADI
PSAPPROTD
PSAPES46CD
PSAPSOURCED
PSAPSOURCEI
PSAPEL700D
PSAPUSER1D
PSAPES46CI
PSAPDOCUI

NAME
------------------------------
PSAPPOOLI
PSAPEL700I
PSAPSTABI
PSAPPROTI
PSAPCLUI
PSAPEL46CI
PSAPES700D
PSAPUSER1I
PSAPES700I
PSAPTEMP

32 rows selected.

SQL>

Thank you in advance.

BR,
Ruzica

Former Member
0 Kudos

Hi Deepak,

I've shared the DDLORA.TPL above.

The dbsize.XML file is too big . Can I paste it here?

BR,
Ruzica

Former Member
0 Kudos

Hi,

Please go to /export location/ABAP/DB/ORA and paste the DDLORA.TPL file available there..

Or it should be under / export location/ABAP/DB

Thanks and Regards,

Vimal

former_member206552
Active Contributor
0 Kudos

hi ruzica,

you should be able just to change the entries in that file but you will also have to have a look at

select * from sapsr3.taora;

select * from sapsr3.iaora;

Former Member
0 Kudos

Hi,

From the export dir from source:

#

cat DDLORA.TPL
prikey: AFTER_LOAD ORDER_BY_PKEY
seckey: AFTER_LOAD

cretab: CREATE TABLE &tab_name&
        ( /{ &fld_name& &fld_desc& /-, /} )
        TABLESPACE &tablespace&
        &compress&
        &lob_cache&
        STORAGE (INITIAL     &init&
                 NEXT        &next&
                 MINEXTENTS  &minext&
                 MAXEXTENTS  &maxext&
                 PCTINCREASE &pctinc& )

drptab: DROP TABLE &tab_name&

crepky: CREATE UNIQUE INDEX &pri_key&
        ON &tab_name&
        ( &key_fld& /-, )
        TABLESPACE &tablespace&
        STORAGE (INITIAL     &init&
                 NEXT        &next&
                 MINEXTENTS  &minext&
                 MAXEXTENTS  &maxext&
                 PCTINCREASE &pctinc& )
                 NOLOGGING
                 COMPUTE STATISTICS ;
        ALTER INDEX &pri_key& LOGGING

drppky: DROP INDEX &pri_key&

creind: CREATE &unique& INDEX &ind_name&
        ON &tab_name&
        ( /{ &fld_name& /-, /} )
        TABLESPACE &tablespace&
        STORAGE (INITIAL     &init&
                 NEXT        &next&
                 MINEXTENTS  &minext&
                 MAXEXTENTS  &maxext&
                 PCTINCREASE &pctinc& )
                 NOLOGGING
                 COMPUTE STATISTICS ;
        ALTER INDEX &ind_name& LOGGING

drpind: DROP INDEX &ind_name&

crevie: CREATE VIEW &view_name&
        ( /{ &fld_name& /-, /} )
        AS &query&

drpvie: DROP VIEW &view_name&

trcdat: TRUNCATE TABLE &tab_name&

deldat: DELETE FROM &tab_name& &where&

negtab: LICHECK MLICHECK

negdat: LICHECK MLICHECK
negind: LICHECK~0 MLICHECK~0 LICHECK^0 MLICHECK^0

negvie:

negcpr: NRIV ARFCSSTATE ARFCSDATA ARFCRSTATE TRFCQDATA TRFCQIN TRFCQOUT TRFCQSTATE QRFCTRACE QRFCLOG

# table storage parameters

loc: APPL0 PSAPSTABD                      0000
     APPL1 PSAPBTABD                      0000
     APPL2 PSAPPOOLD                      0000
     CLUST PSAPCLUD                       0000
     DDIM  PSAPCLUD                       0000
     DFACT PSAPCLUD                       0000
     DODS  PSAPCLUD                       0000
     POOL  PSAPPOOLD                      0000
     SDIC  PSAPDDICD                      0
     SDOCU PSAPDOCUD                      0000
     SLDEF PSAPEL700D                     0000
     SLEXC PSAPEL700D                     0000
     SLOAD PSAPLOADD                      0000
     SPROT PSAPPROTD                      0000
     SSDEF PSAPES700D                     0000
     SSEXC PSAPES700D                     0000
     SSRC  PSAPSOURCED                    0000
     TEMP  PSAPPROTD                      0000
     USER  PSAPUSER1D                     0000
     USER1 PSAPUSER1D                     0000

sto: 0  0000000016K 0000000040K 0000000001 2147483645
     1  0000000016K 0000000160K 0000000001 2147483645
     10 0000000016K 0000655360K 0000000001 2147483645
     11 0000000016K 0001310720K 0000000001 2147483645
     12 0000000016K 0002621440K 0000000001 2147483645
     13 0000000016K 0005242880K 0000000001 2147483645
     14 0000000016K 0010485760K 0000000001 2147483645
     2  0000000016K 0000000640K 0000000001 2147483645
     3  0000000016K 0000002560K 0000000001 2147483645
     4  0000000016K 0000010240K 0000000001 2147483645
     5  0000000016K 0000020480K 0000000001 2147483645
     6  0000000016K 0000040960K 0000000001 2147483645
     7  0000000016K 0000081920K 0000000001 2147483645
     8  0000000016K 0000163840K 0000000001 2147483645
     9  0000000016K 0000327680K 0000000001 2147483645

# index storage parameters

loc: APPL0 PSAPSTABI                      0000
     APPL1 PSAPBTABI                      0000
     APPL2 PSAPPOOLI                      0000
     CLUST PSAPCLUI                       0000
     DDIM  PSAPCLUI                       0000
     DFACT PSAPCLUI                       0000
     DODS  PSAPCLUI                       0000
     POOL  PSAPPOOLI                      0000
     SDIC  PSAPDDICI                      0
     SDOCU PSAPDOCUI                      0000
     SLDEF PSAPEL700I                     0000
     SLEXC PSAPEL700I                     0000
     SLOAD PSAPLOADI                      0000
     SPROT PSAPPROTI                      0000
     SSDEF PSAPES700I                     0000
     SSEXC PSAPES700I                     0000
     SSRC  PSAPSOURCEI                    0000
     TEMP  PSAPPROTI                      0000
     USER  PSAPUSER1I                     0000
     USER1 PSAPUSER1I                     0000

sto: 0  0000000016K 0000000040K 0000000001 2147483645
     1  0000000016K 0000000080K 0000000001 2147483645
     10 0000000016K 0000163840K 0000000001 2147483645
     11 0000000016K 0000327680K 0000000001 2147483645
     12 0000000016K 0000655360K 0000000001 2147483645
     13 0000000016K 0001310720K 0000000001 2147483645
     14 0000000016K 0002621440K 0000000001 2147483645
     2  0000000016K 0000000160K 0000000001 2147483645
     3  0000000016K 0000000640K 0000000001 2147483645
     4  0000000016K 0000002560K 0000000001 2147483645
     5  0000000016K 0000005120K 0000000001 2147483645
     6  0000000016K 0000010240K 0000000001 2147483645
     7  0000000016K 0000020480K 0000000001 2147483645
     8  0000000016K 0000040960K 0000000001 2147483645
     9  0000000016K 0000081920K 0000000001 2147483645

BR,

Ruzica

Former Member
0 Kudos

Hi Marius,

From the target DB - there is no tablespace PSAPSR370000D:

SQL> select * from sapsr3.taora;

TABAR TABSPACE                       PCTI OFR OF OP OP
----- ------------------------------ ---- --- -- -- --
APPL0 PSAPSTABD                      0000 001 01 10 40
APPL1 PSAPBTABD                      0000 1   1  10 40
APPL2 PSAPPOOLD                      0000 1   1  10 40
CLUST PSAPCLUD                       0000 1   1  10 40
DDIM  PSAPCLUD                       0000 001 01 00 60
DFACT PSAPCLUD                       0000 004 01 10 60
DODS  PSAPCLUD                       0000 004 01 00 60
POOL  PSAPPOOLD                      0000 1   1  10 40
SDIC  PSAPDDICD                      0    1   1  10 40
SDOCU PSAPDOCUD                      0000 1   1  10 40
SLDEF PSAPEL700D                     0000 1   1  10 40

TABAR TABSPACE                       PCTI OFR OF OP OP
----- ------------------------------ ---- --- -- -- --
SLEXC PSAPEL700D                     0000 1   1  10 40
SLOAD PSAPLOADD                      0000 1   1  10 40
SPROT PSAPPROTD                      0000 1   1  10 40
SSDEF PSAPES700D                     0000 1   1  10 40
SSEXC PSAPES700D                     0000 1   1  10 40
SSRC  PSAPSOURCED                    0000 1   1  10 40
TEMP  PSAPPROTD                      0000 1   1  10 40
USER  PSAPUSER1D                     0000 1   1  10 40
USER1 PSAPUSER1D                     0000 1   1  10 40

20 rows selected.

SQL> select * from sapsr3.iaora;
select * from sapsr3.iaora
                     *
ERROR at line 1:
ORA-00942: table or view does not exist


SQL>

Thank you in advance,

BR,

Ruzica

Former Member
0 Kudos

Hi,

Thanks .. Please try the following.

1. Stop the sapinst.

2. navigate to sapinst_instdir folder  and rename the DDLORA.TPL file.

3. Copy the DDLORA.TPL file from the export location to sapinst_instdir location.

4.Start the sapinst and continue with old option

Please share your feedback.

Thanks and Regards,

Vimal

former_member206552
Active Contributor
0 Kudos

hi ruzica

then i would suggest backip up and changing the file (DDLORA.TPL) to host the new tablespace name and retying.just before the import phase check the iora and taora tables to make sure there is not refrence to PSAPSR370000D

best regards

marius

Former Member
0 Kudos

Hi Vimal,

I was wondering for something, if I use the DDLORA.TPL from export location there will be no mapping (or changing) from schema SAPR3 to SAPSR3 what I need to perform with this export and import.

Am I right ?

Thank you in advance.

BR,

Ruzica

Former Member
0 Kudos

Hi Marius,

What should be the change ?

DDLORA with which tablespace names, from the v$tablespace from the target or?

Thank you in advance.

BR,

Ruzica

Former Member
0 Kudos

Hi,

  You can try to rename the contents in the file DDLORA.TPL file which was copied to sapinst directory from the export location.

Example

Rename

# table storage parameters

loc: APPL0 PSAPSTABD                      0000

to

# table storage parameters

loc: APPL0 PSAPSR3                      0000

Likewise change for the others also .

Thanks and Regards,

Vimal

former_member206552
Active Contributor
0 Kudos

DDLORA.TPL on the target system change the PSAPSR370000D with PSAPSR3700


# table storage parameters

loc: APPL0 PSAPSR3                      0000

     APPL1 PSAPSR3                      0000

     APPL2 PSAPSR3                      0000

     CLUST PSAPSR3                       0000

     DDIM  PSAPSR3                       0000

     DFACT PSAPSR3                       0000

     DODS  PSAPSR3                       0000

     POOL  PSAPSR3                      0000

     SDIC  PSAPSR3                      0

     SDOCU PSAPSR3                      0000

     SLDEF PSAPSR3700                     0000

     SLEXC PSAPSR3700                     0000

     SLOAD PSAPSR3                      0000

     SPROT PSAPSR3                      0000

     SSDEF PSAPSR3700                     0000

     SSEXC PSAPSR3700                     0000

     SSRC  PSAPSR3                    0000

     TEMP  PSAPSR3                      0000

     USER  PSAPSR3USR                     0000

     USER1 PSAPSR3USR                     0000


# index storage parameters

loc: APPL0 PSAPSR3                      0000

     APPL1 PSAPSR3                      0000

     APPL2 PSAPSR3                      0000

     CLUST PSAPSR3                       0000

     DDIM  PSAPSR3                       0000

     DFACT PSAPSR3                       0000

     DODS  PSAPSR3                       0000

     POOL  PSAPSR3                      0000

     SDIC  PSAPSR3                      0

     SDOCU PSAPSR3                      0000

     SLDEF PSAPSR3700                     0000

     SLEXC PSAPSR3700                     0000

     SLOAD PSAPSR3                      0000

     SPROT PSAPSR3                      0000

     SSDEF PSAPSR3700                     0000

     SSEXC PSAPSR3700                     0000

     SSRC  PSAPSR3                    0000

     TEMP  PSAPSR3                      0000

     USER  PSAPSR3USR                     0000

     USER1 PSAPSR3USR                     0000

Former Member
0 Kudos

Hello Marius,

I've changed the rows with PSAPSR370000D with PSAPSR3700 and restart the installation with continue with old option, then the Import phase finished successfully.

BR,

Ruzica

former_member206552
Active Contributor
0 Kudos

hi ruzica,

glad to hear 

best regards

marius

Former Member
0 Kudos

Hi Vimal,

I've changed the DDLORA.TPL and DDLORA_LRG.TPL like this and Import finished OK:

> cat "DDLORA.TPL"|grep PSAPSR3700

  ###     SLDEF PSAPSR370000D                     0000

  SLDEF PSAPSR3700                     0000

  ###     SLEXC PSAPSR370000D                     0000

SLEXC PSAPSR3700                    0000

  ###     SSDEF PSAPSR370000D                     0000

SSDEF PSAPSR3700                    0000

  ###     SSEXC PSAPSR370000D                     0000

SSEXC PSAPSR3700                    0000

  ###     SLDEF PSAPSR370000I                     0000

SLDEF PSAPSR3700                     0000

###     SLEXC PSAPSR370000I                     0000

SLEXC PSAPSR3700                    0000

###     SSDEF PSAPSR370000I                     0000

SSDEF PSAPSR3700                    0000

###     SSEXC PSAPSR370000I                     0000

SSEXC PSAPSR3700                    0000

Thank you for all your help.

BR,
Ruzica

Answers (3)

Answers (3)

marcosmata
Participant
0 Kudos

Thanks man.. It works FINE for me.

I changed

PSAPSR370000D with PSAPSR3700

PSAPSR370000I  with PSAPSR3700

PSAPSR370000E with PSAPSR3700

And its done... Thanks again.

0 Kudos

Hi.

Which patch level of SWPM did you use? The lastest is  PLV06.

I have the same issue using SWPM PL03, and I had to change manually the tablespace entries in DDLORA.TPL, DDLORA_LRG.TP and DBSIZE.XML.

Former Member
0 Kudos

Hi Mauricio,

I'm using the PLV05 70SWPM10SP01_5-20009701.sar

And the same problem where I need to change  the DDLORA.TPL, DDLORA_LRG.TPL manually.

BR,

Ruzica

former_member206552
Active Contributor
0 Kudos

Hi Ruzica

please try below from note 1317500

Error during export preparation with R3szchk

Symptom:

When preparing the export, R3szchk creates wrong tablespace entries PSAPES70I and PSAPES700 in DBSIZE.XML. Hence SAPinst creates the wrong tablespace name PSAP<SCHEMAID>70 instead of PSAP<SCHEMAID>700.

Solution: 

  1. 3. Get the latest R3szchk from the SAP Service Marketplace at http://service.sap.com/swdc -> Download -> Support Packages and Patches -> Entry by Application Group -> SAP NetWeaver -> SAP NETWEAVER -> <your product> -> Entry by Component -> Application Server ABAP -> <SAP KERNEL of your product> -> <your OS> -> ORACLE.
  2. 4. Restart the R3szchk step.
  3. 5. Correct the tablespace names in DBSIZE.XML befor you start the import on the target system.

Best Regards

Marius

Former Member
0 Kudos

Hi Marius,

First I can't open the Note 1317500 - The requested SAP Note is either in reworking or is released internally only .

Please send me the text from the note.

I've seen this error in Note Note 970518 - Hom./Het.System Copy SAP NetWeaver 7.0 (2004s) SR2, but ith was for BW systems. (BW only: Error during "Import ABAP" phase in step runMigrationMonitor" of BW specific packages SAPDDIM, SAPDFACT, SAPDODS).

Thank you

BR,

RUzica

former_member206552
Active Contributor
0 Kudos

hi ruzica,

please try the link below

http://www.stechno.net/sap-notes.html?view=sapnote&id=1317500

best regards

marius